Category Archives: MySQL Cluster

Notes for Installing Percona Xtradb Cluster 5.7 on CentOS 5

Percona supports Percona Xtradb Cluster 5.7 on CentOS 6 and CentOS 7, but not CentOS 5. You can install the RPMs or tarball binary, but on start will see various package dependencies that can’t be resolved on openssl.0.10 and others. … Continue reading

Posted in Linux, MySQL, MySQL Cluster, Open Source, Oracle, Tech | Leave a comment

Poor Man’s Profiling with the Linux ts Command

Sometimes when you’re investigating server performance issues, you don’t have the luxury of a full development suite installed with tools like a profiler. It turns out that the linux ts command, included in moreutils, can be surprisingly helpful. It can … Continue reading

Posted in API Programming, MySQL, MySQL Cluster, Open Source, Perl, Tech | Leave a comment

Percona Clustercheck Improved Error Handling Patch

Here’s my Github pull request for improved error handling in Percona’s clustercheck utility, used by haproxy for health-checking a Percona XtraDB Cluster. It adds two features: 401 Unauthorized response for failed authentication 404 Not Found response if the mysql program … Continue reading

Posted in API Programming, Linux, MySQL, MySQL Cluster, Open Source, Tech | Leave a comment

MySQL Blackhole Storage Engine for Fun and Profit

Recently I did some work with MySQL and MySQL Cluster, where the dev and test environments ran on CloudStack VMs, and a reporting server ran on AWS EC2. The MySQL Blackhole storage engine could have helped in two cases: disk … Continue reading

Posted in Business, Cloud, MySQL, MySQL Cluster, Open Source, Tech | Leave a comment

MySQL 5.6 Views and Stored Procedures Tips

I recently tuned an existing application that used dozens of views and hundreds of stored procedures using MySQL 5.6. There seems to be three attitudes towards using views and stored procedures (SPs) with MySQL: don’t use them at all to … Continue reading

Posted in MySQL, MySQL Cluster, Open Source, Oracle, Tech | Leave a comment