Hi,
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.
Hi,
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 perfectly clear - I only want schema altering queries, such as 'alter table', 'create table' etc. to be distributed, not regular 'select', 'update', 'delete'.