I have two apps with a current configuration as follows:
- DB on server A/MySQL Instance A
- DB on server B/MySQL Instance B
Students can apply for internship using App1 and those applications are stored on App1 DB. Because we want to be able to review those applications on App2 and update their statuses. Master-Master replication is used and we are able to get the apps. Now requirements have changed and we want both Apps and DBs to be on server B with a presume config as follows
App1 App2 MySQL Instance B contain DB1 and DB2
How can I configure Master-Master replication between two databases on the same instance or is it better to have just one DB now and make both apps use the one DB?