Re: Mysql Cluster , Partitioning , Shreds, Replication , Fabric

[Ted Wennmark]

1) MySQL Cluster is separate engine (NDB), supports ACID but not Foreign Keys ? Innodb engine support Foreign Keys and also ACID compliance?
Answer: We have support for foreign keys in NDB also, InnoDB also support FK and is ACID compliant. You can see differences between here InnoDB and NDB here: http://dev.mysql.com/doc/refman/5.6/en/mysql-cluster-ndb-innodb-engines.html
In short InnoDB is your standard disk-based DBMS whilst NDB is a in-memory ditributed database.

2) To get auto partitioning (Sherds) and Replication in Inndodb we need Fabric ?
Answer: If you need sharding you can use MySQL fabric and InnoDB. You can use replication in InnoDB without using MySQL Fabric.

3) Is this the basic difference between Fabric and Cluster ?
Answer: MySQL fabric is just a framework for managing InnoDB instances to achive sharding and HA. MySQL Cluster is an homogenous distributed in-memory database that have native support sharding and HA.
You can read more about Fabric here: http://dev.mysql.com/tech-resources/articles/mysql-fabric-ga.html
And getting started with MySQL Cluster here: http://www.mysql.com/products/cluster/start.html

I hope this helps!

Best Regards,
Ted