Re: Data Replication Between Servers

[Jesús Uzcanga]

To replicate to a different database you should use:

replicate-rewrite-db="dbname1->dbname1test"

To replicate to a different server is with a basic MySQL replication configuration just be sure to have the 3306 port open in the master server. (no open port needed in slave server).

___________________________
Ing. Jesús Alfredo Uzcanga
Twitter: @JesusUzcanga

We learn the 20% of what we HEAR,
the 50% of what we SEE,
the 80% of what we DO and
the 95% of what we TEACH.

____________________________________________________________
https://www.linkedin.com/in/jauzcanga/