stevetold.me

Using Percona’s Xtrabackup to back up MySQL to “remote” host

  • Dev Ops and Linux

Quick note about one method to back up MySQL database to another host. There are lots of ways to do this but I use this one the most. Note: you should read and fully understand how to use Xtrabackup. Please read at Percona’s site.

Xtraback up can now use qpress, but I have just not had luck with qpress and so still use the ever trusty pigz. In addition to pigz you will need netcat ( nc).

On the destination hosts ( the host where you want to send the back up to) cd into your directory where you want to create the back up:

cd /mybackups/

and run:

nc host 1234 | gunzip | tar ixvf -

where host is the hostname or ipaddress of the server you want to back up.

 

On host you want to back up ( note: I would recommend this be a slave of the actual master but depending on engine type and size you could do this on master). 

cd to data directory and run

innobackupex --user=user --password=password  --stream=tar ./ | pigz | nc -l 1234

 

you should now see your back up running and sending its copy to remote host.

 

If you are not using Percona’s tools, or you need MySQL support I HIGHLY recommend Percona. They are fantastic.

October 9, 2013 Steve

Post navigation

Leveraging Artificial Intelligence in Home Healthcare to Improve Quality of Care → ← Linux: Find out whats using up your file system with these handy commands

Related Posts

Linux: Find out whats using up your file system with these handy commands

Alas, there are so many good sites already that give you every kind of command line tip available for Linux. So why would I also post them? For absolutely no good reason that’s why! I am […]

Recent Posts

Leveraging Artificial Intelligence in Home Healthcare to Improve Quality of Care

The advent of Artificial Intelligence (AI) in healthcare has enabled the development of more efficient and accurate home healthcare solutions. Some examples of home healthcare solutions enabled [...]

More Info

Linux: Find out whats using up your file system with these handy commands

Alas, there are so many good sites already that give you every kind of command line tip available for Linux. So why would I also post them? For absolutely no good [...]

More Info

Consumer Controlled Cloud Based Medical Records

Introduction The future has arrived. It is time for cloud based integrated healthcare records and time for the individual consumer to maintain control of their own data. Although challenging and [...]

More Info

Mobile Technology is a Home Health Care Game Changer.

Mobile Technology, such as cell phones, “smart” phones, and internet connected tablets, have fundamentally changed the way that the average American accesses the internet, purchases [...]

More Info

Categories

  • Dev Ops and Linux
  • Healthcare

Search

Recent Posts

  • Leveraging Artificial Intelligence in Home Healthcare to Improve Quality of Care
  • Using Percona’s Xtrabackup to back up MySQL to “remote” host
  • Linux: Find out whats using up your file system with these handy commands
  • Consumer Controlled Cloud Based Medical Records
  • Mobile Technology is a Home Health Care Game Changer.

Recent Comments

    Tags

    cloud healthcare privacy
    October 2013
    M T W T F S S
     123456
    78910111213
    14151617181920
    21222324252627
    28293031  
    « Jan   Feb »

    Archives

    • February 2023
    • October 2013
    • January 2013
    • February 2012
    • December 2011
    Powered by WordPress | theme cats456