Before we go into how to set up master-slave replication in MySQL, let us talk about some of the reasons I have set up master-slave replication using MySQL. 1) Offload some of the queries from one server to another and spread the load: One of the biggest advantages to have master-slave set up in MySQL…
Tag: mysql
CentOS 6 LAMP Install (Apache MySQL & PHP) via YUM
This tutorial will walk you through the process of installing a CentOS 6 LAMP server, LAMP stands for Linux Apache MySQL PHP and is often refereed to as a “LAMP Stack“. CentOS is a popular choice for web servers as it’s based on RHEL (Redhat Linux), this tutorial will use YUM to install the required packages. This…