Details
-
Bug
-
Status: Closed (View Workflow)
-
Major
-
Resolution: Not a Bug
-
10.11, 11.4
-
Linux Slackware64, C
-
Not for Release Notes
Description
On Linux Slackware PCs, I have a 'Source' database on one PC, and a 'Replica' on the other.
On the Source end (11.4.7-MariaDB) I've programmed ID=1.
On the Replica end (10.11.6-MariaDB), I set ID=11 and set the Source IP.
I've started them, and they seem to like each other, as the Show replica status reports everything as Ok, no errors, comms ok, etc...
BUT, when I create a new table on the 'Source' machine, nothing happens on the 'Replica' - no new table is created.
And, after I manually create the table on the Replica, and I insert a record on the Source, no data transfer happens either. No pointers are incremented, seemingly no data is transferred. And no errors seem to be appearing in the logs. Here are the status reports for Source and Replica.
I dispair, I consulted AI, and after several sessions, AI was in the same state as I was... repeatedly asking me to insert new records at the Source and checking at the other end, maybe hoping something would repair itself. Also suggesting extra complications such as adding SSH, Gtid and other optionals.
What can I do to get the show on the road? I've reinstalled MariaDB at the Replica. I'm somewhat reticent in changing the DB at the Source, as it's in use. I've checked permissions on files and directories... Last session ended at 04:30 AM this morning.
show master status\G
|
*************************** 1. row ***************************
|
File: mysql-bin.000020
|
Position: 328
|
Binlog_Do_DB: homeorptemp, farma1, test_replication
|
Binlog_Ignore_DB:
|
1 row in set (0.000 sec)
|
replica status:
*************************** 1. row ***************************
|
Slave_IO_State: Waiting for master to send event
|
Master_Host: 192.168.1.102
|
Master_User: my_repl
|
Master_Port: 3306
|
Connect_Retry: 60
|
Master_Log_File: mysql-bin.000020
|
Read_Master_Log_Pos: 328
|
Relay_Log_File: mysql-relay-bin.000007
|
Relay_Log_Pos: 627
|
Relay_Master_Log_File: mysql-bin.000020
|
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: 328
|
Relay_Log_Space: 1235
|
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_SSL_Crl:
|
Master_SSL_Crlpath:
|
Using_Gtid: No
|
Gtid_IO_Pos:
|
Replicate_Do_Domain_Ids:
|
Replicate_Ignore_Domain_Ids:
|
Parallel_Mode: optimistic
|
SQL_Delay: 0
|
SQL_Remaining_Delay: NULL
|
Slave_SQL_Running_State: Slave has read all relay log; waiting for more updates
|
Slave_DDL_Groups: 0
|
Slave_Non_Transactional_Groups: 0
|
Slave_Transactional_Groups: 0
|
Replicate_Rewrite_DB:
|
1 row in set (0.001 sec)
|
EDIT my.cnf at the replica:
[client]
|
[mysqld]
|
port = 3306
|
socket = /var/run/mysql/mysql.sock
|
skip-external-locking
|
bind-address = 0.0.0.0
|
key_buffer_size = 256M
|
max_allowed_packet = 32M
|
table_open_cache = 1024
|
sort_buffer_size = 2M
|
net_buffer_length = 8K
|
read_buffer_size = 512K
|
read_rnd_buffer_size = 1M
|
skip-networking = OFF
|
server-id = 11
|
log-bin = mysql-bin
|
binlog_format = mixed
|
innodb_buffer_pool_size = 512M
|
innodb_log_file_size = 256M
|
read_only = OFF
|
log_warnings = 1
|
log_slave_updates = ON
|
|
|
[mysqldump]
|
quick
|
max_allowed_packet = 32M
|
|
|
[mysql]
|
no-auto-rehash
|
|
|
[myisamchk]
|
show processlist;
|
+----+-------------+-----------+------+-----------+-------+--------------------------------------------------------+------------------+----------+
|
| Id | User | Host | db | Command | Time | State | Info | Progress |
|
+----+-------------+-----------+------+-----------+-------+--------------------------------------------------------+------------------+----------+
|
| 5 | system user | | NULL | Slave_IO | 17725 | Waiting for master to send event | NULL | 0.000 |
|
| 6 | system user | | NULL | Slave_SQL | 17724 | Slave has read all relay log; waiting for more updates | NULL | 0.000 |
|
| 8 | root | localhost | NULL | Query | 0 | starting | show processlist | 0.000 |
|
+----+-------------+-----------+------+-----------+-------+--------------------------------------------------------+------------------+----------+
|
3 rows in set (0.000 sec)
|