{"id":2274,"date":"2010-01-31T09:13:06","date_gmt":"2010-01-31T14:13:06","guid":{"rendered":"http:\/\/g33kinfo.com\/info\/?p=2274"},"modified":"2010-01-31T09:13:06","modified_gmt":"2010-01-31T14:13:06","slug":"mariadb-vs-mysql","status":"publish","type":"post","link":"https:\/\/g33kinfo.com\/info\/mariadb-vs-mysql\/","title":{"rendered":"MariaDB vs. MySQL"},"content":{"rendered":"<p>MySQL is dead. Long live MySQL. Now that oracle owns MySQL, it will certainly kill it as quickly and quietly as possible. If you were a large corporation, why would you want to have a stable, open source, widely used software platform competing with your fee related software that is generating a profit from the corporate world. The short and sweet answer is you wouldn&#8217;t. That is why MySQL is going away.<\/p>\n<p>(From <a href=\"http:\/\/askmonty.org\/wiki\/index.php\/Main_Page\" target=\"blank\" rel=\"noopener noreferrer\"> http:\/\/askmonty.org\/wiki\/index.php\/Main_Page)<\/a><\/p>\n<p>Luckily the founder of MySQL, Michael Widenius left Sun and started his own community branch of MySQL, called MariaDB. MariaDB is a backward compatible, drop-in replacement branch of MySQL\u00ae Database Server which includes all major open source storage engines, including the Maria storage engine. You can find the MariaDB code at <a title=\"http:\/\/code.launchpad.net\/maria\" rel=\"nofollow noopener noreferrer\" href=\"http:\/\/code.launchpad.net\/maria\" target=\"_blank\">Launchpad<\/a>, and download binaries at <a title=\"Download\" href=\"http:\/\/askmonty.org\/wiki\/index.php\/Download\" target=\"_blank\" rel=\"noopener noreferrer\">askmonty.org Downloads<\/a>.<\/p>\n<p>MariaDB is community developed, in collaboration with Monty Program<\/p>\n<p>Start checking it out now peeps, it is coming and you better learn about it now.<\/p>\n<p>From <a href=\"http:\/\/askmonty.org\/wiki\/index.php\/Main_Page\" target=\"blank\" rel=\"noopener noreferrer\"> http:\/\/askmonty.org\/wiki\/index.php\/Main_Page<\/a><\/p>\n<h2>About MariaDB<\/h2>\n<p><a title=\"MariaDB\" href=\"http:\/\/askmonty.org\/wiki\/index.php\/MariaDB\" target=\"_blank\" rel=\"noopener noreferrer\">MariaDB<\/a> 5.1 is based on <a title=\"http:\/\/mysql.com\" rel=\"nofollow noopener noreferrer\" href=\"http:\/\/mysql.com\/\" target=\"_blank\">MySQL<\/a> 5.1 and is <a title=\"MariaDB:Download\" href=\"http:\/\/askmonty.org\/wiki\/index.php\/MariaDB:Download\" target=\"_blank\" rel=\"noopener noreferrer\">available<\/a> under the terms of the <a title=\"MariaDB License\" href=\"http:\/\/askmonty.org\/wiki\/index.php\/MariaDB_License\" target=\"_blank\" rel=\"noopener noreferrer\">GPL v2 license<\/a>.<\/p>\n<p>MariaDB will be kept up to date with the latest MySQL release from the same branch.<\/p>\n<p>In <a href=\"http:\/\/askmonty.org\/wiki\/index.php\/MariaDB_versus_MySQL#Incompatibilities_between_MariaDB_5.1_and_MySQL_5.1\" target=\"_blank\" rel=\"noopener noreferrer\">most respects<\/a> MariaDB will work exactly as MySQL: all commands, interfaces, libraries and APIs that exist in MySQL also exist in MariaDB.<\/p>\n<p>Currently the main differences between MariaDB 5.1 and MySQL 5.1 are:<\/p>\n<ul>\n<li> <a href=\"http:\/\/askmonty.org\/wiki\/index.php\/MariaDB_versus_MySQL#Maria_storage_engine_is_included\" target=\"_blank\" rel=\"noopener noreferrer\">Maria storage engine is included<\/a><\/li>\n<li> <a href=\"http:\/\/askmonty.org\/wiki\/index.php\/MariaDB_versus_MySQL#PBXT_storage_engine_is_included\" target=\"_blank\" rel=\"noopener noreferrer\">PBXT storage engine is included<\/a><\/li>\n<li> <a href=\"http:\/\/askmonty.org\/wiki\/index.php\/MariaDB_versus_MySQL#XtraDB_storage_engine_is_included\" target=\"_blank\" rel=\"noopener noreferrer\">XtraDB storage engine is included<\/a><\/li>\n<li> <a href=\"http:\/\/askmonty.org\/wiki\/index.php\/MariaDB_versus_MySQL#FederatedX_storage_engine_is_included\" target=\"_blank\" rel=\"noopener noreferrer\">FederatedX storage engine is included<\/a><\/li>\n<li> <a href=\"http:\/\/askmonty.org\/wiki\/index.php\/MariaDB_versus_MySQL#Faster_complex_queries\" target=\"_blank\" rel=\"noopener noreferrer\">Faster complex queries<\/a><\/li>\n<li> <a href=\"http:\/\/askmonty.org\/wiki\/index.php\/MariaDB_versus_MySQL#Pool_of_Threads\" target=\"_blank\" rel=\"noopener noreferrer\">Pool of Threads<\/a><\/li>\n<li> <a href=\"http:\/\/askmonty.org\/wiki\/index.php\/MariaDB_versus_MySQL#Fewer_warnings_and_bugs\" target=\"_blank\" rel=\"noopener noreferrer\">Fewer warnings and bugs<\/a><\/li>\n<li> <a href=\"http:\/\/askmonty.org\/wiki\/index.php\/MariaDB_versus_MySQL#Speed_improvements\" target=\"_blank\" rel=\"noopener noreferrer\">Speed improvements<\/a><\/li>\n<li> <a href=\"http:\/\/askmonty.org\/wiki\/index.php\/MariaDB_versus_MySQL#Extensions\" target=\"_blank\" rel=\"noopener noreferrer\">Extensions (More index parts, new startup options etc)<\/a><\/li>\n<li> <a href=\"http:\/\/askmonty.org\/wiki\/index.php\/MariaDB_versus_MySQL#Better_testing_of_features\" target=\"_blank\" rel=\"noopener noreferrer\">Better testing of features<\/a><\/li>\n<li> <a href=\"http:\/\/askmonty.org\/wiki\/index.php\/MariaDB_versus_MySQL#Table_elimination\" target=\"_blank\" rel=\"noopener noreferrer\">Table elimination<\/a><\/li>\n<li> <a href=\"http:\/\/askmonty.org\/wiki\/index.php\/MariaDB_versus_MySQL#Slow_Query_Log_Extended_Statistics\" target=\"_blank\" rel=\"noopener noreferrer\">Slow Query Log Extended Statistics<\/a><\/li>\n<li> User profiling (SHOW PROFILE) is compiled in by default.<\/li>\n<\/ul>\n<p>In <a title=\"MariaDB52\" href=\"http:\/\/askmonty.org\/wiki\/index.php\/MariaDB52\" target=\"_blank\" rel=\"noopener noreferrer\">MariaDB 5.2<\/a>, the new features are:<\/p>\n<ul>\n<li> Group commit for the Maria storage engine. (faster)<\/li>\n<li> <a title=\"http:\/\/www.percona.com\/docs\/wiki\/patches:userstatv2\" rel=\"nofollow noopener noreferrer\" href=\"http:\/\/www.percona.com\/docs\/wiki\/patches:userstatv2\" target=\"_blank\">userstatv2&#8242;<\/a>, which creates several new information_schema tables with useful statistics information. You enable the statistics by setting the &#8216;userstat&#8217; variable.<\/li>\n<\/ul>\n<p>(for a definite and up-to-date list of features in 5.2, see <a title=\"MariaDB52\" href=\"http:\/\/askmonty.org\/wiki\/index.php\/MariaDB52\" target=\"_blank\" rel=\"noopener noreferrer\">MariaDB 5.2<\/a> page).<\/p>\n<p><a href=\"http:\/\/askmonty.org\/\" target=\"_blank\" rel=\"noopener noreferrer\">Askmonty.org<\/a> has recently released MariaDB 5.1.41 RC for download and testing. You can <a href=\"http:\/\/askmonty.org\/wiki\/index.php\/MariaDB:Download\" target=\"_blank\" rel=\"noopener noreferrer\">download it here<\/a>. It should be a drop in replacement for any recent MySQL 5.1 release.<\/p>\n<p>As a final note, Oracle has made 10 promises regarding it&#8217;s commitment to Sun&#8217;s product line and is outlined <a href=\"http:\/\/www.marketwire.com\/press-release\/oracle-makes-commitments-to-customers-developers-and-users-of-mysql-nasdaq-orcl-1180402.htm\" target=\"_blank\" rel=\"noopener noreferrer\">here<\/a>. Of course it should be noted that those promises were followed by a disclaimer called the <strong>&#8220;Cautionary Statement Regarding Forward-Looking Statement&#8221;<br \/>\n<\/strong> which makes quite clear that the document is in no way legally binding. <\/p>\n<p>He that hath an ear, let him hear&#8230;<\/p>\n","protected":false},"excerpt":{"rendered":"<p>MySQL is dead. Long live MySQL. Now that oracle owns MySQL, it will certainly kill it as quickly and quietly as possible. If you were a large corporation, why would you want to have a stable, open source, widely used software platform competing with your fee related software that is generating a profit from the&#8230; <\/p>\n<div class=\"read-more navbutton\"><a href=\"https:\/\/g33kinfo.com\/info\/mariadb-vs-mysql\/\">Read More<i class=\"fa fa-angle-double-right\"><\/i><\/a><\/div>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[9],"tags":[],"class_list":["post-2274","post","type-post","status-publish","format-standard","hentry","category-info"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v27.8 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\n<title>MariaDB vs. MySQL - Linux Shtuff<\/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:\/\/g33kinfo.com\/info\/mariadb-vs-mysql\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"MariaDB vs. MySQL - Linux Shtuff\" \/>\n<meta property=\"og:description\" content=\"MySQL is dead. Long live MySQL. Now that oracle owns MySQL, it will certainly kill it as quickly and quietly as possible. If you were a large corporation, why would you want to have a stable, open source, widely used software platform competing with your fee related software that is generating a profit from the... Read More\" \/>\n<meta property=\"og:url\" content=\"https:\/\/g33kinfo.com\/info\/mariadb-vs-mysql\/\" \/>\n<meta property=\"og:site_name\" content=\"Linux Shtuff\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/fb.me\/g33kinf0\" \/>\n<meta property=\"article:author\" content=\"https:\/\/fb.me\/g33kinf0\" \/>\n<meta property=\"article:published_time\" content=\"2010-01-31T14:13:06+00:00\" \/>\n<meta name=\"author\" content=\"g33kadmin\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:creator\" content=\"@https:\/\/twitter.com\/drsinger1111\" \/>\n<meta name=\"twitter:site\" content=\"@drsinger1111\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\\\/\\\/g33kinfo.com\\\/info\\\/mariadb-vs-mysql\\\/#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/g33kinfo.com\\\/info\\\/mariadb-vs-mysql\\\/\"},\"author\":{\"name\":\"g33kadmin\",\"@id\":\"https:\\\/\\\/g33kinfo.com\\\/info\\\/#\\\/schema\\\/person\\\/c022e4c40b13ea1b678e6f020756f547\"},\"headline\":\"MariaDB vs. MySQL\",\"datePublished\":\"2010-01-31T14:13:06+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/g33kinfo.com\\\/info\\\/mariadb-vs-mysql\\\/\"},\"wordCount\":442,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\\\/\\\/g33kinfo.com\\\/info\\\/#\\\/schema\\\/person\\\/c022e4c40b13ea1b678e6f020756f547\"},\"articleSection\":[\"General Info\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\\\/\\\/g33kinfo.com\\\/info\\\/mariadb-vs-mysql\\\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/g33kinfo.com\\\/info\\\/mariadb-vs-mysql\\\/\",\"url\":\"https:\\\/\\\/g33kinfo.com\\\/info\\\/mariadb-vs-mysql\\\/\",\"name\":\"MariaDB vs. MySQL - Linux Shtuff\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/g33kinfo.com\\\/info\\\/#website\"},\"datePublished\":\"2010-01-31T14:13:06+00:00\",\"breadcrumb\":{\"@id\":\"https:\\\/\\\/g33kinfo.com\\\/info\\\/mariadb-vs-mysql\\\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/g33kinfo.com\\\/info\\\/mariadb-vs-mysql\\\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/g33kinfo.com\\\/info\\\/mariadb-vs-mysql\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\\\/\\\/g33kinfo.com\\\/info\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"MariaDB vs. MySQL\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/g33kinfo.com\\\/info\\\/#website\",\"url\":\"https:\\\/\\\/g33kinfo.com\\\/info\\\/\",\"name\":\"Linux Shtuff\",\"description\":\"Because I have CRS Syndrome...\",\"publisher\":{\"@id\":\"https:\\\/\\\/g33kinfo.com\\\/info\\\/#\\\/schema\\\/person\\\/c022e4c40b13ea1b678e6f020756f547\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\\\/\\\/g33kinfo.com\\\/info\\\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":[\"Person\",\"Organization\"],\"@id\":\"https:\\\/\\\/g33kinfo.com\\\/info\\\/#\\\/schema\\\/person\\\/c022e4c40b13ea1b678e6f020756f547\",\"name\":\"g33kadmin\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/g33kinfo.com\\\/info\\\/wp-content\\\/uploads\\\/2022\\\/07\\\/minion-researchA.gif\",\"url\":\"https:\\\/\\\/g33kinfo.com\\\/info\\\/wp-content\\\/uploads\\\/2022\\\/07\\\/minion-researchA.gif\",\"contentUrl\":\"https:\\\/\\\/g33kinfo.com\\\/info\\\/wp-content\\\/uploads\\\/2022\\\/07\\\/minion-researchA.gif\",\"width\":512,\"height\":512,\"caption\":\"g33kadmin\"},\"logo\":{\"@id\":\"https:\\\/\\\/g33kinfo.com\\\/info\\\/wp-content\\\/uploads\\\/2022\\\/07\\\/minion-researchA.gif\"},\"description\":\"I am a g33k, Linux blogger, developer, student and Tech Writer for Liquidweb.com\\\/kb. My passion for all things tech drives my hunt for all the coolz. I often need a vacation after I get back from vacation....\",\"sameAs\":[\"https:\\\/\\\/thelinuxreport.com\",\"https:\\\/\\\/fb.me\\\/g33kinf0\",\"https:\\\/\\\/x.com\\\/https:\\\/\\\/twitter.com\\\/drsinger1111\"]}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"MariaDB vs. MySQL - Linux Shtuff","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:\/\/g33kinfo.com\/info\/mariadb-vs-mysql\/","og_locale":"en_US","og_type":"article","og_title":"MariaDB vs. MySQL - Linux Shtuff","og_description":"MySQL is dead. Long live MySQL. Now that oracle owns MySQL, it will certainly kill it as quickly and quietly as possible. If you were a large corporation, why would you want to have a stable, open source, widely used software platform competing with your fee related software that is generating a profit from the... Read More","og_url":"https:\/\/g33kinfo.com\/info\/mariadb-vs-mysql\/","og_site_name":"Linux Shtuff","article_publisher":"https:\/\/fb.me\/g33kinf0","article_author":"https:\/\/fb.me\/g33kinf0","article_published_time":"2010-01-31T14:13:06+00:00","author":"g33kadmin","twitter_card":"summary_large_image","twitter_creator":"@https:\/\/twitter.com\/drsinger1111","twitter_site":"@drsinger1111","schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/g33kinfo.com\/info\/mariadb-vs-mysql\/#article","isPartOf":{"@id":"https:\/\/g33kinfo.com\/info\/mariadb-vs-mysql\/"},"author":{"name":"g33kadmin","@id":"https:\/\/g33kinfo.com\/info\/#\/schema\/person\/c022e4c40b13ea1b678e6f020756f547"},"headline":"MariaDB vs. MySQL","datePublished":"2010-01-31T14:13:06+00:00","mainEntityOfPage":{"@id":"https:\/\/g33kinfo.com\/info\/mariadb-vs-mysql\/"},"wordCount":442,"commentCount":0,"publisher":{"@id":"https:\/\/g33kinfo.com\/info\/#\/schema\/person\/c022e4c40b13ea1b678e6f020756f547"},"articleSection":["General Info"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/g33kinfo.com\/info\/mariadb-vs-mysql\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/g33kinfo.com\/info\/mariadb-vs-mysql\/","url":"https:\/\/g33kinfo.com\/info\/mariadb-vs-mysql\/","name":"MariaDB vs. MySQL - Linux Shtuff","isPartOf":{"@id":"https:\/\/g33kinfo.com\/info\/#website"},"datePublished":"2010-01-31T14:13:06+00:00","breadcrumb":{"@id":"https:\/\/g33kinfo.com\/info\/mariadb-vs-mysql\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/g33kinfo.com\/info\/mariadb-vs-mysql\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/g33kinfo.com\/info\/mariadb-vs-mysql\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/g33kinfo.com\/info\/"},{"@type":"ListItem","position":2,"name":"MariaDB vs. MySQL"}]},{"@type":"WebSite","@id":"https:\/\/g33kinfo.com\/info\/#website","url":"https:\/\/g33kinfo.com\/info\/","name":"Linux Shtuff","description":"Because I have CRS Syndrome...","publisher":{"@id":"https:\/\/g33kinfo.com\/info\/#\/schema\/person\/c022e4c40b13ea1b678e6f020756f547"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/g33kinfo.com\/info\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":["Person","Organization"],"@id":"https:\/\/g33kinfo.com\/info\/#\/schema\/person\/c022e4c40b13ea1b678e6f020756f547","name":"g33kadmin","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/g33kinfo.com\/info\/wp-content\/uploads\/2022\/07\/minion-researchA.gif","url":"https:\/\/g33kinfo.com\/info\/wp-content\/uploads\/2022\/07\/minion-researchA.gif","contentUrl":"https:\/\/g33kinfo.com\/info\/wp-content\/uploads\/2022\/07\/minion-researchA.gif","width":512,"height":512,"caption":"g33kadmin"},"logo":{"@id":"https:\/\/g33kinfo.com\/info\/wp-content\/uploads\/2022\/07\/minion-researchA.gif"},"description":"I am a g33k, Linux blogger, developer, student and Tech Writer for Liquidweb.com\/kb. My passion for all things tech drives my hunt for all the coolz. I often need a vacation after I get back from vacation....","sameAs":["https:\/\/thelinuxreport.com","https:\/\/fb.me\/g33kinf0","https:\/\/x.com\/https:\/\/twitter.com\/drsinger1111"]}]}},"_links":{"self":[{"href":"https:\/\/g33kinfo.com\/info\/wp-json\/wp\/v2\/posts\/2274","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/g33kinfo.com\/info\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/g33kinfo.com\/info\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/g33kinfo.com\/info\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/g33kinfo.com\/info\/wp-json\/wp\/v2\/comments?post=2274"}],"version-history":[{"count":0,"href":"https:\/\/g33kinfo.com\/info\/wp-json\/wp\/v2\/posts\/2274\/revisions"}],"wp:attachment":[{"href":"https:\/\/g33kinfo.com\/info\/wp-json\/wp\/v2\/media?parent=2274"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/g33kinfo.com\/info\/wp-json\/wp\/v2\/categories?post=2274"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/g33kinfo.com\/info\/wp-json\/wp\/v2\/tags?post=2274"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}