Re: [PERFORM] Reliability with RAID 10 SSD and Streaming Replication

2013-05-19 Thread Cuong Hoang
perfectly fine. > > So this is what I'd suggest: > > 1) use SSD for data files, SAS RAID1 for WAL on the master > 2) setup WAL archiving (base backup + archive on SAS system) > 3) update the base backup daily (incremental recovery) > 4) in case of crash, keep WA

Re: [PERFORM] Reliability with RAID 10 SSD and Streaming Replication

2013-05-16 Thread Cuong Hoang
Fri, May 17, 2013 at 10:06 AM, Tomas Vondra wrote: > Hi, > > On 16.5.2013 16:46, Cuong Hoang wrote: > > 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 Samsu

Re: [PERFORM] Reliability with RAID 10 SSD and Streaming Replication

2013-05-16 Thread Cuong Hoang
erlin Moncure wrote: > >> On Thu, May 16, 2013 at 1:34 PM, Jeff Janes wrote: >> > On Thu, May 16, 2013 at 7:46 AM, Cuong Hoang >> wrote: >> >> >> >> Hi all, >> >> >> >> Our application is heavy write and IO utilisation has be

[PERFORM] Reliability with RAID 10 SSD and Streaming Replication

2013-05-16 Thread Cuong Hoang
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 choi