2010/6/29 Gordan Bobic <[email protected]> > 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 > [email protected] > https://www.redhat.com/mailman/listinfo/linux-cluster >
-- Linux-cluster mailing list [email protected] https://www.redhat.com/mailman/listinfo/linux-cluster
