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...