1

I want to be able to replicate a local mysql db to an online mysql db over adsl.

My adsl ip is dynamic, so I dont have static ip.

I use a custom application to fill the local db, the app uses quite a lot of cpu and the on webserver that hosts the online db is suffering when I run the app online.

Is there any way to do this ?

Thanks lin advance for any help.

Regards

Potman100

potman100
  • 11
  • 1

1 Answers1

1

You must use MySQL Replication and data transport protocol doesn't metter.

You can use a Dynamic DNS service for get constant DNS address with A or AAAA record (A is for IPv4, AAAA is for IPv6) pointed always to your dynamic adsl IP address.

Svisstack
  • 16,203
  • 6
  • 66
  • 100
  • 1
    Hi, the problem I have is when setting up the config, the slave requires an ip for the master, as I have a dynamic ip on my adsl connection I cant supply an ip. I need to be able to push any changes from the master (Local) db, to the online db, rather than the slave requesting updates from the master. – potman100 Jul 14 '10 at 10:55
  • @potman100: You can use dynamic dns service like a dyndns.org to get const dns with A record poited always to your dynamic adsl. – Svisstack Jul 14 '10 at 21:48
  • He can't, as the config file requires an IP, not a DNS. – davide Nov 27 '12 at 12:14