Uploaded image for project: 'MariaDB Server'
  1. MariaDB Server
  2. MDEV-4831

Replication to store filter in master.info

Details

    • Task
    • Status: Open (View Workflow)
    • Minor
    • Resolution: Unresolved
    • None
    • None

    Description

      With multi source replication it would logical to have replication filters stored with other per domain replication informations. This would allow changing the replication topology using scripting without reconfiguring and restarting the server . Changing the filters on the fly is already a good step but if you lose the information after a restart it will break the replication. This will allow tools like MHA or SQL command like SWITCH MASTER to elect a a slave that get more schemas but contain at least all of the original master schemas and dynamically ignoring additional databases .

      Attachments

        Issue Links

          relates to

          Task - A task that needs to be done. MDEV-26706 Enable per table gtid domain_id

          • Major - Major loss of function.
          • Open

          Activity

            monty Michael Widenius added a comment -

            I think the above is a good idea and something that needs to be done to make using replication filters more easily.

            The problem is that the filters can be quite big and storing them in the master.info file
            may not be the best idea.

            We should really have two files per master:

            • One for the active state
            • One for startup variables that never changes.

            We should look into this at least in MariaDB 10.1

            monty Michael Widenius added a comment - I think the above is a good idea and something that needs to be done to make using replication filters more easily. The problem is that the filters can be quite big and storing them in the master.info file may not be the best idea. We should really have two files per master: One for the active state One for startup variables that never changes. We should look into this at least in MariaDB 10.1

            People

              Unassigned Unassigned
              stephane@skysql.com VAROQUI Stephane
              Votes:
              0 Vote for this issue
              Watchers:
              4 Start watching this issue

              Dates

                Created:
                Updated:

                Git Integration

                  Error rendering 'com.xiplink.jira.git.jira_git_plugin:git-issue-webpanel'. Please contact your Jira administrators.