RE: Shortest offline window on database migration

Поиск
Список
Период
Сортировка
От Steven Winfield
Тема RE: Shortest offline window on database migration
Дата
Msg-id E9FA92C2921F31408041863B74EE4C2001BD6F949F@ccpmaildag02.cantab.local
обсуждение исходный текст
Ответ на Re: Shortest offline window on database migration  (Tomas Vondra <tomas.vondra@2ndquadrant.com>)
Ответы Re: Shortest offline window on database migration
Список pgsql-performance
>Has anyone been through this type of problem?
>

You could set up a new, empty db (with checksums enabled, etc.) on the new hardware and then use logical replication to
syncacross all the data from the existing cluster. 
(This logical replica could be doing binary replication to hot standbys too, if you like).

When the sync has finished you could perhaps gradually shift read-only load over to the new db, and finally switch
writeload too - your downtime would then be limited to how long this final cut-over takes. 

Steve.




В списке pgsql-performance по дате отправления:

Предыдущее
От: Tomas Vondra
Дата:
Сообщение: Re: Shortest offline window on database migration
Следующее
От: Haroldo Kerry
Дата:
Сообщение: Re: Shortest offline window on database migration