[Date Prev][Date Next]   [Thread Prev][Thread Next]   [Thread Index] [Date Index] [Author Index]

Re: [Linux-cluster] postgres cluster without shared storage





2010/6/29 Gordan Bobic <gordan bobich net>
On 06/29/2010 01:26 PM, ESGLinux wrote:
Hi all,

I need to mount a two nodes cluster with postgres as service. I have
mounted it in the past but with a shared storage and using GFS but now I
don´t have this element.

Any particular reason why you cannot use DRBD to provide that element without a standalone SAN?


the reason is that I haven´t done it before ;-). perhaps it´s time to take a look at DRBD...
 

The idea is to have a master node with all the data in its own disk and
have a mechanism to replicate this data to the slave node in its own
disk. If the master goes down the slave begin to give the service and
the flow of data will go from this node to the other one. (the slave
node becomes the master one)

Have a look at Bucardo replication system for PostgreSQL:
http://bucardo.org/



 
It is as similar a solution as PostgreSQL has available to MySQL's replication.

It's master-slave only, though, there is no provision for master-master replication like in MySQL (but master-master is riddled with race conditions anyway, and you shouldn't be using it if you don't understand the edge cases that are likely to break your app).

Have a look here for more info on PostgreSQL's replication/clustering functionality:

http://wiki.postgresql.org/wiki/Replication,_Clustering,_and_Connection_Pooling


Interesting link, I´m going to evaluate this solutions
 
You're probably better off asking about this stuff on the PostgreSQL mailing lists, though.


I´ll do it, 

Thank you all for your answers

 
Gordan



ESG
 


[Date Prev][Date Next]   [Thread Prev][Thread Next]   [Thread Index] [Date Index] [Author Index]