Closed

PhpMyAdmin modification

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 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.

Skills: MySQL, PHP

See more: schema update, clear array, sql table remove, php table array, mysql number sql, create schema mysql, schema sql, mysql create schema, table queries, mysql remove table, create alter, mysql schema, phpmyadmin mysql, distributed mysql, modify query, mysql config, mysql update select query, php change detect, sql query modification, file handling, php mysql modification, code modification, create mysql table, php single query, modification code

About the Employer:
( 0 reviews ) United States

Project ID: #1287687

8 freelancers are bidding on average $375 for this job

khanhhuyna

I can do this. Thanks.

$250 USD in 5 days
(86 Reviews)
6.6
tonykim100

I am ready to start now.

$250 USD in 7 days
(115 Reviews)
6.2
topscripter

Hello, im highly interested in this and Let's start now. Thanks.

$500 USD in 7 days
(20 Reviews)
4.6
gutenmorgen11

Hi. I'm ready to start. Please check PM.

$250 USD in 5 days
(26 Reviews)
4.4
tehnicsmart

Hello, i`m ready

$250 USD in 0 days
(12 Reviews)
3.7
techyash

php, mysql experienced

$500 USD in 4 days
(2 Reviews)
2.8
aniajenniferusa

I am an experienced web designer and developer. I have an experience of over 4years in this industry. I have degrees after graduating Computer Science and Digital Art Faculties. I have many skills so I can work any pro More

$750 USD in 20 days
(0 Reviews)
0.0
bellasoft

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.

$250 USD in 5 days
(0 Reviews)
0.0