[Spock Proxy Devel] Spock proxy vs MySQL Cluster
Status: Alpha
Brought to you by:
kaotao
From: Jacques-Olivier G. <jog...@gm...> - 2009-02-11 17:21:09
|
Hi You mention on your site that "MySQL Cluster <http://www.mysql.com/products/database/cluster/> was designed for high availability and performance, not for sharding. All indices and the main data are stored in main memory, which causes problems if your combined dataset is larger than memory. It also requires changing storage engines." AFAIK, starting with MySQLCluster 5.1, only indexes are required to stay in memory and support for user-defined distribution algorithms was added. So now - how does SpockProxy compare with this solution ? It looks to me that putting your distribution algo (from the spock table) into MySQL cluster would remove the need for this proxy - but I'm no expert. /jog |