Hi, I am looking for active-active clustering solution.
I have one SAN box and two separate NODES, where I need to create active-active cluster. My data directory would be one and mounted to the SAN box for both the nodes. (There will be one sharable data directory for both the nodes) So the query which will come to the load balancer (pgpool) it will route to the node which has a less load. However, it will use the same data directory. It is nothing but the RAC kind of structure. Now, my question is. 1) Is it possible above implementation in PostgreSQL? 2) Has someone implemented cluster in their production environment? Please experts share your thought/comments/experience how I shall achieve that. -- Thanks & Regards Dhaval Jaiswal The information transmitted is intended only for the person or entity to which it is addressed and may contain confidential and/or privileged material. Any review, re-transmission, dissemination or other use of or taking of any action in reliance upon,this information by persons or entities other than the intended recipient is prohibited. If you received this in error, please contact the sender and delete the material from your computer. Microland takes all reasonable steps to ensure that its electronic communications are free from viruses. However, given Internet accessibility, the Company cannot accept liability for any virus introduced by this e-mail or any attachment and you are advised to use up-to-date virus checking software.
