online-migration
online-migration copied to clipboard
lefred
MySQL schema versioning and migration management utility
When init for a database that doesn't exist yet is called, an python staktrace is returned but the folder and the file 0000-up.mig are created. An entry with satus "ok"...
Let's add cfg file to deal with the connections. The file will be /etc/online-migration.cfg and its content will be like: ``` [world] user=root password=fred host=127.0.0.1 port=3340 [sysbench] user=test password=test host=127.0.0.1...
When for any reason (SQL syntax for example) the migration creation fails, all the steps already done for that migration should be removed. Ex: [root@devel ~]# ./online-migration.py create world sql1.sql...
If pt-online-schema-change is not found, we should stop (until we specify we won't use it, if this new feature gets implemented). We avoid this and let bad status: ``` ERROR...
Would it be possible to add store procedures support to the versionning tool ? With schema changes comes SP changes in many cases. I would be glad to help, to...
pt-online-schema-change h=127.0.0.1,P=3306,u=root,p=,D="world",t=City --alter="ALTER TABLE `world`.`City` DROP INDEX pol_idx, DROP COLUMN PolutionLevel; > " > -bash: world: command not found > -bash: City: command not found