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

change default_storage_engine does not affect the replication connection

    XMLWordPrintable

Details

    Description

      1. I install two mariadb server with default_storage_engine=innodb in the my.cnf
      2. I install the tokudb plugin on each mariadb, and use "show engines" to check the install of tokudb engine
      3. Set up the replication between the two mariadb server
      4. modify the master my.cnf file to add default_storage_engine=tokudb and restart master
      5. execute "set global default_storage_engine=tokudb" on slave
      6. execute "create table t1(c1 int);" on master
      we will get a tokudb table t1 on master, but a innodb table t1 on slave
      7. restart the replication on slave
      8. execute "create table t2(c1 int);" on master
      we will get a tokudb table t2 on master, but a innodb table t2 on slave
      9. modify the slave my.cnf file to add default_storage_engine=tokudb and restart slave
      10. execute "create table t3(c1 int);" on master
      we will get a tokudb table t3 on master, but a tokudb table t3 on slave

      Attachments

        Activity

          People

            Unassigned Unassigned
            gao1738 dennis
            Votes:
            0 Vote for this issue
            Watchers:
            3 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.