MySQL Forums
Forum List  »  Replication

binlog overflow
Posted by: Alax James
Date: April 24, 2013 07:55PM

Hi,

I am using Binlog to sync between master and slave.

After loading 20GB data into master, I found some data lost in slave.
In master, there is warning like replication overflow.

I guess the binlog writting speed doesn't match the speed of data loading. So, there is some data lost.

Is there any way to speedup binlog writting, or other ways to solve this problem?


mysql> show variables like '%binlog%';
+-----------------------------------------+----------------------+
| Variable_name | Value |
+-----------------------------------------+----------------------+
| binlog_cache_size | 32768 |
| binlog_direct_non_transactional_updates | OFF |
| binlog_format | MIXED |
| max_binlog_cache_size | 18446744073709547520 |
| max_binlog_size | 1073741824 |
| ndb_log_binlog_index | ON |
| ndb_report_thresh_binlog_epoch_slip | 3 |
| ndb_report_thresh_binlog_mem_usage | 10 |
| sync_binlog | 0 |
+-----------------------------------------+----------------------+

Thanks

Alex

Options: ReplyQuote


Subject
Views
Written By
Posted
binlog overflow
1531
April 24, 2013 07:55PM
827
April 25, 2013 09:33PM
697
April 28, 2013 02:57AM
748
April 30, 2013 10:41PM
746
May 03, 2013 02:13AM


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.