[ADMIN] Do backups on slave. Is it OK?
[ADMIN] Do backups on slave. Is it OK?
От:
Artem Tomyuk <admin@leboutique.com>
Дата:
Hi.
In my setup i currently have standard streaming replication. Currently all backups are done from master.
Is it correct to schedule nightly backups only from slave, i want my master to be 24/7 accessible for clients?
Thanks!
Re: [ADMIN] Do backups on slave. Is it OK?
От:
Stéphane KANSCHINE <stephane@hexack.fr>
Дата:
Le mer. 17 mai, vers 18:27, Artem Tomyuk exprimait : > Hi. Hey ! > In my setup i currently have standard streaming replication. Currently all > backups are done from master. Standard means synchrone, asynchrone ? Is your secondary open to SELECT ? > Is it correct to schedule nightly backups only from slave, i want my master > to be 24/7 accessible for clients? You can do your backup while your primary cluster is up. Regards, -- Stéphane KANSCHINE - http://www.hexack.fr./ - http://www.nuajik.com./ @ stephane@hexack.fr +33 6 64 31 72 52