EmergencyEMERGENCY? Get 24/7 Help Now!

Managing Replication with Percona XtraDB Cluster

 | December 1, 2016 |  Posted In: GTID, High-availability, Percona XtraDB Cluster, Replication

Managing Replication

This blog post discusses managing replication with Percona XtraDB Cluster. Recently a customer asked me to setup replication between two distinct Percona XtraDB Clusters located in geographically separate data centers. The customer goal was to use one of the clusters only in case of disaster recovery. They tried extending the cluster, but because of the […]

Read More

Galera Cache (gcache) is finally recoverable on restart

 | November 30, 2016 |  Posted In: MySQL, Percona XtraDB Cluster, XtraDB Cluster

Gcache

This post describes how to recover Galera Cache (or gcache) on restart. Recently Codership introduced (with Galera 3.19) a very important and long awaited feature. Now users can recover Galera cache on restart. Need If you gracefully shutdown cluster nodes one after another, with some lag time between nodes, then the last node to shutdown holds […]

Read More

All You Need to Know About GCache (Galera-Cache)

 | November 16, 2016 |  Posted In: High-availability, MySQL, Percona XtraDB Cluster, XtraDB Cluster

GCache

This blog discusses some important aspects of GCache. Why do we need GCache? Percona XtraDB Cluster is a multi-master topology, where a transaction executed on one node is replicated on another node(s) of the cluster. This transaction is then copied over from the group channel to Galera-Cache followed by apply action. The cache can be discarded immediately […]

Read More

Webinar Thursday, November 17: MySQL High Availability with Percona XtraDB Cluster 5.7

 | November 15, 2016 |  Posted In: High-availability, MySQL, Percona XtraDB Cluster, Technical Webinars

Percona XtraDB Cluster 5.7.16-27.19

Join Percona’s Percona XtraDB Cluster Lead Software Engineer Krunal Bauskar for a webinar on Thursday, November 17, 2016, at 7:30 am PST on MySQL High Availability with Percona XtraDB Cluster 5.7. Percona XtraDB Cluster 5.7 is our brand new MySQL 5.7 compatible Galera-based high availability (HA) solution. Whether you’re new to MySQL clustering technology, or […]

Read More

Updating Percona XtraDB Cluster from 5.6.24-72.2 to 5.6.32-25.17

 | November 7, 2016 |  Posted In: High-availability, Percona XtraDB Cluster

ProxySQL Admin

This blog describes how to upgrade Percona XtraDB Cluster in place from 5.6.24-72.2 to 5.6.32-25.17. This very hands-on blog is the result of some questions such as “can I perform an in-place upgrade for Percona XtraDB Cluster” coming in. We have done these minor upgrades for Percona Managed Services customers running Percona XtraDB Cluster with lots […]

Read More

Percona responds to CVE-2016-6663 and CVE-2016-6664

 | November 2, 2016 |  Posted In: Events and Announcements, MySQL, Percona XtraDB Cluster

CVE-2016-9962

Percona has addressed CVE-2016-6663 and CVE-2016-6664 in releases of Percona Server for MySQL and Percona XtraDB Cluster. Percona is happy to announce that the following vulnerabilities are fixed in current releases of Percona Server for MySQL and Percona XtraDB Cluster: CVE-2016-6663: allows a local system user with access to the affected database in the context of […]

Read More

Percona Monitoring and Management (PMM) Information Script

 | November 1, 2016 |  Posted In: InnoDB, MongoDB, MySQL, Percona Monitoring and Management, Percona XtraDB Cluster

Percona Monitoring and Management

This blog post discusses an information script for the Percona Monitoring and Management (PMM) tool. In recent news, we announced the fresh-of-the-press Percona Monitoring and Management (or PMM for short) platform. Given the interaction of the different components that together make up PMM, I developed a script that helps provide you information about the status of your PMM installation. You can use this script yourself, or one of our […]

Read More

Replication Triggers a Performance Schema Issue on Percona XtraDB Cluster

 | October 21, 2016 |  Posted In: MySQL, Percona XtraDB Cluster

ProxySQL Admin

In this blog post, we’ll look at how replication triggers a Performance Schema issue on Percona XtraDB Cluster. During an upgrade to Percona XtraDB Cluster 5.6, I faced an issue that I wanted to share. In this environment, we set up three Percona XtraDB Cluster nodes (mostly configured as default), copied from a production server. We […]

Read More

Consul Architecture

 | October 10, 2016 |  Posted In: MySQL, Percona XtraDB Cluster

consul

In this blog post, I’ll provide my thoughts about Consul for ProxySQL service discovery and automation. I approached Consul recently while looking for a service discovery and configuration automation solution for ProxySQL. My colleague Nik Vyzas wrote a great post on this topic, and I suggest you read it. I wrote this article to share my first impressions […]

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.