Topic > MySQL Database Case Study - 3366

Data is replicated from the master node; Due to the asynchronous nature of replication, there will be no guarantee that data will be replicated immediately from the master node to all slave nodes. Therefore, this technique is useful depending on the nature of the application. - Follows the Master-Slave model; allows data replication from the MySQL database server (the master) to multiple MySQL database servers (the slave). Any changes in the Master will be recorded in a binary log as events. While each slave will receive a copy of the binary log and will continue to read and execute events. It means that it is a process that allows you to easily maintain multiple copies of MySQL data by having the data automatically copied from a Master database to a Slave. - Slaves do not need to be permanently connected to receive updates from the master. Slaves do not need to be always connected to receive updates from the master. This means that updates can occur via long-distance communications, even via intermittent or temporary connections such as dial-up