How to mySQL replication Master to Slave

Wednesday, July 14th, 2010 266 views

When you have a MySQL database and want to spread the load across multiple servers, you can setup replication. What this does is in almost-realtime copy all commands from the master server to the slave server, keeping the data the same on both servers so both servers can serve requests simultaneously, sharing the load. This [...]

Posted in How to, Knowledge, MYSQL | 1 Comment »

How to mySQL replication Master to Master

Wednesday, July 14th, 2010 207 views

When you have a MySQL database and want to spread the data reads and writes across multiple servers, you can setup master-master replication. What this does is in almost-realtime copy all commands from each server to the other, each acting as both a Master and Slave server. This is NOT a good system for backups, [...]

Posted in Hosting Tutorial | No Comments »