Another streaming replication question
От | Mark Steben |
---|---|
Тема | Another streaming replication question |
Дата | |
Msg-id | CADyzmyys52hHwdYXAx3FPeTHuPk3V_ewL2bCoOXNfRieeRqPjA@mail.gmail.com обсуждение исходный текст |
Ответы |
Re: Another streaming replication question
Re: Another streaming replication question |
Список | pgsql-admin |
Good morning,
--
Thank you all for your responses to my questions about streaming/cascading replication. I have them ironed out and running on three postgres 9.4 sandbox servers.
My question is not 'how to ' but more 'best practices'. We currently have hot standby non-streaming replication with one master serving two standbys in parallel. We wish to convert
to streaming replication. My concern is that the logshipping load can be quite high - up to 40 16MB logs per minute (during off-hours maintenance). In our current hot standby
environment the logs can queue up on the master side during this period - eventually, during times of lower load they do catch up. So, a couple questions:
1. Can streaming replication work in this high-load situation?
2. What, if anything, can I do to make it work better? Perhaps convert to cascade? Master -->standby1 ---> standby2
I have attached the postgres.conf file for our master for reference.
Any insights welcome. Thank you.
Mark Steben
Database Administrator
@utoRevenue | Autobase
CRM division of Dominion Dealer Solutions
95D Ashley Ave.
West Springfield, MA 01089
t: 413.327-3045
f: 413.383-9567
Database Administrator
@utoRevenue | Autobase
CRM division of Dominion Dealer Solutions
95D Ashley Ave.
West Springfield, MA 01089
t: 413.327-3045
f: 413.383-9567
www.fb.com/DominionDealerSolutions
www.twitter.com/DominionDealer
www.drivedominion.com
Вложения
В списке pgsql-admin по дате отправления: