Re: Postgresql under RHCS4

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

 




Hi,

On Mon, 22 May 2006, carlopmart wrote:

No Devrim, I mean which can be the best form to setup replication between master and slave ... and when master goes down, if I put data on slave how can I update master node.

You don't need a replication system there. Use an SAN :)

Here is the schema:

+-------+		+-------+
|Master |		|Slave	|
|	|		|	|
|Node	|		|Node	|
+-------+		+-------+
   |			    |
   --------------------------
		|
		|
	+--------------
	|	      |
	| SAN or NAS  |
	|	      |
	+-------------+


You will install just operating system,PostgreSQL binaries and Cluster tools to both Master and Slave nodes. All $PGDATA will reside in the storage.

If master node goes down, Slave node will mount $PGDATA and continue working. When master node is up, slave will umount $PGDATA, stop its postmaster and will trigger master node and start its postmaster so that data will not be corrupted.

Regards,
--
Devrim GUNDUZ
Kivi Bilişim Teknolojileri         -          http://www.kivi.com.tr
devrim~gunduz.org, devrim~PostgreSQL.org, devrim.gunduz~linux.org.tr
                      http://www.gunduz.org
--

Linux-cluster@xxxxxxxxxx
https://www.redhat.com/mailman/listinfo/linux-cluster

[Index of Archives]     [Corosync Cluster Engine]     [GFS]     [Linux Virtualization]     [Centos Virtualization]     [Centos]     [Linux RAID]     [Fedora Users]     [Fedora SELinux]     [Big List of Linux Books]     [Yosemite Camping]

  Powered by Linux