2004-08-04 kl. 03.29 skrev Joe Wong:
> Hi,
>
> I am studying mysql cluster at the moment. My purpose is solely for
> failsafe implementation so I am looking at a two nodes mysql cluster
> solution. What is the pros and cons compared with master/slave
> replication. For later, I think it can provide me a kind of fail-safe
> but I need to manually switch over to the slave in case the master
> fail? I am using python and zope and thus the mysql cluster support
> for these tools is one of my considerations too.
>
Python and zope is supported for MySQL Cluster in the same way as for
other MySQL storage engines.
At the moment there is no fail-over support from a Python or Zope
client to several MySQL servers but it
is very straightforward to accomplish with a small amount of
programming. Connector/J has support for
this fail-over so far and other MySQL clients will get it eventually.
Rgrds Mikael
> Regards,
>
> - Wong
>
Mikael Ronström, Senior Software Architect
MySQL AB, www.mysql.com
Clustering:
http://www.infoworld.com/article/04/04/14/HNmysqlcluster_1.html
http://www.eweek.com/article2/0,1759,1567546,00.asp