clustering and/or failover?
От | Robert J. Sanford, Jr. |
---|---|
Тема | clustering and/or failover? |
Дата | |
Msg-id | HAEKIEGIHMCDGLOIEKGMIECPCIAA.rsanford@nolimitsystems.com обсуждение исходный текст |
Ответы |
Re: clustering and/or failover?
|
Список | pgsql-general |
thinking in the long-term for my project... i'm looking at trying to set up two database servers with some sort of clustering and/or failover that are talking to a SAN. is this even feasible using postgres? using ms sql server as an example (because that is what my office is currently using) you can set up two database servers that will check each other's heartbeat to see if they are both up. if one goes down then the other takes over responding to requests. you can also set up a cluster that will have both machines responding to requests concurrently. with the data set up on a fibre channel raid box you don't have to worry about replication, you just have to make sure that the data is properly locked by each of the servers (in the clustering example) so that no two machines are updating the same data at the same time. i am fairly certain that postgres cannot handle the first example (heartbeats) but am wondering if it can handle the second example where two instances are hitting the same physical data store. many thanks! rjsjr
В списке pgsql-general по дате отправления: