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?
no there 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 nothing there 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.reindl@thelounge.net <mailto:h.reindl@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