MySQL Forums :: Partitioning :: Advice on partitioning

Advanced Search

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
Advice on partitioning 1598 me su 04/24/2015 01:40PM
Re: Advice on partitioning 911 Rick James 04/24/2015 05:34PM
Re: Advice on partitioning 849 Mehdi Salarkia 04/27/2015 09:05AM
Re: Advice on partitioning 895 Rick James 04/27/2015 02:22PM
Re: Advice on partitioning 749 Drew Morris 04/28/2015 11:02AM
Re: Advice on partitioning 781 Rick James 04/28/2015 12:32PM
Re: Advice on partitioning 810 Mehdi Salarkia 04/28/2015 04:07PM
Re: Advice on partitioning 658 Mehdi Salarkia 06/15/2015 06:39PM
Re: Advice on partitioning 803 Rick James 06/15/2015 07:05PM
Re: Advice on partitioning 751 Mehdi Salarkia 06/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.