As described in my thread's title.. Here's the situation:
On this CRM I am currently developing to migrate a desktop CRM. I have planned to separate the database for my core and still use the current desktop CRM database to prevent any more file size increase the CRM database. Also, the project requires me to have a failover database for the old DB
The first database (MySQL) being my primary core DB (this has server settings, style, users etc.. essentially what i need to process full system initialisation) and is the failover database.
Second has the data that I need to load in some of my forms (MSSQL/MySQL).
I may have a third database (type would vary)
Now, in terms of performance and server load on a full production web server (apache, php, mysql)--would it be fast or stable enough to handle on/off connections?
I have two databases i need to switch on and off connections ex. because I may need to grab data from database a and another one from database b or c--would this be heavy server side?