{"id":148,"date":"2012-04-05T17:58:00","date_gmt":"2012-04-05T16:58:00","guid":{"rendered":"http:\/\/www.bocciolesi.fr\/tutoriels-et-cours\/?p=148"},"modified":"2017-02-24T14:20:09","modified_gmt":"2017-02-24T13:20:09","slug":"replication-mysql-croisee","status":"publish","type":"post","link":"https:\/\/bocciolesi.fr\/tutoriels-et-cours\/replication-mysql-croisee\/","title":{"rendered":"R\u00e9plication MySql Crois\u00e9e"},"content":{"rendered":"
\"image_pdf\"Enregistrer en PDF<\/span><\/a><\/a><\/div>

I\u25ba Nous allons voir dans cet article comment mettre en place une r\u00e9plication crois\u00e9e MySql en optimisant donc la r\u00e9partition des charges et la s\u00e9curisation des donn\u00e9es.<\/strong><\/span><\/p>\n

Pour des raisons de simplicit\u00e9, nous testerons cette config sur le m\u00eame serveur en utilisant mysqld_multi ( r\u00e9f\u00e9rez vous aux pr\u00e9c\u00e9dents articles )<\/p>\n

\"Ordi2\"<\/a><\/p>\n

 <\/p>\n

 <\/p>\n

 <\/p>\n

 <\/p>\n

 <\/p>\n

 <\/p>\n

 <\/p>\n

 <\/p>\n

 <\/p>\n

Voici le fichier de conf de MySql<\/span><\/strong><\/h1>\n

[root@\/etc\/mysql] cat multi_my.cnf.replicant.double<\/em><\/p>\n

[mysqld_multi]<\/strong>
\nmysqld = \/usr\/bin\/mysqld_safe
\nmysqladmin = \/usr\/bin\/mysqladmin
\nuser = root
\npassword = debian<\/p>\n

#——————– Serveur A ——————<\/strong>
\n[mysqld1]
\nsocket = \/tmp\/mysql.sock1
\nport = 3307
\npid-file = \/var\/lib\/mysql1\/hostname.pid1
\ndatadir = \/var\/lib\/mysql1
\nlanguage = \/usr\/share\/mysql\/french
\nuser = mysql<\/p>\n

server-id=1<\/strong>
\nlog-bin = \/var\/log\/mysql\/mysql_master_bin.log<\/strong>
\nbinlog_do_db=centrale<\/strong>
\nreplicate-do-db=centrale<\/strong><\/p>\n

master-host = 127.0.0.1
\nmaster-port = 3308
\nmaster-user = replicant
\nmaster-password = replicator<\/p>\n

relay-log = \/var\/lib\/mysql\/slave-relay.log<\/strong>
\nrelay-log-index = \/var\/lib\/mysql\/slave-relay-log.index<\/strong><\/p>\n

auto_increment_increment = 10
\nauto_increment_offset = 1<\/p>\n

#————–Serveur B ———————-<\/strong>
\n[mysqld2]
\nsocket = \/tmp\/mysql.sock2
\nport = 3308
\npid-file = \/var\/lib\/mysql2\/hostname.pid2
\ndatadir = \/var\/lib\/mysql2
\nlanguage = \/usr\/share\/mysql\/french
\nuser = mysql<\/p>\n

server-id=2<\/strong>
\nlog-bin = \/var\/log\/mysql\/mysql_master_bin.log<\/strong>
\nbinlog_do_db=centrale<\/strong>
\nreplicate-do-db=centrale<\/strong><\/p>\n

master-host = 127.0.0.1
\nmaster-port = 3307
\nmaster-user = replicant
\nmaster-password = replicator
\nmaster-connect-retry=60<\/p>\n

relay-log = \/var\/lib\/mysql\/slave-relay.log<\/strong>
\nrelay-log-index = \/var\/lib\/mysql\/slave-relay-log.index
\n<\/strong>
\nauto_increment_increment = 10
\nauto_increment_offset = 2<\/p>\n

Important :<\/span><\/strong><\/p>\n

Les fichiers de logs doivent \u00eatre les m\u00eames et l’utilisateur de r\u00e9plication doit bien s\u00fbr \u00eatre cr\u00e9\u00e9 sur les 2 serveurs ma\u00eetres.<\/p>\n","protected":false},"excerpt":{"rendered":"

I\u25ba Nous allons voir dans cet article comment mettre en place une r\u00e9plication crois\u00e9e MySql en optimisant donc la r\u00e9partition des charges et la s\u00e9curisation des donn\u00e9es. Pour …<\/p>\n","protected":false},"author":1,"featured_media":1547,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[37,5,39],"tags":[20],"class_list":["post-148","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-mariadb","category-mysql","category-tutoriels","tag-replication-mysql-croisee"],"yoast_head":"\nR\u00e9plication MySql Crois\u00e9e - Tutoriels et Cours<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/bocciolesi.fr\/tutoriels-et-cours\/replication-mysql-croisee\/\" \/>\n<meta property=\"og:locale\" content=\"fr_FR\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"R\u00e9plication MySql Crois\u00e9e - Tutoriels et Cours\" \/>\n<meta property=\"og:description\" content=\"I\u25ba Nous allons voir dans cet article comment mettre en place une r\u00e9plication crois\u00e9e MySql en optimisant donc la r\u00e9partition des charges et la s\u00e9curisation des donn\u00e9es. Pour ...\" \/>\n<meta property=\"og:url\" content=\"https:\/\/bocciolesi.fr\/tutoriels-et-cours\/replication-mysql-croisee\/\" \/>\n<meta property=\"og:site_name\" content=\"Tutoriels et Cours\" \/>\n<meta property=\"article:published_time\" content=\"2012-04-05T16:58:00+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2017-02-24T13:20:09+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/bocciolesi.fr\/tutoriels-et-cours\/wp-content\/uploads\/2013\/08\/bases-de-donnees.jpg\" \/>\n\t<meta property=\"og:image:width\" content=\"424\" \/>\n\t<meta property=\"og:image:height\" content=\"283\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/jpeg\" \/>\n<meta name=\"author\" content=\"Michel BOCCIOLESI\" \/>\n<meta name=\"twitter:label1\" content=\"\u00c9crit par\" \/>\n\t<meta name=\"twitter:data1\" content=\"Michel BOCCIOLESI\" \/>\n\t<meta name=\"twitter:label2\" content=\"Dur\u00e9e de lecture estim\u00e9e\" \/>\n\t<meta name=\"twitter:data2\" content=\"1 minute\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/bocciolesi.fr\/tutoriels-et-cours\/replication-mysql-croisee\/\",\"url\":\"https:\/\/bocciolesi.fr\/tutoriels-et-cours\/replication-mysql-croisee\/\",\"name\":\"R\u00e9plication MySql Crois\u00e9e - Tutoriels et Cours\",\"isPartOf\":{\"@id\":\"https:\/\/bocciolesi.fr\/tutoriels-et-cours\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/bocciolesi.fr\/tutoriels-et-cours\/replication-mysql-croisee\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/bocciolesi.fr\/tutoriels-et-cours\/replication-mysql-croisee\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/bocciolesi.fr\/tutoriels-et-cours\/wp-content\/uploads\/2013\/08\/bases-de-donnees.jpg\",\"datePublished\":\"2012-04-05T16:58:00+00:00\",\"dateModified\":\"2017-02-24T13:20:09+00:00\",\"author\":{\"@id\":\"https:\/\/bocciolesi.fr\/tutoriels-et-cours\/#\/schema\/person\/6bdfe0a1263b803645c69e3d5748dabe\"},\"breadcrumb\":{\"@id\":\"https:\/\/bocciolesi.fr\/tutoriels-et-cours\/replication-mysql-croisee\/#breadcrumb\"},\"inLanguage\":\"fr-FR\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/bocciolesi.fr\/tutoriels-et-cours\/replication-mysql-croisee\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"fr-FR\",\"@id\":\"https:\/\/bocciolesi.fr\/tutoriels-et-cours\/replication-mysql-croisee\/#primaryimage\",\"url\":\"https:\/\/bocciolesi.fr\/tutoriels-et-cours\/wp-content\/uploads\/2013\/08\/bases-de-donnees.jpg\",\"contentUrl\":\"https:\/\/bocciolesi.fr\/tutoriels-et-cours\/wp-content\/uploads\/2013\/08\/bases-de-donnees.jpg\",\"width\":424,\"height\":283,\"caption\":\"Cours et tutoriels MySQL et Maria DB\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/bocciolesi.fr\/tutoriels-et-cours\/replication-mysql-croisee\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Accueil\",\"item\":\"https:\/\/bocciolesi.fr\/tutoriels-et-cours\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"R\u00e9plication MySql Crois\u00e9e\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/bocciolesi.fr\/tutoriels-et-cours\/#website\",\"url\":\"https:\/\/bocciolesi.fr\/tutoriels-et-cours\/\",\"name\":\"Tutoriels et Cours\",\"description\":\"Michel Bocciolesi | Formateur Consultant en Informatique\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/bocciolesi.fr\/tutoriels-et-cours\/?s={search_term_string}\"},\"query-input\":\"required name=search_term_string\"}],\"inLanguage\":\"fr-FR\"},{\"@type\":\"Person\",\"@id\":\"https:\/\/bocciolesi.fr\/tutoriels-et-cours\/#\/schema\/person\/6bdfe0a1263b803645c69e3d5748dabe\",\"name\":\"Michel BOCCIOLESI\",\"description\":\"Michel Bocciolesi est consultant et formateur sp\u00e9cialis\u00e9 en Informatique.\",\"sameAs\":[\"https:\/\/www.mb-creation-web.fr\"],\"url\":\"https:\/\/bocciolesi.fr\/tutoriels-et-cours\/author\/michel\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"R\u00e9plication MySql Crois\u00e9e - Tutoriels et Cours","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/bocciolesi.fr\/tutoriels-et-cours\/replication-mysql-croisee\/","og_locale":"fr_FR","og_type":"article","og_title":"R\u00e9plication MySql Crois\u00e9e - Tutoriels et Cours","og_description":"I\u25ba Nous allons voir dans cet article comment mettre en place une r\u00e9plication crois\u00e9e MySql en optimisant donc la r\u00e9partition des charges et la s\u00e9curisation des donn\u00e9es. Pour ...","og_url":"https:\/\/bocciolesi.fr\/tutoriels-et-cours\/replication-mysql-croisee\/","og_site_name":"Tutoriels et Cours","article_published_time":"2012-04-05T16:58:00+00:00","article_modified_time":"2017-02-24T13:20:09+00:00","og_image":[{"width":424,"height":283,"url":"https:\/\/bocciolesi.fr\/tutoriels-et-cours\/wp-content\/uploads\/2013\/08\/bases-de-donnees.jpg","type":"image\/jpeg"}],"author":"Michel BOCCIOLESI","twitter_misc":{"\u00c9crit par":"Michel BOCCIOLESI","Dur\u00e9e de lecture estim\u00e9e":"1 minute"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/bocciolesi.fr\/tutoriels-et-cours\/replication-mysql-croisee\/","url":"https:\/\/bocciolesi.fr\/tutoriels-et-cours\/replication-mysql-croisee\/","name":"R\u00e9plication MySql Crois\u00e9e - Tutoriels et Cours","isPartOf":{"@id":"https:\/\/bocciolesi.fr\/tutoriels-et-cours\/#website"},"primaryImageOfPage":{"@id":"https:\/\/bocciolesi.fr\/tutoriels-et-cours\/replication-mysql-croisee\/#primaryimage"},"image":{"@id":"https:\/\/bocciolesi.fr\/tutoriels-et-cours\/replication-mysql-croisee\/#primaryimage"},"thumbnailUrl":"https:\/\/bocciolesi.fr\/tutoriels-et-cours\/wp-content\/uploads\/2013\/08\/bases-de-donnees.jpg","datePublished":"2012-04-05T16:58:00+00:00","dateModified":"2017-02-24T13:20:09+00:00","author":{"@id":"https:\/\/bocciolesi.fr\/tutoriels-et-cours\/#\/schema\/person\/6bdfe0a1263b803645c69e3d5748dabe"},"breadcrumb":{"@id":"https:\/\/bocciolesi.fr\/tutoriels-et-cours\/replication-mysql-croisee\/#breadcrumb"},"inLanguage":"fr-FR","potentialAction":[{"@type":"ReadAction","target":["https:\/\/bocciolesi.fr\/tutoriels-et-cours\/replication-mysql-croisee\/"]}]},{"@type":"ImageObject","inLanguage":"fr-FR","@id":"https:\/\/bocciolesi.fr\/tutoriels-et-cours\/replication-mysql-croisee\/#primaryimage","url":"https:\/\/bocciolesi.fr\/tutoriels-et-cours\/wp-content\/uploads\/2013\/08\/bases-de-donnees.jpg","contentUrl":"https:\/\/bocciolesi.fr\/tutoriels-et-cours\/wp-content\/uploads\/2013\/08\/bases-de-donnees.jpg","width":424,"height":283,"caption":"Cours et tutoriels MySQL et Maria DB"},{"@type":"BreadcrumbList","@id":"https:\/\/bocciolesi.fr\/tutoriels-et-cours\/replication-mysql-croisee\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Accueil","item":"https:\/\/bocciolesi.fr\/tutoriels-et-cours\/"},{"@type":"ListItem","position":2,"name":"R\u00e9plication MySql Crois\u00e9e"}]},{"@type":"WebSite","@id":"https:\/\/bocciolesi.fr\/tutoriels-et-cours\/#website","url":"https:\/\/bocciolesi.fr\/tutoriels-et-cours\/","name":"Tutoriels et Cours","description":"Michel Bocciolesi | Formateur Consultant en Informatique","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/bocciolesi.fr\/tutoriels-et-cours\/?s={search_term_string}"},"query-input":"required name=search_term_string"}],"inLanguage":"fr-FR"},{"@type":"Person","@id":"https:\/\/bocciolesi.fr\/tutoriels-et-cours\/#\/schema\/person\/6bdfe0a1263b803645c69e3d5748dabe","name":"Michel BOCCIOLESI","description":"Michel Bocciolesi est consultant et formateur sp\u00e9cialis\u00e9 en Informatique.","sameAs":["https:\/\/www.mb-creation-web.fr"],"url":"https:\/\/bocciolesi.fr\/tutoriels-et-cours\/author\/michel\/"}]}},"_links":{"self":[{"href":"https:\/\/bocciolesi.fr\/tutoriels-et-cours\/wp-json\/wp\/v2\/posts\/148","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/bocciolesi.fr\/tutoriels-et-cours\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/bocciolesi.fr\/tutoriels-et-cours\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/bocciolesi.fr\/tutoriels-et-cours\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/bocciolesi.fr\/tutoriels-et-cours\/wp-json\/wp\/v2\/comments?post=148"}],"version-history":[{"count":10,"href":"https:\/\/bocciolesi.fr\/tutoriels-et-cours\/wp-json\/wp\/v2\/posts\/148\/revisions"}],"predecessor-version":[{"id":1633,"href":"https:\/\/bocciolesi.fr\/tutoriels-et-cours\/wp-json\/wp\/v2\/posts\/148\/revisions\/1633"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/bocciolesi.fr\/tutoriels-et-cours\/wp-json\/wp\/v2\/media\/1547"}],"wp:attachment":[{"href":"https:\/\/bocciolesi.fr\/tutoriels-et-cours\/wp-json\/wp\/v2\/media?parent=148"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/bocciolesi.fr\/tutoriels-et-cours\/wp-json\/wp\/v2\/categories?post=148"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/bocciolesi.fr\/tutoriels-et-cours\/wp-json\/wp\/v2\/tags?post=148"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}