Percona announces the release of Percona XtraDB Cluster 5.7.22-29.26 (PXC) on June 29, 2018. Binaries are available from the downloads section or our software repositories.
Percona XtraDB Cluster 5.7.22-29.26 is now the current release, based on the following:
Deprecated
The following variables …
[Read more]Percona announces the release of Percona XtraDB Cluster 5.6.40-26.25 (PXC) on June 20, 2018. Binaries are available from the downloads section or our software repositories.
Percona XtraDB Cluster 5.6.40-26.25 is now the current release, based on the following:
All Percona software is open-source and free. …
[Read more]Let them stay together.
In the last YEARS, I have seen quite often that users, when installing a product such as PXC, instead of spending five minutes to understand what to do just run
iptables -F
and save.
In short, they remove any rules for their firewall.
With this post, I want to show you how easy it can be to do the right thing instead of putting your server at risk. I’ll show you how a slightly more complex setup like PXC (compared to MySQL), can be easily achieved without risky shortcuts.
iptables is the utility used to manage the chains of rules used
by the Linux kernel firewall, which is your basic security
tool.
Linux comes with a wonderful firewall built into the kernel. As
an administrator, you can configure this firewall with interfaces
like ipchains — which we are not going to cover — and
iptables, which we shall talk about.
iptables is …
[Read more]At my latest webinar “MySQL Test Framework (MTR) for Troubleshooting”, I received an interesting question about MTR test cases for Percona XtraDB Cluster (PXC). Particularly about testing SST and IST.
This post is intended to answer this question. It assumes you are familiar with MTR and can write tests for MySQL servers. If you are not, please watch the webinar recording first.
You can find example tests in any PXC tarball package. They are located in directories
mysql-test/suite/galera
,
mysql-test/suite/galera_3nodes
and
mysql-test/suite/wsrep
, though that last directory only contains a configuration file.
If you …
[Read more]Encryption is a very important form of security and It’s becoming a standard from a compliance perspective to ensure PCI, PII and HIPPA compliances. Encryption needs to be performed for Data at Rest, Data over Wire.
Data At Rest:
In this blog post, We will be explaining about the timeouts in SST on systemd implementation which we faced recently in Percona XtraDB Cluster during our Consulting with a client. State Snapshot Transfers (SST) refers to complete data sync from one of the nodes from the cluster to the joining node.
SST will happen for one or more reasons listed below.
Please join Percona’s Ramesh Sivaraman (QA Engineer) and Krunal Bauskar (Software Engineer, Percona XtraDB Cluster Lead) as they present Percona XtraDB Cluster 5.7 with ProxySQL for Your MySQL High Availability and Clustering Needs on Thursday, March 22, 2018 at 8:30 am PDT (UTC-7) / 11:30 am EDT (UTC-4).
Percona has developed Percona XtraDB Cluster (based on Galera Cluster) and integrated it with ProxySQL to address MySQL high availability and …
[Read more]Percona announces the release of Percona XtraDB Cluster 5.7.21-29.26 (PXC) on March 2, 2018. Binaries are available from the downloads section or our software repositories.
Percona XtraDB Cluster 5.7.21-29.26 is now the current release, based on the following:
Starting from now, Percona XtraDB Cluster issue …
[Read more]Percona announces the release of Percona XtraDB Cluster 5.6.39-26.25 (PXC) on February 26, 2018. Binaries are available from the downloads section or our software repositories.
Percona XtraDB Cluster 5.6.39-26.25 is now the current release, based on the following:
Starting from this release, Percona XtraDB …
[Read more]Percona announces the release of Percona XtraDB Cluster 5.7.20-29.24 (PXC) on January 26, 2018. Binaries are available from the downloads section or our software repositories.
NOTE: Due to new package dependency,
Ubuntu/Debian users should use apt-get dist-upgrade,
apt upgrade, or apt-get install
percona-xtradb-cluster-57 to upgrade.
Percona XtraDB Cluster 5.7.20-29.24 is now the current release, based on the following:
