[RESOLVED] Distribute & partition mySQL database across machines

[artella]

Hi,

Is it possible to distribute & partition a mySQL database across several machines, so that each machine contains a unique section/segment of the overall database.

MySQL Cluster seems to provide the facility for cloning a database across machines (i.e. replicas of the database on each machine). However is it possible to partition a database across machines?

Thanks

[hspc]

I think you need federated tables.
Check this article: MySQL Federated Tables: The Missing Manual (http://www.onlamp.com/pub/a/databases/2006/08/10/mysql-federated-tables.html)

[artella]

Thanks a lot for the link:)