Articles by sheikhsa

• MySQL Master Master Replication

  Author: sheikhsa • Tags: mysql • Comments: 45

  MySQL Master Master Repliction Tutorial This tutorial describes how to set up MySQL master-master replication. We need to replicate MySQL servers to achieve high-availability (HA). In my case I need two masters that are synchronized with each other so that if one of them drops down, other could take over and no data is lost. Similarly when the first one goes up again, it will still be used as slave for the live one.

  read more... | view as pdf

• MySQL Replication On The Same Machine

  Author: sheikhsa • Tags: mysql • Comments: 2

  This How To explain the replication in MySQL on the same machine. You have large hits, with database driven site and performance, redundancy, security now comes in mind. DBA is now input by many fingers to seek some good solution to make happy faces. So here comes words like Cluster, Replication, Backup, Fail Over and others. So what these are? We currently discuss Replication in terms of a web based database driven site for large hits.

  read more... | view as pdf