0

Can anyone tell me what is the easy way to backup 500Gb datasize on windows environment ? My physical memory is 672 GB RAM on server? Which tools will be fast to back up and restore? Note : mysqldump will take more than 1 week for 500GB datasize Any suggestion with details and is there way any way around that it can take within 2 days?

  • Do you have slave and not used for production purpose? – Mannoj Jun 9 '17 at 9:20
  • No , I dont have slave server . This is the production server @Mannoj – SAM AB Jun 9 '17 at 10:36
  • @McDonalds I'm not understanding what u r suggested me. Can you please tell me details , do we have any tools or is there any workaround ? – SAM AB Jun 10 '17 at 5:37
  • out of 500Gb , weekly the data will truncate and add same millions of rows, there are three tables which weekly used for transaction. combined them , there are 200 Gb which changes regularly every month. My server is : windows 2012 server R2 Intel Xeon Cpu 2 GHZ ( 2 processor) 672 Installed physically RAM @McDonald's – SAM AB Jun 13 '17 at 5:18
  • Have you read dev.mysql.com/doc/refman/5.7/en/backup-methods.html ? mysqldump is just one (bad) way to do a backup. – Colin 't Hart Jun 13 '17 at 7:13
0

You may give it a try using percona backup alpha version for Windows - Download_Link .

Below are the steps after installation in Windows Bash.

C:\Users\lorainne>bash

C:\Users\lorainne$ xtrabackup –user=root –password=secret -host=127.0.0.1 –port=3306 –backup –target-dir=\test

I haven't tested this but this seems to be a working command, ensure that you have https://msdn.microsoft.com/en-us/commandline/wsl/release_notes - Build 14332 fixed to have prctl system call supported on Windows.

  • Thanks @Mannoj , Can you please tell me what are the steps to take backup using xtrabackup on windows environment after installation of backup alpha version? – SAM AB Jun 13 '17 at 4:45
  • try executing the above commands. You may verify the commands using xtrabackup --help. – Mannoj Jun 13 '17 at 6:02
  • Thanks @Mannoj , do u have any idea how much time will take for 200 Gb database backup using xtrabackup – SAM AB Jun 13 '17 at 6:34
  • Depends upon ur free space in ram, cpu processing capacity, IO read/write capacity if not you may take once and see how long it takes and start keeping your bench mark. But it can't take more than 10hrs in decent provisioned servers. First time I'm hearing 672GB RAM. I hope your config and server capacity should be more. Check the IOPs and CPU and run it on non-peak hrs. – Mannoj Jun 13 '17 at 6:50
  • Yes its 672 GB RAM, normally IO read/write capacity good.@Mannoj – SAM AB Jun 14 '17 at 5:10

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.