(SOLVED) Source and Replica in a MariaDB 'pair' do not start exchanging data
0
votes
1
answer
37
views
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.
**source** status:
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:
slave status\G
*************************** 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)
Asked by jcoppens
(101 rep)
Aug 5, 2025, 03:32 PM
Last activity: Aug 6, 2025, 04:55 PM
Last activity: Aug 6, 2025, 04:55 PM