{"id":1392,"date":"2015-01-20T06:28:28","date_gmt":"2015-01-20T06:28:28","guid":{"rendered":"http:\/\/stratio.tumblr.com\/post\/108643802539"},"modified":"2023-09-20T13:45:25","modified_gmt":"2023-09-20T13:45:25","slug":"tutorial-migrating-data-from-mysql-to-mongodb","status":"publish","type":"post","link":"https:\/\/www.stratio.com\/blog\/tutorial-migrating-data-from-mysql-to-mongodb\/","title":{"rendered":"Tutorial: Migrating Data from MySQL to MongoDB"},"content":{"rendered":"<p>In the next tutorial you will learn how to migrate data from MySQL to MongoDB. We will show you how to do it using Spark step by step. From creating a configuration for the player RDD to the installation guide for prerequisites components.<br \/>\nEasy and intuitive!<\/p>\n<p><!--more--><\/p>\n<p><strong>PREREQUISITES*:<\/strong><\/p>\n<ul>\n<li>MongoDB (versi\u00f3n 2.6 recommended)<\/li>\n<li>MySQL 5<\/li>\n<li>Java 7+<\/li>\n<li>Maven 3+<\/li>\n<li>Spark 1.2<\/li>\n<li>Deep-Spark<\/li>\n<\/ul>\n<p><strong><br \/>\n<\/strong><strong>TUTORIAL TO L<\/strong><strong>OAD A DATASET TO MySQL:<\/strong><\/p>\n<p>Create schema:<\/p>\n<pre>create schema football<\/pre>\n<p>Create tables:<\/p>\n<pre>create table if not exists football.team(\n    id bigint not null auto_increment,\n    name varchar(255) not null,\n    short_name varchar(255) not null,\n    arena_name varchar(255) not null,\n    coach_name varchar(255) not null,\n    city_name varchar(255) not null,\n    league_name varchar(255) not null,\n    primary key (id)\n);\n<\/pre>\n<pre>create table if not exists football.player(\n    id bigint not null auto_increment,\n    firstname varchar(255) not null,\n    lastname varchar(255) not null,\n    date_of_birth date,\n    place_of_birth_name varchar(255) not null,\n    position_name varchar(255) not null,\n    team_id bigint not null,\n    primary key (id),\n    foreign key (team_id) references football.team(id)\n);\n<\/pre>\n<p>Populate tables:<\/p>\n<pre>insert into football.team (name, short_name, arena_name, coach_name, city_name, league_name) \nvalues\n('FC Bayern M\u00fcnchen', 'FCB', 'Allianz Arena', 'Josep Guardiola', 'M\u00fcnchen', 'Bundesliga'),\n('Hamburger SV', 'HSV', 'Imtech Arena', 'Josef Zinnbauer', 'Hamburg', 'Bundesliga'),\n('Herta BSC Berlin', 'Herta', 'Olympiastaion Berlin', 'Jos Luhukay', 'Berlin', 'Bundesliga'),\n('FC Basel 1893', 'FCB', 'St. Jakob-Park', 'Paulo Sousa', 'Basel', 'Raiffeisen Super League'),\n('FC Paris Saint-Germain', 'PSG', 'Parc des Princes', 'Laurent Blanc', 'Paris', 'Ligue 1'),\n('HJK Helsinki', 'HJK', 'Sonera Stadium', 'Mika Lehkosuo', 'Helsinki', 'Veikkausliiga');\n<\/pre>\n<pre>insert into football.player(firstname, lastname, date_of_birth, place_of_birth_name, position_name, team_id) \nvalues\n('Manuel', 'Neuer', '1986-3-27', 'Gelsenkirchen', 'Goalkeeper', 1),\n('Julian', 'Schieber', '1989-2-13', 'Backnang', 'Centre Forward', 3),\n('Dennis ', 'Diekmeier', '1989-10-20', 'Thedinghausen', 'Right Wing', 2),\n('Zlatan', 'Ibrahimovic', '1981-10-03', 'Malm\u00f6', 'Centre Forward', 5),\n('Xabier', 'Alonso', '1981-11-25', 'Tolosa', 'Midfielder', 1);\n<\/pre>\n<p>Running Spark-shel:<\/p>\n<pre> .\/spark-shell --jars YOUR_PATH\/deep-core-0.7.0.jar, \n                      YOUR_PATH\/deep-commons-0.7.0.jar,YOUR_PATH\/deep-jdbc-0.7.0.jar, \n                      YOUR_PATH\/deep-mongodb-0.7.0.jar,YOUR_PATH\/mongo-java-driver-2.12.4.jar,YOUR_PATH\/mysql-connector-java-5.1.34.jar\n\n<\/pre>\n<p><strong>USING SPARK STEP BY STEP:<\/strong><\/p>\n<p>Necessary imports:<\/p>\n<pre>import com.stratio.deep.commons.entity.{Cell, Cells}\nimport com.stratio.deep.core.context.DeepSparkContext\nimport com.stratio.deep.jdbc.config.{JdbcConfigFactory, JdbcDeepJobConfig}\nimport com.stratio.deep.mongodb.config.{MongoConfigFactory, MongoDeepJobConfig}\nimport org.apache.spark.SparkContext._\nimport org.apache.spark.rdd.RDD\nimport org.apache.spark.{SparkConf, SparkContext}\nimport scala.collection.JavaConverters._\n\nprivate val CLUSTER: String = \"local\"\nprivate val APP_NAME: String = \"deepMySQLToMongodbMigration\"\nprivate val MYSQL_DRIVER: String = \"com.mysql.jdbc.Driver\"\nprivate val MYSQL_HOST: String = \"localhost\"\nprivate val MYSQL_PORT: Integer = 3306\nprivate val MYSQL_USER: String = \"root\"\nprivate val MYSQL_PASS: String = \"root\"\nprivate val MYSQL_DBNAME: String = \"football\"\nprivate val MONGODB_HOST: String = \"localhost:27017\"\nprivate val MONGODB_DBNAME: String = \"football\"\nprivate val MONGODB_COLLECTION: String = \"teams\"<strong>eating a configuration for the team RDD and initialize it<\/strong><\/pre>\n<pre>val mySQLTeamConfig: JdbcDeepJobConfig[Cells] = JdbcConfigFactory        \n    .createJdbc\n    .host(MYSQL_HOST).port(MYSQL_PORT)\n    .username(MYSQL_USER).password(MYSQL_PASS)\n    .database(MYSQL_DBNAME).table(\"team\")\n    .driverClass(MYSQL_DRIVER)\n    .initialize\n<\/pre>\n<p>Creating a configuration for the player RDD and initialize it:<\/p>\n<pre>val mySQLPlayerConfig: JdbcDeepJobConfig[Cells] = JdbcConfigFactory      \n    .createJdbc\n    .host(MYSQL_HOST).port(MYSQL_PORT)\n    .username(MYSQL_USER).password(MYSQL_PASS)\n    .database(MYSQL_DBNAME).table(\"player\")\n    .driverClass(MYSQL_DRIVER)\n    .initialize\n<\/pre>\n<p>Creating the RDDs that represent the data set in MySQL:<\/p>\n<pre>val teamRDD: RDD[Cells] = deepContext.createRDD(mySQLTeamConfig)\nval playerRDD: RDD[Cells] = deepContext.createRDD(mySQLPlayerConfig)<\/pre>\n<p>Map teams to pair with (team id, team):<\/p>\n<pre>val teamPairRDD: RDD[(Long, Cells)] = teamRDD.map(team =&gt; (team.getLong(\"id\").longValue(), team))<\/pre>\n<p>Map players to pair with (team id, player) and group by team_id<\/p>\n<pre>val playerPairRDD: RDD[(Long, Iterable[Cells])] = playerRDD.map(cells =&gt;(cells.getLong(\"team_id\").longValue(), cells)).groupByKey\nval joinedPairRDD: RDD[(Long, (Cells, Option[Iterable[Cells]]))] = teamPairRDD.leftOuterJoin(playerPairRDD)\n<\/pre>\n<p>Creating a configuration for the mongodb result RDD and initialize it:<\/p>\n<pre>val outputMongodbConfig: MongoDeepJobConfig[Cells] = MongoConfigFactory.createMongoDB\n.host(MONGODB_HOST)\n.database(MONGODB_DBNAME).collection(MONGODB_COLLECTION)\n.initialize<\/pre>\n<p>Transforming the joined result to the desirable structure in mongodb:<\/p>\n<pre>\/\/ Ej: {_id: &lt;team_id&gt;, name: &lt;team_name&gt;, players: [&lt;player_name_1&gt;, &lt;player_name_2&gt;]}\n val outputRDD: RDD[Cells] = joinedPairRDD.map(joined =&gt; {\n    val cells: Cells = new Cells\n    cells.add(Cell.create(\"_id\", joined._1))\n    cells.add(Cell.create(\"name\", joined._2._1.getString(\"name\")))\n    cells.add(Cell.create(\"players\", joined._2._2 match {\n        case Some(players) =&gt; players.map(player =&gt; player.getString(\"lastname\") + \", \" + player.getString(\"firstname\")).asJava\n        case _ =&gt; null\n    }))\n    cells\n})<\/pre>\n<p>Save the RDD in MongoDB<\/p>\n<pre>DeepSparkContext.saveRDD(outputRDD, outputMongodbConfig)\n<\/pre>\n<p><strong><br \/>\nUSING SPARK WITH OUR EXAMPLE PROJECT:<\/strong><\/p>\n<p><a href=\"https:\/\/github.com\/robertomorandeira\/deep-example\">https:\/\/github.com\/robertomorandeira\/deep-example\u00a0<\/a><br \/>\nJust make a git clone a run our java or scala example<\/p>\n<pre>git clone <a href=\"https:\/\/github.com\/robertomorandeira\/deep-example.git\">https:\/\/github.com\/robertomorandeira\/deep-example.git<\/a><\/pre>\n<p>Java example:<br \/>\n<a href=\"https:\/\/github.com\/robertomorandeira\/deep-example\/blob\/master\/src\/main\/java\/FootballMigrationApp.java\">https:\/\/github.com\/robertomorandeira\/deep-example\/blob\/master\/src\/main\/java\/FootballMigrationApp.java\u00a0<\/a><br \/>\nScala example:<br \/>\n<a href=\"https:\/\/github.com\/robertomorandeira\/deep-example\/blob\/master\/src\/main\/scala\/FootballMigrationAppScala.scala\">https:\/\/github.com\/robertomorandeira\/deep-example\/blob\/master\/src\/main\/scala\/FootballMigrationAppScala.scala\u00a0<\/a><\/p>\n<p><strong><br \/>\nCHECKING DATA.<\/strong><\/p>\n<p>Connect to mongodb, normally<\/p>\n<pre>$ mongo --host 127.0.0.1 --port 27017 football\ndb.output.find(\u201cteams\u201d).pretty()<\/pre>\n<p>You can see the data loaded in mongoDB<\/p>\n<p><strong><br \/>\n<a name=\"prerequisites\"><\/a>INSTALLATION GUIDE FOR PREREQUISITES COMPONENTS:<\/strong><br \/>\n<strong>MongoDB<\/strong><\/p>\n<pre>sudo apt-get update\nsudo apt-get install mongodb-org<\/pre>\n<p><strong>MySQL Server<\/strong><\/p>\n<pre>sudo apt-get install mysql-server<\/pre>\n<p><strong>Java 7<\/strong><\/p>\n<pre>sudo add-apt-repository ppa:webupd8team\/java\nsudo apt-get update\nsudo apt-get install oracle-java7-installer<\/pre>\n<p><strong>Maven<\/strong><\/p>\n<pre class=\"\">sudo apt-get update\nsudo apt-get install maven<\/pre>\n","protected":false},"excerpt":{"rendered":"<p>In the next tutorial you will learn how to migrate data from MySQL to MongoDB. We will show you how to do it using Spark step by step. From creating a configuration for the player RDD to the installation guide for prerequisites components. Easy and intuitive!<\/p>\n","protected":false},"author":2,"featured_media":121,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[686],"tags":[],"ppma_author":[794],"yoast_head":"<!-- This site is optimized with the Yoast SEO Premium plugin v22.9 (Yoast SEO v22.9) - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>Tutorial: Migrating Data from MySQL to MongoDB - Stratio<\/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.stratio.com\/blog\/tutorial-migrating-data-from-mysql-to-mongodb\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Tutorial: Migrating Data from MySQL to MongoDB\" \/>\n<meta property=\"og:description\" content=\"In the next tutorial you will learn how to migrate data from MySQL to MongoDB. We will show you how to do it using Spark step by step. From creating a configuration for the player RDD to the installation guide for prerequisites components. Easy and intuitive!\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.stratio.com\/blog\/tutorial-migrating-data-from-mysql-to-mongodb\/\" \/>\n<meta property=\"og:site_name\" content=\"Stratio\" \/>\n<meta property=\"article:published_time\" content=\"2015-01-20T06:28:28+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2023-09-20T13:45:25+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.stratio.com\/blog\/wp-content\/uploads\/2015\/01\/Data-migration.jpg\" \/>\n\t<meta property=\"og:image:width\" content=\"730\" \/>\n\t<meta property=\"og:image:height\" content=\"312\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/jpeg\" \/>\n<meta name=\"author\" content=\"admin\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:creator\" content=\"@stratiobd\" \/>\n<meta name=\"twitter:site\" content=\"@stratiobd\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"admin\" \/>\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.stratio.com\/blog\/tutorial-migrating-data-from-mysql-to-mongodb\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/www.stratio.com\/blog\/tutorial-migrating-data-from-mysql-to-mongodb\/\"},\"author\":{\"name\":\"admin\",\"@id\":\"https:\/\/www.stratio.com\/blog\/#\/schema\/person\/af4f5fbbeb95bd7d55f79d9a677e615d\"},\"headline\":\"Tutorial: Migrating Data from MySQL to MongoDB\",\"datePublished\":\"2015-01-20T06:28:28+00:00\",\"dateModified\":\"2023-09-20T13:45:25+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/www.stratio.com\/blog\/tutorial-migrating-data-from-mysql-to-mongodb\/\"},\"wordCount\":228,\"publisher\":{\"@id\":\"https:\/\/www.stratio.com\/blog\/#organization\"},\"image\":{\"@id\":\"https:\/\/www.stratio.com\/blog\/tutorial-migrating-data-from-mysql-to-mongodb\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/www.stratio.com\/blog\/wp-content\/uploads\/2015\/01\/Data-migration.jpg\",\"articleSection\":[\"Product\"],\"inLanguage\":\"en-US\"},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.stratio.com\/blog\/tutorial-migrating-data-from-mysql-to-mongodb\/\",\"url\":\"https:\/\/www.stratio.com\/blog\/tutorial-migrating-data-from-mysql-to-mongodb\/\",\"name\":\"Tutorial: Migrating Data from MySQL to MongoDB - Stratio\",\"isPartOf\":{\"@id\":\"https:\/\/www.stratio.com\/blog\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/www.stratio.com\/blog\/tutorial-migrating-data-from-mysql-to-mongodb\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/www.stratio.com\/blog\/tutorial-migrating-data-from-mysql-to-mongodb\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/www.stratio.com\/blog\/wp-content\/uploads\/2015\/01\/Data-migration.jpg\",\"datePublished\":\"2015-01-20T06:28:28+00:00\",\"dateModified\":\"2023-09-20T13:45:25+00:00\",\"breadcrumb\":{\"@id\":\"https:\/\/www.stratio.com\/blog\/tutorial-migrating-data-from-mysql-to-mongodb\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.stratio.com\/blog\/tutorial-migrating-data-from-mysql-to-mongodb\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.stratio.com\/blog\/tutorial-migrating-data-from-mysql-to-mongodb\/#primaryimage\",\"url\":\"https:\/\/www.stratio.com\/blog\/wp-content\/uploads\/2015\/01\/Data-migration.jpg\",\"contentUrl\":\"https:\/\/www.stratio.com\/blog\/wp-content\/uploads\/2015\/01\/Data-migration.jpg\",\"width\":730,\"height\":312},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.stratio.com\/blog\/tutorial-migrating-data-from-mysql-to-mongodb\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/www.stratio.com\/blog\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Tutorial: Migrating Data from MySQL to MongoDB\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/www.stratio.com\/blog\/#website\",\"url\":\"https:\/\/www.stratio.com\/blog\/\",\"name\":\"Stratio Blog\",\"description\":\"Corporate blog\",\"publisher\":{\"@id\":\"https:\/\/www.stratio.com\/blog\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/www.stratio.com\/blog\/?s={search_term_string}\"},\"query-input\":\"required name=search_term_string\"}],\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/www.stratio.com\/blog\/#organization\",\"name\":\"Stratio\",\"url\":\"https:\/\/www.stratio.com\/blog\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.stratio.com\/blog\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/stratio.com\/blog\/wp-content\/uploads\/2020\/06\/stratio-web-logo-1.png\",\"contentUrl\":\"https:\/\/stratio.com\/blog\/wp-content\/uploads\/2020\/06\/stratio-web-logo-1.png\",\"width\":260,\"height\":55,\"caption\":\"Stratio\"},\"image\":{\"@id\":\"https:\/\/www.stratio.com\/blog\/#\/schema\/logo\/image\/\"},\"sameAs\":[\"https:\/\/x.com\/stratiobd\",\"https:\/\/es.linkedin.com\/company\/stratiobd\",\"https:\/\/www.youtube.com\/c\/StratioBD\"]},{\"@type\":\"Person\",\"@id\":\"https:\/\/www.stratio.com\/blog\/#\/schema\/person\/af4f5fbbeb95bd7d55f79d9a677e615d\",\"name\":\"admin\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.stratio.com\/blog\/#\/schema\/person\/image\/589aaf4b404b1fe099b09564062c4563\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/9b181ae4395243dccaf1c3e3a4749d81?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/9b181ae4395243dccaf1c3e3a4749d81?s=96&d=mm&r=g\",\"caption\":\"admin\"}}]}<\/script>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"title":"Tutorial: Migrating Data from MySQL to MongoDB - Stratio","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.stratio.com\/blog\/tutorial-migrating-data-from-mysql-to-mongodb\/","og_locale":"en_US","og_type":"article","og_title":"Tutorial: Migrating Data from MySQL to MongoDB","og_description":"In the next tutorial you will learn how to migrate data from MySQL to MongoDB. We will show you how to do it using Spark step by step. From creating a configuration for the player RDD to the installation guide for prerequisites components. Easy and intuitive!","og_url":"https:\/\/www.stratio.com\/blog\/tutorial-migrating-data-from-mysql-to-mongodb\/","og_site_name":"Stratio","article_published_time":"2015-01-20T06:28:28+00:00","article_modified_time":"2023-09-20T13:45:25+00:00","og_image":[{"width":730,"height":312,"url":"https:\/\/www.stratio.com\/blog\/wp-content\/uploads\/2015\/01\/Data-migration.jpg","type":"image\/jpeg"}],"author":"admin","twitter_card":"summary_large_image","twitter_creator":"@stratiobd","twitter_site":"@stratiobd","twitter_misc":{"Written by":"admin","Est. reading time":"4 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.stratio.com\/blog\/tutorial-migrating-data-from-mysql-to-mongodb\/#article","isPartOf":{"@id":"https:\/\/www.stratio.com\/blog\/tutorial-migrating-data-from-mysql-to-mongodb\/"},"author":{"name":"admin","@id":"https:\/\/www.stratio.com\/blog\/#\/schema\/person\/af4f5fbbeb95bd7d55f79d9a677e615d"},"headline":"Tutorial: Migrating Data from MySQL to MongoDB","datePublished":"2015-01-20T06:28:28+00:00","dateModified":"2023-09-20T13:45:25+00:00","mainEntityOfPage":{"@id":"https:\/\/www.stratio.com\/blog\/tutorial-migrating-data-from-mysql-to-mongodb\/"},"wordCount":228,"publisher":{"@id":"https:\/\/www.stratio.com\/blog\/#organization"},"image":{"@id":"https:\/\/www.stratio.com\/blog\/tutorial-migrating-data-from-mysql-to-mongodb\/#primaryimage"},"thumbnailUrl":"https:\/\/www.stratio.com\/blog\/wp-content\/uploads\/2015\/01\/Data-migration.jpg","articleSection":["Product"],"inLanguage":"en-US"},{"@type":"WebPage","@id":"https:\/\/www.stratio.com\/blog\/tutorial-migrating-data-from-mysql-to-mongodb\/","url":"https:\/\/www.stratio.com\/blog\/tutorial-migrating-data-from-mysql-to-mongodb\/","name":"Tutorial: Migrating Data from MySQL to MongoDB - Stratio","isPartOf":{"@id":"https:\/\/www.stratio.com\/blog\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.stratio.com\/blog\/tutorial-migrating-data-from-mysql-to-mongodb\/#primaryimage"},"image":{"@id":"https:\/\/www.stratio.com\/blog\/tutorial-migrating-data-from-mysql-to-mongodb\/#primaryimage"},"thumbnailUrl":"https:\/\/www.stratio.com\/blog\/wp-content\/uploads\/2015\/01\/Data-migration.jpg","datePublished":"2015-01-20T06:28:28+00:00","dateModified":"2023-09-20T13:45:25+00:00","breadcrumb":{"@id":"https:\/\/www.stratio.com\/blog\/tutorial-migrating-data-from-mysql-to-mongodb\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.stratio.com\/blog\/tutorial-migrating-data-from-mysql-to-mongodb\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.stratio.com\/blog\/tutorial-migrating-data-from-mysql-to-mongodb\/#primaryimage","url":"https:\/\/www.stratio.com\/blog\/wp-content\/uploads\/2015\/01\/Data-migration.jpg","contentUrl":"https:\/\/www.stratio.com\/blog\/wp-content\/uploads\/2015\/01\/Data-migration.jpg","width":730,"height":312},{"@type":"BreadcrumbList","@id":"https:\/\/www.stratio.com\/blog\/tutorial-migrating-data-from-mysql-to-mongodb\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.stratio.com\/blog\/"},{"@type":"ListItem","position":2,"name":"Tutorial: Migrating Data from MySQL to MongoDB"}]},{"@type":"WebSite","@id":"https:\/\/www.stratio.com\/blog\/#website","url":"https:\/\/www.stratio.com\/blog\/","name":"Stratio Blog","description":"Corporate blog","publisher":{"@id":"https:\/\/www.stratio.com\/blog\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.stratio.com\/blog\/?s={search_term_string}"},"query-input":"required name=search_term_string"}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/www.stratio.com\/blog\/#organization","name":"Stratio","url":"https:\/\/www.stratio.com\/blog\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.stratio.com\/blog\/#\/schema\/logo\/image\/","url":"https:\/\/stratio.com\/blog\/wp-content\/uploads\/2020\/06\/stratio-web-logo-1.png","contentUrl":"https:\/\/stratio.com\/blog\/wp-content\/uploads\/2020\/06\/stratio-web-logo-1.png","width":260,"height":55,"caption":"Stratio"},"image":{"@id":"https:\/\/www.stratio.com\/blog\/#\/schema\/logo\/image\/"},"sameAs":["https:\/\/x.com\/stratiobd","https:\/\/es.linkedin.com\/company\/stratiobd","https:\/\/www.youtube.com\/c\/StratioBD"]},{"@type":"Person","@id":"https:\/\/www.stratio.com\/blog\/#\/schema\/person\/af4f5fbbeb95bd7d55f79d9a677e615d","name":"admin","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.stratio.com\/blog\/#\/schema\/person\/image\/589aaf4b404b1fe099b09564062c4563","url":"https:\/\/secure.gravatar.com\/avatar\/9b181ae4395243dccaf1c3e3a4749d81?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/9b181ae4395243dccaf1c3e3a4749d81?s=96&d=mm&r=g","caption":"admin"}}]}},"authors":[{"term_id":794,"user_id":2,"is_guest":0,"slug":"admin","display_name":"admin","avatar_url":"https:\/\/secure.gravatar.com\/avatar\/9b181ae4395243dccaf1c3e3a4749d81?s=96&d=mm&r=g","0":null,"1":"","2":"","3":"","4":"","5":"","6":"","7":"","8":""}],"amp_enabled":true,"_links":{"self":[{"href":"https:\/\/www.stratio.com\/blog\/wp-json\/wp\/v2\/posts\/1392"}],"collection":[{"href":"https:\/\/www.stratio.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.stratio.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.stratio.com\/blog\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/www.stratio.com\/blog\/wp-json\/wp\/v2\/comments?post=1392"}],"version-history":[{"count":15,"href":"https:\/\/www.stratio.com\/blog\/wp-json\/wp\/v2\/posts\/1392\/revisions"}],"predecessor-version":[{"id":13863,"href":"https:\/\/www.stratio.com\/blog\/wp-json\/wp\/v2\/posts\/1392\/revisions\/13863"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.stratio.com\/blog\/wp-json\/wp\/v2\/media\/121"}],"wp:attachment":[{"href":"https:\/\/www.stratio.com\/blog\/wp-json\/wp\/v2\/media?parent=1392"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.stratio.com\/blog\/wp-json\/wp\/v2\/categories?post=1392"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.stratio.com\/blog\/wp-json\/wp\/v2\/tags?post=1392"},{"taxonomy":"author","embeddable":true,"href":"https:\/\/www.stratio.com\/blog\/wp-json\/wp\/v2\/ppma_author?post=1392"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}