How to Avoid SST When Adding a New Node to MySQL Galera Cluster
State Snapshot Transfer (SST) is a way for Galera to transfer a full data copy from an existing node (donor) to a new node (joiner). If you come from a MySQL replication background, it is...
MySQL Database Management Common Operations – Replication Topology Changes
MySQL replication has been available for years, and even though a number of new clustering technologies showed up recently, replication is still very common among MySQL users. It is understandable as replication is a reliable...
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...
An Overview of MySQL Database High Availability
There are many many approaches to MySQL high availability - from traditional, loosely-coupled database setups based on asynchronous replication to more modern, tightly-coupled architectures based on synchronous replication. These offer varying degrees of protection, and...
MySQL Backup and Restore Best Practices
It is not uncommon for developers, network/system administrators, or DevOps folks with general backgrounds to find themselves in a DBA role at some point in their careers. So, what does a DBA do? In the...
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,...
SQL Load Balancing Benchmark – Comparing Performance of MaxScale vs HAProxy
In a previous post, we gave you a quick overview of the MaxScale load balancer and walked through installation and configuration. We did some quick benchmarks using sysbench, a system performance benchmark that supports testing...
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...
Deploying an asynchronous slave to MySQL Galera Cluster
Due to its synchronous nature, Galera performance can be limited by the slowest node in the cluster. So running heavy reporting queries or making frequent backups on one node, or putting a node across a...
How to Cluster Atlassian Server Apps in Your Data Center – JIRA, Confluence, Stash with MySQL Galera Cluster
Atlassian apps are widely used by development teams to facilitate software development and collaboration. For larger teams who require enterprise-grade tools, you might want to host the applications in your own data center and cluster...
Webinar Replay: A DevOps Guide to Database Infrastructure Automation for eCommerce
Thanks to everyone who attended and participated in last week’s webinar on ‘A DevOps Guide to Database Infrastructure Automation for eCommerce’. If you missed the sessions or would like to watch the webinar again &...
How to Deploy High Availability CloudStack/CloudPlatform with MariaDB Galera Cluster
Apache CloudStack is a turnkey orchestration platform to deliver IaaS clouds. As a cloud infrastructure scales to hundreds or thousands of servers, with production environments supporting multiple applications and services, high availability becomes a key...