MySQL - Replication
Hi all, Mysql replication helps to replicate data from one mysql server (called "Master") to another server or servers (called "slave/slaves" which locates either same machine where Master locates or a remote machine). This is useful in certain occations like when we have to keep a backup of a database while restricting read /write permission of one so that data is secure in that particular database and also when we have to reduce the load over one database so that we get the maximum efficiency. You can replicate all database or a particuler database/s or even a table. So here are the steps to do that. N.B : If you want to replicate in one machine you have to install 2 mysql servers that is running in two ports. I assume that you are aware of installing mysql.Here are the steps to setup replication in a one machine. When you install and run mysql it will ues its default configuration file "my.cnf". So if you want to add extra features you have create your ...