{"id":2143,"date":"2011-05-26T21:49:13","date_gmt":"2011-05-27T02:49:13","guid":{"rendered":"http:\/\/www.bytebot.net\/blog\/?p=2143"},"modified":"2011-05-26T21:59:55","modified_gmt":"2011-05-27T02:59:55","slug":"the-skysql-reference-architecture","status":"publish","type":"post","link":"https:\/\/www.bytebot.net\/blog\/archives\/2011\/05\/26\/the-skysql-reference-architecture","title":{"rendered":"The SkySQL Reference Architecture"},"content":{"rendered":"<p>I have a bunch of notes from the <a href=\"http:\/\/en.oreilly.com\/mysql2011\">O&#8217;Reilly MySQL Conference &amp; Expo 2011<\/a>, and I figure its about time I started blogging it. These are notes from the panel on the <a href=\"http:\/\/www.skysql.com\/en\/products\/reference-architecture\">SkySQL Reference Architecture<\/a>, led by Kaj Arno and Ivan Zoratti. The notes are raw (read their <a href=\"http:\/\/www.skysql.com\/en\/products\/reference-architecture\/RA-FAQ\">FAQ<\/a> for more), and I talk a little bit about the <a href=\"http:\/\/config.skysql.com\/\">SkySQL Configurator<\/a> at the end (a tool I immediately used, and submitted some bugs\/improvements for &#8211; 7 at last count, which I hear got fixed in the 0.02 release, which got pushed last night!).<\/p>\n<p>There were 7 panelists. The MySQL world needs:<\/p>\n<div style=\"font-family: Arial;\">\n<ul>\n<li>technical support<\/li>\n<li>monitoring &amp; administration tools<\/li>\n<li>simplified interfaces<\/li>\n<li>development &amp; user tools<\/li>\n<li>consulting &amp; training<\/li>\n<\/ul>\n<\/div>\n<div style=\"font-family: Arial;\">Services &amp; consulting generally are difficult to scale.<\/div>\n<div style=\"font-family: Arial;\">The most comprehensive architecture around MySQL, scalable, adaptable and cloud ready<\/div>\n<div style=\"font-family: Arial;\">Implementation:<\/div>\n<div style=\"font-family: Arial;\">\n<ul>\n<li>select and test specific components<\/li>\n<li>integrate components<\/li>\n<li>provision the components in a simple interface<\/li>\n<li>simplify monitoring &amp; administration<\/li>\n<li>technical services &amp; support<\/li>\n<li>validate solutions<\/li>\n<li>improvements and new releases can be done<\/li>\n<li>knowledge sharing related to the reference architecture<\/li>\n<\/ul>\n<\/div>\n<div style=\"font-family: Arial;\">Technologies selected from Webyog, Sphinx, Drizzle, Monty Program, Calpont, Tokutek, ScaleDB, Schooner, Linbit, Zimory, Canonical.<\/div>\n<p>SkySQL Provisioning tools:<\/p>\n<ul>\n<li>SkySQL Manager &#8211; control and administer the SkySQL\/MySQL environment<\/li>\n<li><a href=\"http:\/\/config.skysql.com\/\">SkySQL Configurator<\/a> &#8211; configure and update SkySQL reference architecture modules<\/li>\n<li>SkySQL Tuner &#8211; analyse the configuration and prepare the packages<\/li>\n<\/ul>\n<p>I did a test, and it seemed like I got binaries built in under 5 minutes. Custom configurations with a stock build.\u00a0You get a 70MB binary.\u00a0Hosted at http:\/\/www.enovance.com\/. A lot of people never configure their my.cnf, so I think having a GUI on the web might be a good idea to help people have sensible defaults.<\/p>\n<pre>lovegood:skysql byte$ ls\ntotal 143352\ndrwxr-xr-x    3 byte  staff       102 14 Apr 06:13 .\/\ndrwx------@ 598 byte  staff     20332 14 Apr 06:13 ..\/\n-rw-r--r--@   1 byte  staff  73395132 14 Apr 06:12 SkySQL-mariadb-poboffcfrm5bi054559q8iea74.tar.gz\n\nlovegood:skysql byte$ tar -zxvpf SkySQL-mariadb-poboffcfrm5bi054559q8iea74.tar.gz\nx etc\/\nx etc\/my.cnf\nx install\nx packages\/\nx packages\/xtrabackup-1.4-74.rhel5.x86_64.rpm\nx packages\/MySQL-client-5.5.10-1.rhel5.x86_64.rpm\nx packages\/MySQL-server-5.5.10-1.rhel5.x86_64.rpm\n<\/pre>\n<p>SkySQL is also going to have a customer advisory board, and they are starting it this week. <em>(I don&#8217;t know any further details about this as of yet.)<\/em><\/p>\n<p>The SkySQL Configurator can only get better. I expect it will do custom packages including things like Sphinx\/SphinxSE, Drizzle, and other things in due time.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>I have a bunch of notes from the O&#8217;Reilly MySQL Conference &amp; Expo 2011, and I figure its about time I started blogging it. These are notes from the panel on the SkySQL Reference Architecture, led by Kaj Arno and Ivan Zoratti. The notes are raw (read their FAQ for more), and I talk a [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_jetpack_newsletter_access":"","_jetpack_dont_email_post_to_subs":false,"_jetpack_newsletter_tier_id":0,"_jetpack_memberships_contains_paywalled_content":false,"_jetpack_feature_clip_id":0,"_jetpack_memberships_contains_paid_content":false,"footnotes":"","jetpack_publicize_message":"","jetpack_publicize_feature_enabled":true,"jetpack_social_post_already_shared":false,"jetpack_social_options":{"image_generator_settings":{"template":"highway","default_image_id":0,"font":"","enabled":false},"version":2},"jetpack_post_was_ever_published":false},"categories":[1064,23],"tags":[1052,1775,1253,1230,621,988,1264],"class_list":["post-2143","post","type-post","status-publish","format-standard","hentry","category-mariadb-databases","category-mysql","tag-mariadb","tag-mysql","tag-mysql-conference-expo-2011","tag-mysqlce2011","tag-mysqlconf","tag-planet-mysql","tag-skysql"],"jetpack_publicize_connections":[],"jetpack_shortlink":"https:\/\/wp.me\/p4vJD-yz","jetpack_sharing_enabled":true,"jetpack-related-posts":[],"jetpack_featured_media_url":"","_links":{"self":[{"href":"https:\/\/www.bytebot.net\/blog\/wp-json\/wp\/v2\/posts\/2143","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.bytebot.net\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.bytebot.net\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.bytebot.net\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.bytebot.net\/blog\/wp-json\/wp\/v2\/comments?post=2143"}],"version-history":[{"count":5,"href":"https:\/\/www.bytebot.net\/blog\/wp-json\/wp\/v2\/posts\/2143\/revisions"}],"predecessor-version":[{"id":2148,"href":"https:\/\/www.bytebot.net\/blog\/wp-json\/wp\/v2\/posts\/2143\/revisions\/2148"}],"wp:attachment":[{"href":"https:\/\/www.bytebot.net\/blog\/wp-json\/wp\/v2\/media?parent=2143"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.bytebot.net\/blog\/wp-json\/wp\/v2\/categories?post=2143"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.bytebot.net\/blog\/wp-json\/wp\/v2\/tags?post=2143"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}