I am thinking of make a control panel for creating db's. Both the db and cp will be on seperate vps's and I was trying to think how it can be controlled. This was my idea:
Simple sqlite db on the cp vps with the app -
Create instanse vars for the username,dbname,password -
Method for creating the user,db etc -
If this passes it adds to the sqlite db
or the reverse of this but i issue i can see is that if the method passes but the local db insert fails it will create the db on the server but no entry in the local db, this is also the same if you reverse the order so creating the local db entry first and then running the method to create the db on the remote server.
How could this be done so that whatever way if the db is create or the local db entry is create the oppsite will be created or not created depending on which ever failes.