0

I'd use replication on a big structure. I would know if doing a INSERT on a master will wait for the data to be replicated on all the servers or will end after putting the data on the server the request was run on and then run the replication in background.

Thanks.

azenet
  • 371
  • 6
  • 14
  • The client write request to the master does not have to wait for the replication to finish. Replication runs "in the background". – Girish Rao Jun 09 '12 at 17:06

1 Answers1

0

See here http://dev.mysql.com/doc/refman/5.1/en/replication-howto-masterbaseconfig.html

The master writes changes to the binary log and the binary log is transferred to the slave behind the scenes.

There are a number of steps required for master-slave replication. Depending on your version of MySQL, follow the steps described here

Girish Rao
  • 2,479
  • 1
  • 18
  • 24