MySQL

Common Replication Administration Tasks

Common Replication Administration tasks : 1. Checking the Replication Status. The most common task when managing a replication process is to ensure that replication is taking place and that there has been no errors between the slave and the master. On Slave Server (192.168.36.2) mysql>     Show slave statusG The key fields from the status report to examine are: Slave_io_state: indicates…

Continue Reading

MySQL

MySQL Replication

Implementing Master-Slave Replication: Master-Slave replication is mainly for scale-out solutions- spreading the load among the multiple slaves to improve the performance. And for Analytics – while the analysis of the information can take place on the slave without affecting the performance of the master. The target uses for Replication in MySQL include: Scale-out solutions: spreading the load among multiple slaves…

Continue Reading