MySQL Forums
Forum List  »  Partitioning

Re: Advice on partitioning
Posted by: Mehdi Salarkia
Date: June 15, 2015 06:39PM

Sorry for my late response because of the fact that we were having a lot of discussions and testing different solutions and testing them.

So after some more research and considering Ricks advises we decided to focus more on sharding and have the right clustered in index for our tables .
We are in the process of implementing the sharding and testing it but meanwhile we could deal with a big load of data without partitioning and by adding the right clustered index (which by the way strangely called primary key and MYSQL is not very clear about the difference between an index and primary key its documentations, or atleast I didn't see it) we could server 20,000 users with incoming/outgoing mails with a database of size 550,000,000 records.
We are also considering to make the table smaller and move some of the information to a clustered NO-SQL database (for now we are working on Riak and we are testing it) to store mail information and remove the mail heavy information from database.

Here is my last status update.
Hope that it will be useful for others, I'll come back to share more information a little latter.

Options: ReplyQuote


Subject
Views
Written By
Posted
1748
April 24, 2015 01:40PM
1000
April 24, 2015 05:34PM
963
April 27, 2015 09:05AM
994
April 27, 2015 02:22PM
833
April 28, 2015 11:02AM
868
April 28, 2015 12:32PM
901
April 28, 2015 04:07PM
Re: Advice on partitioning
738
June 15, 2015 06:39PM
890
June 15, 2015 07:05PM
848
June 16, 2015 06:40PM


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.