MySQL Forums
Forum List  »  Partitioning

Re: Partitioning tables with grouping
Posted by: Rick James
Date: April 13, 2010 11:40PM

If the clients are sharing nothing, consider creating a database per client. That will probably provide better security. You can easily dump a database. And (if you let them login directly) you can GRANT access to only their own database.

If there are more than a few thousand clients, this approach may get unwieldy.

Create the database names yourself. If not, be sure to sanitize and dedup the database names.

Options: ReplyQuote

Written By
April 10, 2010 07:31AM
Re: Partitioning tables with grouping
April 13, 2010 11: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.