MySQL Forums :: Partitioning :: Horizontal partitioning on a per user basis?


Advanced Search

Horizontal partitioning on a per user basis?
Posted by: Peter Sarkozi ()
Date: September 18, 2014 05:40PM

I'm looking for a solution where I can have the structure and maintainability of one large database, but with the security and performance of smaller separate databases.

This seems to be more and more common with Saas and cloud solutions, where all instances have identical database structures.

So, is it possible to set up one database that stores the tables for each user separately, so as to offer the security and performance of being it's own database?

Is this something that MySQL can do, or something that it plans to be able to do in the future?

Options: ReplyQuote


Subject Views Written By Posted
Horizontal partitioning on a per user basis? 1890 Peter Sarkozi 09/18/2014 05:40PM
Re: Horizontal partitioning on a per user basis? 982 Luke Taylor 09/19/2014 01:12AM
Re: Horizontal partitioning on a per user basis? 1022 Rick James 09/19/2014 11:18PM


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.