{"id":383,"date":"2017-01-25T16:51:25","date_gmt":"2017-01-25T15:51:25","guid":{"rendered":"https:\/\/memo.xtranet.info\/?p=383"},"modified":"2017-01-25T16:51:25","modified_gmt":"2017-01-25T15:51:25","slug":"mysql-replication","status":"publish","type":"post","link":"https:\/\/memo.xtranet.info\/?p=383","title":{"rendered":"MySQL Replication"},"content":{"rendered":"

MySQL Replication<\/span><\/h1>\n
Passer par l'interface PhpMyAdmin\r\n\r\nA : Configurer Master \/ My.cnf :<\/span>\r\n\r\n\r\n- Restart Mysql : service mysql restart\r\n\r\n- Verification du log binaire : mysql> show master status;\r\n\r\n- Blocage des transactin Mysql : mysql> FLUSH TABLES WITH READ LOCK;\r\n\r\n- Arret du service Mysql : service mysql stop\r\n\r\n- Sauvegarder bases: recup\u00e9ration des bases dans \/var\/lib\/mysql et upload sur serveur Slave.\r\n\r\n- D\u00e9marrage du service Mysql : service mysql start\r\n\r\n- D\u00e9blocage des transactions Mysql : mysql> UNLOCK TABLES;\r\n\r\n\r\nB : configurer Slave \/ My.cnf<\/span>\r\n\r\n\r\n- Arret du service Mysql : service mysql stop\r\n\r\n- D\u00e9marrage du service Mysql : service mysql start --NOMDHOTE-host\r\n\u00a0\u00a0 \u00a0\r\n- D\u00e9marrage du porcess Slave : mysql> START SLAVE;\r\n\r\n\r\n---------------\r\nCommande Mysql|\r\n---------------\r\n\r\n\u00a0\u00a0 \u00a0- mysql -u root -p\r\n\u00a0\u00a0 \u00a0- SHOW MASTER STATUS;\r\n\u00a0\u00a0 \u00a0- SHOW SLAVE STATUS;<\/pre>\n
 <\/p>\n
My.cnf-Master :<\/strong><\/span>
\n[client]
\nport\u00a0\u00a0 \u00a0\u00a0\u00a0 \u00a0= 3306
\nsocket\u00a0\u00a0 \u00a0\u00a0\u00a0 \u00a0= \/var\/run\/mysqld\/mysqld.sock<\/p>\n
[mysqld_safe]
\nsocket\u00a0\u00a0 \u00a0\u00a0\u00a0 \u00a0= \/var\/run\/mysqld\/mysqld.sock
\nnice\u00a0\u00a0 \u00a0\u00a0\u00a0 \u00a0= 0<\/p>\n
[mysqld]<\/p>\n
log-bin=\/var\/log\/mysql\/mysql-bin.log
\nlog-error=\/var\/log\/mysql\/mysql-error.log
\nserver-id=1
\nbinlog-do-db = test1<\/p>\n
user\u00a0\u00a0 \u00a0\u00a0\u00a0 \u00a0= mysql
\npid-file\u00a0\u00a0 \u00a0= \/var\/run\/mysqld\/mysqld.pid
\nsocket\u00a0\u00a0 \u00a0\u00a0\u00a0 \u00a0= \/var\/run\/mysqld\/mysqld.sock
\nport\u00a0\u00a0 \u00a0\u00a0\u00a0 \u00a0= 3306
\nbasedir\u00a0\u00a0 \u00a0\u00a0\u00a0 \u00a0= \/usr
\ndatadir\u00a0\u00a0 \u00a0\u00a0\u00a0 \u00a0= \/var\/lib\/mysql
\ntmpdir\u00a0\u00a0 \u00a0\u00a0\u00a0 \u00a0= \/tmp
\nlc-messages-dir\u00a0\u00a0 \u00a0= \/usr\/share\/mysql
\nskip-external-locking<\/p>\n
bind-address\u00a0\u00a0 \u00a0\u00a0\u00a0 \u00a0= IP Local<\/p>\n
key_buffer\u00a0\u00a0 \u00a0\u00a0\u00a0 \u00a0= 16M
\nmax_allowed_packet\u00a0\u00a0 \u00a0= 16M
\nthread_stack\u00a0\u00a0 \u00a0\u00a0\u00a0 \u00a0= 192K
\nthread_cache_size\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 = 8<\/p>\n
myisam-recover\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 = BACKUP<\/p>\n
query_cache_limit\u00a0\u00a0 \u00a0= 1M
\nquery_cache_size\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 = 16M<\/p>\n
expire_logs_days\u00a0\u00a0 \u00a0= 10
\nmax_binlog_size\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 = 100M<\/p>\n
[mysqldump]
\nquick
\nquote-names
\nmax_allowed_packet\u00a0\u00a0 \u00a0= 16M<\/p>\n
[mysql]
\n#no-auto-rehash\u00a0\u00a0 \u00a0# faster start of mysql but no tab completition<\/p>\n
[isamchk]
\nkey_buffer\u00a0\u00a0 \u00a0\u00a0\u00a0 \u00a0= 16M<\/p>\n
!includedir \/etc\/mysql\/conf.d\/<\/p>\n
 <\/p>\n
My.cnf-Slave<\/strong><\/span><\/p>\n
 <\/p>\n
[client]
\nport\u00a0\u00a0 \u00a0\u00a0\u00a0 \u00a0= 3306
\nsocket\u00a0\u00a0 \u00a0\u00a0\u00a0 \u00a0= \/var\/run\/mysqld\/mysqld.sock<\/p>\n
[mysqld_safe]
\nsocket\u00a0\u00a0 \u00a0\u00a0\u00a0 \u00a0= \/var\/run\/mysqld\/mysqld.sock
\nnice\u00a0\u00a0 \u00a0\u00a0\u00a0 \u00a0= 0<\/p>\n
[mysqld]
\nlog-bin=mysql-bin
\nserver-id=1414677401<\/p>\n
user\u00a0\u00a0 \u00a0\u00a0\u00a0 \u00a0= mysql
\npid-file\u00a0\u00a0 \u00a0= \/var\/run\/mysqld\/mysqld.pid
\nsocket\u00a0\u00a0 \u00a0\u00a0\u00a0 \u00a0= \/var\/run\/mysqld\/mysqld.sock
\nport\u00a0\u00a0 \u00a0\u00a0\u00a0 \u00a0= 3306
\nbasedir\u00a0\u00a0 \u00a0\u00a0\u00a0 \u00a0= \/usr
\ndatadir\u00a0\u00a0 \u00a0\u00a0\u00a0 \u00a0= \/var\/lib\/mysql
\ntmpdir\u00a0\u00a0 \u00a0\u00a0\u00a0 \u00a0= \/tmp
\nlc-messages-dir\u00a0\u00a0 \u00a0= \/usr\/share\/mysql
\nskip-external-locking<\/p>\n
bind-address\u00a0\u00a0 \u00a0\u00a0\u00a0 \u00a0= 127.0.0.1<\/p>\n
key_buffer\u00a0\u00a0 \u00a0\u00a0\u00a0 \u00a0= 16M
\nmax_allowed_packet\u00a0\u00a0 \u00a0= 16M
\nthread_stack\u00a0\u00a0 \u00a0\u00a0\u00a0 \u00a0= 192K
\nthread_cache_size\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 = 8<\/p>\n
myisam-recover\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 = BACKUP<\/p>\n
query_cache_limit\u00a0\u00a0 \u00a0= 1M
\nquery_cache_size\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 = 16M<\/p>\n
log_slow_queries\u00a0\u00a0 \u00a0= \/var\/log\/mysql\/mysql-slow.log
\nlong_query_time = 2
\nlog-queries-not-using-indexes<\/p>\n
expire_logs_days\u00a0\u00a0 \u00a0= 10
\nmax_binlog_size\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 = 100M<\/p>\n
[mysqldump]
\nquick
\nquote-names
\nmax_allowed_packet\u00a0\u00a0 \u00a0= 16M<\/p>\n
[mysql]
\n#no-auto-rehash\u00a0\u00a0 \u00a0# faster start of mysql but no tab completition<\/p>\n
[isamchk]
\nkey_buffer\u00a0\u00a0 \u00a0\u00a0\u00a0 \u00a0= 16M<\/p>\n
!includedir \/etc\/mysql\/conf.d\/<\/p>\n","protected":false},"excerpt":{"rendered":"
MySQL Replication Passer par l’interface PhpMyAdmin A : Configurer Master \/ My.cnf : – Restart Mysql : service mysql restart – Verification du log binaire : mysql> show master status; – Blocage des transactin Mysql : mysql> FLUSH TABLES WITH READ LOCK; – Arret du service Mysql : service mysql stop – Sauvegarder bases: recup\u00e9ration… Continue reading MySQL Replication<\/span><\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[4,36],"tags":[45],"class_list":["post-383","post","type-post","status-publish","format-standard","hentry","category-linux","category-mysql","tag-mysql"],"_links":{"self":[{"href":"https:\/\/memo.xtranet.info\/index.php?rest_route=\/wp\/v2\/posts\/383","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/memo.xtranet.info\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/memo.xtranet.info\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/memo.xtranet.info\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/memo.xtranet.info\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=383"}],"version-history":[{"count":1,"href":"https:\/\/memo.xtranet.info\/index.php?rest_route=\/wp\/v2\/posts\/383\/revisions"}],"predecessor-version":[{"id":384,"href":"https:\/\/memo.xtranet.info\/index.php?rest_route=\/wp\/v2\/posts\/383\/revisions\/384"}],"wp:attachment":[{"href":"https:\/\/memo.xtranet.info\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=383"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/memo.xtranet.info\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=383"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/memo.xtranet.info\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=383"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}