Обсуждение: [ADMIN] Do backups on slave. Is it OK?

Поиск
Список
Период
Сортировка

[ADMIN] Do backups on slave. Is it OK?

От
Artem Tomyuk
Дата:
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
Дата:
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