EmergencyEMERGENCY? Get 24/7 Help Now!

Group Replication: The Sweet and the Sour

 | August 1, 2017 |  Posted In: GTID, High-availability, InnoDB, MySQL, Percona XtraDB Cluster, PMM

Group Replication

In this blog, we’ll look at group replication and how it deals with flow control (FC) and replication lag.  Overview In the last few months, we had two main actors in the MySQL ecosystem: ProxySQL and Group-Replication (with the evolution to InnoDB Cluster).  While I have extensively covered the first, my last serious work on […]

Read More

Platform End of Life (EOL) Announcement for RHEL 5 and Ubuntu 12.04 LTS

 | July 31, 2017 |  Posted In: Events and Announcements, InnoDB, MariaDB, MongoDB, MySQL, Percona Software, Percona Support

End of Life

Upstream platform vendors have announced the general end of life (EOL) for Red Hat Enterprise Linux 5 (RHEL 5) and its derivatives, as well as Ubuntu 12.04 LTS. With this announcement comes some implications to support for Percona software running on these operating systems. RHEL 5 was EOL as of March 31st, 2017 and Ubuntu […]

Read More

Webinar Wednesday August 2, 2017: MySQL Disk Encryption with LUKS

 | July 31, 2017 |  Posted In: MySQL, Security, Technical Webinars

MySQL Disk Encryption

Join Percona’s, Senior Architect, Matthew Boehm as he presents MySQL Disk Encryption with LUKS on Wednesday, August 2, 2017, at 1:00 pm PDT / 4:00 pm EDT (UTC-7). Register Now Clients require strong security measures for PCI, HIPAA or PHI. You must encrypt MySQL “at rest” to satisfy the data managed under these standards. InnoDB’s built-in […]

Read More

Percona Server for MySQL 5.7.18-16 Is Now Available

 | July 28, 2017 |  Posted In: Events and Announcements, MySQL

Percona Server for MySQL 5.6

Percona is glad to announce the GA release of Percona Server for MySQL 5.7.18-16 on July 28, 2017 (Downloads are available here and from the Percona Software Repositories). Based on MySQL 5.7.18, including all the bug fixes in it, Percona Server for MySQL 5.7.18-16 is the current GA release in the Percona Server for MySQL 5.7 series. All of Percona‘s software is open-source and free, […]

Read More

Percona Server for MongoDB 3.4.6-1.6 is Now Available

 | July 28, 2017 |  Posted In: Events and Announcements, MongoDB, Percona Server for MongoDB, Percona Software

Percona Server for MongoDB 3.2

Percona announces the release of Percona Server for MongoDB 3.4.6-1.6 on July 27, 2017. Download the latest version from the Percona web site or the Percona Software Repositories. Percona Server for MongoDB is an enhanced, open source, fully compatible, highly-scalable, zero-maintenance downtime database supporting the MongoDB v3.4 protocol and drivers. It extends MongoDB with Percona Memory Engine and MongoRocks storage engine, as well as several enterprise-grade features: External […]

Read More

What is MySQL Partitioning?

 | July 27, 2017 |  Posted In: Insight for DBAs, MySQL, MySQL 101

MySQL Partitioning

In this blog, we’ll quickly look at MySQL partitioning. Partitioning is a way in which a database (MySQL in this case) splits its actual data down into separate tables, but still get treated as a single table by the SQL layer. When partitioning, it’s a good idea to find a natural partition key. You want […]

Read More

What is innodb_autoinc_lock_mode and why should I care?

 | July 26, 2017 |  Posted In: MySQL

innodb_autoinc_lock_mode

In this blog post, we’ll look at what innodb_autoinc_lock_mode is and how it works. I was recently discussing innodb_autoinc_lock_mode with some colleagues to address issues at a company I was working with. This variable defines the lock mode to use for generating auto-increment values. The permissible values are 0, 1 or 2 (for “traditional”, “consecutive” or […]

Read More

Percona XtraBackup 2.4.8 is Now Available

 | July 24, 2017 |  Posted In: Events and Announcements, MySQL, Percona Software, Percona XtraBackup

Percona XtraBackup

Percona announces the GA release of Percona XtraBackup 2.4.8 on July 24, 2017. You can download it from our download site and apt and yum 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 free […]

Read More

Percona’s widely read Percona Database 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.