Hi

Looking for inspiration ...

Are there recommended solutions to track and replicate changes on MariaDB tables?

I was hoping that DBs like information_schema or mysql might log ALTER TABLE queries.

My research pointed me to 'log_bin':

find the binary log for the relevant time period, use mysqlbinlog to convert it to SQL, then grep for the relevant table name to find the alter table statement

I'd be interested to know about alternatives.

background

My client likes to change from time to time the data model for some of my applications and tends to inform me per email "Please change ..." afterwards.

To make it more difficult this models are used on several different DB Severs.

My application is already adapting to the local model on a server and checking the schema against a "master" server, but I'd like to have better control and allow a semi-automatic update.

A manual solution would be to train my client to record every ALTER TABLE manually after changes

... well ... I'm not too keen for the resulting social tension of enforcing protocols.

Cheers Rolf
(addicted to the Perl Programming Language :)
Wikisyntax for the Monastery FootballPerl is like chess, only without the dice

In reply to Tracking and deploying changes in (MySql/Maria) DB schema ... by LanX

Title:
Use:  <p> text here (a paragraph) </p>
and:  <code> code here </code>
to format your post, it's "PerlMonks-approved HTML":


  • Posts are HTML formatted. Put <p> </p> tags around your paragraphs. Put <code> </code> tags around your code and data!
  • Titles consisting of a single word are discouraged, and in most cases are disallowed outright.
  • Read Where should I post X? if you're not absolutely sure you're posting in the right place.
  • Please read these before you post! —
  • Posts may use any of the Perl Monks Approved HTML tags:
    a, abbr, b, big, blockquote, br, caption, center, col, colgroup, dd, del, details, div, dl, dt, em, font, h1, h2, h3, h4, h5, h6, hr, i, ins, li, ol, p, pre, readmore, small, span, spoiler, strike, strong, sub, summary, sup, table, tbody, td, tfoot, th, thead, tr, tt, u, ul, wbr
  • You may need to use entities for some characters, as follows. (Exception: Within code tags, you can put the characters literally.)
            For:     Use:
    & &amp;
    < &lt;
    > &gt;
    [ &#91;
    ] &#93;
  • Link using PerlMonks shortcuts! What shortcuts can I use for linking?
  • See Writeup Formatting Tips and other pages linked from there for more info.