← Back to team overview

maria-discuss team mailing list archive

Re: New Question: backup


Am 10.07.2015 um 14:03 schrieb Pantelis Theodosiou:
Is rsync a valid backup option for a running server?


Without stopping it or at least (flushing and) locking tables first?


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@xxxxxxxxxxxxx
<mailto:h.reindl@xxxxxxxxxxxxx>> 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

    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

Attachment: signature.asc
Description: OpenPGP digital signature