sharding a database with hierarchical data structure

Question

I am using MySQL to store my parent-child relation. The data is concentrated in one table and it is really elegant by design.

I do not have any problem quering; however the table has grown in size dramatically. I would like to shard or use some techniques to improve the performance of my queries (and joins). How would I do it?

Any pointers would be appreciated.

Thanks, R

Answer 1

There is not enough information in this post to give you a good answer. The first thing we would need to know is what the table structure is. Do you have non-clustered indexes defined or is it simply one clustered index.

Your application that uses this database, what does it do with the data?

In addition, are you searching for say a name field, or a specific date? If so these could be candidates for an index type.

The number one thing to look after though is indexes.