Database Replication in MySQL

[Muhammad Waqar]

I have created a large employee database in MySQL. I want to know the use of database Replication in MySQL. Does any one how to set up database replication in MySQL? Is it applicable in all database or selected database? What are the advantages?

[Zecho]

MySQL replication has many uses including read scalability, backups, failover, online maintenance, upgrade testing and verification, Replication in MySQL gives the asynchronous replication, which means there are two server one it acts as master and another one slave. Software upgrades, alternative data or structure for performance queries and even benchmarking to name the popular uses.

[absolute55]

Replication allows you to take one database, make an exact copy of it on another server, and set one of them (the slave) to take all its updates from the other (the master). MySQL Replication is powerful technology, but many things can trip you up. Sometimes the slaves get out of sync with the master, or dump errors into their logfiles.

[kelfro]

Even though setting up MySQL Replication is a relatively simple task, there are several things that can be configured. Replication is not a backup policy. MySQL provides asynchronous replication in which a master database server is replicated to one or more slave server. You can configure the replication to include all or select databases or only select tables.

[Katty]

MySQL Cluster is a powerful peering system to add high availability and replication across multiple database servers. When the master-slave replication is configured a master is given a unique id. However, it is not possible to figure out the master's id while talking to the slave. It's not perfect, though. Using features of MySQL 5.0 and 5.1, it's possible to build a master/slave replication system with fail-over.

[MindSpace]

Replication capabilities allowing the databases on one MySQL server to be duplicated on another. MySQL replication can increase performance by allowing developers to spread queries over two servers. Replication is not a guarantee that the slave will be in sync with the master at any one point in time.