Understanding the MySQL Galera Cluster and MariaDB Cluster Diagnostic Logs
In a previous post, we discussed the error log as a source of diagnostic information for MySQL. We’ve shown examples of problems where the error log can help you diagnose issues with MySQL. This post...
High Availability MySQL on cPanel with Galera Cluster
cPanel is a very popular Linux hosting control panel, used not only by hosting providers but also enterprise and goverment bodies. For large scale hosting environments hosting mission critical databases, how do you integrate cPanel...
Webinar Replay: Schema Changes for MySQL Replication & Galera Cluster
Thanks to everyone who joined us for our recent live webinar on ‘Schema Changes for MySQL Replication & Galera Cluster’ led by Krzysztof Książek, Senior Support Engineer at Severalnines. The replay and slides to the...
How to Preform an Online Upgrade of MariaDB Galera Cluster 5.5 to MariaDB 10
The MariaDB team released a GA version of MariaDB Galera Cluster 10 in June 2014. MariaDB 10 is the equivalent of MySQL 5.6, and therefore, packed with lots of great features. In this blog post,...
How to Perform an Online Upgrade of Galera Cluster to MySQL 5.6
Oracle released a GA version of MySQL 5.6 in February 2013, Codership released the first GA in their patched 5.6 series in November 2013. Galera Cluster for MySQL 5.6 has been around for almost 2...
Architecting for Failure – Disaster Recovery of MySQL Galera Cluster
Failure is a fact of life, and cannot be avoided. No IT vendor in their right mind will claim 100% system availability, although some might claim several nines :-) We might have armies of ops...
Deploying MySQL Galera Cluster Using Vagrant
Please note: The content of this blog is outdated. Please refer to our other blogs or resources on related topics. Or contact us via our online chat if you have any questions. Setting up environments, starting...
Leveraging AWS Tools to Speed up the Management of Galera Cluster on Amazon Cloud
We previously covered basic tuning and configuration best practices for MyQL Galera Cluster on AWS. In this blog post, we’ll go over some AWS features/tools that you may find useful when managing Galera on Amazon...
5 Performance Tips for Running Galera Cluster on AWS Cloud
Amazon Web Services is one of the most popular cloud environments. Galera Cluster is one of the most popular MySQL clustering solutions. This is exactly why you’ll see many Galera clusters running on EC2 instances....
Monitoring Galera Cluster – Understanding and Optimizing IO-Related InnoDB Metrics
This blog post is a follow up to our previous post on monitoring CPU-related InnoDB metrics in Galera Cluster. One of the main issues in terms of scalability of MySQL (and thereby also Galera) is...
Webinar Replay: How to Monitor MySQL Galera Cluster, MariaDB Cluster & Percona XtraDB Cluster
Thanks to everyone who attended and participated in this week’s webinar on 'How to Monitor Galera Cluster'. If you missed the sessions or would like to watch the webinar again & browse through the slides,...
Database Security – How to Fully SSL-Encrypt Your MySQL Galera Cluster
Data security is a hot topic for many companies these days. But for those who need to adhere to security standards like PCI DSS or HIPAA, security is not an option. We showed you sometime...