11-12-2013 01:34 PM
Do you mean separate databases as in, use each role's native/embedded database, or do you mean separate as in multiple MySQL servers? I don't want to run in to goofy upgrade issues in the future if I were to use MySQL for all roles.
11-12-2013 01:54 PM
I mean run multiple MySQL server instances on different machines when you have large clusters with heavy load. Usually you can co-locate the MySQL with the service role that uses it.
Derby and SQLite should not be used in production if the service has a real database alternative.