by Marco Tusa | Oct 9, 2020 | Benchmarks, Cloud, MySQL, ProxySQL
For what reason should I use a real multi-primary setup? To be clear, not a multi-writer solution where any node can become the active writer in case of needs, as for Percona XtraDB Cluster (PXC) or Percona Server for MySQL using Group_replication. No, we are talking...
by David Quilty | Oct 7, 2020 | Insight for DBAs, Insight for Developers, Webinars
Any good system must be built to expect the unexpected. None are perfect and at some point, something WILL happen to render the system non-operational causing failure. Join Dimitri Vanoverbeke, Senior Percona Engineer, as he discusses the concepts of High...
by Robert Bernier | May 29, 2020 | Insight for DBAs, PostgreSQL
Taking our cue from Peter Zaitsev’s article on MySQL Performance Bottlenecks, I’m going to talk a little about the PostgreSQL perspective of removing bottlenecks caused by high traffic. Many stacks these days are implemented by trusting the Object...
by Vadim Tkachenko | Apr 16, 2020 | MySQL, Percona Software
Percona XtraDB Cluster 8.0 is in the final stretch before GA release and we have pre-release packages available for testing, and I wanted to see how Percona XtraDB Cluster 8.0 performs in CPU and IO-bound scenarios, like in my previous posts about MySQL Group...
by Vadim Tkachenko | Apr 14, 2020 | MySQL, Percona Software
Percona XtraDB Cluster 8.0 is on the final stretch before GA release, and we have pre-release packages available for testing. I wanted to see how Percona XtraDB Cluster 8.0 performs in CPU and IO-bound scenarios, like in my previous posts about MySQL Group...
by Peter Zaitsev | Apr 7, 2020 | Database Trends, Insight for DBAs, MySQL
This is a three-part blog series that focuses on dealing with an unexpected high traffic event as it is happening. Part one can be found here, and part two can be found here. 13. Configure MySQL Server Properly Complexity:Medium Potential Impact: High A poorly...
by Peter Zaitsev | Apr 6, 2020 | Database Trends, Insight for DBAs, MySQL
This is a three-part blog series that focuses on dealing with an unexpected high traffic event as it is happening. Part one can be found here and part three can be found here. 7. Get More Memory Complexity: Low Potential Impact: High If your data does not fit into...
by Peter Zaitsev | Apr 3, 2020 | Database Trends, Insight for DBAs, MySQL
This is a three-part blog series. Part two is located here, and part three can be found here. There was no reason to plan for it, but the load on your system increased 100%, 300%, 500%, and your MySQL database has to support it. This is a reality many online systems...
by Borys Belinsky | Mar 19, 2020 | Cloud, Insight for DBAs, MySQL, Percona Software
Percona is happy to announce the experimental release of Percona XtraDB Cluster 8.0. This is a major step for tuning Percona XtraDB Cluster to be more cloud- and user-friendly. This is the second experimental release that combines the updated and feature-rich Galera...
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 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 | 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 Walter Garcia | Apr 10, 2019 | MySQL, ProxySQL
In my previous post, some time ago, I wrote about the new cluster feature of ProxySQL. For that post, we were working with three nodes, now we’ll work with even more! If you’ve installed one ProxySQL per application instance and would like to work up to...
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 Marco Tusa | Feb 20, 2019 | MySQL, Percona Software, ProxySQL
ProxySQL in its versions up to 1.x did not natively support Percona XtraDB Cluster (PXC). Instead, it relied on the flexibility offered by the scheduler. This approach allowed users to implement their own preferred way to manage the ProxySQL behaviour in relation to...
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...