hi everybody
I am a newcommer to mysql cluster area, nowadays deal with a problem where
we have mianly two big tables, and each have about 30 million rows of data
and performance
was not so good, and as prediction, it will increase to 0.1 billion in the
coming two years.
We hope to manage it in mysql cluster, or split it into two or more mysql
servers, but in the last method, we are afraid that there might be some JOIN
operations
that needs to across serveral servers. so we hope mysql cluster can cover
all these for us.
I hope can partition each big table into serveral parts by its id, and when
data volume increases, we will add new server and it will handle it
automatically, does that
resonable in exist mysql cluster solutions?
looking forwards to your kindly suggestions and ideas.
Best Regards
Eric Syu
--
Nothing Impossible
