EmergencyEMERGENCY? Get 24/7 Help Now!

How to setup a PXC cluster with GTIDs (and have async slaves replicating from it!)

 | February 20, 2015 |  Posted In: GTID, MySQL, Percona XtraBackup, Percona XtraDB Cluster

This past week was marked by a series of personal findings related to the use of Global Transaction IDs (GTIDs) on Galera-based clusters such as Percona XtraDB Cluster (PXC). The main one being the fact that transactions touching MyISAM tables (and FLUSH PRIVILEGES!) issued on a giving node of the cluster are recorded on a GTID set […]

Read More

More on MySQL 5.6 multi-threaded replication and GTIDs (and Feb. 25 webinar)

 | February 19, 2015 |  Posted In: MySQL, Percona XtraBackup

In a previous post, titled “Multi-threaded replication with MySQL 5.6: Use GTIDs,” I explained that using GTID replication is almost a requirement when using MySQL 5.6 MTS. Let’s see now how to perform the day-to-day operations when MTS and GTIDs are both enabled. (I’ll also be presenting a related webinar next week titled “Multi-threaded Replication […]

Read More

Percona XtraBackup 2.2.8 is now available

 | January 14, 2015 |  Posted In: Events and Announcements, MySQL, Percona Software, Percona XtraBackup

Percona is glad to announce the release of Percona XtraBackup 2.2.8 on January 14, 2015. Downloads are available from our download site or Percona Software Repositories. Percona XtraBackup enables MySQL backups without blocking user queries, making it ideal for companies with large data sets and mission-critical applications that cannot tolerate long periods of downtime. Offered […]

Read More

MySQL 5.6 Transportable Tablespaces best practices

 | December 9, 2014 |  Posted In: Insight for DBAs, MySQL, Percona XtraBackup

In MySQL 5.6 Oracle introduced a Transportable Tablespace feature (copying tablespaces to another server) and Percona Server adopted it for partial backups which means you can now take individual database or table backups and your destination server can be a vanilla MySQL server. Moreover, since Percona Server 5.6, innodb_import_table_from_xtrabackup is obsolete as Percona Server also […]

Read More

Backup and restore of MySQL to OpenStack Swift

 | November 1, 2014 |  Posted In: MySQL, OpenStack, Percona Server, Percona XtraBackup

MySQL database usage is popular in OpenStack. Core OpenStack services for Compute (Nova), Storage (Cinder), Neutron (Networking), Image (Glance) and Identity (Keystone) all use MySQL database. MySQL – as the world’s most popular database, runs inside OpenStack Virtual Machines and serves as database backend to OpenStack cloud based applications. The MySQL instances can be configured […]

Read More

Rackspace doubling-down on open-source databases, Percona Server

and  | October 15, 2014 |  Posted In: MySQL, OpenStack, Percona XtraBackup

Founded in 1998, Rackspace has evolved over the years to address the way customers are using data – and more specifically, databases. The San Antonio-based company is fueling the adoption of cloud computing among organizations large and small. Today Rackspace is doubling down on open source database technologies. Why? Because that’s where the industry is […]

Read More

Percona XtraBackup 2.2.5 now available (free MySQL hot backup software)

 | October 6, 2014 |  Posted In: Events and Announcements, MySQL, Percona Software, Percona XtraBackup

Percona is glad to announce the release of Percona XtraBackup 2.2.5 on October 2, 2014. Downloads are available from our download site here and Percona Software Repositories. Percona XtraBackup enables MySQL backups without blocking user queries, making it ideal for companies with large data sets and mission-critical applications that cannot tolerate long periods of downtime. […]

Read More

mysqld_multi: How to run multiple instances of MySQL

 | August 26, 2014 |  Posted In: Insight for DBAs, MySQL, Percona MySQL Support, Percona Server, Percona XtraBackup

The need to have multiple instances of MySQL (the well-known mysqld process) running in the same server concurrently in a transparent way, instead of having them executed in separate containers/virtual machines, is not very common. Yet from time to time the Percona Support team receives a request from a customer to assist in the configuration of […]

Read More

OpenStack’s Trove: The benefits of this database as a service (DBaaS)

 | August 25, 2014 |  Posted In: MySQL, OpenStack, Percona Software

In a previous post, my colleague Dimitri Vanoverbeke discussed at a high level the concepts of database as a service (DBaaS), OpenStack and OpenStack’s implementation of a DBaaS, Trove. Today I’d like to delve a bit further into Trove and discuss where it fits in, and who benefits. Just to recap, Trove is OpenStack’s implementation […]

Read More

Paris OpenStack Summit Voting – Percona Submits 16 MySQL Talks

 | August 1, 2014 |  Posted In: MySQL, OpenStack, Percona MySQL Consulting, Percona Software

MySQL plays a critical role in OpenStack. It serves as the host database supporting most components such as Nova, Glance, and Keystone and is the most mature guest database in Trove. Many OpenStack operators use Percona open source software including the MySQL drop-in compatible Percona Server and Galera-based Percona XtraDB Cluster as well as tools such as Percona XtraBackup and Percona Toolkit. […]

Read More

Percona’s widely read Percona Data Performance blog highlights our expertise in enterprise-class software, support, consulting and managed services solutions for both MySQL® and MongoDB® across traditional and cloud-based platforms. The decades of experience represented by our consultants is found daily in numerous and relevant blog posts.

Besides specific database help, the blog also provides notices on upcoming events and webinars.
Want to get weekly updates listing the latest blog posts? Subscribe to our blog now! Submit your email address below and we’ll send you an update every Friday at 1pm ET.

No, thank you. Please do not ask me again.