MySQL and Ensim

[-RJ]

It appears that when I create an account, one MySQL database is created which has the same name as the user I created when I setup the account. It doesn't appear that I can set the number of databases each account can create...

Is this correct, or am I missing something? Is each account limited to one MySQL database regardless of what I want give that account?

[knightfoo]

Ensim only configures one database per account, based on the name of the domain. This is done to prevent database name conflicts (you don't want users adding databases with arbitrary names). You really do not need more than one database per account, since you can create as many tables as you want inside of each database. It doesn't make sense to create a database for each application, it just increases load on the database server.

-knightfoo

[-RJ]

Agreed... I'm just getting used to the differences between Ensim and Helm. Helm lets you allocate x number of databases per account.

Although.... If you had some crappy program which didn't allow you to set a table prefix and you needed to install more than one instance of it.... then it would be time to look for a new application anyway, I guess.

[Buckaroo]

The Linux version of Ensim WEBppliance allows multiple databases per site. At some point in the future, windows and linux webppliance will be closer in feature sets.

Personally, from a sys admin operations level, its much better to have one database per application. In this way, applications don't conflict with each other in the tables they want to create. It is also a security measure to have a separate user per database per application, if one app has a security hole, it won't affect other databases....