{"id":2324,"date":"2015-11-04T11:59:09","date_gmt":"2015-11-04T11:59:09","guid":{"rendered":"http:\/\/kedar.nitty-witty.com\/?p=2324"},"modified":"2024-01-27T17:17:19","modified_gmt":"2024-01-27T17:17:19","slug":"setting-up-second-mysql-instance-replication-on-linux-in-10-steps","status":"publish","type":"post","link":"https:\/\/kedar.nitty-witty.com\/blog\/setting-up-second-mysql-instance-replication-on-linux-in-10-steps","title":{"rendered":"Setting-up second MySQL instance &#038; replication on Linux in 10 steps"},"content":{"rendered":"\n<p class=\"wp-block-paragraph\">This post will help you configure second MySQL instance on same machine and also setup replication between them. We often see requirement for having multiple MySQL instances on same machine for restore, testing or backup purposes.<br><\/p>\n\n\n\n<p class=\"wp-block-paragraph\">This is a quick setup guide of 10-steps to install and configure MySQL instance on 3307 port, and make it slave from MySQL running on port 3306.<\/p>\n\n\n\n<!--more-->\n\n\n\n<p class=\"wp-block-paragraph\">This post assumes you already have a MySQL instance running on port 3306.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">1. Make datadir, tmpdir and correct permissions:<\/p>\n\n\n\n<pre class=\"wp-block-preformatted\"> mkdir -p \/var\/lib\/mysql3307\/tmp\/\n chown -R mysql:mysql \/var\/lib\/mysql3307\n<\/pre>\n\n\n\n<p class=\"wp-block-paragraph\">2. Create config<\/p>\n\n\n\n<pre class=\"wp-block-preformatted\"> cp \/etc\/my.cnf \/etc\/my3307.cnf (Correct relevant parameters)\n# Usually we will set following parameters:\n\n    datadir=\/var\/lib\/mysql3307\n    socket=\/var\/run\/mysql\/mysqld3307.sock\n    server-id=&lt;different-than-master&gt;\n    port=3307\n    pid-file=\/var\/lib\/mysql3307\/mysqld3307.pid\n    log-error=\/var\/lib\/mysql3307\/mysqld3307.err\n    tmpdir=\/var\/lib\/mysql3307\/tmp\/\n<\/pre>\n\n\n\n<p class=\"wp-block-paragraph\">3. Install basic auth system \/ dbs:<\/p>\n\n\n\n<pre class=\"wp-block-preformatted\">mysql_install_db --user=mysql --basedir=\/usr --datadir=\/var\/lib\/mysql3307 --defaults-file=\/etc\/my3307.cnf\n<\/pre>\n\n\n\n<p class=\"wp-block-paragraph\">4. Start mysql<\/p>\n\n\n\n<pre class=\"wp-block-preformatted\"> mysqld_safe --defaults-file=\/etc\/my3307.cnf --user=mysql &amp;\n<\/pre>\n\n\n\n<p class=\"wp-block-paragraph\">5. Take fulldump from 3306 instance:<\/p>\n\n\n\n<pre class=\"wp-block-preformatted\"> mysqldump -uroot -p --all-databases --master-data=2 | gzip &gt; backup.sql.gz\n<\/pre>\n\n\n\n<p class=\"wp-block-paragraph\">6. Load it to new 3307 instance<\/p>\n\n\n\n<pre class=\"wp-block-preformatted\"> zcat backup.sql.gz  | MySQL -uroot -p --port=3307 --socket=\/var\/run\/mysql\/mysqld3307.sock\n<\/pre>\n\n\n\n<p class=\"wp-block-paragraph\">7. Grab binary log co-ordinates from backup:<\/p>\n\n\n\n<pre class=\"wp-block-preformatted\"> zcat backup.sql.gz | head -30 | grep -i change\n<\/pre>\n\n\n\n<p class=\"wp-block-paragraph\">8. Create replication user on master (3306 MySQL instance):<\/p>\n\n\n\n<pre class=\"wp-block-preformatted\"> grant replication slave on *.* to 'repluser'@'%' identified by 'replpass';\n<\/pre>\n\n\n\n<p class=\"wp-block-paragraph\">9. Run change master to on 3307 slave using binlogs take from step #7:<\/p>\n\n\n\n<pre class=\"wp-block-preformatted\">#You may connect to MySQL as:\n$ mysql  -uUSER -p --socket=\/path\/to\/3307\/socket\n\n\nmysql&gt;CHANGE MASTER TO MASTER_HOST='localhost', MASTER_USER='repluser', MASTER_PASSWORD='replpass', MASTER_PORT=3306, MASTER_LOG_FILE='XXXX', MASTER_LOG_POS=XXXX;\n<\/pre>\n\n\n\n<p class=\"wp-block-paragraph\">10. Start slave on 3307.<\/p>\n\n\n\n<pre class=\"wp-block-preformatted\">start slave;<\/pre>\n\n\n\n<p class=\"wp-block-paragraph\">Hope this helps.<\/p>\n","protected":false},"excerpt":{"rendered":"This is a quick setup guide of 10-steps to install and configure (multiple) MySQL instance on 3307 port, and make it slave from MySQL running on port 3306.\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"om_disable_all_campaigns":false,"_monsterinsights_skip_tracking":false,"_monsterinsights_sitenote_active":false,"_monsterinsights_sitenote_note":"","_monsterinsights_sitenote_category":0,"footnotes":""},"categories":[8,377],"tags":[858,862,859,861,863,860],"class_list":["post-2324","post","type-post","status-publish","format-standard","category-mysql","category-mysql-articles","tag-how-to-setup-mysql","tag-install-2-mysql-on-linux","tag-multiple-mysql-instances","tag-mysqld_multi","tag-step-by-step-second-mysql-instance-configuration-on-same-machine","tag-two-mysql-instances"],"aioseo_notices":[],"aioseo_head":"\n\t\t<!-- All in One SEO 4.9.10 - aioseo.com -->\n\t<meta name=\"description\" content=\"Setup guide of 10-steps to install and configure (multiple) MySQL instance on 3307 port, and make it slave from MySQL running on port 3306.\" \/>\n\t<meta name=\"robots\" content=\"max-image-preview:large\" \/>\n\t<meta name=\"author\" content=\"Kedar\"\/>\n\t<meta name=\"google-site-verification\" content=\"_Bu1h5r0PxIC0D2jBVdmYN45RTeG9ogcX85XLkbG1qA\" \/>\n\t<meta name=\"msvalidate.01\" content=\"116B62074CBCA1BA99B8CCE09CCF2FB8\" \/>\n\t<meta name=\"keywords\" content=\"mysql,multiple instance,second mysql instance,replication,linux,setup steps,how to setup mysql,install 2 mysql on linux,multiple mysql instances,mysqld_multi,step by step second mysql instance configuration on same machine,two mysql instances\" \/>\n\t<link rel=\"canonical\" href=\"https:\/\/kedar.nitty-witty.com\/blog\/setting-up-second-mysql-instance-replication-on-linux-in-10-steps\" \/>\n\t<meta name=\"generator\" content=\"All in One SEO (AIOSEO) 4.9.10\" \/>\n\t\t<meta property=\"og:locale\" content=\"en_US\" \/>\n\t\t<meta property=\"og:site_name\" content=\"Change Is Inevitable | Kedar Vaijanapurkar&#039;s Blog for MySQL, technology and various subjects\" \/>\n\t\t<meta property=\"og:type\" content=\"article\" \/>\n\t\t<meta property=\"og:title\" content=\"Setting-up second (multiple) MySQL instance &amp; replication on Linux | Change Is Inevitable\" \/>\n\t\t<meta property=\"og:description\" content=\"Setup guide of 10-steps to install and configure (multiple) MySQL instance on 3307 port, and make it slave from MySQL running on port 3306.\" \/>\n\t\t<meta property=\"og:url\" content=\"https:\/\/kedar.nitty-witty.com\/blog\/setting-up-second-mysql-instance-replication-on-linux-in-10-steps\" \/>\n\t\t<meta property=\"article:published_time\" content=\"2015-11-04T11:59:09+00:00\" \/>\n\t\t<meta property=\"article:modified_time\" content=\"2024-01-27T17:17:19+00:00\" \/>\n\t\t<meta name=\"twitter:card\" content=\"summary\" \/>\n\t\t<meta name=\"twitter:title\" content=\"Setting-up second (multiple) MySQL instance &amp; replication on Linux | Change Is Inevitable\" \/>\n\t\t<meta name=\"twitter:description\" content=\"Setup guide of 10-steps to install and configure (multiple) MySQL instance on 3307 port, and make it slave from MySQL running on port 3306.\" \/>\n\t\t<script type=\"application\/ld+json\" class=\"aioseo-schema\">\n\t\t\t{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\\\/\\\/kedar.nitty-witty.com\\\/blog\\\/setting-up-second-mysql-instance-replication-on-linux-in-10-steps#article\",\"name\":\"Setting-up second (multiple) MySQL instance & replication on Linux | Change Is Inevitable\",\"headline\":\"Setting-up second MySQL instance &#038; replication on Linux in 10 steps\",\"author\":{\"@id\":\"https:\\\/\\\/kedar.nitty-witty.com\\\/blog\\\/author\\\/admin#author\"},\"publisher\":{\"@id\":\"https:\\\/\\\/kedar.nitty-witty.com\\\/blog\\\/#person\"},\"image\":{\"@type\":\"ImageObject\",\"@id\":\"https:\\\/\\\/kedar.nitty-witty.com\\\/blog\\\/setting-up-second-mysql-instance-replication-on-linux-in-10-steps#articleImage\",\"url\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/be1f7021485c325d92cc4c5d961accb9c1af72b1b11281a790f7f4f066ef10d3?s=96&d=mm&r=g\",\"width\":96,\"height\":96,\"caption\":\"Kedar\"},\"datePublished\":\"2015-11-04T11:59:09+00:00\",\"dateModified\":\"2024-01-27T17:17:19+00:00\",\"inLanguage\":\"en-US\",\"commentCount\":3,\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/kedar.nitty-witty.com\\\/blog\\\/setting-up-second-mysql-instance-replication-on-linux-in-10-steps#webpage\"},\"isPartOf\":{\"@id\":\"https:\\\/\\\/kedar.nitty-witty.com\\\/blog\\\/setting-up-second-mysql-instance-replication-on-linux-in-10-steps#webpage\"},\"articleSection\":\"MySQL, MySQL-Articles, How to setup MySQL, install 2 MySQL on linux, Multiple MySQL instances, mysqld_multi, step by step second mysql instance configuration on same machine, two mysql instances\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/kedar.nitty-witty.com\\\/blog\\\/setting-up-second-mysql-instance-replication-on-linux-in-10-steps#breadcrumblist\",\"itemListElement\":[{\"@type\":\"ListItem\",\"@id\":\"https:\\\/\\\/kedar.nitty-witty.com\\\/blog#listItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\\\/\\\/kedar.nitty-witty.com\\\/blog\",\"nextItem\":{\"@type\":\"ListItem\",\"@id\":\"https:\\\/\\\/kedar.nitty-witty.com\\\/blog\\\/category\\\/mysql#listItem\",\"name\":\"MySQL\"}},{\"@type\":\"ListItem\",\"@id\":\"https:\\\/\\\/kedar.nitty-witty.com\\\/blog\\\/category\\\/mysql#listItem\",\"position\":2,\"name\":\"MySQL\",\"item\":\"https:\\\/\\\/kedar.nitty-witty.com\\\/blog\\\/category\\\/mysql\",\"nextItem\":{\"@type\":\"ListItem\",\"@id\":\"https:\\\/\\\/kedar.nitty-witty.com\\\/blog\\\/category\\\/mysql\\\/mysql-articles#listItem\",\"name\":\"MySQL-Articles\"},\"previousItem\":{\"@type\":\"ListItem\",\"@id\":\"https:\\\/\\\/kedar.nitty-witty.com\\\/blog#listItem\",\"name\":\"Home\"}},{\"@type\":\"ListItem\",\"@id\":\"https:\\\/\\\/kedar.nitty-witty.com\\\/blog\\\/category\\\/mysql\\\/mysql-articles#listItem\",\"position\":3,\"name\":\"MySQL-Articles\",\"item\":\"https:\\\/\\\/kedar.nitty-witty.com\\\/blog\\\/category\\\/mysql\\\/mysql-articles\",\"nextItem\":{\"@type\":\"ListItem\",\"@id\":\"https:\\\/\\\/kedar.nitty-witty.com\\\/blog\\\/setting-up-second-mysql-instance-replication-on-linux-in-10-steps#listItem\",\"name\":\"Setting-up second MySQL instance &#038; replication on Linux in 10 steps\"},\"previousItem\":{\"@type\":\"ListItem\",\"@id\":\"https:\\\/\\\/kedar.nitty-witty.com\\\/blog\\\/category\\\/mysql#listItem\",\"name\":\"MySQL\"}},{\"@type\":\"ListItem\",\"@id\":\"https:\\\/\\\/kedar.nitty-witty.com\\\/blog\\\/setting-up-second-mysql-instance-replication-on-linux-in-10-steps#listItem\",\"position\":4,\"name\":\"Setting-up second MySQL instance &#038; replication on Linux in 10 steps\",\"previousItem\":{\"@type\":\"ListItem\",\"@id\":\"https:\\\/\\\/kedar.nitty-witty.com\\\/blog\\\/category\\\/mysql\\\/mysql-articles#listItem\",\"name\":\"MySQL-Articles\"}}]},{\"@type\":\"Person\",\"@id\":\"https:\\\/\\\/kedar.nitty-witty.com\\\/blog\\\/#person\",\"name\":\"Kedar\",\"image\":{\"@type\":\"ImageObject\",\"@id\":\"https:\\\/\\\/kedar.nitty-witty.com\\\/blog\\\/setting-up-second-mysql-instance-replication-on-linux-in-10-steps#personImage\",\"url\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/be1f7021485c325d92cc4c5d961accb9c1af72b1b11281a790f7f4f066ef10d3?s=96&d=mm&r=g\",\"width\":96,\"height\":96,\"caption\":\"Kedar\"}},{\"@type\":\"Person\",\"@id\":\"https:\\\/\\\/kedar.nitty-witty.com\\\/blog\\\/author\\\/admin#author\",\"url\":\"https:\\\/\\\/kedar.nitty-witty.com\\\/blog\\\/author\\\/admin\",\"name\":\"Kedar\",\"image\":{\"@type\":\"ImageObject\",\"@id\":\"https:\\\/\\\/kedar.nitty-witty.com\\\/blog\\\/setting-up-second-mysql-instance-replication-on-linux-in-10-steps#authorImage\",\"url\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/be1f7021485c325d92cc4c5d961accb9c1af72b1b11281a790f7f4f066ef10d3?s=96&d=mm&r=g\",\"width\":96,\"height\":96,\"caption\":\"Kedar\"}},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/kedar.nitty-witty.com\\\/blog\\\/setting-up-second-mysql-instance-replication-on-linux-in-10-steps#webpage\",\"url\":\"https:\\\/\\\/kedar.nitty-witty.com\\\/blog\\\/setting-up-second-mysql-instance-replication-on-linux-in-10-steps\",\"name\":\"Setting-up second (multiple) MySQL instance & replication on Linux | Change Is Inevitable\",\"description\":\"Setup guide of 10-steps to install and configure (multiple) MySQL instance on 3307 port, and make it slave from MySQL running on port 3306.\",\"inLanguage\":\"en-US\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/kedar.nitty-witty.com\\\/blog\\\/#website\"},\"breadcrumb\":{\"@id\":\"https:\\\/\\\/kedar.nitty-witty.com\\\/blog\\\/setting-up-second-mysql-instance-replication-on-linux-in-10-steps#breadcrumblist\"},\"author\":{\"@id\":\"https:\\\/\\\/kedar.nitty-witty.com\\\/blog\\\/author\\\/admin#author\"},\"creator\":{\"@id\":\"https:\\\/\\\/kedar.nitty-witty.com\\\/blog\\\/author\\\/admin#author\"},\"datePublished\":\"2015-11-04T11:59:09+00:00\",\"dateModified\":\"2024-01-27T17:17:19+00:00\"},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/kedar.nitty-witty.com\\\/blog\\\/#website\",\"url\":\"https:\\\/\\\/kedar.nitty-witty.com\\\/blog\\\/\",\"name\":\"..::CHANGE is INEVITABLE::..\",\"description\":\"Kedar Vaijanapurkar's Blog for MySQL, technology and various subjects\",\"inLanguage\":\"en-US\",\"publisher\":{\"@id\":\"https:\\\/\\\/kedar.nitty-witty.com\\\/blog\\\/#person\"}}]}\n\t\t<\/script>\n\t\t<!-- All in One SEO -->\n\n","aioseo_head_json":{"title":"Setting-up second (multiple) MySQL instance & replication on Linux | Change Is Inevitable","description":"Setup guide of 10-steps to install and configure (multiple) MySQL instance on 3307 port, and make it slave from MySQL running on port 3306.","canonical_url":"https:\/\/kedar.nitty-witty.com\/blog\/setting-up-second-mysql-instance-replication-on-linux-in-10-steps","robots":"max-image-preview:large","keywords":"mysql,multiple instance,second mysql instance,replication,linux,setup steps,how to setup mysql,install 2 mysql on linux,multiple mysql instances,mysqld_multi,step by step second mysql instance configuration on same machine,two mysql instances","webmasterTools":{"google-site-verification":"_Bu1h5r0PxIC0D2jBVdmYN45RTeG9ogcX85XLkbG1qA","msvalidate.01":"116B62074CBCA1BA99B8CCE09CCF2FB8","miscellaneous":""},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/kedar.nitty-witty.com\/blog\/setting-up-second-mysql-instance-replication-on-linux-in-10-steps#article","name":"Setting-up second (multiple) MySQL instance & replication on Linux | Change Is Inevitable","headline":"Setting-up second MySQL instance &#038; replication on Linux in 10 steps","author":{"@id":"https:\/\/kedar.nitty-witty.com\/blog\/author\/admin#author"},"publisher":{"@id":"https:\/\/kedar.nitty-witty.com\/blog\/#person"},"image":{"@type":"ImageObject","@id":"https:\/\/kedar.nitty-witty.com\/blog\/setting-up-second-mysql-instance-replication-on-linux-in-10-steps#articleImage","url":"https:\/\/secure.gravatar.com\/avatar\/be1f7021485c325d92cc4c5d961accb9c1af72b1b11281a790f7f4f066ef10d3?s=96&d=mm&r=g","width":96,"height":96,"caption":"Kedar"},"datePublished":"2015-11-04T11:59:09+00:00","dateModified":"2024-01-27T17:17:19+00:00","inLanguage":"en-US","commentCount":3,"mainEntityOfPage":{"@id":"https:\/\/kedar.nitty-witty.com\/blog\/setting-up-second-mysql-instance-replication-on-linux-in-10-steps#webpage"},"isPartOf":{"@id":"https:\/\/kedar.nitty-witty.com\/blog\/setting-up-second-mysql-instance-replication-on-linux-in-10-steps#webpage"},"articleSection":"MySQL, MySQL-Articles, How to setup MySQL, install 2 MySQL on linux, Multiple MySQL instances, mysqld_multi, step by step second mysql instance configuration on same machine, two mysql instances"},{"@type":"BreadcrumbList","@id":"https:\/\/kedar.nitty-witty.com\/blog\/setting-up-second-mysql-instance-replication-on-linux-in-10-steps#breadcrumblist","itemListElement":[{"@type":"ListItem","@id":"https:\/\/kedar.nitty-witty.com\/blog#listItem","position":1,"name":"Home","item":"https:\/\/kedar.nitty-witty.com\/blog","nextItem":{"@type":"ListItem","@id":"https:\/\/kedar.nitty-witty.com\/blog\/category\/mysql#listItem","name":"MySQL"}},{"@type":"ListItem","@id":"https:\/\/kedar.nitty-witty.com\/blog\/category\/mysql#listItem","position":2,"name":"MySQL","item":"https:\/\/kedar.nitty-witty.com\/blog\/category\/mysql","nextItem":{"@type":"ListItem","@id":"https:\/\/kedar.nitty-witty.com\/blog\/category\/mysql\/mysql-articles#listItem","name":"MySQL-Articles"},"previousItem":{"@type":"ListItem","@id":"https:\/\/kedar.nitty-witty.com\/blog#listItem","name":"Home"}},{"@type":"ListItem","@id":"https:\/\/kedar.nitty-witty.com\/blog\/category\/mysql\/mysql-articles#listItem","position":3,"name":"MySQL-Articles","item":"https:\/\/kedar.nitty-witty.com\/blog\/category\/mysql\/mysql-articles","nextItem":{"@type":"ListItem","@id":"https:\/\/kedar.nitty-witty.com\/blog\/setting-up-second-mysql-instance-replication-on-linux-in-10-steps#listItem","name":"Setting-up second MySQL instance &#038; replication on Linux in 10 steps"},"previousItem":{"@type":"ListItem","@id":"https:\/\/kedar.nitty-witty.com\/blog\/category\/mysql#listItem","name":"MySQL"}},{"@type":"ListItem","@id":"https:\/\/kedar.nitty-witty.com\/blog\/setting-up-second-mysql-instance-replication-on-linux-in-10-steps#listItem","position":4,"name":"Setting-up second MySQL instance &#038; replication on Linux in 10 steps","previousItem":{"@type":"ListItem","@id":"https:\/\/kedar.nitty-witty.com\/blog\/category\/mysql\/mysql-articles#listItem","name":"MySQL-Articles"}}]},{"@type":"Person","@id":"https:\/\/kedar.nitty-witty.com\/blog\/#person","name":"Kedar","image":{"@type":"ImageObject","@id":"https:\/\/kedar.nitty-witty.com\/blog\/setting-up-second-mysql-instance-replication-on-linux-in-10-steps#personImage","url":"https:\/\/secure.gravatar.com\/avatar\/be1f7021485c325d92cc4c5d961accb9c1af72b1b11281a790f7f4f066ef10d3?s=96&d=mm&r=g","width":96,"height":96,"caption":"Kedar"}},{"@type":"Person","@id":"https:\/\/kedar.nitty-witty.com\/blog\/author\/admin#author","url":"https:\/\/kedar.nitty-witty.com\/blog\/author\/admin","name":"Kedar","image":{"@type":"ImageObject","@id":"https:\/\/kedar.nitty-witty.com\/blog\/setting-up-second-mysql-instance-replication-on-linux-in-10-steps#authorImage","url":"https:\/\/secure.gravatar.com\/avatar\/be1f7021485c325d92cc4c5d961accb9c1af72b1b11281a790f7f4f066ef10d3?s=96&d=mm&r=g","width":96,"height":96,"caption":"Kedar"}},{"@type":"WebPage","@id":"https:\/\/kedar.nitty-witty.com\/blog\/setting-up-second-mysql-instance-replication-on-linux-in-10-steps#webpage","url":"https:\/\/kedar.nitty-witty.com\/blog\/setting-up-second-mysql-instance-replication-on-linux-in-10-steps","name":"Setting-up second (multiple) MySQL instance & replication on Linux | Change Is Inevitable","description":"Setup guide of 10-steps to install and configure (multiple) MySQL instance on 3307 port, and make it slave from MySQL running on port 3306.","inLanguage":"en-US","isPartOf":{"@id":"https:\/\/kedar.nitty-witty.com\/blog\/#website"},"breadcrumb":{"@id":"https:\/\/kedar.nitty-witty.com\/blog\/setting-up-second-mysql-instance-replication-on-linux-in-10-steps#breadcrumblist"},"author":{"@id":"https:\/\/kedar.nitty-witty.com\/blog\/author\/admin#author"},"creator":{"@id":"https:\/\/kedar.nitty-witty.com\/blog\/author\/admin#author"},"datePublished":"2015-11-04T11:59:09+00:00","dateModified":"2024-01-27T17:17:19+00:00"},{"@type":"WebSite","@id":"https:\/\/kedar.nitty-witty.com\/blog\/#website","url":"https:\/\/kedar.nitty-witty.com\/blog\/","name":"..::CHANGE is INEVITABLE::..","description":"Kedar Vaijanapurkar's Blog for MySQL, technology and various subjects","inLanguage":"en-US","publisher":{"@id":"https:\/\/kedar.nitty-witty.com\/blog\/#person"}}]},"og:locale":"en_US","og:site_name":"Change Is Inevitable | Kedar Vaijanapurkar's Blog for MySQL, technology and various subjects","og:type":"article","og:title":"Setting-up second (multiple) MySQL instance &amp; replication on Linux | Change Is Inevitable","og:description":"Setup guide of 10-steps to install and configure (multiple) MySQL instance on 3307 port, and make it slave from MySQL running on port 3306.","og:url":"https:\/\/kedar.nitty-witty.com\/blog\/setting-up-second-mysql-instance-replication-on-linux-in-10-steps","article:published_time":"2015-11-04T11:59:09+00:00","article:modified_time":"2024-01-27T17:17:19+00:00","twitter:card":"summary","twitter:title":"Setting-up second (multiple) MySQL instance &amp; replication on Linux | Change Is Inevitable","twitter:description":"Setup guide of 10-steps to install and configure (multiple) MySQL instance on 3307 port, and make it slave from MySQL running on port 3306."},"aioseo_meta_data":{"post_id":"2324","title":"Setting-up second (multiple) MySQL instance &amp; replication on Linux | #site_title","description":"Setup guide of 10-steps to install and configure (multiple) MySQL instance on 3307 port, and make it slave from MySQL running on port 3306.","keywords":[{"label":"MySQL","value":"MySQL"},{"label":"multiple instance","value":"multiple instance"},{"label":"second mysql instance","value":"second mysql instance"},{"label":"replication","value":"replication"},{"label":"linux","value":"linux"},{"label":"setup steps","value":"setup steps"}],"keyphrases":{"focus":{"keyphrase":"","score":0,"analysis":{"keyphraseInTitle":{"score":0,"maxScore":9,"error":1}}},"additional":[]},"primary_term":null,"canonical_url":null,"og_title":null,"og_description":null,"og_object_type":"default","og_image_type":"default","og_image_url":null,"og_image_width":null,"og_image_height":null,"og_image_custom_url":null,"og_image_custom_fields":null,"og_video":"","og_custom_url":null,"og_article_section":null,"og_article_tags":[],"twitter_use_og":false,"twitter_card":"default","twitter_image_type":"default","twitter_image_url":null,"twitter_image_custom_url":null,"twitter_image_custom_fields":null,"twitter_title":null,"twitter_description":null,"schema":{"blockGraphs":[],"customGraphs":[],"default":{"data":{"Article":[],"Course":[],"Dataset":[],"FAQPage":[],"Movie":[],"Person":[],"Product":[],"ProductReview":[],"Car":[],"Recipe":[],"Service":[],"SoftwareApplication":[],"WebPage":[]},"graphName":"Article","isEnabled":true},"graphs":[]},"schema_type":null,"schema_type_options":null,"pillar_content":false,"robots_default":true,"robots_noindex":false,"robots_noarchive":false,"robots_nosnippet":false,"robots_nofollow":false,"robots_noimageindex":false,"robots_noodp":false,"robots_notranslate":false,"robots_max_snippet":"-1","robots_max_videopreview":"-1","robots_max_imagepreview":"large","priority":null,"frequency":"default","location":null,"local_seo":null,"breadcrumb_settings":null,"limit_modified_date":false,"ai":null,"created":"2021-03-24 17:40:44","updated":"2025-08-16 19:16:14","seo_analyzer_scan_date":null},"aioseo_breadcrumb":"<div class=\"aioseo-breadcrumbs\"><span class=\"aioseo-breadcrumb\">\n\t\t\t<a href=\"https:\/\/kedar.nitty-witty.com\/blog\" title=\"Home\">Home<\/a>\n\t\t<\/span><span class=\"aioseo-breadcrumb-separator\">\u00bb<\/span><span class=\"aioseo-breadcrumb\">\n\t\t\t<a href=\"https:\/\/kedar.nitty-witty.com\/blog\/category\/mysql\" title=\"MySQL\">MySQL<\/a>\n\t\t<\/span><span class=\"aioseo-breadcrumb-separator\">\u00bb<\/span><span class=\"aioseo-breadcrumb\">\n\t\t\t<a href=\"https:\/\/kedar.nitty-witty.com\/blog\/category\/mysql\/mysql-articles\" title=\"MySQL-Articles\">MySQL-Articles<\/a>\n\t\t<\/span><span class=\"aioseo-breadcrumb-separator\">\u00bb<\/span><span class=\"aioseo-breadcrumb\">\n\t\t\tSetting-up second MySQL instance &amp; replication on Linux in 10 steps\n\t\t<\/span><\/div>","aioseo_breadcrumb_json":[{"label":"Home","link":"https:\/\/kedar.nitty-witty.com\/blog"},{"label":"MySQL","link":"https:\/\/kedar.nitty-witty.com\/blog\/category\/mysql"},{"label":"MySQL-Articles","link":"https:\/\/kedar.nitty-witty.com\/blog\/category\/mysql\/mysql-articles"},{"label":"Setting-up second MySQL instance &#038; replication on Linux in 10 steps","link":"https:\/\/kedar.nitty-witty.com\/blog\/setting-up-second-mysql-instance-replication-on-linux-in-10-steps"}],"amp_enabled":true,"_links":{"self":[{"href":"https:\/\/kedar.nitty-witty.com\/blog\/wp-json\/wp\/v2\/posts\/2324","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/kedar.nitty-witty.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/kedar.nitty-witty.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/kedar.nitty-witty.com\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/kedar.nitty-witty.com\/blog\/wp-json\/wp\/v2\/comments?post=2324"}],"version-history":[{"count":8,"href":"https:\/\/kedar.nitty-witty.com\/blog\/wp-json\/wp\/v2\/posts\/2324\/revisions"}],"predecessor-version":[{"id":3196,"href":"https:\/\/kedar.nitty-witty.com\/blog\/wp-json\/wp\/v2\/posts\/2324\/revisions\/3196"}],"wp:attachment":[{"href":"https:\/\/kedar.nitty-witty.com\/blog\/wp-json\/wp\/v2\/media?parent=2324"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/kedar.nitty-witty.com\/blog\/wp-json\/wp\/v2\/categories?post=2324"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/kedar.nitty-witty.com\/blog\/wp-json\/wp\/v2\/tags?post=2324"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}