MySQL Forums
Forum List  »  Replication

Re: Replication problem
Posted by: Jonatas Prust
Date: September 04, 2019 09:05AM

Hi Peter,

Thanks for your answer, i read the troubleshooting, and maded all the tests.

I got it running now by droping the bd on master(all empty) and taking a copy from slave to master with mysqldump, but i dont uderstand some things(what is wrong if i have this conditions?);

- The model what i used to create the BDs by the two sides with mysql workbench is the same.
- The 2 bds are empty,
- The position was "reseted" with "reset master" and "reset slave for channel 'xx'"
- The slave stabilished connection, and read the relay log.
- Exec_master_log_pos is the same of master position;
- No errors about sincronization in error log or on slave status;
- then i put content on a table in master, and it is not replicated, no errors and nothing wrong in status, the position changed on slave and master.

Version of Slave:
mysql Ver 14.14 Distrib 5.7.25, for Linux (x86_64)

Version of masters:
mysql Ver 14.14 Distrib 5.7.26, for Linux (armv7l)

Here is my master mysql config(running on orange pi pc plus):

[mysqld_safe]
socket = /var/run/mysqld/mysqld.sock
nice = 0

[mysqld]
user = mysql
pid-file = /var/run/mysqld/mysqld.pid
socket = /var/run/mysqld/mysqld.sock
port = 3306
basedir = /usr
datadir = /var/lib/mysql
tmpdir = /tmp
lc-messages-dir = /usr/share/mysql

skip-external-locking

bind-address = 0.0.0.0
key_buffer_size = 16M
max_allowed_packet = 16M
thread_stack = 192K
thread_cache_size = 8
myisam-recover-options = BACKUP
query_cache_limit = 1M
query_cache_size = 16M

log_error = /var/log/mysql/error.log
binlog-format = mixed
log-slave-updates = true
log_bin
binlog-do-db = siqueira
expire_logs_days = 60
max_binlog_size = 50M

gtid-mode = on
enforce-gtid-consistency= true
master_info_repository = table
relay_log_info_repository = table
server-id = 12

and slave config:
[mysqld]
pid-file = /var/run/mysqld/mysqld.pid
socket = /var/run/mysqld/mysqld.sock
datadir = /var/lib/mysql
log-error = /var/log/mysql/error.log
bind-address = 127.0.0.1
symbolic-links=0

binlog-format = MIXED
log-slave-updates = true
log-bin
gtid-mode = on
enforce-gtid-consistency= true
master-info-repository = TABLE
relay-log-info-repository= TABLE
server-id = 1

I need to understand what happened so that when it happens again I have a better solution.

Options: ReplyQuote


Subject
Views
Written By
Posted
1093
September 03, 2019 10:22AM
246
September 03, 2019 03:16PM
Re: Replication problem
284
September 04, 2019 09:05AM
271
September 04, 2019 11:20AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.