--- On Sat, 7/24/10, Anand Kapoor <anand...@gmail.com> wrote: > Could somebody point me to the best place to get started if > both nodes of a > MYSQL cluster need to be active.
Ideally, something like http://dev.mysql.com/tech-resources/articles/mysql-cluster-for-two-servers.html Investigate using a load balancer in such a case. > Also how best to achieve > this if the > instances are segregated over the WAN ? Thats fraught with risks. Remember that a dropped TCP/IP connection is essentially a node failure as far as mysql is concerned. The network partitioning itself will have to be tuned. So you're looking at a very unreliable connection over a WAN. Clustering over different subnets is never really recommended. IIRC, you can set a connection between ndbd nodes with some localization options - but MySQL unlike actual distributed databases like Cassandra or MongoDB doesn't have a method to choose which node to access in the event one dies. So you'd have to build that logic yourself keeping in mind your localization needs. Cheers Viksit -- Viksit Gaur http://viksit.com _______________________________________________ Ilugd mailing list Ilugd@lists.linux-delhi.org http://frodo.hserus.net/mailman/listinfo/ilugd