MySQL Forums
Forum List  »  Replication

Re: Master freezes when replication starts to write a relay-log
Posted by: Edward Lee
Date: May 27, 2013 12:31AM

Hi Rick,

thx for your answer!

Rick James Wrote:
-------------------------------------------------------
> Strange. What Operating System(s)?

Master - Windows 2003 Service Pack 2
Slave - Windows 7 Prof.

> So, the only difference is whether the Slave is
> pulling the replication stream from the Master.
>
> SHOW VARIABLES LIKE '%binlog%'; -- RBR or SBR?
I have RBR. There are two configs

Master:
binlog_cache_size 32768
binlog_direct_non_transactional_updates OFF
binlog_format ROW
innodb_locks_unsafe_for_binlog OFF
max_binlog_cache_size 4294963200
max_binlog_size 1073741824
sync_binlog 0

Slave:
binlog_cache_size 32768
binlog_direct_non_transactional_updates OFF
binlog_format ROW
innodb_locks_unsafe_for_binlog OFF
max_binlog_cache_size 4294963200
max_binlog_size 1073741824
sync_binlog 1


> SHOW VARIABLES LIKE 'server_id'; -- make sure they
> are different

They are different

> SHOW VARIABLES LIKE '%buffer%; -- memory usage

Master:
bulk_insert_buffer_size 8388608
innodb_buffer_pool_size 402653184
innodb_log_buffer_size 8388608
join_buffer_size 131072
key_buffer_size 402653184
myisam_sort_buffer_size 67108864
net_buffer_length 16384
preload_buffer_size 32768
read_buffer_size 2097152
read_rnd_buffer_size 8388608
sort_buffer_size 2097152
sql_buffer_result OFF

Slave:
bulk_insert_buffer_size 8388608
innodb_buffer_pool_size 402653184
innodb_log_buffer_size 8388608
join_buffer_size 131072
key_buffer_size 268435456
myisam_sort_buffer_size 72351744
net_buffer_length 16384
preload_buffer_size 32768
read_buffer_size 65536
read_rnd_buffer_size 262144
sort_buffer_size 262144
sql_buffer_result OFF



> What happens if you do this sequence?
> STOP SLAVE; -- on slave
> CREATE TABLE ...; -- on Master (and wait for it to
> finish)
> START SLAVE; -- on slave

If I do the sequence, everything is ok, there are no problems. But if the slave is running, the master freezes and the error "waiting for initial comm. packet" occur.

Options: ReplyQuote


Subject
Views
Written By
Posted
Re: Master freezes when replication starts to write a relay-log
1081
May 27, 2013 12:31AM


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.