We help IT Professionals succeed at work.

MySQL: Load balancing replication

Hi there,

We have a MySQL database that serves two sites. One local and one remote via VPN.

I would like to have a MySQL server on both sites:
1-MySQL clients would connect to the local site MySQL Server.
2-Both servers need to sync database changes between them in almost real time.

What would be the best solution?

Thanks for your help,
Rene
Comment
Watch Question

Author

Commented:
Sorry dsine for my late response.

Your link help.

Cheers,
Rene