| From: | Cuong Hoang <climbingrose(at)gmail(dot)com> |
|---|---|
| To: | pgsql-performance(at)postgresql(dot)org |
| Subject: | Reliability with RAID 10 SSD and Streaming Replication |
| Date: | 2013-05-16 14:46:10 |
| Message-ID: | CAAE-9WHMycEZOB5J6HKME5AZLEdL2hYF+FV8hzbLksJinq=EJg@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-performance |
Hi all,
Our application is heavy write and IO utilisation has been the problem for
us for a while. We've decided to use RAID 10 of 4x500GB Samsung 840 Pro for
the master server. I'm aware of write cache issue on SSDs in case of power
loss. However, our hosting provider doesn't offer any other choices of SSD
drives with supercapacitor. To minimise risk, we will also set up another
RAID 10 SAS in streaming replication mode. For our application, a few
seconds of data loss is acceptable.
My question is, would corrupted data files on the primary server affect the
streaming standby? In other word, is this setup acceptable in terms of
minimising deficiency of SSDs?
Cheers,
Cuong
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Merlin Moncure | 2013-05-16 17:31:48 | Re: Reliability with RAID 10 SSD and Streaming Replication |
| Previous Message | Shaun Thomas | 2013-05-16 12:47:08 | Re: Thinking About Correlated Columns (again) |