[Linux-cluster] postgres cluster without shared storage

[ESGLinux]

2010/6/29 Gordan Bobic <gordan at 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


> --
> Linux-cluster mailing list
> Linux-cluster at redhat.com
> https://www.redhat.com/mailman/listinfo/linux-cluster
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://listman.redhat.com/archives/linux-cluster/attachments/20100630/1cdc022d/attachment.htm>