by Kenn Takara | Oct 4, 2019 | Insight for DBAs, MySQL, Percona Software
Starting with the experimental release of Percona XtraDB Cluster 8.0, we have made changes to the SST process to make the process more robust and easier to use. mysqldump and rsync are no longer supported SST methods. Support for mysqldump was deprecated starting with...
by Kenn Takara | Oct 3, 2019 | Insight for DBAs, MySQL, Percona Software, ProxySQL
The problem In PXC 5.6 and 5.7, when using xtrabackup-v2 as the SST method, the DBA must create a user with the appropriate privileges for use by Percona XtraBackup (PXB). The username and password of this backup user are specified in the wsrep_sst_auth variable. This...
by Borys Belinsky | Oct 1, 2019 | Insight for DBAs, MySQL, Percona Software, ProxySQL
Percona is happy to announce the first experimental binary of Percona XtraDB Cluster 8.0 on October 1, 2019. This is a major step for tuning Percona XtraDB Cluster to be more cloud- and user-friendly. This release combines the updated and feature-rich Galera 4, with...
by Walter Garcia | Sep 26, 2019 | Insight for DBAs, MySQL, Percona Software
In a previous post, I showed you how to compile Percona Mysql 5.7 on Raspberry PI 3. Now, I’ll show you how to compile and run the latest version of Percona XtraDB Cluster 5.7.26. We will need at least 3 RaspberryPi 3 boards, and I recommend you use an external...
by Borys Belinsky | Sep 18, 2019 | Insight for DBAs, MySQL, Percona Software, ProxySQL
Percona is happy to announce the release of Percona XtraDB Cluster 5.7.27-31.39 on September 18, 2019. Binaries are available from the downloads section or from our software repositories. Percona XtraDB Cluster 5.7.27-31.39 is now the current release, based on the...
by Borys Belinsky | Sep 17, 2019 | Insight for DBAs, MySQL, Percona Software, ProxySQL
Percona is glad to announce the release of Percona XtraDB Cluster 5.6.45-28.36 on September 17, 2019. Binaries are available from the downloads section or from our software repositories. Percona XtraDB Cluster 5.6.45-28.36 is now the current release, based on the...
by Borys Belinsky | Aug 21, 2019 | MySQL, Percona Software, ProxySQL
ProxySQL 2.0.6, released by MariaDB). It acts as an intermediary for client requests seeking resources from the database. René Cannaò created ProxySQL for DBAs as a means of solving complex replication topology issues. This release includesDocker images for release...
by Borys Belinsky | Aug 12, 2019 | MySQL, Percona Software, ProxySQL
ProxySQL 2.0.5, released by MariaDB). It acts as an intermediary for client requests seeking resources from the database. René Cannaò created ProxySQL for DBAs as a means of solving complex replication topology issues. This release includes Docker images for release...
by Borys Belinsky | Jun 26, 2019 | Insight for DBAs, MySQL, Percona Software, ProxySQL
Percona is glad to announce the release of Percona XtraDB Cluster 5.7.26-31.37 on June 26, 2019. Binaries are available from the downloads section or from our software repositories. Percona XtraDB Cluster 5.7.26-31.37 is now the current release, based on the...
by Borys Belinsky | Jun 19, 2019 | Insight for DBAs, MySQL, Percona Software, ProxySQL
Percona is glad to announce the release of Percona XtraDB Cluster 5.6.44-28.34 on June 19, 2019. Binaries are available from the downloads section or from our software repositories. Percona XtraDB Cluster 5.6.44-28.34 is now the current release, based on the...
by Uday Varagani | Jun 4, 2019 | MySQL, Percona Software
Recently, I received a support request where the customer wanted to convert an INTEGER column to BIGINT on two tables. These tables are related by a foreign key, and it is a 3 node PXC cluster. These tables are 20GB and 82 GB in size and DDL’s on such tables in...
by Borys Belinsky | May 28, 2019 | MySQL, Percona Software, ProxySQL
ProxySQL 2.0.4, released by ProxySQL, is now available for download in the Percona Repository along with Percona’s proxysql-admin tool. ProxySQL is a high-performance proxy, currently for MySQL and database servers in the MySQL ecosystem (like Percona Server for...
by Borys Belinsky | May 7, 2019 | MySQL, Percona Software, ProxySQL
ProxySQL 2.0.3, released by ProxySQL, is now available for download in the Percona Repository along with an updated version of Percona’s proxysql-admin tool. ProxySQL is a high-performance proxy, currently for MySQL, and database servers in the MySQL ecosystem...
by Borys Belinsky | Feb 28, 2019 | Insight for DBAs, MySQL, Percona Software, ProxySQL
Percona is glad to announce the release of Percona XtraDB Cluster 5.6.43-28.32 on February 28, 2019. Binaries are available from the downloads section or from our software repositories. This release of Percona XtraDB Cluster includes the support of Ubuntu 18.10...
by Borys Belinsky | Feb 28, 2019 | Insight for DBAs, MySQL, Percona Software, ProxySQL
Percona is glad to announce the release of Percona XtraDB Cluster 5.7.25-31.35 on February 28, 2018. Binaries are available from the downloads section or from our software repositories. This release of Percona XtraDB Cluster includes the support of Ubuntu 18.10...
by Borys Belinsky | Feb 8, 2019 | MySQL, Percona Software, ProxySQL
ProxySQL 1.4.14, released by ProxySQL, is now available for download in the Percona Repository along with an updated version of Percona’s proxysql-admin tool. ProxySQL is a high-performance proxy, currently for MySQL, and database servers in the MySQL ecosystem...
by Borys Belinsky | Jan 10, 2019 | MySQL, Percona Software, ProxySQL
ProxySQL 1.4.13, released by ProxySQL, is now available for download in the Percona Repository along with an updated version of Percona’s proxysql-admin tool. ProxySQL is a high-performance proxy, currently for MySQL and its forks (like Percona Server for MySQL...
by Dmitriy Kostiuk | Jan 4, 2019 | Insight for DBAs, MySQL, Percona Software, ProxySQL
Percona announces the release of Percona XtraDB Cluster 5.6.42-28.30 (PXC) on January 4, 2019. Binaries are available from the downloads section or our software repositories. Percona XtraDB Cluster 5.6.42-28.30 is now the current release, based on the following:...
by Dmitriy Kostiuk | Jan 4, 2019 | Insight for DBAs, MySQL, Percona Software, ProxySQL
Percona is glad to announce the release of Percona XtraDB Cluster 5.7.24-31.33 (PXC) on January 4, 2019. Binaries are available from the downloads section or from our software repositories. Percona XtraDB Cluster 5.7.24-31.33 is now the current release, based on the...
by Borys Belinsky | Nov 13, 2018 | MySQL, Percona Software, ProxySQL
ProxySQL 1.4.12, released by ProxySQL, is now available for download in the Percona Repository along with an updated version of Percona’s proxysql-admin tool. ProxySQL is a high-performance proxy, currently for MySQL and its forks (like Percona Server for MySQL...