live update of tables

[agilo]

Hi Guys,

I do have the following problem:
A local server running MySql includes the database A, another server in another region (connected to the internet) includes a mirror database of A. What I need is to live update the tables of the mirror database via a secure connection. Both networks have an internet connection

Can anybody help...

Thanks in advance,

agilo

 

[TonyGroves]

Have a look at replication:

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

 

[agilo]

Thank you TonyGroves, I will take a look at it..

 

[ericbrunson]

FWIW, I tried for weeks to get replication working with 3.x and about pulled my hair out. When I upgraded to 4.0 all my troubles went away.

 

[agilo]

Thanks Guys, I will try it out