{"id":4044,"date":"2016-04-29T14:34:05","date_gmt":"2016-04-29T04:34:05","guid":{"rendered":"https:\/\/www.flamingspork.com\/blog\/?p=4044"},"modified":"2016-04-29T14:50:16","modified_gmt":"2016-04-29T04:50:16","slug":"toy-database-on-mainframes","status":"publish","type":"post","link":"https:\/\/www.flamingspork.com\/blog\/2016\/04\/29\/toy-database-on-mainframes\/","title":{"rendered":"&#8220;Toy&#8221; database on mainframes"},"content":{"rendered":"<p>While much less common than 10 or 15 (err&#8230; even 20) years ago, you still sometimes hear MySQL being called a &#8220;toy&#8221; database. The good news is, when somebody says that, they&#8217;re admitting ignorance and you can help educate them!<\/p>\n<p>Recently, a fellow IBMer submitted a <a href=\"https:\/\/github.com\/mysql\/mysql-server\/pull\/58\">pull request<\/a> (and <a href=\"https:\/\/bugs.mysql.com\/bug.php?id=80907\">bug<\/a>) to start having MySQL support on Z Series (s390x).<\/p>\n<p>Generally speaking, when there&#8217;s effort being spent on getting something to run on Z, it is in no way considered a toy by those who&#8217;ll end up using it.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>While much less common than 10 or 15 (err&#8230; even 20) years ago, you still sometimes hear MySQL being called a &#8220;toy&#8221; database. The good news is, when somebody says that, they&#8217;re admitting ignorance and you can help educate them! &hellip; <a href=\"https:\/\/www.flamingspork.com\/blog\/2016\/04\/29\/toy-database-on-mainframes\/\">Continue reading <span class=\"meta-nav\">&rarr;<\/span><\/a><\/p>\n","protected":false},"author":2,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"jetpack_post_was_ever_published":false,"_jetpack_newsletter_access":"","_jetpack_dont_email_post_to_subs":false,"_jetpack_newsletter_tier_id":0,"_jetpack_memberships_contains_paywalled_content":false,"_jetpack_memberships_contains_paid_content":false,"footnotes":"","jetpack_publicize_message":"","jetpack_publicize_feature_enabled":true,"jetpack_social_post_already_shared":true,"jetpack_social_options":{"image_generator_settings":{"template":"highway","default_image_id":0,"font":"","enabled":false},"version":2}},"categories":[570,14],"tags":[628,652,653],"class_list":["post-4044","post","type-post","status-publish","format-standard","hentry","category-ibm-work-et-al","category-mysql","tag-mysql","tag-s390x","tag-z"],"jetpack_publicize_connections":[],"jetpack_featured_media_url":"","jetpack_sharing_enabled":true,"jetpack_shortlink":"https:\/\/wp.me\/p5a6n8-13e","jetpack-related-posts":[{"id":2398,"url":"https:\/\/www.flamingspork.com\/blog\/2011\/09\/16\/mysql-no-longer-fully-open-source-database\/","url_meta":{"origin":4044,"position":0},"title":"MySQL no longer fully open source database","author":"Stewart Smith","date":"2011-09-16","format":false,"excerpt":"Just in case anybody missed it:\u00c2\u00a0http:\/\/blogs.oracle.com\/MySQL\/entry\/new_commercial_extensions_for_mysql MySQL has long been an open source product, not an open source project.... and this really is the final nail in that. To me, this was expected, but it's still sad to see it. I am very, very glad we have diverse copyright ownership\u2026","rel":"","context":"In &quot;mysql&quot;","block_context":{"text":"mysql","link":"https:\/\/www.flamingspork.com\/blog\/category\/work-et-al\/mysql\/"},"img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":913,"url":"https:\/\/www.flamingspork.com\/blog\/2007\/11\/08\/speaking-at-vitta-victorian-it-teachers-association-inc-conference\/","url_meta":{"origin":4044,"position":1},"title":"Speaking at VITTA (Victorian IT Teachers Association Inc) Conference","author":"Stewart Smith","date":"2007-11-08","format":false,"excerpt":"I'm speaking at the upcoming VITTA conference. Title:MySQL database administration for non DBAs Abstract: MySQL is incredibly ubiquitous. MySQL database administrators are not everywhere; MySQL is. Often MySQL is run to power a small web site or two, an application or two, or run on a machine purely for someone\u2026","rel":"","context":"In &quot;mysql&quot;","block_context":{"text":"mysql","link":"https:\/\/www.flamingspork.com\/blog\/category\/work-et-al\/mysql\/"},"img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":3237,"url":"https:\/\/www.flamingspork.com\/blog\/2013\/03\/08\/mysql-modularity-are-we-there-yet\/","url_meta":{"origin":4044,"position":2},"title":"MySQL modularity, are we there yet?","author":"Stewart Smith","date":"2013-03-08","format":false,"excerpt":"MySQL is now over four times the size than it was with MySQL 3.23. This has not come in the shape of plugins. Have we improved modularity over time? I decided to take LoC count for plugins and storage engines (in the case of Drizzle, memory, myisam and innobase are\u2026","rel":"","context":"In &quot;code&quot;","block_context":{"text":"code","link":"https:\/\/www.flamingspork.com\/blog\/category\/code\/"},"img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":2335,"url":"https:\/\/www.flamingspork.com\/blog\/2011\/03\/21\/the-problems-with-multi-tenant-mysql\/","url_meta":{"origin":4044,"position":3},"title":"The problems with multi-tenant MySQL","author":"Stewart Smith","date":"2011-03-21","format":false,"excerpt":"Just about every web host in the world gives people \"mysql databases\". Usually one. Why? because that's how permissions work in MySQL and it's a relatively simple way to set it up (each of your web host clients is a user with access to their one database). This has a\u2026","rel":"","context":"In &quot;mysql&quot;","block_context":{"text":"mysql","link":"https:\/\/www.flamingspork.com\/blog\/category\/work-et-al\/mysql\/"},"img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":3674,"url":"https:\/\/www.flamingspork.com\/blog\/2014\/02\/06\/ghosts-of-mysql-past-part-4-a-million-features-for-enterprise\/","url_meta":{"origin":4044,"position":4},"title":"Ghosts of MySQL Past: Part 4, A million features for Enterprise","author":"Stewart Smith","date":"2014-02-06","format":false,"excerpt":"Continuing on from Part 3.... SAP is all about Enterprises and as such, used all the Enterprise features of databases. This is a much different application than every user of MySQL so far (which were often web applications, and increasingly being used at scale). This was \"MySQL focuses on Enterprise\".\u2026","rel":"","context":"In &quot;mysql&quot;","block_context":{"text":"mysql","link":"https:\/\/www.flamingspork.com\/blog\/category\/work-et-al\/mysql\/"},"img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":3697,"url":"https:\/\/www.flamingspork.com\/blog\/2014\/03\/11\/ghosts-of-mysql-past-part-8-the-first-fork\/","url_meta":{"origin":4044,"position":5},"title":"Ghosts of MySQL Past, Part 8: The First Fork.","author":"Stewart Smith","date":"2014-03-11","format":false,"excerpt":"This is the 8th installment in the rather long series that started with Part 1 about a month ago. Back in 2006, we were in the situation where MySQL 5.0 had taken forever, and the first \"GA\" release was not suitable for production. Looking towards MySQL 5.1, it was also\u2026","rel":"","context":"In &quot;mysql&quot;","block_context":{"text":"mysql","link":"https:\/\/www.flamingspork.com\/blog\/category\/work-et-al\/mysql\/"},"img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]}],"jetpack_likes_enabled":true,"_links":{"self":[{"href":"https:\/\/www.flamingspork.com\/blog\/wp-json\/wp\/v2\/posts\/4044","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.flamingspork.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.flamingspork.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.flamingspork.com\/blog\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/www.flamingspork.com\/blog\/wp-json\/wp\/v2\/comments?post=4044"}],"version-history":[{"count":2,"href":"https:\/\/www.flamingspork.com\/blog\/wp-json\/wp\/v2\/posts\/4044\/revisions"}],"predecessor-version":[{"id":4047,"href":"https:\/\/www.flamingspork.com\/blog\/wp-json\/wp\/v2\/posts\/4044\/revisions\/4047"}],"wp:attachment":[{"href":"https:\/\/www.flamingspork.com\/blog\/wp-json\/wp\/v2\/media?parent=4044"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.flamingspork.com\/blog\/wp-json\/wp\/v2\/categories?post=4044"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.flamingspork.com\/blog\/wp-json\/wp\/v2\/tags?post=4044"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}