{"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":"http:\/\/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<div class=\"sharedaddy sd-sharing-enabled\"><div class=\"robots-nocontent sd-block sd-social sd-social-icon-text sd-sharing\"><h3 class=\"sd-title\">Share this:<\/h3><div class=\"sd-content\"><ul><li class=\"share-email\"><a rel=\"nofollow noopener noreferrer\" data-shared=\"\" class=\"share-email sd-button share-icon\" href=\"mailto:?subject=%5BShared%20Post%5D%20The%20SkySQL%20Reference%20Architecture&body=http%3A%2F%2Fwww.bytebot.net%2Fblog%2Farchives%2F2011%2F05%2F26%2Fthe-skysql-reference-architecture&share=email\" target=\"_blank\" title=\"Click to email a link to a friend\" data-email-share-error-title=\"Do you have email set up?\" data-email-share-error-text=\"If you&#039;re having problems sharing via email, you might not have email set up for your browser. You may need to create a new email yourself.\" data-email-share-nonce=\"abcd5bf185\" data-email-share-track-url=\"http:\/\/www.bytebot.net\/blog\/archives\/2011\/05\/26\/the-skysql-reference-architecture?share=email\"><span>Email<\/span><\/a><\/li><li class=\"share-facebook\"><a rel=\"nofollow noopener noreferrer\" data-shared=\"sharing-facebook-2143\" class=\"share-facebook sd-button share-icon\" href=\"http:\/\/www.bytebot.net\/blog\/archives\/2011\/05\/26\/the-skysql-reference-architecture?share=facebook\" target=\"_blank\" title=\"Click to share on Facebook\" ><span>Facebook<\/span><\/a><\/li><li class=\"share-linkedin\"><a rel=\"nofollow noopener noreferrer\" data-shared=\"sharing-linkedin-2143\" class=\"share-linkedin sd-button share-icon\" href=\"http:\/\/www.bytebot.net\/blog\/archives\/2011\/05\/26\/the-skysql-reference-architecture?share=linkedin\" target=\"_blank\" title=\"Click to share on LinkedIn\" ><span>LinkedIn<\/span><\/a><\/li><li class=\"share-twitter\"><a rel=\"nofollow noopener noreferrer\" data-shared=\"sharing-twitter-2143\" class=\"share-twitter sd-button share-icon\" href=\"http:\/\/www.bytebot.net\/blog\/archives\/2011\/05\/26\/the-skysql-reference-architecture?share=twitter\" target=\"_blank\" title=\"Click to share on Twitter\" ><span>Twitter<\/span><\/a><\/li><li class=\"share-end\"><\/li><\/ul><\/div><\/div><\/div>","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<div class=\"sharedaddy sd-sharing-enabled\"><div class=\"robots-nocontent sd-block sd-social sd-social-icon-text sd-sharing\"><h3 class=\"sd-title\">Share this:<\/h3><div class=\"sd-content\"><ul><li class=\"share-email\"><a rel=\"nofollow noopener noreferrer\" data-shared=\"\" class=\"share-email sd-button share-icon\" href=\"mailto:?subject=%5BShared%20Post%5D%20The%20SkySQL%20Reference%20Architecture&body=http%3A%2F%2Fwww.bytebot.net%2Fblog%2Farchives%2F2011%2F05%2F26%2Fthe-skysql-reference-architecture&share=email\" target=\"_blank\" title=\"Click to email a link to a friend\" data-email-share-error-title=\"Do you have email set up?\" data-email-share-error-text=\"If you&#039;re having problems sharing via email, you might not have email set up for your browser. You may need to create a new email yourself.\" data-email-share-nonce=\"abcd5bf185\" data-email-share-track-url=\"http:\/\/www.bytebot.net\/blog\/archives\/2011\/05\/26\/the-skysql-reference-architecture?share=email\"><span>Email<\/span><\/a><\/li><li class=\"share-facebook\"><a rel=\"nofollow noopener noreferrer\" data-shared=\"sharing-facebook-2143\" class=\"share-facebook sd-button share-icon\" href=\"http:\/\/www.bytebot.net\/blog\/archives\/2011\/05\/26\/the-skysql-reference-architecture?share=facebook\" target=\"_blank\" title=\"Click to share on Facebook\" ><span>Facebook<\/span><\/a><\/li><li class=\"share-linkedin\"><a rel=\"nofollow noopener noreferrer\" data-shared=\"sharing-linkedin-2143\" class=\"share-linkedin sd-button share-icon\" href=\"http:\/\/www.bytebot.net\/blog\/archives\/2011\/05\/26\/the-skysql-reference-architecture?share=linkedin\" target=\"_blank\" title=\"Click to share on LinkedIn\" ><span>LinkedIn<\/span><\/a><\/li><li class=\"share-twitter\"><a rel=\"nofollow noopener noreferrer\" data-shared=\"sharing-twitter-2143\" class=\"share-twitter sd-button share-icon\" href=\"http:\/\/www.bytebot.net\/blog\/archives\/2011\/05\/26\/the-skysql-reference-architecture?share=twitter\" target=\"_blank\" title=\"Click to share on Twitter\" ><span>Twitter<\/span><\/a><\/li><li class=\"share-end\"><\/li><\/ul><\/div><\/div><\/div>","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"jetpack_post_was_ever_published":false,"jetpack_publicize_message":"","jetpack_is_tweetstorm":false,"jetpack_publicize_feature_enabled":true,"jetpack_social_options":[]},"categories":[1064,23],"tags":[1052,1775,1253,1230,621,988,1264],"jetpack_publicize_connections":[],"jetpack_featured_media_url":"","jetpack_shortlink":"https:\/\/wp.me\/p4vJD-yz","jetpack_sharing_enabled":true,"jetpack-related-posts":[{"id":2640,"url":"http:\/\/www.bytebot.net\/blog\/archives\/2013\/01\/26\/skysql-solutions-day-fosdem-mysql-activity","url_meta":{"origin":2143,"position":0},"title":"SkySQL Solutions Day, FOSDEM MySQL activity","date":"26\/1\/2013","format":false,"excerpt":"February is turning out to be a busy month. I'll be giving a talk about MariaDB at the SkySQL Solutions Day in Hamburg, alongside Sergei Golubchik. This happens February 1 2013. I'll also be in Brussels for FOSDEM and presenting at the MySQL & Friends devroom. Here I will talk\u2026","rel":"","context":"In &quot;MariaDB&quot;","img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":2693,"url":"http:\/\/www.bytebot.net\/blog\/archives\/2013\/04\/12\/upcoming-talks-in-santa-clara","url_meta":{"origin":2143,"position":1},"title":"Upcoming talks in Santa Clara","date":"12\/4\/2013","format":false,"excerpt":"I'm planning my calendar and thought I'd share what talks I'd be giving in Santa Clara in a couple of weeks for the Percona Live MySQL Conference & Expo 2013 and the\u00a0MySQL & Cloud Database Solutions Day 2013. Its going to be a busy April 22-26 2013. MariaDB Cassandra Interoperability\u2026","rel":"","context":"In &quot;MariaDB&quot;","img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":2853,"url":"http:\/\/www.bytebot.net\/blog\/archives\/2014\/01\/20\/fosdem-mysql-friends-devroom-signup-for-dinner","url_meta":{"origin":2143,"position":2},"title":"FOSDEM MySQL &#038; Friends Devroom &#8211; signup for dinner","date":"20\/1\/2014","format":false,"excerpt":"FOSDEM happens this year, February 1&2 2014. This year is a special year as it is the 10th anniversary: great content in the schedule, you must\u00a0pre-register for dinner\u00a0(lot's of wonderful Belgian food & drink), and we have a shared booth in the expo hall. Read more about the event with\u2026","rel":"","context":"In &quot;MariaDB&quot;","img":{"alt_text":"","src":"https:\/\/i0.wp.com\/farm8.staticflickr.com\/7022\/6812308649_91ae4bde46_n.jpg?resize=350%2C200","width":350,"height":200},"classes":[]},{"id":2242,"url":"http:\/\/www.bytebot.net\/blog\/archives\/2012\/01\/30\/mariadbmysql-users-in-paris-brussels","url_meta":{"origin":2143,"position":3},"title":"MariaDB\/MySQL users in Paris &#038; Brussels","date":"30\/1\/2012","format":false,"excerpt":"I'm about to head to Paris to present at the February meetup of the MySQL User Group in Paris, France. It happens 1st February from 6-8pm at the Patricks Irish Pub. Its free to attend, and I understand that SkySQL keeps this event afloat. I'm also heading to my first\u2026","rel":"","context":"In &quot;MariaDB&quot;","img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":2922,"url":"http:\/\/www.bytebot.net\/blog\/archives\/2014\/05\/02\/mysql-related-irc-discussion-channels","url_meta":{"origin":2143,"position":4},"title":"MySQL related IRC discussion channels","date":"2\/5\/2014","format":false,"excerpt":"There are many MySQL related IRC discussion channels as the ecosystem itself grows. I join the following. Are there any that I\u2019m missing? Freenode (irc.freenode.net): #mysql - main channel for all kinds of end user MySQL related discussions (the noisiest of the lot, naturally) #maria - main channel for all\u2026","rel":"","context":"In &quot;MariaDB&quot;","img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":2814,"url":"http:\/\/www.bytebot.net\/blog\/archives\/2013\/10\/15\/mariadb-now-in-the-aws-marketplace","url_meta":{"origin":2143,"position":5},"title":"MariaDB now in the AWS Marketplace","date":"15\/10\/2013","format":false,"excerpt":"Saw this on @awsmarketplace the other day: #opensource #MariaDB by @SkySQL on @AWSMarketplace http:\/\/t.co\/o3KQ9xe9sr #mysql\u2014 AWS Marketplace (@awsmarketplace) October 8, 2013 Now on the AWS Marketplace, you can get MariaDB 5.5.32 on Ubuntu 12.04, CentOS 6 and Debian Wheezy. These are eligible for the Amazon free tier as well. Would\u2026","rel":"","context":"In &quot;MariaDB&quot;","img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]}],"amp_enabled":true,"_links":{"self":[{"href":"http:\/\/www.bytebot.net\/blog\/wp-json\/wp\/v2\/posts\/2143"}],"collection":[{"href":"http:\/\/www.bytebot.net\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/www.bytebot.net\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/www.bytebot.net\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"http:\/\/www.bytebot.net\/blog\/wp-json\/wp\/v2\/comments?post=2143"}],"version-history":[{"count":5,"href":"http:\/\/www.bytebot.net\/blog\/wp-json\/wp\/v2\/posts\/2143\/revisions"}],"predecessor-version":[{"id":2148,"href":"http:\/\/www.bytebot.net\/blog\/wp-json\/wp\/v2\/posts\/2143\/revisions\/2148"}],"wp:attachment":[{"href":"http:\/\/www.bytebot.net\/blog\/wp-json\/wp\/v2\/media?parent=2143"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/www.bytebot.net\/blog\/wp-json\/wp\/v2\/categories?post=2143"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/www.bytebot.net\/blog\/wp-json\/wp\/v2\/tags?post=2143"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}