{"id":19418,"date":"2016-06-17T08:01:55","date_gmt":"2016-06-17T13:01:55","guid":{"rendered":"https:\/\/www.rosehosting.com\/blog\/?p=19418"},"modified":"2023-04-25T07:13:08","modified_gmt":"2023-04-25T12:13:08","slug":"how-to-setup-mysql-replication-on-centos","status":"publish","type":"post","link":"https:\/\/www.rosehosting.com\/blog\/how-to-setup-mysql-replication-on-centos\/","title":{"rendered":"How to setup MySQL replication on CentOS"},"content":{"rendered":"<div id=\"bsf_rt_marker\"><\/div><p><img decoding=\"async\" class=\"alignnone size-full wp-image-24537\" src=\"https:\/\/www.rosehosting.com\/blog\/wp-content\/uploads\/2016\/06\/How-to-setup-MySQL-replication-on-CentOS.jpg\" alt=\"How to setup MySQL replication on CentOS\" width=\"1200\" height=\"600\" srcset=\"https:\/\/www.rosehosting.com\/blog\/wp-content\/uploads\/2016\/06\/How-to-setup-MySQL-replication-on-CentOS.jpg 1200w, https:\/\/www.rosehosting.com\/blog\/wp-content\/uploads\/2016\/06\/How-to-setup-MySQL-replication-on-CentOS-150x75.jpg 150w, https:\/\/www.rosehosting.com\/blog\/wp-content\/uploads\/2016\/06\/How-to-setup-MySQL-replication-on-CentOS-300x150.jpg 300w, https:\/\/www.rosehosting.com\/blog\/wp-content\/uploads\/2016\/06\/How-to-setup-MySQL-replication-on-CentOS-768x384.jpg 768w, https:\/\/www.rosehosting.com\/blog\/wp-content\/uploads\/2016\/06\/How-to-setup-MySQL-replication-on-CentOS-1024x512.jpg 1024w, https:\/\/www.rosehosting.com\/blog\/wp-content\/uploads\/2016\/06\/How-to-setup-MySQL-replication-on-CentOS-860x430.jpg 860w, https:\/\/www.rosehosting.com\/blog\/wp-content\/uploads\/2016\/06\/How-to-setup-MySQL-replication-on-CentOS-680x340.jpg 680w, https:\/\/www.rosehosting.com\/blog\/wp-content\/uploads\/2016\/06\/How-to-setup-MySQL-replication-on-CentOS-500x250.jpg 500w, https:\/\/www.rosehosting.com\/blog\/wp-content\/uploads\/2016\/06\/How-to-setup-MySQL-replication-on-CentOS-400x200.jpg 400w, https:\/\/www.rosehosting.com\/blog\/wp-content\/uploads\/2016\/06\/How-to-setup-MySQL-replication-on-CentOS-200x100.jpg 200w, https:\/\/www.rosehosting.com\/blog\/wp-content\/uploads\/2016\/06\/How-to-setup-MySQL-replication-on-CentOS-50x25.jpg 50w\" sizes=\"(max-width: 1200px) 100vw, 1200px\" \/><\/p>\n<p>In this tutorial we will show you how to setup basic MySQL replication on two <a href=\"https:\/\/www.rosehosting.com\/centos-hosting.html\" target=\"_blank\" rel=\"noopener noreferrer\">CentOS 7 servers<\/a>, but the same steps should work on all RPM based systems. We will use two test CentOS 7 virtual servers for this tutorial with the following IP addresses:<\/p>\n<p><!--more--><br \/>\n<strong>MASTER:<\/strong> 123.456.789.1<br \/>\n<strong>SLAVE:<\/strong> 123.456.789.2<\/p>\n<h3><strong>Master Server:<\/strong><\/h3>\n<div id=\"ez-toc-container\" class=\"ez-toc-v2_0_82_2 counter-hierarchy ez-toc-counter ez-toc-transparent ez-toc-container-direction\">\n<p class=\"ez-toc-title\" style=\"cursor:inherit\">Table of Contents<\/p>\n<label for=\"ez-toc-cssicon-toggle-item-69eadf69e5f06\" class=\"ez-toc-cssicon-toggle-label\"><span class=\"ez-toc-cssicon\"><span class=\"eztoc-hide\" style=\"display:none;\">Toggle<\/span><span class=\"ez-toc-icon-toggle-span\"><svg style=\"fill: #999;color:#999\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\" class=\"list-377408\" width=\"20px\" height=\"20px\" viewBox=\"0 0 24 24\" fill=\"none\"><path d=\"M6 6H4v2h2V6zm14 0H8v2h12V6zM4 11h2v2H4v-2zm16 0H8v2h12v-2zM4 16h2v2H4v-2zm16 0H8v2h12v-2z\" fill=\"currentColor\"><\/path><\/svg><svg style=\"fill: #999;color:#999\" class=\"arrow-unsorted-368013\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\" width=\"10px\" height=\"10px\" viewBox=\"0 0 24 24\" version=\"1.2\" baseProfile=\"tiny\"><path d=\"M18.2 9.3l-6.2-6.3-6.2 6.3c-.2.2-.3.4-.3.7s.1.5.3.7c.2.2.4.3.7.3h11c.3 0 .5-.1.7-.3.2-.2.3-.5.3-.7s-.1-.5-.3-.7zM5.8 14.7l6.2 6.3 6.2-6.3c.2-.2.3-.5.3-.7s-.1-.5-.3-.7c-.2-.2-.4-.3-.7-.3h-11c-.3 0-.5.1-.7.3-.2.2-.3.5-.3.7s.1.5.3.7z\"\/><\/svg><\/span><\/span><\/label><input type=\"checkbox\"  id=\"ez-toc-cssicon-toggle-item-69eadf69e5f06\"  aria-label=\"Toggle\" \/><nav><ul class='ez-toc-list ez-toc-list-level-1 ' ><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-1\" href=\"https:\/\/www.rosehosting.com\/blog\/how-to-setup-mysql-replication-on-centos\/#1-Login-via-SSH\" >1. Login via SSH<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-2\" href=\"https:\/\/www.rosehosting.com\/blog\/how-to-setup-mysql-replication-on-centos\/#2-Install-MySQL-server\" >2. Install MySQL server<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-3\" href=\"https:\/\/www.rosehosting.com\/blog\/how-to-setup-mysql-replication-on-centos\/#3-Start-the-MySQL-server\" >3.\u00a0Start the MySQL server<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-4\" href=\"https:\/\/www.rosehosting.com\/blog\/how-to-setup-mysql-replication-on-centos\/#4-Configure-MySQL-server\" >4. Configure\u00a0MySQL server<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-5\" href=\"https:\/\/www.rosehosting.com\/blog\/how-to-setup-mysql-replication-on-centos\/#5-Restart-MySQL-server\" >5.\u00a0 Restart MySQL server<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-6\" href=\"https:\/\/www.rosehosting.com\/blog\/how-to-setup-mysql-replication-on-centos\/#6-Create-MySQL-user-for-the-slave-server-and-configure-it\" >6. Create MySQL user for the slave server and configure it<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-7\" href=\"https:\/\/www.rosehosting.com\/blog\/how-to-setup-mysql-replication-on-centos\/#7-Login-via-SSH-and-install-MySQL-Server-on-the-Slave-Server\" >7. Login via SSH and install MySQL Server on the Slave Server<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-8\" href=\"https:\/\/www.rosehosting.com\/blog\/how-to-setup-mysql-replication-on-centos\/#8-Restart-MySQL-Server\" >8. Restart MySQL Server<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-9\" href=\"https:\/\/www.rosehosting.com\/blog\/how-to-setup-mysql-replication-on-centos\/#9-Configure-MySQL-Server\" >9. Configure MySQL Server<\/a><\/li><\/ul><\/nav><\/div>\n<h2><span class=\"ez-toc-section\" id=\"1-Login-via-SSH\"><\/span>1. Login via SSH<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>Login to the master server as user root<\/p>\n<pre>ssh root@IP_Address<\/pre>\n<h2><span class=\"ez-toc-section\" id=\"2-Install-MySQL-server\"><\/span>2. Install MySQL server<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>and install MySQL server if it is not already installed<\/p>\n<pre>yum install mysql-server mysql<\/pre>\n<h2><span class=\"ez-toc-section\" id=\"3-Start-the-MySQL-server\"><\/span>3.\u00a0Start the MySQL server<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>Start the MySQL server and enable it to start at boot time<\/p>\n<pre>systemctl start mysql\nsystemctl enable mysql<\/pre>\n<h2><span class=\"ez-toc-section\" id=\"4-Configure-MySQL-server\"><\/span>4. Configure\u00a0MySQL server<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>Next, open the MySQL configuration file with a text editor and add the following lines<\/p>\n<pre>vi \/etc\/my.cnf<\/pre>\n<pre>server-id = 1\nbinlog-do-db=database\nrelay-log = mysql-relay-bin\nrelay-log-index = mysql-relay-bin.index\nlog-bin = mysql-bin<\/pre>\n<p>Don&#8217;t forget to replace &#8216;<em>database<\/em>&#8216; with the actual name of the database that you want to replicate to the slave server.<\/p>\n<h2><span class=\"ez-toc-section\" id=\"5-Restart-MySQL-server\"><\/span>5.\u00a0 Restart MySQL server<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>Save the configuration file and restart the MySQL server for the changes to take effect<\/p>\n<pre>systemctl restart mysql<\/pre>\n<h2><span class=\"ez-toc-section\" id=\"6-Create-MySQL-user-for-the-slave-server-and-configure-it\"><\/span>6. Create MySQL user for the slave server and configure it<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>Login to the MySQL server as user root and create a user that will be used by the slave<\/p>\n<pre>mysql -u root -p<\/pre>\n<pre>mysql&gt; GRANT REPLICATION SLAVE ON *.* TO 'slaveuser'@'%' IDENTIFIED BY 'PASSWORD'\nmysql&gt; FLUSH PRIVILEGES;\nmysql&gt; FLUSH TABLES WITH READ LOCK;\nmysql&gt; SHOW MASTER STATUS;\nmysql&gt; SHOW MASTER STATUS;\n+------------------+----------+--------------+------------------+\n| File             | Position | Binlog_Do_DB | Binlog_Ignore_DB |\n+------------------+----------+--------------+------------------+\n| mysql-bin.000001 |      245 | database     |                  |\n+------------------+----------+--------------+------------------+\n1 row in set (0.00 sec)\n\nmysql&gt; exit<\/pre>\n<p>We will need the master&#8217;s coordinates that are going to be used for the slave server, so write them down.<\/p>\n<p><em><strong>File:<\/strong> mysql-bin.000001<br \/>\n<strong>Position:<\/strong> 245<\/em><\/p>\n<p>Replace &#8216;<em>PASSWORD<\/em>&#8216; with an actual strong password.<\/p>\n<p>Now, if the database you want to replicate is not empty, create a dump from the database<\/p>\n<pre>mysqldump -u root -p --master-data database &gt; \/root\/database.sql<\/pre>\n<p>and transfer the dump file to the slave server<\/p>\n<pre>rsync -Waq -e ssh \/root\/database.sql 123.456.789.2:\/root<\/pre>\n<h3><strong>Slave Server:<\/strong><\/h3>\n<h2><span class=\"ez-toc-section\" id=\"7-Login-via-SSH-and-install-MySQL-Server-on-the-Slave-Server\"><\/span>7. Login via SSH and install MySQL Server on the Slave Server<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>Next step is to configure the slave server. Login to the slave server via SSH as user root and install MySQL server as we did on the master server.<\/p>\n<p>After the MySQL server is installed and started, open its configuration file and add the following lines:<\/p>\n<pre>vi \/etc\/my.cnf<\/pre>\n<pre>server-id = 2\nmaster-host=123.456.789.1\nmaster-connect-retry=60\nmaster-user=slaveuser\nmaster-password=PASSWORD\nreplicate-do-db=database\nrelay-log = mysql-relay-bin\nlog-bin = mysql-bin<\/pre>\n<h2><span class=\"ez-toc-section\" id=\"8-Restart-MySQL-Server\"><\/span>8. Restart MySQL Server<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>Save the file and restart the MySQL server for the changes to change effect.<\/p>\n<pre>systemctl restart mysql<\/pre>\n<p>Import the MySQL dump file we created on the master server<\/p>\n<pre>mysql -u root -p &lt; \/root\/database.sql<\/pre>\n<h2><span class=\"ez-toc-section\" id=\"9-Configure-MySQL-Server\"><\/span>9. Configure MySQL Server<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>Login to MySQL as user root stop the slave and configure it where to look for the &#8216;master log file&#8217;<\/p>\n<pre>mysql -u root -p<\/pre>\n<pre>mysql&gt; slave stop;\nmysql&gt; CHANGE MASTER TO MASTER_HOST='123.456.789.1', MASTER_USER='slaveuser', MASTER_PASSWORD='PASSWORD', MASTER_LOG_FILE='mysql-bin.000001', MASTER_LOG_POS=245;\nmysql&gt; slave start;<\/pre>\n<p>Use the MySQL username and password we created on the master server.<\/p>\n<p>You can check the slave status by executing the following MySQL command:<\/p>\n<pre>mysql&gt; show slave status;<\/pre>\n<pre>*************************** 1. row ***************************\n               Slave_IO_State: Waiting for master to send event\n                  Master_Host: 123.456.789.1\n                  Master_User: slaveuser\n                  Master_Port: 3306\n              Master_Log_File: mysql-bin.000001\n             Slave_IO_Running: Yes\n            Slave_SQL_Running: Yes\n              Replicate_Do_DB: database<\/pre>\n<p>If &#8216;<em>Slave_IO_State<\/em>&#8216; reports &#8216;Waiting for master to send event&#8217; the replication is successful.<\/p>\n<p>That is all. It&#8217;s that easy. If you need more information on how to setup a replication master configuration you can find it on <a href=\"https:\/\/dev.mysql.com\/doc\/refman\/8.0\/en\/replication-howto-masterbaseconfig.html\" target=\"_blank\" rel=\"noopener noreferrer\">MySQL&#8217;s official website.<\/a><\/p>\n<hr \/>\n<p>Of course you don\u2019t have to\u00a0setup MySQL replication on CentOS, if you use one of our <a href=\"https:\/\/www.rosehosting.com\/mysql-hosting.html\">MySQL Hosting services<\/a>, in which case you can simply ask our expert Linux admins to setup MySQL replication on CentOS for you. They are available 24\u00d77 and will take care of your request immediately. You can also check new updates on <a href=\"https:\/\/www.rosehosting.com\/blog\/how-to-install-mysql-on-centos-7\/\">How to Install MySQL on CentOS 7<\/a>.<\/p>\n<p><span style=\"color: #ff0000;\"><strong>PS.<\/strong><\/span> If you liked this post on how to setup MySQL replication on CentOS, please share it with your friends on the social networks using the buttons on the left or simply leave a reply below. Thanks.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>In this tutorial we will show you how to setup basic MySQL replication on two CentOS 7 servers, but the &#8230; <\/p>\n<p class=\"read-more-container\"><a title=\"How to setup MySQL replication on CentOS\" class=\"read-more button\" href=\"https:\/\/www.rosehosting.com\/blog\/how-to-setup-mysql-replication-on-centos\/#more-19418\" aria-label=\"Read more about How to setup MySQL replication on CentOS\">Read More<\/a><\/p>\n","protected":false},"author":4,"featured_media":24537,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[1699,1702,21],"tags":[34,39,1238],"class_list":["post-19418","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-centos","category-databases","category-tips-and-tricks","tag-centos","tag-mysql","tag-replication","generate-columns","tablet-grid-50","mobile-grid-100","grid-parent","grid-33"],"yoast_head":"<!-- This site is optimized with the Yoast SEO Premium plugin v27.4 (Yoast SEO v27.4) - https:\/\/yoast.com\/product\/yoast-seo-premium-wordpress\/ -->\n<title>How to setup MySQL replication on CentOS | RoseHosting<\/title>\n<meta name=\"description\" content=\"How to setup MySQL replication on CentOS | RoseHosting\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/www.rosehosting.com\/blog\/how-to-setup-mysql-replication-on-centos\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"How to setup MySQL replication on CentOS\" \/>\n<meta property=\"og:description\" content=\"How to setup MySQL replication on CentOS | RoseHosting\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.rosehosting.com\/blog\/how-to-setup-mysql-replication-on-centos\/\" \/>\n<meta property=\"og:site_name\" content=\"RoseHosting\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/RoseHosting\" \/>\n<meta property=\"article:author\" content=\"https:\/\/www.facebook.com\/rosehosting.helpdesk\" \/>\n<meta property=\"article:published_time\" content=\"2016-06-17T13:01:55+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2023-04-25T12:13:08+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.rosehosting.com\/blog\/wp-content\/uploads\/2016\/06\/How-to-setup-MySQL-replication-on-CentOS.jpg\" \/>\n\t<meta property=\"og:image:width\" content=\"1200\" \/>\n\t<meta property=\"og:image:height\" content=\"600\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/jpeg\" \/>\n<meta name=\"author\" content=\"Jeff Wilson\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:creator\" content=\"@rosehosting\" \/>\n<meta name=\"twitter:site\" content=\"@rosehosting\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Jeff Wilson\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"4 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\\\/\\\/www.rosehosting.com\\\/blog\\\/how-to-setup-mysql-replication-on-centos\\\/#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.rosehosting.com\\\/blog\\\/how-to-setup-mysql-replication-on-centos\\\/\"},\"author\":{\"name\":\"Jeff Wilson\",\"@id\":\"https:\\\/\\\/www.rosehosting.com\\\/blog\\\/#\\\/schema\\\/person\\\/7ce77a842fa6a9a7f8efa186f2353713\"},\"headline\":\"How to setup MySQL replication on CentOS\",\"datePublished\":\"2016-06-17T13:01:55+00:00\",\"dateModified\":\"2023-04-25T12:13:08+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/www.rosehosting.com\\\/blog\\\/how-to-setup-mysql-replication-on-centos\\\/\"},\"wordCount\":518,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\\\/\\\/www.rosehosting.com\\\/blog\\\/#organization\"},\"image\":{\"@id\":\"https:\\\/\\\/www.rosehosting.com\\\/blog\\\/how-to-setup-mysql-replication-on-centos\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/www.rosehosting.com\\\/blog\\\/wp-content\\\/uploads\\\/2016\\\/06\\\/How-to-setup-MySQL-replication-on-CentOS.jpg\",\"keywords\":[\"centos\",\"mysql\",\"replication\"],\"articleSection\":[\"CentOS\",\"Databases\",\"Tips and Tricks\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\\\/\\\/www.rosehosting.com\\\/blog\\\/how-to-setup-mysql-replication-on-centos\\\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/www.rosehosting.com\\\/blog\\\/how-to-setup-mysql-replication-on-centos\\\/\",\"url\":\"https:\\\/\\\/www.rosehosting.com\\\/blog\\\/how-to-setup-mysql-replication-on-centos\\\/\",\"name\":\"How to setup MySQL replication on CentOS | RoseHosting\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.rosehosting.com\\\/blog\\\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\\\/\\\/www.rosehosting.com\\\/blog\\\/how-to-setup-mysql-replication-on-centos\\\/#primaryimage\"},\"image\":{\"@id\":\"https:\\\/\\\/www.rosehosting.com\\\/blog\\\/how-to-setup-mysql-replication-on-centos\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/www.rosehosting.com\\\/blog\\\/wp-content\\\/uploads\\\/2016\\\/06\\\/How-to-setup-MySQL-replication-on-CentOS.jpg\",\"datePublished\":\"2016-06-17T13:01:55+00:00\",\"dateModified\":\"2023-04-25T12:13:08+00:00\",\"description\":\"How to setup MySQL replication on CentOS | RoseHosting\",\"breadcrumb\":{\"@id\":\"https:\\\/\\\/www.rosehosting.com\\\/blog\\\/how-to-setup-mysql-replication-on-centos\\\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/www.rosehosting.com\\\/blog\\\/how-to-setup-mysql-replication-on-centos\\\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/www.rosehosting.com\\\/blog\\\/how-to-setup-mysql-replication-on-centos\\\/#primaryimage\",\"url\":\"https:\\\/\\\/www.rosehosting.com\\\/blog\\\/wp-content\\\/uploads\\\/2016\\\/06\\\/How-to-setup-MySQL-replication-on-CentOS.jpg\",\"contentUrl\":\"https:\\\/\\\/www.rosehosting.com\\\/blog\\\/wp-content\\\/uploads\\\/2016\\\/06\\\/How-to-setup-MySQL-replication-on-CentOS.jpg\",\"width\":1200,\"height\":600,\"caption\":\"How to setup MySQL replication on CentOS\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/www.rosehosting.com\\\/blog\\\/how-to-setup-mysql-replication-on-centos\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\\\/\\\/www.rosehosting.com\\\/blog\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"How to setup MySQL replication on CentOS\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/www.rosehosting.com\\\/blog\\\/#website\",\"url\":\"https:\\\/\\\/www.rosehosting.com\\\/blog\\\/\",\"name\":\"RoseHosting.com\",\"description\":\"Premium Linux Tutorials Since 2001\",\"publisher\":{\"@id\":\"https:\\\/\\\/www.rosehosting.com\\\/blog\\\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\\\/\\\/www.rosehosting.com\\\/blog\\\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\\\/\\\/www.rosehosting.com\\\/blog\\\/#organization\",\"name\":\"RoseHosting\",\"url\":\"https:\\\/\\\/www.rosehosting.com\\\/blog\\\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/www.rosehosting.com\\\/blog\\\/#\\\/schema\\\/logo\\\/image\\\/\",\"url\":\"https:\\\/\\\/www.rosehosting.com\\\/blog\\\/wp-content\\\/uploads\\\/2022\\\/03\\\/android-chrome-192x192-1.png\",\"contentUrl\":\"https:\\\/\\\/www.rosehosting.com\\\/blog\\\/wp-content\\\/uploads\\\/2022\\\/03\\\/android-chrome-192x192-1.png\",\"width\":192,\"height\":192,\"caption\":\"RoseHosting\"},\"image\":{\"@id\":\"https:\\\/\\\/www.rosehosting.com\\\/blog\\\/#\\\/schema\\\/logo\\\/image\\\/\"},\"sameAs\":[\"https:\\\/\\\/www.facebook.com\\\/RoseHosting\",\"https:\\\/\\\/x.com\\\/rosehosting\",\"https:\\\/\\\/www.linkedin.com\\\/in\\\/rosehosting\\\/\"],\"description\":\"RoseHosting is a leading Linux hosting provider, serving thousands of clients world-wide since 2001.\",\"email\":\"info@rosehosting.com\",\"telephone\":\"(314) 275-0414\",\"legalName\":\"Rose Web Services LLC\",\"foundingDate\":\"2001-04-02\",\"numberOfEmployees\":{\"@type\":\"QuantitativeValue\",\"minValue\":\"11\",\"maxValue\":\"50\"}},{\"@type\":\"Person\",\"@id\":\"https:\\\/\\\/www.rosehosting.com\\\/blog\\\/#\\\/schema\\\/person\\\/7ce77a842fa6a9a7f8efa186f2353713\",\"name\":\"Jeff Wilson\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/0985fed6af04cc60703d2ecf27c65dfa373e0ca00eb21c0b03477e099ea3f99f?s=96&r=g\",\"url\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/0985fed6af04cc60703d2ecf27c65dfa373e0ca00eb21c0b03477e099ea3f99f?s=96&r=g\",\"contentUrl\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/0985fed6af04cc60703d2ecf27c65dfa373e0ca00eb21c0b03477e099ea3f99f?s=96&r=g\",\"caption\":\"Jeff Wilson\"},\"description\":\"An experienced Linux veteran with many years of experience. Helping other Linux admins with frequent Linux and business-related blog posts on the RoseHosting blog. Techie by choice. Loving nature and travel. Happily married and father of two lovely children.\",\"sameAs\":[\"https:\\\/\\\/www.rosehosting.com\",\"https:\\\/\\\/www.facebook.com\\\/rosehosting.helpdesk\"],\"url\":\"https:\\\/\\\/www.rosehosting.com\\\/blog\\\/author\\\/jwilson\\\/\"}]}<\/script>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"title":"How to setup MySQL replication on CentOS | RoseHosting","description":"How to setup MySQL replication on CentOS | RoseHosting","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:\/\/www.rosehosting.com\/blog\/how-to-setup-mysql-replication-on-centos\/","og_locale":"en_US","og_type":"article","og_title":"How to setup MySQL replication on CentOS","og_description":"How to setup MySQL replication on CentOS | RoseHosting","og_url":"https:\/\/www.rosehosting.com\/blog\/how-to-setup-mysql-replication-on-centos\/","og_site_name":"RoseHosting","article_publisher":"https:\/\/www.facebook.com\/RoseHosting","article_author":"https:\/\/www.facebook.com\/rosehosting.helpdesk","article_published_time":"2016-06-17T13:01:55+00:00","article_modified_time":"2023-04-25T12:13:08+00:00","og_image":[{"width":1200,"height":600,"url":"https:\/\/www.rosehosting.com\/blog\/wp-content\/uploads\/2016\/06\/How-to-setup-MySQL-replication-on-CentOS.jpg","type":"image\/jpeg"}],"author":"Jeff Wilson","twitter_card":"summary_large_image","twitter_creator":"@rosehosting","twitter_site":"@rosehosting","twitter_misc":{"Written by":"Jeff Wilson","Est. reading time":"4 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.rosehosting.com\/blog\/how-to-setup-mysql-replication-on-centos\/#article","isPartOf":{"@id":"https:\/\/www.rosehosting.com\/blog\/how-to-setup-mysql-replication-on-centos\/"},"author":{"name":"Jeff Wilson","@id":"https:\/\/www.rosehosting.com\/blog\/#\/schema\/person\/7ce77a842fa6a9a7f8efa186f2353713"},"headline":"How to setup MySQL replication on CentOS","datePublished":"2016-06-17T13:01:55+00:00","dateModified":"2023-04-25T12:13:08+00:00","mainEntityOfPage":{"@id":"https:\/\/www.rosehosting.com\/blog\/how-to-setup-mysql-replication-on-centos\/"},"wordCount":518,"commentCount":0,"publisher":{"@id":"https:\/\/www.rosehosting.com\/blog\/#organization"},"image":{"@id":"https:\/\/www.rosehosting.com\/blog\/how-to-setup-mysql-replication-on-centos\/#primaryimage"},"thumbnailUrl":"https:\/\/www.rosehosting.com\/blog\/wp-content\/uploads\/2016\/06\/How-to-setup-MySQL-replication-on-CentOS.jpg","keywords":["centos","mysql","replication"],"articleSection":["CentOS","Databases","Tips and Tricks"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/www.rosehosting.com\/blog\/how-to-setup-mysql-replication-on-centos\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/www.rosehosting.com\/blog\/how-to-setup-mysql-replication-on-centos\/","url":"https:\/\/www.rosehosting.com\/blog\/how-to-setup-mysql-replication-on-centos\/","name":"How to setup MySQL replication on CentOS | RoseHosting","isPartOf":{"@id":"https:\/\/www.rosehosting.com\/blog\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.rosehosting.com\/blog\/how-to-setup-mysql-replication-on-centos\/#primaryimage"},"image":{"@id":"https:\/\/www.rosehosting.com\/blog\/how-to-setup-mysql-replication-on-centos\/#primaryimage"},"thumbnailUrl":"https:\/\/www.rosehosting.com\/blog\/wp-content\/uploads\/2016\/06\/How-to-setup-MySQL-replication-on-CentOS.jpg","datePublished":"2016-06-17T13:01:55+00:00","dateModified":"2023-04-25T12:13:08+00:00","description":"How to setup MySQL replication on CentOS | RoseHosting","breadcrumb":{"@id":"https:\/\/www.rosehosting.com\/blog\/how-to-setup-mysql-replication-on-centos\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.rosehosting.com\/blog\/how-to-setup-mysql-replication-on-centos\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.rosehosting.com\/blog\/how-to-setup-mysql-replication-on-centos\/#primaryimage","url":"https:\/\/www.rosehosting.com\/blog\/wp-content\/uploads\/2016\/06\/How-to-setup-MySQL-replication-on-CentOS.jpg","contentUrl":"https:\/\/www.rosehosting.com\/blog\/wp-content\/uploads\/2016\/06\/How-to-setup-MySQL-replication-on-CentOS.jpg","width":1200,"height":600,"caption":"How to setup MySQL replication on CentOS"},{"@type":"BreadcrumbList","@id":"https:\/\/www.rosehosting.com\/blog\/how-to-setup-mysql-replication-on-centos\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.rosehosting.com\/blog\/"},{"@type":"ListItem","position":2,"name":"How to setup MySQL replication on CentOS"}]},{"@type":"WebSite","@id":"https:\/\/www.rosehosting.com\/blog\/#website","url":"https:\/\/www.rosehosting.com\/blog\/","name":"RoseHosting.com","description":"Premium Linux Tutorials Since 2001","publisher":{"@id":"https:\/\/www.rosehosting.com\/blog\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.rosehosting.com\/blog\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/www.rosehosting.com\/blog\/#organization","name":"RoseHosting","url":"https:\/\/www.rosehosting.com\/blog\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.rosehosting.com\/blog\/#\/schema\/logo\/image\/","url":"https:\/\/www.rosehosting.com\/blog\/wp-content\/uploads\/2022\/03\/android-chrome-192x192-1.png","contentUrl":"https:\/\/www.rosehosting.com\/blog\/wp-content\/uploads\/2022\/03\/android-chrome-192x192-1.png","width":192,"height":192,"caption":"RoseHosting"},"image":{"@id":"https:\/\/www.rosehosting.com\/blog\/#\/schema\/logo\/image\/"},"sameAs":["https:\/\/www.facebook.com\/RoseHosting","https:\/\/x.com\/rosehosting","https:\/\/www.linkedin.com\/in\/rosehosting\/"],"description":"RoseHosting is a leading Linux hosting provider, serving thousands of clients world-wide since 2001.","email":"info@rosehosting.com","telephone":"(314) 275-0414","legalName":"Rose Web Services LLC","foundingDate":"2001-04-02","numberOfEmployees":{"@type":"QuantitativeValue","minValue":"11","maxValue":"50"}},{"@type":"Person","@id":"https:\/\/www.rosehosting.com\/blog\/#\/schema\/person\/7ce77a842fa6a9a7f8efa186f2353713","name":"Jeff Wilson","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/secure.gravatar.com\/avatar\/0985fed6af04cc60703d2ecf27c65dfa373e0ca00eb21c0b03477e099ea3f99f?s=96&r=g","url":"https:\/\/secure.gravatar.com\/avatar\/0985fed6af04cc60703d2ecf27c65dfa373e0ca00eb21c0b03477e099ea3f99f?s=96&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/0985fed6af04cc60703d2ecf27c65dfa373e0ca00eb21c0b03477e099ea3f99f?s=96&r=g","caption":"Jeff Wilson"},"description":"An experienced Linux veteran with many years of experience. Helping other Linux admins with frequent Linux and business-related blog posts on the RoseHosting blog. Techie by choice. Loving nature and travel. Happily married and father of two lovely children.","sameAs":["https:\/\/www.rosehosting.com","https:\/\/www.facebook.com\/rosehosting.helpdesk"],"url":"https:\/\/www.rosehosting.com\/blog\/author\/jwilson\/"}]}},"_links":{"self":[{"href":"https:\/\/www.rosehosting.com\/blog\/wp-json\/wp\/v2\/posts\/19418","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.rosehosting.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.rosehosting.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.rosehosting.com\/blog\/wp-json\/wp\/v2\/users\/4"}],"replies":[{"embeddable":true,"href":"https:\/\/www.rosehosting.com\/blog\/wp-json\/wp\/v2\/comments?post=19418"}],"version-history":[{"count":2,"href":"https:\/\/www.rosehosting.com\/blog\/wp-json\/wp\/v2\/posts\/19418\/revisions"}],"predecessor-version":[{"id":45469,"href":"https:\/\/www.rosehosting.com\/blog\/wp-json\/wp\/v2\/posts\/19418\/revisions\/45469"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.rosehosting.com\/blog\/wp-json\/wp\/v2\/media\/24537"}],"wp:attachment":[{"href":"https:\/\/www.rosehosting.com\/blog\/wp-json\/wp\/v2\/media?parent=19418"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.rosehosting.com\/blog\/wp-json\/wp\/v2\/categories?post=19418"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.rosehosting.com\/blog\/wp-json\/wp\/v2\/tags?post=19418"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}