LXer: How To Set Up Database Replication In MySQL

LXer · 01-16-2006, 02:46 AM

Published at LXer:

This tutorial describes how to set up database replication in MySQL. MySQL replication allows you to have an exact copy of a database from a master server on another server (slave), and all updates to the database on the master server are immediately replicated to the database on the slave server so that both databases are in sync.

Read More...

XOR007 · 06-23-2006, 08:53 AM

Hi All.

I have setup MySQL replication with 1 slave PC1 and 1 master: PC2

inserts, deletes, updates ... on the master get replicated to the slave. but I tried to insert on the slave it does not replicate go the master. Is that normal? Is there a slave flag that I must set to allow it to update the master when it comes back online?