Jagi C. Sarcilla wrote:
2 IBM server XSeries 345 (Running RedHat Enterprise Linux with PostgreSQL) 1 XTP400 Storage (this will be the Sorage of SQL Data)
This storage is attached to the 2 IBM Server using SCSI Channels, (not fiber). and it will be synchronized the data and Fail-Over .
But HP they said they can do it with there storageworks, is it ibm dont have storagewaorks like hardware?.
we've evaluated the same technique before but aborted the plan due to the storage's single point of failure. instead, we're now using DRBD's (www.drbd.org) Raid 1 over LAN replication.
the replication speed is impressive enough. it is at 20Mbytes/sec (yup, Bytes & not bits) max on a typical 7200 rpm HDD & 100Mbps switch but using a lean linux kernel.
using a disk mirroring technique for database replication should be your last resort since a lot time will be wasted during a full-sync instead of only updating the necessary tables, rows,etc. when using a typical db replicator not to mention the absence of query load-balancing. but there's no doubt that it is effective than those replicators that are not production-ready (those who can't replicate a table with auto-numbered column,etc).
HTH
-- Philippine Linux Users' Group (PLUG) Mailing List [EMAIL PROTECTED] (#PLUG @ irc.free.net.ph) Official Website: http://plug.linux.org.ph Searchable Archives: http://marc.free.net.ph . To leave, go to http://lists.q-linux.com/mailman/listinfo/plug . Are you a Linux newbie? To join the newbie list, go to http://lists.q-linux.com/mailman/listinfo/ph-linux-newbie
