|
|
 | | From: | David Freeman | | Subject: | Database clusters | | Date: | Wed, 19 Jan 2005 09:22:53 +0000 (UTC) |
|
|
 | Hi,
Are there any database systems that can support clustering accross multiple
machines (> 10) to spread the load.
I am looking for a database system that can handle a single large table with
about 2 million rows accross multiple machines, so that both reads and
writes are distributed accross the machines and transaction atomicity is
preserved. Currently, I am using mysql with NDB clustered tables, and while
these meet all the criteria, the memory requirements are huge (the entre
table is kept in ram). Each machine partitipating in the cluster needs about
2GB of ram to keep from swapping or crashes if I remove the swap area. Also
machines cant be added and removed from the cluster easily, though it does
gracefully recover from a single node failure.
So, is there any cluster solution that would suit me better than MySQL/NDB?
I do not have SAN hardware, so Oracle's RAC is out of the question.
TIA,
Dave
|
|
|
