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

Add SST for asynchronous slaves

Details

    • Task
    • Status: Closed (View Workflow)
    • Major
    • Resolution: Won't Do
    • N/A
    • N/A

    Description

      One of the common pain points for DBAs is creating and managing slaves. Since MariaDB already contains Galera libraries, the SST portion could be leveraged to allow async slave creation after a fresh install.

      Flow:

      1. New server is provisioned
      2. MariaDB Installed
      3. Server is brought up
      4. root user issues CHANGE MASTER TO ...... MASTER_SST=1;
      5. Server initiates SST utilizing replication user/pass
      6. After server comes back up, it connects as an asynchronous or semi-sync slave

      Attachments

        Issue Links

          relates to

          New Feature - A new feature of the product, which has yet to be developed. MDEV-7502 Automatic provisioning of slave

          • Major - Major loss of function.
          • Open

          Task - A task that needs to be done. MDEV-21106 Port clone plugin from MySQL

          • Major - Major loss of function.
          • Closed

          New Feature - A new feature of the product, which has yet to be developed. MXS-2542 Add rebuild server to MariaDB Monitor

          • Major - Major loss of function.
          • Closed

          Activity

            Ascending order - Click to sort in descending order
            danblack Daniel Black added a comment -

            would require:

            • donor sst scripts to provide replication file/offset or gtid position at the point of the snapshot (MDEV-5968)
            • joiner side of the scripts would need know the connection name (of the CHANGE MASTER ['connection name'] TO)
            danblack Daniel Black added a comment - would require: donor sst scripts to provide replication file/offset or gtid position at the point of the snapshot ( MDEV-5968 ) joiner side of the scripts would need know the connection name (of the CHANGE MASTER ['connection name'] TO )
            manjot Manjot Singh (Inactive) added a comment -
            • Donor scripts could easily provide this as they use xtrabackup or mariadb-backup which can provide xtrabackup_binlog_info (MDEV-5968 is unrelated as that relates to mysqldump which SST does not use)
            • I think to start, this idea cannot be used with MSR (feature could be worked on later)
            manjot Manjot Singh (Inactive) added a comment - Donor scripts could easily provide this as they use xtrabackup or mariadb-backup which can provide xtrabackup_binlog_info ( MDEV-5968 is unrelated as that relates to mysqldump which SST does not use) I think to start, this idea cannot be used with MSR (feature could be worked on later)
            GeoffMontee Geoff Montee (Inactive) added a comment -

            Galera's SST scripts are very fragile, and when they break, the issues can be difficult to debug. If MDEV-21106 were implemented in MariaDB Server, then the clone plugin could also be used for this.

            GeoffMontee Geoff Montee (Inactive) added a comment - Galera's SST scripts are very fragile, and when they break, the issues can be difficult to debug. If MDEV-21106 were implemented in MariaDB Server, then the clone plugin could also be used for this.

            People

              Unassigned Unassigned
              manjot Manjot Singh (Inactive)
              Votes:
              2 Vote for this issue
              Watchers:
              11 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved:

                Git Integration

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