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

Create server on master node is not replicate to slave

    XMLWordPrintable

Details

    Description

      My steps:

      Master

      		 
      MariaDB [(none)]> CREATE SERVER corehis_servertest FOREIGN DATA WRAPPER mysql OPTIONS (HOST '10.151.101.*',USER 'rpt',PASSWORD '********', PORT 4008,DATABASE 'corehistest');
      		 
       
      		 
       
      		 
      MariaDB [(none)]> select * from mysql.servers;
      		 
      +--------------------+----------------+-------------+----------+---------------+------+--------+---------+-------+
      		 
      | Server_name        | Host           | Db          | Username | Password      | Port | Socket | Wrapper | Owner |
      		 
      +--------------------+----------------+-------------+----------+---------------+------+--------+---------+-------+
      		 
      | core001_server     | 10.151.101.* | core001     | rpt      | ******** | 4008 |        | mysql   |       |
      		 
      | payment_server     | 10.151.101.* | payment   | rpt      | ******** | 4008 |        | mysql   |       |
      		 
      | corehis_server     | 10.151.101.* | corehis        | rpt      | ******** | 4008 |        | mysql   |       |
      		 
      | corehis_servertest | 10.151.101.* | corehistest | rpt      | ******** | 4008 |        | mysql   |       |
      		 
      +--------------------+----------------+-------------+----------+---------------+------+--------+---------+-------+

      Slave

      		 
       
      		 
      MariaDB [(none)]> select * from mysql.servers;
      		 
      +--------------------+----------------+-------------+----------+---------------+------+--------+---------+-------+
      		 
      | Server_name        | Host           | Db          | Username | Password      | Port | Socket | Wrapper | Owner |
      		 
      +--------------------+----------------+-------------+----------+---------------+------+--------+---------+-------+
      		 
      | core001_server     | 10.151.101.* | core001     | rpt      | ******** | 4008 |        | mysql   |       |
      		 
      | payment_server     | 10.151.101.* | payment   | rpt      | ******** | 4008 |        | mysql   |       |
      		 
      | corehis_server     | 10.151.101.* | corehis        | rpt      | ******** | 4008 |        | mysql   |       |
      		 
      +--------------------+----------------+-------------+----------+---------------+------+--------+---------+-------+

      Attachments

        Issue Links

          relates to

          Task - A task that needs to be done. MDEV-5023 Documentation CREATE SERVER regarding Replication and spider

          • Trivial - Cosmetic problem like misspelt words or misaligned text.
          • Closed

          Task - A task that needs to be done. MDEV-21605 Clean up and speed up interfaces for binary row logging

          • Major - Major loss of function.
          • Closed

          Activity

            People

              Elkin Andrei Elkin
              VA Khamhak
              Votes:
              0 Vote for this issue
              Watchers:
              6 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.