Monday, February 13, 2017

MySql transfer / update (a bit specific)

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

No comments:

Post a Comment

linux - How to SSH to ec2 instance in VPC private subnet via NAT server

I have created a VPC in aws with a public subnet and a private subnet. The private subnet does not have direct access to external network. S...