Split/Balance the tables on multiple databases

Dear all,

I want to know if there is a proper way to split Sugar database between 2 separated database : one for some confidential data (so 3 or 4 specifics tables) and keep the main sugar one for the other tables.

I know that this "option" exists for reporting purpose, but I want to know if someone got an idea for my expectations ?

For the moment, my "best" idea is to replace the corresponding tables as mySQL view (which allows most of standard SQL operation - create, update ) but it's really "ugly".

The idea to override the bean retrieve etc. seems to complex because we need to handle so many behaviors and contexts (global search, local search, all webservices etc.)

Any idea is welcome,

Fred

my favorite list of reviewers ;-) : Cédric Mourizard, Alex Nassi, Matt Marum, Francesca Shiekh, Angel Magana, Michael Shaheen, Jeff Bickart, Enrico Simonetti

0 Cédric Mourizard over 5 years ago

Hello Fred,
We made this type of things (using views) in the past however that was to do not perform some sync than but not for security reason. I don't see how that can solve a security or privacy concern to have 2 separate database if one application can access both in Read/Write/Delete.
0 Frédéric Rinaldi over 5 years ago in reply to Cédric Mourizard

For the moment the security concerns for my customer is that some of the data are not "store" in a single database (so a mysql dump will not provide the full base).
Of course, the security breach is there if we considered that, as a login user, you can access the view with the full permission.
Fred