EmergencyEMERGENCY? Get 24/7 Help Now!

Webinar Wednesday June 29: Percona XtraDB Cluster Reference Architecture

 | June 27, 2016 |  Posted In: MySQL, Percona XtraDB Cluster

Percona XtraDB Cluster Reference Architecture

Please join Jay Janssen for the webinar Percona XtraDB Cluster Reference Architecture Wednesday, June 29 at 10:00 AM PDT (UTC- 7). A reference architecture shows a typical, common, best-practice deployment of a system with all the surrounding infrastructure. In the case of database clusters, this can include the hosting platform, load balancing, monitoring, backups, etc. Percona […]

Read More

Docker automatic MySQL slave propagation

 | June 21, 2016 |  Posted In: Docker, MySQL, Percona XtraDB Cluster

Docker automatic MySQL slave propagation

In this post, we’ll discuss Docker automatic MySQL slave propagation for help with scaling. In my previous posts on the Docker environment, I covered Percona XtraDB Cluster. Percona XtraDB Cluster can automatically scale by conveniently adding new nodes using the highly automated State Snapshot Transfer. State Snapshot Transfer allows a new node to copy data […]

Read More

Percona XtraDB Cluster 5.6.30-25.16 is now available

 | June 10, 2016 |  Posted In: Events and Announcements, MySQL, Percona Software, Percona XtraDB Cluster

Percona XtraDB Cluster Reference Architecture

Percona is glad to announce the new release of Percona XtraDB Cluster 5.6 on June 10, 2016. Binaries are available from the downloads area or our software repositories. Percona XtraDB Cluster 5.6.30-25.16 is now the current release, based on the following: Percona Server 5.6.30-76.3 Galera Replication library 3.16 Codership wsrep API version 25 All of Percona […]

Read More

Percona XtraDB Cluster 5.7 beta is now available

 | June 9, 2016 |  Posted In: Events and Announcements, MySQL, Percona Software, Percona XtraDB Cluster

Percona XtraDB Cluster Reference Architecture

Percona is glad to announce the release of Percona XtraDB Cluster 5.7.11-4beta-25.14.2 on June 9, 2016. Binaries are available from the downloads area or our software repositories. NOTE: This beta release is only available from the testing repository. It is not meant for upgrade from Percona XtraDB Cluster 5.6 and earlier versions. Only a fresh installation is supported. […]

Read More

Galera warning “last inactive check”

 | June 2, 2016 |  Posted In: Percona XtraDB Cluster, PXC Internals, XtraDB Cluster

Galera warning "last inactive check"

In this post, we’ll discuss the Galera warning “last inactive check” and what it means. Problem I’ve been working with Percona XtraDB Cluster quite a bit recently, and have been investigating various warnings. I came across this one today: [Warning] WSREP: last inactive check more than PT1.5S ago (PT1.51811S), skipping check This warning is related […]

Read More

Galera Error Failed to Report Last Committed (Interrupted System Call)

 | May 27, 2016 |  Posted In: MySQL, Percona XtraDB Cluster, PXC Internals, XtraDB Cluster

MySQL-Got-an-error-reading-communication-packet-errors

In this blog, we’ll discuss the ramifications of the Galera Error Failed to Report Last Committed (Interrupted System Call). I have recently seen this error with Percona XtraDB Cluster (or Galera): [Warning] WSREP: Failed to report last committed 549684236, -4 (Interrupted system call) It was posted in launchpad as a bug in 2013: https://bugs.launchpad.net/percona-xtradb-cluster/+bug/1434646 My […]

Read More

How Percona XtraDB Cluster certification works

 | April 17, 2016 |  Posted In: Percona XtraDB Cluster, PXC Internals

Percona XtraDB Cluster threading model

In this blog, we’ll  discuss how Percona XtraDB Cluster certification works. Percona XtraDB Cluster replicates actions executed on one node to all other nodes in the cluster and make it fast enough to appear as it if is synchronous (aka virtually synchronous). Let’s understand all the things involved in the process (without losing data integrity). There are […]

Read More

Understanding GCache and Record-Set Cache in Percona XtraDB Cluster

 | April 11, 2016 |  Posted In: MySQL, Percona XtraDB Cluster, PXC Internals

In this blog, we will examine the differences between GCache and Record-Set Cache in Percona XtraDB Cluster. In Percona XtraDB Cluster (PXC), there is the concept of GCache and Record-Set cache (which can also be called transaction write-set cache). The use of these two caches is often confusing if you are running long transactions, as both of […]

Read More

Understanding Percona XtraDB Cluster threading model

 | April 11, 2016 |  Posted In: MySQL, Percona XtraDB Cluster

In this blog, we’ll discuss how the Percona XtraDB Cluster threading model works. Percona XtraDB Cluster (PXC) creates a different set of threads to service its operations. These threads are in addition to existing MySQL threads. Let’s understand what these threads are and how they’re used. There are three main groups of threads: Applier thread(s) Applier threads […]

Read More

Percona XtraDB Cluster 5.6.28-25.14 is now available

 | January 29, 2016 |  Posted In: Events and Announcements, MySQL, Percona Software, Percona XtraDB Cluster

How to calculate the correct size of Percona XtraDB Cluster's gcache

Percona is glad to announce the new release of Percona XtraDB Cluster 5.6 on January 29, 2016. Binaries are available from the downloads area or from our software repositories. Percona XtraDB Cluster 5.6.28-25.14 is now the current release, based on the following: Percona Server 5.6.28-76.1 Galera Replicator 3.14 Codership wsrep API 25.13 All of Percona software […]

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.