Clustering SugarCRM with MySQL Galera for High Availability and Performance
SugarCRM is the leader in open source CRM systems, and has been adopted by some of the largest firms, including IBM. The CRM software includes all sales, marketing and support tools out of the box, and...
Webinar Replay: Migrating to MySQL, MariaDB Galera and/or Percona XtraDB Cluster
Thanks to everyone who attended this week’s webinar; if you missed the sessions or would like to watch the webinar again & browse through the slides, they are now available online. Special thanks to Seppo...
Active-Active Alfresco Cluster with MySQL Galera and GlusterFS
Alfresco is a popular collaboration tool available on the open-source market. It is Java based, and has a content repository, web application framework and web content management system. For critical large-scale implementations that require 24*7...
Deploying an Active-Active FreeRadius Cluster with MySQL NDB or Galera
MySQL Cluster is a popular backend for FreeRADIUS, as it provides a scalable backend to store user and accounting data. However, there are situations when the backend database becomes a centralized datastore for additional applications...
Online Schema Upgrade in MySQL Galera Cluster using TOI Method
As a follow-up to the Webinar on Zero Downtime Schema Changes in Galera Cluster, we’ll now walk you through the detailed steps on how to update your schema. The two methods (TOI and RSU) have both...
Webinar Replay: Galera Cluster Best Practices – Zero Downtime Schema Changes
Thanks to everyone who attended yesterday’s webinar; if you missed the sessions or would like to watch the webinar again & browse through the slides, they are now available online. ...
Point-in-Time Recovery for MySQL Galera Cluster
**Update: 6th May, 2016 - This blog post has been updated to reflect ClusterControl v1.3.0 Data protection is vital for DB admins, especially when it involves data that is accessed and updated 24 hours a day....
Webinar Replay: Galera 3.0 Introduction and Cluster Management – with MySQL 5.6, Global Transaction IDs and WAN
The Severalnines & Codership teams came together to co-host two webinar sessions on Galera 3.0, MySQL 5.6, Global Transaction IDs and WAN. The sessions were held during EMEA/APAC as well as NA/LATAM timezones, which worked...
Understanding gcache in Galera
Galera uses a preallocated file with a specific size called gcache, used to store the writesets in circular buffer style. By default, its size is 128MB. In this post, we are going to explore how to leverage...
Avoiding Deadlocks in Galera – Setting Up HAProxy for Single-Node Writes and Multi-Node Reads
Galera cluster has known limitations, one of them is that it uses cluster-wide optimistic locking. This may cause some transactions to rollback. With an increasing number of writeable masters, the transaction rollback rate may increase, especially...
Live Database Migration from MMM to MariaDB Galera Cluster
This is a guest post from Igor Shevtsov, a MySQL DBA based in Twickenham, UK. Igor has had the opportunity to deploy and manage different types of high availability MySQL solutions, and we invited him...
Migrating MySQL Galera Cluster to a New Data Center Without Downtime
Are you tired and frustrated with your hosting or cloud provider? Have you seen a constant degradation in service levels and responsiveness? Or was the public cloud a bit too expensive after all, and you’re...