Thanks for your reply, Vikram and Deven. I do not really know the good source to study. Also I understand yet the concept of "load balancer" and "SQL proxy". I assume "load balancer" can be used for client computer to check the working SQL servers or switching servers. And the "SQL proxy" can be worked as replicate the SQL database between the servers.
I'm planning to do while primary SQL database is working on server#1, I would like to back up the database to the secondly server (server#2). Client computers are usually connecting to the server#1. However if server#1 fails to run the SQL databases, all the client computers may seamlessly switch to the server#2 to continue working. Also after server#1 recovered the PostgreSQL database, somehow I may want to automatically retrieve the data from the server#2. Then client computers switch back to read from the server#1 again. However, if "load balancer" and "SQL proxy" could allowing to run the two PostgreSQL database computers at the same time, and the two servers working as an identically same database, and client computers can be connect to both servers at the same time. I think it would be better replication and clustering solution. Please let me know about "load balancer" and "SQL proxy" on PostgreSQL server. Best regards, Takuya -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Deven Phillips Sent: Wednesday, June 11, 2003 10:13 AM To: [EMAIL PROTECTED] Subject: Re: [luau] PostgreSQL Replication/Clustering solution Takuya, I'm afraid the only method I have heard of doing thiis is to use a load balancer or a SQL proxy. Check freshmeat for SQL proxy and I think that can help. Deven On Tuesday 10 June 2003 09:05 am, Takuya Nakayama / 中山 卓也 wrote: > Hello: > > Is anyone know, how to setup Replication/Clustering on two PostgreSQL > servers? I have two Debian/GNU Linux servers with running PostogreSQL > databases. Two servers are identically same hardware and software > configuration now. Now, I would like to setup one server for primary, the > other server for secondly backup server configuration. With my budget, I’m > unable to add external RAID hardware for the servers. I may possible to > add additional Ethernet cards for data replication between the servers. > Also, client computers should automatically switch the servers when primary > server fails down. If anyone has any idea, please let me know. > > Best regards, > > Takuya Nakayama > > > _______________________________________________ > LUAU mailing list > [EMAIL PROTECTED] > http://videl.ics.hawaii.edu/mailman/listinfo/luau _______________________________________________ LUAU mailing list [EMAIL PROTECTED] http://videl.ics.hawaii.edu/mailman/listinfo/luau
