Le 17/07/2014 10:00, Cédric Krier a écrit : > On 17 Jul 08:51, Dominique Chabord wrote:
>> If you restore db_archive_A, save it, and then restore db-archive_B, you >> donr'need to restart the server. This would become impossible. > > You will have to restart. You need to access the server for this and if you access the server you get access to all instances. As a side effect, the "restore" function can be suppressed, as well as the master password. > >> This is off-topic, but single database would be uncompatible with >> education requirements. > > Can not understand why education will need server provisioning in the > ERP instead of general provisioning solution. I don't understand what you mean above. Education requirement is to manage several hundreds of databases, and create tens of new ones (typically 30 for a classroom) at a time. Creating/Deleting new instances require complex port management. The teacher also has to manage connection profiles accordingly. Running hundreds of instances is also a waste in resources (disk and memory). Security is not important because there are only fake data there. > >> >> Today they just need two databases on the same instance. > > And tomorrow two instances which will lead to correct privilege > separation. > For production instances, I recommand today to go single-database indeed. I also create training and test instances and automate database moves from production to training and to test. On these instances, every training session and every test session can use many databases. A max_databases_number in the configuration file would help to enforce this kind of recommendation. -- Dominique Chabord - SISalp Logiciel libre pour l'entreprise : Gestion Odoo, OpenERP et Tryton 18 avenue Beauregard 74960 Cran Gevrier 145A rue Alexandre Borrely 83000 Toulon tél +33(0)950274960 fax +33(0)955274960 mob +33(0)622616438 http://sisalp.fr
