Re^3: Tracking and deploying changes in (MySql/Maria) DB schema ...

Replies are listed 'Best First'.
Re^4: Tracking and deploying changes in (MySql/Maria) DB schema ... by soonix (Chancellor) on May 23, 2019 at 00:58 UTC
my crazy idea: Have a cron job doing hourly (or so) `mysqldump ... git commit ...` [download] If the cron job is scheduled often enough, it would register the modifications with enough granularity.	[reply] [d/l]
Re^5: Tracking and deploying changes in (MySql/Maria) DB schema ... by karlgoethebier (Abbot) on May 23, 2019 at 11:30 UTC
This is not crazy. It works. We did it like this with a huge MySQL DB for about 10 years. Best regards, Karl ŤThe Crux of the Biscuit is the Apostropheť `perl -MCrypt::CBC -E 'say Crypt::CBC->new(-key=>'kgb',-cipher=>"Blowfish")->decrypt_hex($ENV{KARL});'`Help	[reply] [d/l]
Re^6: Tracking and deploying changes in (MySql/Maria) DB schema ... by soonix (Chancellor) on May 23, 2019 at 13:32 UTC
What about impact on resource usage? (That was my main reason for preliminarily calling it crazy)	[reply]
Re^7: Tracking and deploying changes in (MySql/Maria) DB schema ... by karlgoethebier (Abbot) on May 23, 2019 at 14:17 UTC
Re^8: Tracking and deploying changes in (MySql/Maria) DB schema ... by soonix (Chancellor) on May 24, 2019 at 05:42 UTC
Some notes below your chosen depth have not been shown here
Re^4: Tracking and deploying changes in (MySql/Maria) DB schema ... by erix (Prior) on May 23, 2019 at 21:01 UTC
Maybe I should have been more explicit about needing the incremental steps (i.e. ALTER TABLEs) So you need auditing. The audit plugin `[1]` seems to be made for this. As expected it has a QUERY_DDL setting which is pretty much what you seem to need. `[1]` https://mariadb.com/kb/en/library/mariadb-audit-plugin-log-settings/	[reply] [d/l] [select]
Re^5: Tracking and deploying changes in (MySql/Maria) DB schema ... by LanX (Saint) on May 23, 2019 at 21:34 UTC
This looks good, will try it out, thanks! :) Cheers Rolf _{(addicted to the Perl Programming Language :) Wikisyntax for the Monastery FootballPerl is like chess, only without the dice}	[reply]
Re^6: Tracking and deploying changes in (MySql/Maria) DB schema ... by holli (Abbot) on May 23, 2019 at 22:03 UTC
And what are you going to tell the client in order to get him to install, configure and maintain this thing that he probaply doesn't want? I mean, it's a database plugin right, so it must run on the server. holli You can lead your users to water, but alas, you cannot drown them.	[reply] [d/l]
Re^7: Tracking and deploying changes in (MySql/Maria) DB schema ... by hippo (Archbishop) on May 24, 2019 at 08:18 UTC
Re^8: Tracking and deploying changes in (MySql/Maria) DB schema ... (consulting) by LanX (Saint) on May 24, 2019 at 17:24 UTC
Re^7: Tracking and deploying changes in (MySql/Maria) DB schema ... by LanX (Saint) on May 23, 2019 at 22:17 UTC