I work for a big european company. We are rewriting our old CMS (php 5.3, Zend Framework) with php 7.0, Phalcon.
We have nearly 20 php servers with around 5000 CMS website per servers. Each of our clients have its own database. For compatibility purphose the database structure and file structure of the clients are keep intact. Only the library part of our CMS is adapted. Also we are creating new modules while making this "update".
For those new modules I would like to implement the usage of the phalcon migration mecanism. On a single server we could have 5000 databases by exemple with names like the DB: 27926, 152636. Every number correspond to single clients database based on the client id. The structures are the same for every clients.
Can we use migration tools to update thoses database wihout impacting for exemple the "project_server" database we could have on the same server with another structure ?
how can we use the config.ini for this? do we have to create a config.ini for each clients? The connection to the database is the same for all clients/projet_server database as we have shared provileges for that.
Thanks for the help.