{"id":711,"date":"2013-09-26T18:34:57","date_gmt":"2013-09-26T16:34:57","guid":{"rendered":"http:\/\/blog.jeremm.fr\/?p=711"},"modified":"2014-09-24T19:26:42","modified_gmt":"2014-09-24T17:26:42","slug":"installer-un-cluster-percona-xtradb-galera","status":"publish","type":"post","link":"https:\/\/blog.jeremm.fr\/?p=711","title":{"rendered":"Installer un cluster percona-xtradb (galera)"},"content":{"rendered":"

Ajouter les paquets :<\/p>\n

echo 'deb http:\/\/repo.percona.com\/apt wheezy main' > \/etc\/apt\/sources.list.d\/percona.list\r\ngpg --keyserver\u00a0 hkp:\/\/keys.gnupg.net --recv-keys 1C4CBDCDCD2EFD2A ; gpg -a --export CD2EFD2A | apt-key add -\r\napt-get update\r\napt-get install percona-xtradb-cluster-server-5.5 xtrabackup<\/pre>\n
Ajouter la configuration au my.cnf:<\/p>\n
# Cluster\r\nwsrep_provider                  = \/usr\/lib\/libgalera_smm.so\r\nwsrep_cluster_address           = gcomm:\/\/192.168.0.211,192.168.0.212,192.168.0.213\r\nwsrep_slave_threads             = 8\r\nwsrep_sst_method\t\t\t\t= xtrabackup\r\nwsrep_sst_auth                  = debian-sys-maint:\r\nwsrep_cluster_name              = test_cluster\r\nwsrep_node_name                 = M1\r\nwsrep_node_address              = 192.168.0.211\r\nbinlog_format                   = ROW\r\ndefault_storage_engine          = InnoDB\r\ninnodb_autoinc_lock_mode        = 2\r\ninnodb_locks_unsafe_for_binlog  = 1\r\ntransaction-isolation           = READ-COMMITTED\r\nwsrep_causal_reads              = OFF<\/pre>\n
Pour d\u00e9marrer le premier serveur du cluster la premi\u00e8re fois, utiliser la commande :<\/p>\n
\/etc\/init.d\/mysql bootstrap-pxc<\/pre>\n
Il faut au minimum 3 serveurs pour \u00e9viter, quand cas de probl\u00e8me r\u00e9seaux sur un des serveurs, que le noeud restant ne se voit autonome et bloque les requ\u00eates.<\/p>\n
Pour voir si le noeud du cluster est pr\u00eat \u00e0 recevoir des requ\u00eates :<\/p>\n
mysql -e\"show status like 'wsrep_ready'\"<\/pre>\n
Pour voir plus en d\u00e9tail l’\u00e9tat du cluster :<\/p>\n
mysql -e\"show status like 'wsrep_%'\"<\/pre>\n
Pour la description des variables, voir : http:\/\/galeracluster.com\/documentation-webpages\/galerastatusvariables.html<\/a><\/p>\n
!! Attention !!<\/strong> Ce cluster ne fonctionne qu’avec des tables InnoDB, la r\u00e9plication MyISAM n’est qu’en beta et n’est pas fonctionnelle (table non identique sur chaque noeud en cas de \u00ab\u00a0duplicate entry\u00a0\u00bb). Pour l’activer malgr\u00e9 tout :<\/p>\n
wsrep_replicate_myisam          = 1<\/pre>\n
Maj 27\/03\/14 : Lien mort<\/p>\n","protected":false},"excerpt":{"rendered":"
Ajouter les paquets : echo ‘deb http:\/\/repo.percona.com\/apt wheezy main’ > \/etc\/apt\/sources.list.d\/percona.list gpg –keyserver\u00a0 hkp:\/\/keys.gnupg.net –recv-keys 1C4CBDCDCD2EFD2A ; gpg -a –export CD2EFD2A | apt-key add – apt-get update apt-get install percona-xtradb-cluster-server-5.5 xtrabackup Ajouter la configuration au my.cnf: # Cluster wsrep_provider = \/usr\/lib\/libgalera_smm.so wsrep_cluster_address = gcomm:\/\/192.168.0.211,192.168.0.212,192.168.0.213 wsrep_slave_threads = 8 wsrep_sst_method = xtrabackup wsrep_sst_auth = debian-sys-maint: wsrep_cluster_name = […]<\/a><\/p>\n","protected":false},"author":2,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":[],"categories":[5],"tags":[77,75,15,76,74],"_links":{"self":[{"href":"https:\/\/blog.jeremm.fr\/index.php?rest_route=\/wp\/v2\/posts\/711"}],"collection":[{"href":"https:\/\/blog.jeremm.fr\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/blog.jeremm.fr\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/blog.jeremm.fr\/index.php?rest_route=\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/blog.jeremm.fr\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=711"}],"version-history":[{"count":26,"href":"https:\/\/blog.jeremm.fr\/index.php?rest_route=\/wp\/v2\/posts\/711\/revisions"}],"predecessor-version":[{"id":860,"href":"https:\/\/blog.jeremm.fr\/index.php?rest_route=\/wp\/v2\/posts\/711\/revisions\/860"}],"wp:attachment":[{"href":"https:\/\/blog.jeremm.fr\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=711"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/blog.jeremm.fr\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=711"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/blog.jeremm.fr\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=711"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}