We are developing an application where we want each Associate that registers to have a personal Data Base in MySQL, to have the data separately and to have everything more organized.
The registration is easy: when you register you will be created the initial structure and that's it, that's not a problem. We can even put an initial database and that structure is always copied. Our problem is when we modify for an update, we must update all the databases of all the clients, any idea of how to do this?
I have thought about an initial and then a script that when there is an update is executed in all the other databases, but of course, you have to be very careful with that script and at the beginning they can be few but if the thing goes well the same we have thousands of databases and of course it would be a mess to update all simultaneously ...
Any ideas on how to do this right? I do not finish liking this form that we have now raised.