Am 10.07.2015 um 14:03 schrieb Pantelis Theodosiou:
Is rsync a valid backup option for a running server?
no
Without stopping it or at least (flushing and) locking tables first?
nothere are files in use and you can't get a safe, consistent snapshot of the datadir when the server is running, what you can do is one hot rsync, then stop mysqld and make a second rsync which should be fast because it only needs to copy the recent changes and fire up the daemon after that
but that's just a workaround losing caches and buffers for nothingthere is no problem start a replication-slave instance even on the same host while it's prferred to have it on a different because that brings you a "realtime backup" if the master host crashs unclean and refuses to start mysqld because damage of datafiles
On Wed, Jul 8, 2015 at 3:53 PM, Reindl Harald <h.rei...@thelounge.net <mailto:h.rei...@thelounge.net>> wrote: Am 08.07.2015 um 16:40 schrieb AskMonty KB: A new question has been asked in "MariaDB Documentation" by gtrymore. Please answer it at http://mariadb.com/kb/en/backup/ as the person asking the question may not be subscribed to the mailing list. -------------------------------- How do you back up a mariadb server and what is /var/lib/mysql directory -------------------------------- power down the replication slave and rsync /var/lib/mysql to the backup-location or whatever folder is configured as datadir - to be honest you could have typed the same in a google search
signature.asc
Description: OpenPGP digital signature
_______________________________________________ Mailing list: https://launchpad.net/~maria-discuss Post to : maria-discuss@lists.launchpad.net Unsubscribe : https://launchpad.net/~maria-discuss More help : https://help.launchpad.net/ListHelp
