I need create a very big project, the project has a lot of tables and a big quantity data. In first moment I thought to use NDBCLUSTER but I saw that not suport foreign keys and I have to use triggers, really I don't like this solution but I need that my database is replicated to other nodes.
Please if somebody know any solution for use foreigns key with mysql or other database manager and balance data I would love to know it.
I noticed that MySQL Replication can be an alternative, even Apache Cassandra but now we will try to give it a try NDB Cluster and non-relational model