Re: Data replication through disk replication
От | Ben |
---|---|
Тема | Re: Data replication through disk replication |
Дата | |
Msg-id | E03C64A6-55AC-4EF3-981E-42C6A5F72FDF@silentmedia.com обсуждение исходный текст |
Ответ на | Re: Data replication through disk replication (Alvaro Herrera <alvherre@commandprompt.com>) |
Список | pgsql-general |
You pay a price writes, but with write caching enabled on your (battery-backed, of course) RAID card and using gigabit, it's easy to get >100MB/s throughput. It's also easy to replicate different block devices over separate network links, if that becomes your bottleneck. On May 18, 2007, at 6:14 PM, Alvaro Herrera wrote: > Ben wrote: >> If you're just looking for a way to have high availability and >> you're ok >> being tied to linux, DRBD is a good way to go. It keeps things >> simple in >> that all changes are replicated, it won't say an fsync is finished >> until >> it's finished on the remote host too, > > Oh, so that's how it works. I assume performance must be, huh, not > stellar? > > -- > Alvaro Herrera http:// > www.CommandPrompt.com/ > The PostgreSQL Company - Command Prompt, Inc. > > ---------------------------(end of > broadcast)--------------------------- > TIP 9: In versions below 8.0, the planner will ignore your desire to > choose an index scan if your joining column's datatypes do not > match
В списке pgsql-general по дате отправления: