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...
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...
Clustering MySQL Backend in OpenStack
OpenStack uses a database to store data for all OpenStack services such as compute nodes available, running instances, state and so on. The DB takes part in every user request, from listing all instances to...
How to Scale Joomla on Multiple Servers
Joomla! is estimated to be the second most used CMS on the internet after WordPress, with users like eBay, IKEA, Sony, McDonald’s and Pizza Hut. In this post, we will describe how to scale Joomla...
Replicate from a MySQL Server into a Galera Cluster
This article describes how to setup replication between a regular MySQL server and a Galera Cluster. The regular MySQL Server is the MASTER , and one of the Galera nodes will be the SLAVE: In...
How to Cluster Magento, nginx and MySQL on Multiple Servers for High Availability
Magento is an open-source e-commerce platform built on Zend PHP and MySQL. It is widely adopted by online retailers with some 150,000 sites known to use it. Single server setups are easy to set up,...
Scaling WordPress and MySQL on Multiple Servers for Performance
Over the years, WordPress has evolved from a simple blogging platform to a CMS. Over seven million sites use it today, including the likes of CNN, Forbes, The New York Times and eBay. So, how...
Using HAProxy with Your Database Cluster
Severalnines s9s_haproxy script allows you to install HAProxy and loadbalance over the MySQL servers in your cluster. To learn more about HAProxy and SQL load balancing, see this HAProxy Tutorial. By defauly s9s_haproxy installs HAProxy...
Scaling Drupal on Multiple Servers with Galera Cluster for MySQL
This post shows you how to move from a single instance Drupal/MySQL to a multi-server environment. A well designed multi-server deployment not only allows Drupal to scale, but will also enhance redundancy by removing single...
Nagios Plugin for ClusterControl
Nagios is a very popular open source IT infrastructure monitoring tool, used by sysadmins to watch out for problems in their systems. If you use Nagios and would like to utilize it to monitor your...