MySQL Forums
Forum List  »  NDB clusters

MySQL Clusters - Case study.
Posted by: Ranjan Sarma
Date: August 08, 2015 11:40AM

i have a database with two tables, each having around 250 million rows, and disk usage of ~200 GB. These two tables are InnoDB and used for transactional operations. Each of these tables can be easily divided by a column value which has only 3 possible values.

The tables and queries are optimized. But because of high volume, complex queries often takes too long time.

Should I go for MySQL clusters for Auto-Sharding these tables?

These tables are InnoDB. Should they be converted to NDB ?

How many new servers / VMs needed for this design, at least ?

Thanks & Regards.

Options: ReplyQuote


Subject
Views
Written By
Posted
MySQL Clusters - Case study.
1612
August 08, 2015 11:40AM
658
September 11, 2015 05:34AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.