Hello,

I am looking for information about replication strategies on mySQL
databases. I am particularly interested in "dynamic" replication, i.e
how to have the two databases (the original and the replicated one)
always identical, and that when some data is modified in the original
database, the same modification is immediately done in the replicated
database.

Thank you for any link or information about these strategies and
possibilities.

--
Il ne faut pas confondre les temps sont durs et les victimes s’immolent
(Yvan Delporte)

You can configure in my.cnf ,set one server as master and another as
slave, all the changes on master's databases will be logged by master,
then the I/O thread on slave will read the log, and the SQL thread on
slave will do changing on databases on slave.

ByB <nomail (AT) nomail (DOT) com> wrote:
R.T.F.M!

http://dev.mysql.com/doc/refman/5.1/en/replication.html


XL