MySql transfer / update (a bit specific)
- by Jeff
before posting I was digging whole site but didn't find help for my problem, so I hope someone will help...
Facts:
30 Gb mysql database on remote server (about 20.000.000 rows)
data are once weekly updated in local network (mysql)
I need to transfer/replace local updated database with remote
connection is about 2mb (real mb, not mbps) up/down
Point is that I can't have 'down time' of remote mysql server.
Until now I
Tried:
navicat data sync - Ok, but take about 3 days to finish
dbForge - ok but need 5 days to finish
mysql dump transfer to remote server and execution - about day, but a lot of downtime
rsync folder with database /mysql/lib/MY_DATABASE - 4 hours, but after that I need to execute always 'repir on remote server' which takes about 2 hours, and a lot of down time
mysql dump piped from cl to directly goto server - still now satisfied many problems
I could give you more things that I tried...
mysql replication - slow
Anyase, what is best,best way to:
refresh remote mysql on weekly level
and in same time to have 0 sec down time nor huge server load
If you have any idea please share
