{"id":10431,"date":"2017-08-09T12:27:21","date_gmt":"2017-08-09T10:27:21","guid":{"rendered":"https:\/\/www.dbi-services.com\/blog\/mariadb-how-to-migrate-quickly-mysql-to-mariadb-over-different-hosts-with-mydumpermyloader-and-ncat\/"},"modified":"2023-01-03T13:58:28","modified_gmt":"2023-01-03T12:58:28","slug":"mariadb-how-to-migrate-quickly-mysql-to-mariadb-over-different-hosts-with-mydumpermyloader-and-ncat","status":"publish","type":"post","link":"https:\/\/www.dbi-services.com\/blog\/mariadb-how-to-migrate-quickly-mysql-to-mariadb-over-different-hosts-with-mydumpermyloader-and-ncat\/","title":{"rendered":"MariaDB &#8211; How to migrate quickly MySQL to MariaDB over different hosts with mydumper\/myloader and ncat"},"content":{"rendered":"<p>A lot of possibilities exist to migrate MySQL to MariaDB. In this blog I would like to show a scenario where I migrate MySQL 5.7.19 with a lot of databases to MariaDB 10.2.7, which is on a different host. The tools I am using are mydumper\/myloader and ncat.<\/p>\n<p>Please be aware that mydumper does not come out of the box. It has to be installed beforehand, like explained in my previous blog: <a href=\"https:\/\/www.dbi-services.com\/blog\/mariadb-speed-up-your-logical-mariadb-backups-with-mydumper\/\">https:\/\/www.dbi-services.com\/blog\/mariadb-speed-up-your-logical-mariadb-backups-with-mydumper\/<\/a><\/p>\n<p>The same applies to ncat. It might not be on your system. However, the installation of ncat is quite simple. Just run<\/p>\n<pre class=\"brush: actionscript3; gutter: true; first-line: 1\"># yum install nmap-ncat<\/pre>\n<p>Ncat is just a networking utility which reads and writes data across networks from the command line. A quite underestimated tool from my point view. And please take care, ncat does not encrypt your network traffic per default. That&#8217;s why it might be faster than coping it via scp\/sftp. Ncat operates in one of two primary modes: connect mode and listen mode. So, we need to install it on both hosts. In my case on node mysql01 (connect mode) and on mysql02 (listen mode). If you want to learn more about ncat, take a look at the following web site. <a href=\"http:\/\/nmap.org\/ncat\">http:\/\/nmap.org\/ncat<\/a><\/p>\n<p>Ok. Let&#8217;s get started. First of all, we take a look at the current MySQL instance. As you can see in the output below, I do have a lot of databases that I want to migrate, e.g. air, dbi and a couple of sakila databases.<\/p>\n<pre class=\"brush: actionscript3; gutter: true; first-line: 1\">mysql@mysql01:\/u99\/mysqlbackup\/mysqld6\/mydumper_mysqld6\/ [mysqld6] u | grep -A 1 mysqld6\nmysqld6 is running        : 5.7.19 (mysql-5.7.19)\nPort                      : 33006\n\nmysqld6-(root@localhost) [(none)]&gt; select @@version;\n+------------+\n| @@version  |\n+------------+\n| 5.7.19-log |\n+------------+\n1 row in set (0.00 sec)\n\nmysqld6-(root@localhost) [(none)]&gt; show databases;\n+--------------------+\n| Database           |\n+--------------------+\n| information_schema |\n| air                |\n| dbi                |\n| mysql              |\n| performance_schema |\n| sakila             |\n| sakila01           |\n| sakila02           |\n| sakila03           |\n| sakila04           |\n| sakila05           |\n| sakila06           |\n| sys                |\n| wrs                |\n+--------------------+\n14 rows in set (0.00 sec)<\/pre>\n<p>MyDumper comes with a quite cool parameter, called &#8211;regex. By using the &#8211;regex parameter, we can dump out all databases except the ones the we don&#8217;t want in an elegant way. e.g. we might not want to dump (mysql|test|information_schema|sys|performance_schema)<\/p>\n<pre class=\"brush: actionscript3; gutter: true; first-line: 1\">mysql@mysql01:\/u99\/mysqlbackup\/mysqld6\/mydumper_mysqld6\/ [mysqld6] \/u00\/app\/mysql\/product\/tools\/mydumper\/bin\/mydumper --defaults-file=\/u00\/app\/mysql\/admin\/mysqld6\/.my.cnf \n--threads=6 --regex '^(?!(mysql|test|information_schema|sys|performance_schema))' \n--outputdir=\/u99\/mysqlbackup\/mysqld6\/mydumper_mysqld6<\/pre>\n<p>Ok. We got now all databases dumped out and we can copy it over to the MariaDB host with ssh, ftp, rsync or other tools. Or we do it via ncat directly. For doing so, we need to start the ncat in listen mode (-l) on the destination host mysql02.<\/p>\n<pre class=\"brush: actionscript3; gutter: true; first-line: 1\">-- On host mysql02:\n\nmysql@mysql02:\/u00\/app\/mysql\/ [mysqld6] cd \/u99\/mysqlbackup\/mysqld6\/mydumper_mysqld6\nmysql@mysql02:\/u99\/mysqlbackup\/mysqld6\/mydumper_mysqld6\/ [mysqld6]\nmysql@mysql02:\/u99\/mysqlbackup\/mysqld6\/mydumper_mysqld6\/ [mysqld6] nc -4 -l 33333 | tar -xzvp\n...\nthis host is waiting now for network packets<\/pre>\n<p>On our source node, we start mydumper, pipe it to tar and send it to ncat.<\/p>\n<pre class=\"brush: actionscript3; gutter: true; first-line: 1\">On host mysql01:\n\nmysql@mysql01:\/u00\/app\/mysql\/ [mysqld6] cd \/u99\/mysqlbackup\/mysqld6\/mydumper_mysqld6\nmysql@mysql01:\/u99\/mysqlbackup\/mysqld6\/mydumper_mysqld6\/ [mysqld6]\nmysql@mysql01:\/u99\/mysqlbackup\/mysqld6\/mydumper_mysqld6\/ [mysqld6] \/u00\/app\/mysql\/product\/tools\/mydumper\/bin\/mydumper --defaults-file=\/u00\/app\/mysql\/admin\/mysqld6\/.my.cnf \n--threads=6 --regex '^(?!(mysql|test|information_schema|sys|performance_schema))' | tar -czv -f - .  | nc --send-only mysql02 33333\n.\/\n.\/export-20170809-062635\/\n.\/export-20170809-062635\/air-schema-create.sql\n.\/export-20170809-062635\/dbi-schema-create.sql\n.\/export-20170809-062635\/sakila-schema-create.sql\n.\/export-20170809-062635\/sakila01-schema-create.sql\n.\/export-20170809-062635\/sakila02-schema-create.sql\n.\/export-20170809-062635\/sakila03-schema-create.sql\n.\/export-20170809-062635\/sakila04-schema-create.sql\n.\/export-20170809-062635\/sakila05-schema-create.sql\n.\/export-20170809-062635\/sakila06-schema-create.sql\n.\/export-20170809-062635\/wrs-schema-create.sql\n.\/export-20170809-062635\/metadata\n.\/export-20170809-062635\/dbi.dbi_t.sql\n.\/export-20170809-062635\/sakila05.category.sql\n.\/export-20170809-062635\/sakila.actor.sql\n.\/export-20170809-062635\/sakila.address.sql\n.\/export-20170809-062635\/sakila.category.sql\n.\/export-20170809-062635\/sakila.city.sql\n.\/export-20170809-062635\/sakila.country.sql\n.\/export-20170809-062635\/sakila.customer.sql\n.\/export-20170809-062635\/sakila.film.sql\n.\/export-20170809-062635\/sakila.film_actor.sql\n.\/export-20170809-062635\/sakila.film_category.sql\n.\/export-20170809-062635\/sakila.film_text.sql\n.\/export-20170809-062635\/sakila.inventory.sql\n.\/export-20170809-062635\/sakila.language.sql\n.\/export-20170809-062635\/sakila.payment.sql\n.\/export-20170809-062635\/sakila.rental.sql\n.\/export-20170809-062635\/sakila.staff.sql\n.\/export-20170809-062635\/sakila.store.sql\n.\/export-20170809-062635\/sakila01.actor.sql\n.\/export-20170809-062635\/sakila01.address.sql\n...\n...<\/pre>\n<p>On the other terminal, you can see that the files are being received.<\/p>\n<pre class=\"brush: actionscript3; gutter: true; first-line: 1\">On host mysql02:\n\nmysql@mysql02:\/u99\/mysqlbackup\/mysqld6\/mydumper_mysqld6\/ [mysqld6] nc -4 -l 33333 | tar -xzvp\n.\/\n.\/export-20170809-062635\/\n.\/export-20170809-062635\/air-schema-create.sql\n.\/export-20170809-062635\/dbi-schema-create.sql\n.\/export-20170809-062635\/sakila-schema-create.sql\n.\/export-20170809-062635\/sakila01-schema-create.sql\n.\/export-20170809-062635\/sakila02-schema-create.sql\n.\/export-20170809-062635\/sakila03-schema-create.sql\n.\/export-20170809-062635\/sakila04-schema-create.sql\n.\/export-20170809-062635\/sakila05-schema-create.sql\n.\/export-20170809-062635\/sakila06-schema-create.sql\n.\/export-20170809-062635\/wrs-schema-create.sql\n.\/export-20170809-062635\/metadata\n.\/export-20170809-062635\/dbi.dbi_t.sql\n.\/export-20170809-062635\/sakila05.category.sql\n.\/export-20170809-062635\/sakila.actor.sql\n.\/export-20170809-062635\/sakila.address.sql\n.\/export-20170809-062635\/sakila.category.sql\n.\/export-20170809-062635\/sakila.city.sql\n.\/export-20170809-062635\/sakila.country.sql\n.\/export-20170809-062635\/sakila.customer.sql\n.\/export-20170809-062635\/sakila.film.sql\n.\/export-20170809-062635\/sakila.film_actor.sql\n.\/export-20170809-062635\/sakila.film_category.sql\n.\/export-20170809-062635\/sakila.film_text.sql\n.\/export-20170809-062635\/sakila.inventory.sql\n.\/export-20170809-062635\/sakila.language.sql\n.\/export-20170809-062635\/sakila.payment.sql\n.\/export-20170809-062635\/sakila.rental.sql\n.\/export-20170809-062635\/sakila.staff.sql\n.\/export-20170809-062635\/sakila.store.sql\n.\/export-20170809-062635\/sakila01.actor.sql\n.\/export-20170809-062635\/sakila01.address.sql\n...\n...\n...\n\nmysql@mysql02:\/u99\/mysqlbackup\/mysqld6\/mydumper_mysqld6\/ [mysqld6] ls -l\ntotal 20\ndrwx------ 2 mysql mysql 16384 Aug  9 06:26 export-20170809-062635<\/pre>\n<p>That&#8217;s it. We got now all the files on our destination host mysql02. Now it&#8217;s time to import the data via myloader into the new MariaDB 10.2.7 which is empty at the moment.<\/p>\n<pre class=\"brush: actionscript3; gutter: true; first-line: 1\">mysql@mysql02:\/u00\/app\/mysql\/ [mysqld6] u | grep -A 1 mysqld6\nmysqld6 is running        : 10.2.7-MariaDB (mariadb-10.2.7)\nPort                      : 33006\n\nmysql@mysql02:\/u00\/app\/mysql\/product\/tools\/mydumper-0.9.2\/bin\/ [mysqld6] mq\nWelcome to the MariaDB monitor.  Commands end with ; or g.\nYour MariaDB connection id is 14\nServer version: 10.2.7-MariaDB-log MariaDB Server\n\nCopyright (c) 2000, 2017, Oracle, MariaDB Corporation Ab and others.\n\nType 'help;' or 'h' for help. Type 'c' to clear the current input statement.\n\nmysqld6-(root@localhost) [(none)]&gt; select @@version;\n+--------------------+\n| @@version          |\n+--------------------+\n| 10.2.7-MariaDB-log |\n+--------------------+\n1 row in set (0.00 sec)<\/pre>\n<p>Per default, the myloader tool starts 4 parallel threads, and runs in verbose mode 2 which means that only warning messages are shown. In case you want to have it more verbose, you can specify &#8211;verbose=3<\/p>\n<pre class=\"brush: actionscript3; gutter: true; first-line: 1\">mysql@mysql02:\/u99\/mysqlbackup\/mysqld6\/mydumper_mysqld6\/ [mysqld6] \/u00\/app\/mysql\/product\/tools\/mydumper\/bin\/myloader \n--defaults-file=\/u00\/app\/mysql\/admin\/mysqld6\/.my.cnf --threads=6 --verbose=3 \n--directory \/u99\/mysqlbackup\/mysqld6\/mydumper_mysqld6\/export-20170809-062635\n** Message: 6 threads created\n** Message: Creating database `air`\n** Message: Creating table `air`.`muc`\n** Message: Creating database `dbi`\n** Message: Creating table `dbi`.`dbi_t`\n** Message: Creating table `dbi`.`dbi_t2`\n** Message: Creating database `sakila`\n** Message: Creating table `sakila`.`actor`\n** Message: Creating table `sakila`.`address`\n** Message: Creating table `sakila`.`category`\n** Message: Creating table `sakila`.`city`\n** Message: Creating table `sakila`.`country`\n** Message: Creating table `sakila`.`customer`\n** Message: Creating table `sakila`.`film`\n...\n...<\/pre>\n<p>If you take a look at the process list, you should see 6 threads doing the work.<\/p>\n<pre class=\"brush: actionscript3; gutter: true; first-line: 1\">mysqld6-(root@localhost) [(none)]&gt; show processlist;\n...\n...\n| 30 | root        | localhost | sakila01 | Query   |    0 | Opening tables          | INSERT INTO `city` VALUES\n(1,\"A Corua (La Corua)\",87,\"2006-02-15 03:45:25\"),\n(2,\"Abha\",82,\"2006-02-1 |    0.000 |\n| 31 | root        | localhost | sakila   | Query   |    6 | update                  | INSERT INTO `film_actor` VALUES\n(1,1,\"2006-02-15 04:05:03\"),\n(1,23,\"2006-02-15 04:05:03\"),\n(1,25,\"20 |    0.000 |\n| 32 | root        | localhost | sakila   | Query   |    4 | update                  | INSERT INTO `payment` VALUES\n(1,1,1,76,2.99,\"2005-05-25 11:30:37\",\"2006-02-15 21:12:30\"),\n(2,1,1,573 |    0.000 |\n| 33 | root        | localhost | sakila   | Query   |    3 | update                  | INSERT INTO `rental` VALUES\n(1,\"2005-05-24 22:53:30\",367,130,\"2005-05-26 22:04:30\",1,\"2006-02-15 20: |    0.000 |\n| 34 | root        | localhost | sakila01 | Query   |    2 | update                  | INSERT INTO `address` VALUES\n(1,\"47 MySakila Drive\",NULL,\"Alberta\",300,\"\",\"\",\"&gt;n2]c |    0.000 |\n| 35 | root        | localhost | sakila   | Query   |    4 | update                  | INSERT INTO `inventory` VALUES<\/pre>\n<p>That&#8217;s it. We got now the data migrated to MariaDB 10.2.7.<\/p>\n<h3>Conclusion<\/h3>\n<p>Many ways do exist for migrating MySQL to MariaDB. Using mydumper\/myloader in combination with ncat is just one of those. However, from my point of view, a quite cool one.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>A lot of possibilities exist to migrate MySQL to MariaDB. In this blog I would like to show a scenario where I migrate MySQL 5.7.19 with a lot of databases to MariaDB 10.2.7, which is on a different host. The tools I am using are mydumper\/myloader and ncat. Please be aware that mydumper does not [&hellip;]<\/p>\n","protected":false},"author":109,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"footnotes":""},"categories":[229],"tags":[141],"type_dbi":[],"class_list":["post-10431","post","type-post","status-publish","format-standard","hentry","category-database-administration-monitoring","tag-mariadb"],"acf":[],"yoast_head":"<!-- This site is optimized with the Yoast SEO Premium plugin v27.2 (Yoast SEO v27.2) - https:\/\/yoast.com\/product\/yoast-seo-premium-wordpress\/ -->\n<title>MariaDB - How to migrate quickly MySQL to MariaDB over different hosts with mydumper\/myloader and ncat - dbi Blog<\/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:\/\/www.dbi-services.com\/blog\/mariadb-how-to-migrate-quickly-mysql-to-mariadb-over-different-hosts-with-mydumpermyloader-and-ncat\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"MariaDB - How to migrate quickly MySQL to MariaDB over different hosts with mydumper\/myloader and ncat\" \/>\n<meta property=\"og:description\" content=\"A lot of possibilities exist to migrate MySQL to MariaDB. In this blog I would like to show a scenario where I migrate MySQL 5.7.19 with a lot of databases to MariaDB 10.2.7, which is on a different host. The tools I am using are mydumper\/myloader and ncat. Please be aware that mydumper does not [&hellip;]\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.dbi-services.com\/blog\/mariadb-how-to-migrate-quickly-mysql-to-mariadb-over-different-hosts-with-mydumpermyloader-and-ncat\/\" \/>\n<meta property=\"og:site_name\" content=\"dbi Blog\" \/>\n<meta property=\"article:published_time\" content=\"2017-08-09T10:27:21+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2023-01-03T12:58:28+00:00\" \/>\n<meta name=\"author\" content=\"DevOps\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"DevOps\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"5 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/mariadb-how-to-migrate-quickly-mysql-to-mariadb-over-different-hosts-with-mydumpermyloader-and-ncat\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/mariadb-how-to-migrate-quickly-mysql-to-mariadb-over-different-hosts-with-mydumpermyloader-and-ncat\/\"},\"author\":{\"name\":\"DevOps\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/4cd1b5f8a3de93f05a16ab8d7d2b7735\"},\"headline\":\"MariaDB &#8211; How to migrate quickly MySQL to MariaDB over different hosts with mydumper\/myloader and ncat\",\"datePublished\":\"2017-08-09T10:27:21+00:00\",\"dateModified\":\"2023-01-03T12:58:28+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/mariadb-how-to-migrate-quickly-mysql-to-mariadb-over-different-hosts-with-mydumpermyloader-and-ncat\/\"},\"wordCount\":522,\"commentCount\":0,\"keywords\":[\"MariaDB\"],\"articleSection\":[\"Database Administration &amp; Monitoring\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/www.dbi-services.com\/blog\/mariadb-how-to-migrate-quickly-mysql-to-mariadb-over-different-hosts-with-mydumpermyloader-and-ncat\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/mariadb-how-to-migrate-quickly-mysql-to-mariadb-over-different-hosts-with-mydumpermyloader-and-ncat\/\",\"url\":\"https:\/\/www.dbi-services.com\/blog\/mariadb-how-to-migrate-quickly-mysql-to-mariadb-over-different-hosts-with-mydumpermyloader-and-ncat\/\",\"name\":\"MariaDB - How to migrate quickly MySQL to MariaDB over different hosts with mydumper\/myloader and ncat - dbi Blog\",\"isPartOf\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/#website\"},\"datePublished\":\"2017-08-09T10:27:21+00:00\",\"dateModified\":\"2023-01-03T12:58:28+00:00\",\"author\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/4cd1b5f8a3de93f05a16ab8d7d2b7735\"},\"breadcrumb\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/mariadb-how-to-migrate-quickly-mysql-to-mariadb-over-different-hosts-with-mydumpermyloader-and-ncat\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.dbi-services.com\/blog\/mariadb-how-to-migrate-quickly-mysql-to-mariadb-over-different-hosts-with-mydumpermyloader-and-ncat\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/mariadb-how-to-migrate-quickly-mysql-to-mariadb-over-different-hosts-with-mydumpermyloader-and-ncat\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Accueil\",\"item\":\"https:\/\/www.dbi-services.com\/blog\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"MariaDB &#8211; How to migrate quickly MySQL to MariaDB over different hosts with mydumper\/myloader and ncat\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/#website\",\"url\":\"https:\/\/www.dbi-services.com\/blog\/\",\"name\":\"dbi Blog\",\"description\":\"\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/www.dbi-services.com\/blog\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Person\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/4cd1b5f8a3de93f05a16ab8d7d2b7735\",\"name\":\"DevOps\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/secure.gravatar.com\/avatar\/cdd2dd7441774355062c0f0f68612296b059cd1e2ff6c7af0b15dba0ed64a85f?s=96&d=mm&r=g\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/cdd2dd7441774355062c0f0f68612296b059cd1e2ff6c7af0b15dba0ed64a85f?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/cdd2dd7441774355062c0f0f68612296b059cd1e2ff6c7af0b15dba0ed64a85f?s=96&d=mm&r=g\",\"caption\":\"DevOps\"},\"url\":\"https:\/\/www.dbi-services.com\/blog\/author\/devops\/\"}]}<\/script>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"title":"MariaDB - How to migrate quickly MySQL to MariaDB over different hosts with mydumper\/myloader and ncat - dbi Blog","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.dbi-services.com\/blog\/mariadb-how-to-migrate-quickly-mysql-to-mariadb-over-different-hosts-with-mydumpermyloader-and-ncat\/","og_locale":"en_US","og_type":"article","og_title":"MariaDB - How to migrate quickly MySQL to MariaDB over different hosts with mydumper\/myloader and ncat","og_description":"A lot of possibilities exist to migrate MySQL to MariaDB. In this blog I would like to show a scenario where I migrate MySQL 5.7.19 with a lot of databases to MariaDB 10.2.7, which is on a different host. The tools I am using are mydumper\/myloader and ncat. Please be aware that mydumper does not [&hellip;]","og_url":"https:\/\/www.dbi-services.com\/blog\/mariadb-how-to-migrate-quickly-mysql-to-mariadb-over-different-hosts-with-mydumpermyloader-and-ncat\/","og_site_name":"dbi Blog","article_published_time":"2017-08-09T10:27:21+00:00","article_modified_time":"2023-01-03T12:58:28+00:00","author":"DevOps","twitter_card":"summary_large_image","twitter_misc":{"Written by":"DevOps","Est. reading time":"5 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.dbi-services.com\/blog\/mariadb-how-to-migrate-quickly-mysql-to-mariadb-over-different-hosts-with-mydumpermyloader-and-ncat\/#article","isPartOf":{"@id":"https:\/\/www.dbi-services.com\/blog\/mariadb-how-to-migrate-quickly-mysql-to-mariadb-over-different-hosts-with-mydumpermyloader-and-ncat\/"},"author":{"name":"DevOps","@id":"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/4cd1b5f8a3de93f05a16ab8d7d2b7735"},"headline":"MariaDB &#8211; How to migrate quickly MySQL to MariaDB over different hosts with mydumper\/myloader and ncat","datePublished":"2017-08-09T10:27:21+00:00","dateModified":"2023-01-03T12:58:28+00:00","mainEntityOfPage":{"@id":"https:\/\/www.dbi-services.com\/blog\/mariadb-how-to-migrate-quickly-mysql-to-mariadb-over-different-hosts-with-mydumpermyloader-and-ncat\/"},"wordCount":522,"commentCount":0,"keywords":["MariaDB"],"articleSection":["Database Administration &amp; Monitoring"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/www.dbi-services.com\/blog\/mariadb-how-to-migrate-quickly-mysql-to-mariadb-over-different-hosts-with-mydumpermyloader-and-ncat\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/www.dbi-services.com\/blog\/mariadb-how-to-migrate-quickly-mysql-to-mariadb-over-different-hosts-with-mydumpermyloader-and-ncat\/","url":"https:\/\/www.dbi-services.com\/blog\/mariadb-how-to-migrate-quickly-mysql-to-mariadb-over-different-hosts-with-mydumpermyloader-and-ncat\/","name":"MariaDB - How to migrate quickly MySQL to MariaDB over different hosts with mydumper\/myloader and ncat - dbi Blog","isPartOf":{"@id":"https:\/\/www.dbi-services.com\/blog\/#website"},"datePublished":"2017-08-09T10:27:21+00:00","dateModified":"2023-01-03T12:58:28+00:00","author":{"@id":"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/4cd1b5f8a3de93f05a16ab8d7d2b7735"},"breadcrumb":{"@id":"https:\/\/www.dbi-services.com\/blog\/mariadb-how-to-migrate-quickly-mysql-to-mariadb-over-different-hosts-with-mydumpermyloader-and-ncat\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.dbi-services.com\/blog\/mariadb-how-to-migrate-quickly-mysql-to-mariadb-over-different-hosts-with-mydumpermyloader-and-ncat\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/www.dbi-services.com\/blog\/mariadb-how-to-migrate-quickly-mysql-to-mariadb-over-different-hosts-with-mydumpermyloader-and-ncat\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Accueil","item":"https:\/\/www.dbi-services.com\/blog\/"},{"@type":"ListItem","position":2,"name":"MariaDB &#8211; How to migrate quickly MySQL to MariaDB over different hosts with mydumper\/myloader and ncat"}]},{"@type":"WebSite","@id":"https:\/\/www.dbi-services.com\/blog\/#website","url":"https:\/\/www.dbi-services.com\/blog\/","name":"dbi Blog","description":"","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.dbi-services.com\/blog\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Person","@id":"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/4cd1b5f8a3de93f05a16ab8d7d2b7735","name":"DevOps","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/secure.gravatar.com\/avatar\/cdd2dd7441774355062c0f0f68612296b059cd1e2ff6c7af0b15dba0ed64a85f?s=96&d=mm&r=g","url":"https:\/\/secure.gravatar.com\/avatar\/cdd2dd7441774355062c0f0f68612296b059cd1e2ff6c7af0b15dba0ed64a85f?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/cdd2dd7441774355062c0f0f68612296b059cd1e2ff6c7af0b15dba0ed64a85f?s=96&d=mm&r=g","caption":"DevOps"},"url":"https:\/\/www.dbi-services.com\/blog\/author\/devops\/"}]}},"_links":{"self":[{"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/posts\/10431","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/users\/109"}],"replies":[{"embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/comments?post=10431"}],"version-history":[{"count":1,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/posts\/10431\/revisions"}],"predecessor-version":[{"id":21363,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/posts\/10431\/revisions\/21363"}],"wp:attachment":[{"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/media?parent=10431"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/categories?post=10431"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/tags?post=10431"},{"taxonomy":"type","embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/type_dbi?post=10431"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}