{"id":5544,"date":"2012-11-22T12:35:35","date_gmt":"2012-11-22T10:35:35","guid":{"rendered":"http:\/\/code.openark.org\/blog\/?p=5544"},"modified":"2012-11-22T12:35:35","modified_gmt":"2012-11-22T10:35:35","slug":"speaking-in-london-common_schema-dbas-framework-for-mysql","status":"publish","type":"post","link":"https:\/\/code.openark.org\/blog\/mysql\/speaking-in-london-common_schema-dbas-framework-for-mysql","title":{"rendered":"Speaking in London: common_schema, DBA&#8217;s framework for MySQL"},"content":{"rendered":"<p>I&#8217;m happy to be speaking about <a href=\"http:\/\/code.google.com\/p\/common-schema\/\">common_schema<\/a> at <a href=\"http:\/\/www.percona.com\/live\/london-2012\/sessions\/commonschema-dbas-framework-mysql\">Percona Live London<\/a>, <strong>Dec 4th, 2012<\/strong>. This will be the first chance for me to speak about <em>common_schema<\/em>, what I believe to be an extremely useful companion to your MySQL server.<\/p>\n<p>I will show you how <em>common_schema<\/em> can leverage your SQL skills and give you <em>new powers<\/em>. Stuff you had to be SQL-Perl-super-expert to work through is easily attainable with <em>common_schema<\/em> and QueryScript. Some maintenance, security and auditing tasks are now a breeze. Writing server side scripts can be fun!<\/p>\n<p>What I <em>won&#8217;t<\/em> do:<\/p>\n<ul>\n<li>Read the fancy manual aloud<\/li>\n<li>Walk you through every possible view, column, function, parameter and script<\/li>\n<\/ul>\n<p>What I <em>will<\/em> do:<\/p>\n<ul>\n<li>Explain the nature of <em>common_schema<\/em>, show you the concepts behind it (and it is built with concepts in mind)<\/li>\n<li>Provide with selected examples (schema analysis, security, processes &amp; transactions) &#8212; there&#8217;s much to go by, but no boring drill down into all details.<\/li>\n<li>Expose some cool hacks with <em>QueryScript<\/em><\/li>\n<li>Do very brief (as time allows) live demos.<\/li>\n<\/ul>\n<p><em>common_schema<\/em> is an open source project and released under the BSD license.<\/p>\n<p>Last April <a href=\"http:\/\/www.percona.com\/live\/mysql-conference-2012\/sessions\/common-schema-framework-mysql-server-administration\">Roland Bouman gave a great talk<\/a> about <em>common_schema<\/em>. This will not be the same talk; a lot has been developed by this time.<\/p>\n<p>I&#8217;ll be speaking at a very challenging time slot; the three other talks running concurrent to my own are all great ones; I actually wanted to attend all three of them. Heck, <a href=\"http:\/\/www.mysqlperformanceblog.com\/2012\/10\/30\/percona-live-london-2012-talks-you-do-not-want-to-miss\/\">Peter wants to<\/a> (though contrary to belief he can&#8217;t <em>fork()<\/em> himself). So, no hard feelings if you choose another talk during this time slot. But I do know where you live.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>I&#8217;m happy to be speaking about common_schema at Percona Live London, Dec 4th, 2012. This will be the first chance for me to speak about common_schema, what I believe to be an extremely useful companion to your MySQL server. I will show you how common_schema can leverage your SQL skills and give you new powers. [&hellip;]<\/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":false,"jetpack_social_options":{"image_generator_settings":{"template":"highway","default_image_id":0,"enabled":false},"version":2}},"categories":[5],"tags":[67,90,70],"class_list":["post-5544","post","type-post","status-publish","format-standard","hentry","category-mysql","tag-common_schema","tag-perconalive","tag-speaking"],"jetpack_publicize_connections":[],"jetpack_featured_media_url":"","jetpack_sharing_enabled":true,"jetpack_shortlink":"https:\/\/wp.me\/p2bZZp-1rq","_links":{"self":[{"href":"https:\/\/code.openark.org\/blog\/wp-json\/wp\/v2\/posts\/5544","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/code.openark.org\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/code.openark.org\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/code.openark.org\/blog\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/code.openark.org\/blog\/wp-json\/wp\/v2\/comments?post=5544"}],"version-history":[{"count":10,"href":"https:\/\/code.openark.org\/blog\/wp-json\/wp\/v2\/posts\/5544\/revisions"}],"predecessor-version":[{"id":5849,"href":"https:\/\/code.openark.org\/blog\/wp-json\/wp\/v2\/posts\/5544\/revisions\/5849"}],"wp:attachment":[{"href":"https:\/\/code.openark.org\/blog\/wp-json\/wp\/v2\/media?parent=5544"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/code.openark.org\/blog\/wp-json\/wp\/v2\/categories?post=5544"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/code.openark.org\/blog\/wp-json\/wp\/v2\/tags?post=5544"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}