Jumat, 22 Juni 2012

read_buffer_size can break your replication

. Jumat, 22 Juni 2012 .

There are some variables that can affect the replication behavior and sometimes cause some big troubles. In this post I’m going to talk about read_buffer_size and how this variable together with max_allowed_packet can break your replication.
The setup is a master-master replication with the following values:

max_allowed_packet = 32M
read_buffer_size = 100M

 http://www.mysqlperformanceblog.com/2012/06/06/read_buffer_size-can-break-your-replication

0 komentar:

:)) ;)) ;;) :D ;) :p :(( :) :( :X =(( :-o :-/ :-* :| 8-} :)] ~x( :-t b-( :-L x( =))

Poskan Komentar

 
{nama-blog-anda} is proudly powered by Blogger.com | Template by Agus Ramadhani | o-om.com