Comments - Readwritesplit

6 years, 11 months ago Mohammad Lahlouh

yes it's running correctly

mysql> show slave status\G
*************************** 1. row ***************************
               Slave_IO_State: Waiting for master to send event
                  Master_Host: mysql
                  Master_User: repl
                  Master_Port: 33061
                Connect_Retry: 60
              Master_Log_File: mysql-node01.000016
          Read_Master_Log_Pos: 478
               Relay_Log_File: 1b69c4837339-relay-bin.000019
                Relay_Log_Pos: 697
        Relay_Master_Log_File: mysql-node01.000016
             Slave_IO_Running: Yes
            Slave_SQL_Running: Yes
              Replicate_Do_DB:
          Replicate_Ignore_DB:
           Replicate_Do_Table:
       Replicate_Ignore_Table:
      Replicate_Wild_Do_Table:
  Replicate_Wild_Ignore_Table:
                   Last_Errno: 0
                   Last_Error:
                 Skip_Counter: 0
          Exec_Master_Log_Pos: 478
              Relay_Log_Space: 1976
              Until_Condition: None
               Until_Log_File:
                Until_Log_Pos: 0
           Master_SSL_Allowed: No
           Master_SSL_CA_File:
           Master_SSL_CA_Path:
              Master_SSL_Cert:
            Master_SSL_Cipher:
               Master_SSL_Key:
        Seconds_Behind_Master: 0
Master_SSL_Verify_Server_Cert: No
                Last_IO_Errno: 0
                Last_IO_Error:
               Last_SQL_Errno: 0
               Last_SQL_Error:
  Replicate_Ignore_Server_Ids:
             Master_Server_Id: 1
                  Master_UUID: 3c9fbf8b-09bd-11e7-af8e-0242ac110002
             Master_Info_File: /var/lib/mysql/master.info
                    SQL_Delay: 0
          SQL_Remaining_Delay: NULL
      Slave_SQL_Running_State: Slave has read all relay log; waiting for more updates
           Master_Retry_Count: 86400
                  Master_Bind:
      Last_IO_Error_Timestamp:
     Last_SQL_Error_Timestamp:
               Master_SSL_Crl:
           Master_SSL_Crlpath:
           Retrieved_Gtid_Set:
            Executed_Gtid_Set:
                Auto_Position: 0
         Replicate_Rewrite_DB:
                 Channel_Name:
           Master_TLS_Version:
1 row in set (0.00 sec)

and here mysql cnf file for master

root@docker:~# cat /root/docker/mysql-node01/conf.d/my-custom.cnf
[mysql]
port=33061
[mysqld]
port=33061
server-id=1
log-bin=mysql-node01
max_connections=1000
#innodb_buffer_pool_size=30M
binlog_format=mixed
max_allowed_packet=10M
report_host=172.17.0.3

slave:

root@docker:~# cat /root/docker/mysql-node02/conf.d/my-custom.cnf
[mysql]
port=33062
[mysqld]
port=33062
server-id=2
log-bin=mysql-node02
max_connections=1000
#innodb_buffer_pool_size=30M
binlog_format=mixed
read_only
max_allowed_packet=10M
read_only
 
6 years, 11 months ago Mohammad Lahlouh

Hello,

Eureka

GRANT REPLICATION CLIENT ON *.* TO 'myuser'@'%';

give maxscale user access to replica, and I had issue in maxscale logging so i didn't see the error in the log

Thank you.

 
Content reproduced on this site is the property of its respective owners, and this content is not reviewed in advance by MariaDB. The views, information and opinions expressed by this content do not necessarily represent those of MariaDB or any other party.