maria-discuss team mailing list archive

[Reindl Harald <h.reindl@xxxxxxxxxxxxx>]

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@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
>         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

Attachment: signature.asc
Description: OpenPGP digital signature