I have a number of databases with the exactly same schema, living on different hosts, so whenever I need to make changes to a single table, I have to run the same query on all db instances.
I would like to streamline this process by having someone modify phpMyAdmin to detect incoming SQL queries that alter the schema in any way and run them on each of the hosts/databases. I think an addition of an array describing dbhost, dbname. etc to the main config file would be the desirable way of handling it, as I would like to be able to easily add/remove databases affected by this code change.
To be clear:
I only want schema altering queries, such as 'alter table', 'create table' etc. to be distributed across the mirrored databases, not regular 'select', 'update', 'delete' queries.
8 freelancers are bidding on average $375 for this job
having already worked on many PHP/MySQL project, am interested by this job. I work on phpMyAdmin from 3years, on an appach local server and I have a very good experience.