Percona is glad to announce the release of Percona Toolkit 2.2.10 on August 8, 2014 (downloads are available here and from the Percona Software Repositories). This release is the current GA (Generally Available) stable release …[Read more...]
MySQL plays a critical role in OpenStack. It serves as the host database supporting most components such as Nova, Glance, and Keystone and is the most mature guest database in Trove. Many OpenStack operators use Percona open source software including the MySQL drop-in compatible Percona Server and Galera-based Percona XtraDB …[Read more...]
Monitoring flow control in a Galera cluster is very important. If
you do not, you will not understand why writes may sometimes be
stalled. Percona XtraDB Cluster 5.6 provides 2 status
variables for such monitoring:
wsrep_flow_control_paused_ns. Which one should you
What is flow control?
Flow control does not exist with regular MySQL replication, but only with Galera replication. It is simply the mechanism nodes are using when they are not able to keep up with …[Read more...]
We are using Percona Server + TokuDB engine extensively in Percona Cloud Tools and getting real usage operational experience with this engine. So I want to share some findings we came across, in hope it may help someone in their work with TokuDB.
So, one problem I faced is that
SELECT * FROM
INFORMATION_SCHEMA.TABLES is quite slow when I have
thousands tables in TokuDB. How slow? For example…
select * from …[Read more...]