Master,Slave間のデータ通信量を下げる 使用したのはMySQL5.0 Master,Slave両方のmy.cnfに下記を追加 ------------------------------------------------ [mysqld] port = 3306 socket = /tmp/mysql.sock これ追加 slave_compressed_protocol = 1 ------------------------------------------------ MySQLを再起動(Master,Slave両方) 確認 # /usr/local/mysql5.0/bin/mysql mysql> show variables like 'slave_compressed_protocol'; +---------------------------+-------
![『Master⇔Slaveでbinlog圧縮通信』](https://cdn-ak-scissors.b.st-hatena.com/image/square/004b93705677b5aa707ce37178568ca7fe2540c8/height=288;version=1;width=512/https%3A%2F%2Fstat.profile.ameba.jp%2Fprofile_images%2F20180312%2F01%2F73%2Flq%2Fg%2Fo01400140p_1520787082379_glpsa.gif)