MySQL Forums
Forum List  »  Partitioning

MySql Horizontal partitioning - Pros-Cons
Posted by: Manohar K
Date: April 14, 2014 11:43AM

We would like to take the advantage of MySql horizontal partitioning for performance improvement and data separation. We have gone through the MySql documentation and found that there won't be any foreign key support for the partitioned tables and it's referring tables. We have a work around with triggers to check the foreign key values manually, but this will be a huge impact if we have to verify more tables and will be having maintenance tasks if we would like to add new tables.

Please let us know the pros-cons and how partitioning can be achieved with foreign key support.
And also is there any alternate solution for partitioning to get performance improvement and data separation.

Options: ReplyQuote


Subject
Views
Written By
Posted
MySql Horizontal partitioning - Pros-Cons
4095
April 14, 2014 11:43AM


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.