Risk of data corruption/loss?
От | Niels Kristian Schjødt |
---|---|
Тема | Risk of data corruption/loss? |
Дата | |
Msg-id | 90758F5A-C637-4EE8-88B8-EF9AFA5AF576@autouncle.com обсуждение исходный текст |
Ответы |
Re: Risk of data corruption/loss?
Re: Risk of data corruption/loss? |
Список | pgsql-performance |
I'm considering the following setup: - Master server with battery back raid controller with 4 SAS disks in a RAID 0 - so NO mirroring here, due to max performancerequirements. - Slave server setup with streaming replication on 4 HDD's in RAID 10. The setup will be done with synchronous_commit=offand synchronous_standby_names = '' So as you might have noticed, clearly there is a risk of data loss, which is acceptable, since our data is not very crucial.However, I have quite a hard time figuring out, if there is a risk of total data corruption across both server inthis setup? E.g. something goes wrong on the master and the wal files gets corrupt. Will the slave then apply the wal filesINCLUDING the corruption (e.g. an unfinished transaction etc.), or will it automatically stop restoring at the pointjust BEFORE the corruption, so my only loss is data AFTER the corruption? Hope my question is clear
В списке pgsql-performance по дате отправления: