{"id":7678,"date":"2016-04-26T13:46:32","date_gmt":"2016-04-26T11:46:32","guid":{"rendered":"https:\/\/www.dbi-services.com\/blog\/the-almost-same-sample-schema-for-all-major-relational-databases-3-mysqlmariadb\/"},"modified":"2016-04-26T13:46:32","modified_gmt":"2016-04-26T11:46:32","slug":"the-almost-same-sample-schema-for-all-major-relational-databases-3-mysqlmariadb","status":"publish","type":"post","link":"https:\/\/www.dbi-services.com\/blog\/the-almost-same-sample-schema-for-all-major-relational-databases-3-mysqlmariadb\/","title":{"rendered":"The (almost) same sample schema for all major relational databases (3) \u2013 MySQL\/MariaDB"},"content":{"rendered":"

Some time ago I blogged on how to get the “Dell DVD Store Database Test Suite”<\/a> installed in PostgreSQL<\/a> and Oracle<\/a>. This time we’ll do the same on a MariaDB instance. I have to admit here that I am not very familiar with MariaDB\/MySQL so the stuff presented here for sure breaks any security best practices \ud83d\ude42<\/p>\n

<\/p>\n

Again I’ll start with a CentOS 7.2 core installation and use the MariaDB binaries available in the standard repositories:<\/p>\n

\n[root@mysqldell ~] cat \/etc\/centos-release\nCentOS Linux release 7.2.1511 (Core) \n[root@mysqldell ~] yum install -y mariadb-server.x86_64\n<\/pre>\n
Having the binaries available lets enable and start the service:<\/p>\n
\n[root@mysqldell ~] systemctl list-unit-files | grep maria\nmariadb.service                             disabled\n[root@mysqldell ~] systemctl enable mariadb.service\nCreated symlink from \/etc\/systemd\/system\/multi-user.target.wants\/mariadb.service to \/usr\/lib\/systemd\/system\/mariadb.service.\n[root@mysqldell ~] systemctl start mariadb.service\n<\/pre>\n
This should have started my MariaDB instance:<\/p>\n
\n[root@mysqldell ~] systemctl status mariadb.service\n\u25cf mariadb.service - MariaDB database server\n   Loaded: loaded (\/usr\/lib\/systemd\/system\/mariadb.service; enabled; vendor preset: disabled)\n   Active: active (running) since Mon 2016-04-25 17:58:25 CEST; 10s ago\n  Process: 9791 ExecStartPost=\/usr\/libexec\/mariadb-wait-ready $MAINPID (code=exited, status=0\/SUCCESS)\n  Process: 9712 ExecStartPre=\/usr\/libexec\/mariadb-prepare-db-dir %n (code=exited, status=0\/SUCCESS)\n Main PID: 9790 (mysqld_safe)\n   CGroup: \/system.slice\/mariadb.service\n           \u251c\u25009790 \/bin\/sh \/usr\/bin\/mysqld_safe --basedir=\/usr\n           \u2514\u25009948 \/usr\/libexec\/mysqld --basedir=\/usr --datadir=\/var\/lib\/mysql --plugin-dir=\/usr\/lib64\/mysql\/plugin --log-error=\/var\/log\/mariadb\/mariadb.log ...\n\nApr 25 17:58:23 mysqldell mariadb-prepare-db-dir[9712]: The latest information about MariaDB is available at http:\/\/mariadb.org\/.\nApr 25 17:58:23 mysqldell mariadb-prepare-db-dir[9712]: You can find additional information about the MySQL part at:\nApr 25 17:58:23 mysqldell mariadb-prepare-db-dir[9712]: http:\/\/dev.mysql.com\nApr 25 17:58:23 mysqldell mariadb-prepare-db-dir[9712]: Support MariaDB development by buying support\/new features from MariaDB\nApr 25 17:58:23 mysqldell mariadb-prepare-db-dir[9712]: Corporation Ab. You can contact us about this at sales@mariadb.com.\nApr 25 17:58:23 mysqldell mariadb-prepare-db-dir[9712]: Alternatively consider joining our community based development effort:\nApr 25 17:58:23 mysqldell mariadb-prepare-db-dir[9712]: http:\/\/mariadb.com\/kb\/en\/contributing-to-the-mariadb-project\/\nApr 25 17:58:23 mysqldell mysqld_safe[9790]: 160425 17:58:23 mysqld_safe Logging to '\/var\/log\/mariadb\/mariadb.log'.\nApr 25 17:58:23 mysqldell mysqld_safe[9790]: 160425 17:58:23 mysqld_safe Starting mysqld daemon with databases from \/var\/lib\/mysql\nApr 25 17:58:25 mysqldell systemd[1]: Started MariaDB database server.\n<\/pre>\n
Can I login?<\/p>\n
\n[root@mysqldell ~] mysql\nWelcome to the MariaDB monitor.  Commands end with ; or g.\nYour MariaDB connection id is 2\nServer version: 5.5.47-MariaDB MariaDB Server\n\nCopyright (c) 2000, 2015, Oracle, MariaDB Corporation Ab and others.\n\nType 'help;' or 'h' for help. Type 'c' to clear the current input statement.\n\nMariaDB [(none)]> \n<\/pre>\n
As I just want to get the data loaded I do not care much about security and will unlock the mysql account so I do not have to work as root:<\/p>\n
\n[root@mysqldell ~] usermod -s \/bin\/bash mysql\n[root@mysqldell ~] su - mysql\n<\/pre>\n
Can I login as mysql?<\/p>\n
\n-bash-4.2$ mysql\nWelcome to the MariaDB monitor.  Commands end with ; or g.\nYour MariaDB connection id is 3\nServer version: 5.5.47-MariaDB MariaDB Server\n\nCopyright (c) 2000, 2015, Oracle, MariaDB Corporation Ab and others.\n\nType 'help;' or 'h' for help. Type 'c' to clear the current input statement.\n\nMariaDB [(none)]> show databases;\n+--------------------+\n| Database           |\n+--------------------+\n| information_schema |\n| mysql              |\n| performance_schema |\n| test               |\n+--------------------+\n4 rows in set (0.00 sec)\n<\/pre>\n
Looks fine so lets continue with the dell stuff. I’ll create the DS2 database and the user that the scripts will use to connect:<\/p>\n
\nMariaDB [(none)]> create user 'web'@'localhost' identified by \"web\";\nQuery OK, 0 rows affected (0.00 sec)\nriaDB [(none)]> create database DS2;\nQuery OK, 1 row affected (0.00 sec)\nariaDB [(none)]> GRANT ALL PRIVILEGES ON DS2.* TO 'web'@'%' WITH GRANT OPTION;\nQuery OK, 0 rows affected (0.00 sec)\n<\/pre>\n
The next steps are almost the same as with the Oracle and PostgreSQL versions. Transfer the ds2 files to the target machine and extract them:<\/p>\n
\n-bash-4.2$ cd \/var\/tmp\/\n-bash-4.2$ ls\nds21_mysql.tar.gz  ds21.tar.gz \n-bash-4.2$ tar -axf ds21.tar.gz\n-bash-4.2$ tar -axf ds21_mysql.tar.gz\n-bash-4.2$ ls\nCreateConfigFile.pl  drivers                  ds2_change_log.txt  ds2_readme.txt  gpl.txt              mysqlds2\ndata_files           ds2.1_Documentation.txt  ds2_faq.txt         ds2_schema.txt  Install_DVDStore.pl\n-bash-4.2$ cd mysqlds2\/\n-bash-4.2$ ls\nbuild                     ds2_mysql_change_log.txt  ds2mysqlfns.cs        gpl.txt  monitor_load.txt  my.cnf.example.diff          mysqlds2_create_all.sh  web\nds2_lamp_setup_rhel5.txt  ds2mysqldriver.exe        ds2_mysql_readme.txt  load     my.cnf.example    mysqlds2_create_all_nosp.sh  showinnodb.sql\n<\/pre>\n
Looks familiar so lets try to load the data:<\/p>\n
\n-bash-4.2$ .\/mysqlds2_create_all.sh\nERROR 1064 (42000) at line 16: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'TYPE=InnoDB' at line 24\nERROR 1146 (42S02) at line 9: Table 'DS2.CUSTOMERS' doesn't exist\nERROR 1146 (42S02) at line 4: Table 'DS2.CUSTOMERS' doesn't exist\nERROR 1146 (42S02) at line 4: Table 'DS2.ORDERS' doesn't exist\nERROR 1146 (42S02) at line 4: Table 'DS2.ORDERLINES' doesn't exist\nERROR 1146 (42S02) at line 4: Table 'DS2.CUST_HIST' doesn't exist\nERROR 1146 (42S02) at line 5: Table 'DS2.PRODUCTS' doesn't exist\nERROR 1146 (42S02) at line 5: Table 'DS2.INVENTORY' doesn't exist\n<\/pre>\n
Hmm. What went wrong:<\/p>\n
\n-bash-4.2$ grep -i innodb build\/*\nbuild\/mysqlds2_cleanup_generic_template.sql:  TYPE=InnoDB;\nbuild\/mysqlds2_cleanup_large.sql:  TYPE=InnoDB;\nbuild\/mysqlds2_cleanup_med.sql:  TYPE=InnoDB;\nbuild\/mysqlds2_cleanup_small.sql:  TYPE=InnoDB;\nbuild\/mysqlds2_create_db.sql:  TYPE=InnoDB;\nbuild\/mysqlds2_create_db.sql:  TYPE=InnoDB;\nbuild\/mysqlds2_create_db.sql:  TYPE=InnoDB; \nbuild\/mysqlds2_create_db.sql:  TYPE=InnoDB; \nbuild\/mysqlds2_create_db.sql:  TYPE=InnoDB;\nbuild\/mysqlds2_create_db.sql:  TYPE=InnoDB;\nbuild\/mysqlds2_create_db.sql:  TYPE=InnoDB;\n<\/pre>\n
Looks like a syntax issue. Fix it:<\/p>\n
\n-bash-4.2$ sed -i 's\/TYPE=InnoDB\/engine=innodb\/' build\/*\n-bash-4.2$ grep -i innodb build\/*\nbuild\/mysqlds2_cleanup_generic_template.sql:  engine=innodb;\nbuild\/mysqlds2_cleanup_large.sql:  engine=innodb;\nbuild\/mysqlds2_cleanup_med.sql:  engine=innodb;\nbuild\/mysqlds2_cleanup_small.sql:  engine=innodb;\nbuild\/mysqlds2_create_db.sql:  engine=innodb;\nbuild\/mysqlds2_create_db.sql:  engine=innodb;\nbuild\/mysqlds2_create_db.sql:  engine=innodb; \nbuild\/mysqlds2_create_db.sql:  engine=innodb; \nbuild\/mysqlds2_create_db.sql:  engine=innodb;\nbuild\/mysqlds2_create_db.sql:  engine=innodb;\nbuild\/mysqlds2_create_db.sql:  engine=innodb;\n<\/pre>\n
Try again:<\/p>\n
\n-bash-4.2$ .\/mysqlds2_create_all.sh\nERROR 1064 (42000) at line 70: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'TYPE=MyISAM' at line 11\nERROR 1146 (42S02) at line 47: Table 'DS2.PRODUCTS' doesn't exist\nERROR 1146 (42S02) at line 5: Table 'DS2.PRODUCTS' doesn't exist\nERROR 1146 (42S02) at line 5: Table 'DS2.INVENTORY' doesn't exist\n<\/pre>\n
Similar issue, so:<\/p>\n
\n-bash-4.2$ sed -i 's\/TYPE=MyISAM\/engine=myisam\/g' build\/mysqlds2_create_db.sql\n-bash-4.2$ grep -i MyISAM build\/*\nbuild\/mysqlds2_create_db.sql:  engine=myisam;\n<\/pre>\n
… and try again:<\/p>\n
\n-bash-4.2$ .\/mysqlds2_create_all.sh\n-bash-4.2$ \n<\/pre>\n
Much better. What is there:<\/p>\n
\nMariaDB [DS2]> show tables;\n+---------------+\n| Tables_in_DS2 |\n+---------------+\n| CATEGORIES    |\n| CUSTOMERS     |\n| CUST_HIST     |\n| INVENTORY     |\n| ORDERLINES    |\n| ORDERS        |\n| PRODUCTS      |\n| REORDER       |\n+---------------+\n8 rows in set (0.00 sec)\n\nMariaDB [DS2]> select count(*) from PRODUCTS;\n+----------+\n| count(*) |\n+----------+\n|    10000 |\n+----------+\n1 row in set (0.00 sec)\n\n\nMariaDB [DS2]> show index from CUSTOMERS;\n+-----------+------------+------------------+--------------+-------------+-----------+-------------+----------+--------+------+------------+---------+---------------+\n| Table     | Non_unique | Key_name         | Seq_in_index | Column_name | Collation | Cardinality | Sub_part | Packed | Null | Index_type | Comment | Index_comment |\n+-----------+------------+------------------+--------------+-------------+-----------+-------------+----------+--------+------+------------+---------+---------------+\n| CUSTOMERS |          0 | PRIMARY          |            1 | CUSTOMERID  | A         |       20045 |     NULL | NULL   |      | BTREE      |         |               |\n| CUSTOMERS |          0 | IX_CUST_USERNAME |            1 | USERNAME    | A         |       20045 |     NULL | NULL   |      | BTREE      |         |               |\n+-----------+------------+------------------+--------------+-------------+-----------+-------------+----------+--------+------+------------+---------+---------------+\n2 rows in set (0.00 sec)\n<\/pre>\n
You can use the same generator script to get a database sized according to your needs:<\/p>\n
\n-bash-4.2$ .\/Install_DVDStore.pl \nPlease enter following parameters: \n***********************************\nPlease enter database size (integer expected) : 100\nPlease enter whether above database size is in (MB \/ GB) : MB\nPlease enter database type (MSSQL \/ MYSQL \/ PGSQL \/ ORACLE) : MYSQL\nPlease enter system type on which DB Server is installed (WIN \/ LINUX) : LINUX\n***********************************\n***********************************\nInitializing parameters...\n***********************************\nDatabase Size: 100 \nDatabase size is in MB \nDatabase Type is MYSQL \nSystem Type for DB Server is LINUX \n***********************************\n\nCalculating Rows in tables!! \nSmall size database (less than 1 GB) \nRatio calculated : 10 \nCustomer Rows: 200000 \nOrder Rows \/ month: 10000 \nProduct Rows: 100000 \n\nCreating CSV files....\nStarting to create CSV data files.... \nFor larger database sizes, it will take time.\nDo not kill the script till execution is complete. \n\nCreating Customer CSV files!!! \n1 100000 US S 0 \n100001 200000 ROW S 0 \n\nCustomer CSV Files created!! \n\nCreating Orders, Orderlines and Cust_Hist csv files!!! \n\nCreating Order CSV file for Month jan !!! \n1 10000 jan S 1 0 100000 200000 \n\nCreating Order CSV file for Month feb !!! \n10001 20000 feb S 2 0 100000 200000 \n\nCreating Order CSV file for Month mar !!! \n20001 30000 mar S 3 0 100000 200000 \n\nCreating Order CSV file for Month apr !!! \n30001 40000 apr S 4 0 100000 200000 \n\nCreating Order CSV file for Month may !!! \n40001 50000 may S 5 0 100000 200000 \n\nCreating Order CSV file for Month jun !!! \n50001 60000 jun S 6 0 100000 200000 \n\nCreating Order CSV file for Month jul !!! \n60001 70000 jul S 7 0 100000 200000 \n\nCreating Order CSV file for Month aug !!! \n70001 80000 aug S 8 0 100000 200000 \n\nCreating Order CSV file for Month sep !!! \n80001 90000 sep S 9 0 100000 200000 \n\nCreating Order CSV file for Month oct !!! \n90001 100000 oct S 10 0 100000 200000 \n\nCreating Order CSV file for Month nov !!! \n100001 110000 nov S 11 0 100000 200000 \n\nCreating Order CSV file for Month dec !!! \n110001 120000 dec S 12 0 100000 200000 \n\nAll Order, Orderlines, Cust_Hist CSV files created !!! \n\nCreating Inventory CSV file!!!! \n\nInventory CSV file created!!!! \n\nCreating product CSV file!!!! \n\nProduct CSV file created!!!! \n\nCreating build script for MySQL from templates... \n\nTemplate files are stored in respective build folders and the output files are also stored in same folder \n\nTemplate files are named with generic_template at end of their filename and the output files without _template at end \n\nCompleted creating and writing build scripts for MySQL database... \n\nAll database build scripts(shell and sql) are dumped into their respective folders. \n\nThese scripts are created from template files in same folders with '_generic_template' in their name. \n\nScripts that are created from template files have '_' 100 MB in their name. \n\nUser can edit the sql script generated for customizing sql script for more DBFiles per table and change the paths of DBFiles.\n\nNow Run CreateConfigFile.pl perl script in ds2 folder which will generate configuration file used as input to the driver program\n<\/pre>\n
Reload:<\/p>\n
\n-bash-4.2$ .\/mysqlds2_create_all.sh\n-bash-4.2$ \n<\/pre>\n
And you have a database sized as you want it:<\/p>\n
\nMariaDB [DS2]> select count(*) from PRODUCTS;\n+----------+\n| count(*) |\n+----------+\n|   100000 |\n+----------+\n1 row in set (0.00 sec)\n<\/pre>\n
Happy generating \ud83d\ude42 This should work the same for MySQL.<\/p>\n","protected":false},"excerpt":{"rendered":"
Some time ago I blogged on how to get the “Dell DVD Store Database Test Suite” installed in PostgreSQL and Oracle. This time we’ll do the same on a MariaDB instance. I have to admit here that I am not very familiar with MariaDB\/MySQL so the stuff presented here for sure breaks any security best […]<\/p>\n","protected":false},"author":29,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"footnotes":""},"categories":[229],"tags":[141,144],"type_dbi":[],"class_list":["post-7678","post","type-post","status-publish","format-standard","hentry","category-database-administration-monitoring","tag-mariadb","tag-mysql"],"acf":[],"yoast_head":"\nThe (almost) same sample schema for all major relational databases (3) \u2013 MySQL\/MariaDB - 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\/the-almost-same-sample-schema-for-all-major-relational-databases-3-mysqlmariadb\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"The (almost) same sample schema for all major relational databases (3) \u2013 MySQL\/MariaDB\" \/>\n<meta property=\"og:description\" content=\"Some time ago I blogged on how to get the “Dell DVD Store Database Test Suite” installed in PostgreSQL and Oracle. This time we’ll do the same on a MariaDB instance. I have to admit here that I am not very familiar with MariaDB\/MySQL so the stuff presented here for sure breaks any security best […]\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.dbi-services.com\/blog\/the-almost-same-sample-schema-for-all-major-relational-databases-3-mysqlmariadb\/\" \/>\n<meta property=\"og:site_name\" content=\"dbi Blog\" \/>\n<meta property=\"article:published_time\" content=\"2016-04-26T11:46:32+00:00\" \/>\n<meta name=\"author\" content=\"Daniel Westermann\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:creator\" content=\"@westermanndanie\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Daniel Westermann\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"9 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\/the-almost-same-sample-schema-for-all-major-relational-databases-3-mysqlmariadb\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/the-almost-same-sample-schema-for-all-major-relational-databases-3-mysqlmariadb\/\"},\"author\":{\"name\":\"Daniel Westermann\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/8d08e9bd996a89bd75c0286cbabf3c66\"},\"headline\":\"The (almost) same sample schema for all major relational databases (3) \u2013 MySQL\/MariaDB\",\"datePublished\":\"2016-04-26T11:46:32+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/the-almost-same-sample-schema-for-all-major-relational-databases-3-mysqlmariadb\/\"},\"wordCount\":264,\"commentCount\":0,\"keywords\":[\"MariaDB\",\"MySQL\"],\"articleSection\":[\"Database Administration & Monitoring\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/www.dbi-services.com\/blog\/the-almost-same-sample-schema-for-all-major-relational-databases-3-mysqlmariadb\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/the-almost-same-sample-schema-for-all-major-relational-databases-3-mysqlmariadb\/\",\"url\":\"https:\/\/www.dbi-services.com\/blog\/the-almost-same-sample-schema-for-all-major-relational-databases-3-mysqlmariadb\/\",\"name\":\"The (almost) same sample schema for all major relational databases (3) \u2013 MySQL\/MariaDB - dbi Blog\",\"isPartOf\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/#website\"},\"datePublished\":\"2016-04-26T11:46:32+00:00\",\"author\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/8d08e9bd996a89bd75c0286cbabf3c66\"},\"breadcrumb\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/the-almost-same-sample-schema-for-all-major-relational-databases-3-mysqlmariadb\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.dbi-services.com\/blog\/the-almost-same-sample-schema-for-all-major-relational-databases-3-mysqlmariadb\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/the-almost-same-sample-schema-for-all-major-relational-databases-3-mysqlmariadb\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Accueil\",\"item\":\"https:\/\/www.dbi-services.com\/blog\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"The (almost) same sample schema for all major relational databases (3) \u2013 MySQL\/MariaDB\"}]},{\"@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\/8d08e9bd996a89bd75c0286cbabf3c66\",\"name\":\"Daniel Westermann\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/secure.gravatar.com\/avatar\/31350ceeecb1dd8986339a29bf040d4cd3cd087d410deccd8f55234466d6c317?s=96&d=mm&r=g\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/31350ceeecb1dd8986339a29bf040d4cd3cd087d410deccd8f55234466d6c317?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/31350ceeecb1dd8986339a29bf040d4cd3cd087d410deccd8f55234466d6c317?s=96&d=mm&r=g\",\"caption\":\"Daniel Westermann\"},\"description\":\"Daniel Westermann is Principal Consultant and Technology Leader Open Infrastructure at dbi services. He has more than 15 years of experience in management, engineering and optimization of databases and infrastructures, especially on Oracle and PostgreSQL. Since the beginning of his career, he has specialized in Oracle Technologies and is Oracle Certified Professional 12c and Oracle Certified Expert RAC\/GridInfra. Over time, Daniel has become increasingly interested in open source technologies, becoming \u201cTechnology Leader Open Infrastructure\u201d and PostgreSQL expert. \u00a0Based on community or EnterpriseDB tools, he develops and installs complex high available solutions with PostgreSQL. He is also a certified PostgreSQL Plus 9.0 Professional and a Postgres Advanced Server 9.4 Professional. He is a regular speaker at PostgreSQL conferences in Switzerland and Europe. Today Daniel is also supporting our customers on AWS services such as AWS RDS, database migrations into the cloud, EC2 and automated infrastructure management with AWS SSM (System Manager). He is a certified AWS Solutions Architect Professional. Prior to dbi services, Daniel was Management System Engineer at LC SYSTEMS-Engineering AG in Basel. Before that, he worked as Oracle Developper &\u00a0Project Manager at Delta Energy Solutions AG in Basel (today Powel AG). Daniel holds a diploma in Business Informatics (DHBW, Germany). His branch-related experience mainly covers the pharma industry, the financial sector, energy, lottery and telecommunications.\",\"sameAs\":[\"https:\/\/x.com\/westermanndanie\"],\"url\":\"https:\/\/www.dbi-services.com\/blog\/author\/daniel-westermann\/\"}]}<\/script>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"title":"The (almost) same sample schema for all major relational databases (3) \u2013 MySQL\/MariaDB - 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\/the-almost-same-sample-schema-for-all-major-relational-databases-3-mysqlmariadb\/","og_locale":"en_US","og_type":"article","og_title":"The (almost) same sample schema for all major relational databases (3) \u2013 MySQL\/MariaDB","og_description":"Some time ago I blogged on how to get the “Dell DVD Store Database Test Suite” installed in PostgreSQL and Oracle. This time we’ll do the same on a MariaDB instance. I have to admit here that I am not very familiar with MariaDB\/MySQL so the stuff presented here for sure breaks any security best […]","og_url":"https:\/\/www.dbi-services.com\/blog\/the-almost-same-sample-schema-for-all-major-relational-databases-3-mysqlmariadb\/","og_site_name":"dbi Blog","article_published_time":"2016-04-26T11:46:32+00:00","author":"Daniel Westermann","twitter_card":"summary_large_image","twitter_creator":"@westermanndanie","twitter_misc":{"Written by":"Daniel Westermann","Est. reading time":"9 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.dbi-services.com\/blog\/the-almost-same-sample-schema-for-all-major-relational-databases-3-mysqlmariadb\/#article","isPartOf":{"@id":"https:\/\/www.dbi-services.com\/blog\/the-almost-same-sample-schema-for-all-major-relational-databases-3-mysqlmariadb\/"},"author":{"name":"Daniel Westermann","@id":"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/8d08e9bd996a89bd75c0286cbabf3c66"},"headline":"The (almost) same sample schema for all major relational databases (3) \u2013 MySQL\/MariaDB","datePublished":"2016-04-26T11:46:32+00:00","mainEntityOfPage":{"@id":"https:\/\/www.dbi-services.com\/blog\/the-almost-same-sample-schema-for-all-major-relational-databases-3-mysqlmariadb\/"},"wordCount":264,"commentCount":0,"keywords":["MariaDB","MySQL"],"articleSection":["Database Administration & Monitoring"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/www.dbi-services.com\/blog\/the-almost-same-sample-schema-for-all-major-relational-databases-3-mysqlmariadb\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/www.dbi-services.com\/blog\/the-almost-same-sample-schema-for-all-major-relational-databases-3-mysqlmariadb\/","url":"https:\/\/www.dbi-services.com\/blog\/the-almost-same-sample-schema-for-all-major-relational-databases-3-mysqlmariadb\/","name":"The (almost) same sample schema for all major relational databases (3) \u2013 MySQL\/MariaDB - dbi Blog","isPartOf":{"@id":"https:\/\/www.dbi-services.com\/blog\/#website"},"datePublished":"2016-04-26T11:46:32+00:00","author":{"@id":"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/8d08e9bd996a89bd75c0286cbabf3c66"},"breadcrumb":{"@id":"https:\/\/www.dbi-services.com\/blog\/the-almost-same-sample-schema-for-all-major-relational-databases-3-mysqlmariadb\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.dbi-services.com\/blog\/the-almost-same-sample-schema-for-all-major-relational-databases-3-mysqlmariadb\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/www.dbi-services.com\/blog\/the-almost-same-sample-schema-for-all-major-relational-databases-3-mysqlmariadb\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Accueil","item":"https:\/\/www.dbi-services.com\/blog\/"},{"@type":"ListItem","position":2,"name":"The (almost) same sample schema for all major relational databases (3) \u2013 MySQL\/MariaDB"}]},{"@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\/8d08e9bd996a89bd75c0286cbabf3c66","name":"Daniel Westermann","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/secure.gravatar.com\/avatar\/31350ceeecb1dd8986339a29bf040d4cd3cd087d410deccd8f55234466d6c317?s=96&d=mm&r=g","url":"https:\/\/secure.gravatar.com\/avatar\/31350ceeecb1dd8986339a29bf040d4cd3cd087d410deccd8f55234466d6c317?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/31350ceeecb1dd8986339a29bf040d4cd3cd087d410deccd8f55234466d6c317?s=96&d=mm&r=g","caption":"Daniel Westermann"},"description":"Daniel Westermann is Principal Consultant and Technology Leader Open Infrastructure at dbi services. He has more than 15 years of experience in management, engineering and optimization of databases and infrastructures, especially on Oracle and PostgreSQL. Since the beginning of his career, he has specialized in Oracle Technologies and is Oracle Certified Professional 12c and Oracle Certified Expert RAC\/GridInfra. Over time, Daniel has become increasingly interested in open source technologies, becoming \u201cTechnology Leader Open Infrastructure\u201d and PostgreSQL expert. \u00a0Based on community or EnterpriseDB tools, he develops and installs complex high available solutions with PostgreSQL. He is also a certified PostgreSQL Plus 9.0 Professional and a Postgres Advanced Server 9.4 Professional. He is a regular speaker at PostgreSQL conferences in Switzerland and Europe. Today Daniel is also supporting our customers on AWS services such as AWS RDS, database migrations into the cloud, EC2 and automated infrastructure management with AWS SSM (System Manager). He is a certified AWS Solutions Architect Professional. Prior to dbi services, Daniel was Management System Engineer at LC SYSTEMS-Engineering AG in Basel. Before that, he worked as Oracle Developper &\u00a0Project Manager at Delta Energy Solutions AG in Basel (today Powel AG). Daniel holds a diploma in Business Informatics (DHBW, Germany). His branch-related experience mainly covers the pharma industry, the financial sector, energy, lottery and telecommunications.","sameAs":["https:\/\/x.com\/westermanndanie"],"url":"https:\/\/www.dbi-services.com\/blog\/author\/daniel-westermann\/"}]}},"_links":{"self":[{"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/posts\/7678","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\/29"}],"replies":[{"embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/comments?post=7678"}],"version-history":[{"count":0,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/posts\/7678\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/media?parent=7678"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/categories?post=7678"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/tags?post=7678"},{"taxonomy":"type","embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/type_dbi?post=7678"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}