{"id":6769,"date":"2014-03-10T10:27:42","date_gmt":"2014-03-10T08:27:42","guid":{"rendered":"http:\/\/code.openark.org\/blog\/?p=6769"},"modified":"2014-04-04T16:15:22","modified_gmt":"2014-04-04T14:15:22","slug":"speaking-at-perconalive-common_schema-mysql-devops","status":"publish","type":"post","link":"https:\/\/code.openark.org\/blog\/mysql\/speaking-at-perconalive-common_schema-mysql-devops","title":{"rendered":"Speaking at Percona Live: common_schema, MySQL DevOps"},"content":{"rendered":"<p>In less than a month I&#8217;ll be giving these two talks at <a href=\"https:\/\/www.percona.com\/live\/mysql-conference-2014\/\">Percona Live<\/a>:<\/p>\n<ul>\n<li><a href=\"https:\/\/www.percona.com\/live\/mysql-conference-2014\/sessions\/commonschema-dbas-framework-mysql\">common_schema: DBA&#8217;s framework for MySQL<\/a><\/li>\n<\/ul>\n<p>If you are still unfamiliar with <a href=\"http:\/\/code.google.com\/p\/common-schema\/\">common_schema,<\/a> this will make for a good introduction. I&#8217;ll give you multiple reasons why you would want to use it, and how it would come to <em>immediate<\/em> use at your company. I do mean <em>immediate<\/em>, as in previous <em>common_schema<\/em> presentations I happened to get feedback emails from attendees within the same or next day letting me know how <em>common_schema<\/em> solved an insistent problem of theirs or how it exposed an unknown status.<\/p>\n<p>I&#8217;ll review some useful views &amp; routines, and discuss the ease and power of QueryScript. <em>common_schema<\/em> is a Swiss-knife of solutions, and all from within your MySQL server.<\/p>\n<p>I am using <em>common_schema<\/em> in production on a regular basis, and it happened to be hero of the day in multiple occasions. I&#8217;ll present a couple such cases.<\/p>\n<p><iframe loading=\"lazy\" title=\"common_schema 2.2: DBA&#039;s framework for MySQL (April 2014)\" src=\"https:\/\/www.slideshare.net\/slideshow\/embed_code\/key\/izgbQzup8tu7jN\" width=\"427\" height=\"356\" frameborder=\"0\" marginwidth=\"0\" marginheight=\"0\" scrolling=\"no\" style=\"border:1px solid #CCC; border-width:1px; margin-bottom:5px; max-width: 100%;\" allowfullscreen> <\/iframe> <\/p>\n<div style=\"margin-bottom:5px\"> <strong> <a href=\"https:\/\/www.slideshare.net\/shlominoach\/commonschema-22-dbas-framework-for-mysql\" title=\"common_schema 2.2: DBA&#39;s framework for MySQL (April 2014)\" target=\"_blank\">common_schema 2.2: DBA&#39;s framework for MySQL (April 2014)<\/a> <\/strong> from <strong><a href=\"https:\/\/www.slideshare.net\/shlominoach\" target=\"_blank\">Shlomi Noach<\/a><\/strong> <\/div>\n<ul>\n<li><a href=\"https:\/\/www.percona.com\/live\/mysql-conference-2014\/sessions\/mysql-devops-outbrain\">MySQL DevOps @ Outbrain<\/a><\/li>\n<\/ul>\n<p>This is a technical talk touching at some cultural issues.<\/p>\n<p>At <a href=\"http:\/\/www.outbrain.com\/about\/what-is-outbrain\">Outbrain<\/a>, where I work, we have two blessings: a large group of engineers and a large dataset. We at the infrastructure team, together with the ops team, are responsible for the availability of the data. What we really like is technology which lets the owners of a problem be able to recognize it and take care of it. We want ops guys to do ops, and engineers to do engineering. And we want them to be able to talk to each other and <em>understand<\/em> each other.<\/p>\n<p>What tools can you use to increase visibility? To allow sharing of data between the teams? I&#8217;ll share some tools and techniques that allow us to automate deployments, detect a malfunctioning\/abusing service, deploy schema changes across dozens of hosts, control data retention, monitor connections, and more.<\/p>\n<p>We like open source. The tools discussed are mostly open source, or open sourced by Outbrain.<\/p>\n<p>I&#8217;ll explain why these tools matter, and how they serve the purpose of removing friction between teams, allowing for quick analysis of problems and overall visibility on all things that happen.<\/p>\n<p><iframe loading=\"lazy\" title=\"MySQL DevOps at Outbrain\" src=\"https:\/\/www.slideshare.net\/slideshow\/embed_code\/key\/ys7e82mMyh669C\" width=\"427\" height=\"356\" frameborder=\"0\" marginwidth=\"0\" marginheight=\"0\" scrolling=\"no\" style=\"border:1px solid #CCC; border-width:1px; margin-bottom:5px; max-width: 100%;\" allowfullscreen> <\/iframe> <\/p>\n<div style=\"margin-bottom:5px\"> <strong> <a href=\"https:\/\/www.slideshare.net\/shlominoach\/mysql-devops-at-outbrain\" title=\"MySQL DevOps at Outbrain\" target=\"_blank\">MySQL DevOps at Outbrain<\/a> <\/strong> from <strong><a href=\"https:\/\/www.slideshare.net\/shlominoach\" target=\"_blank\">Shlomi Noach<\/a><\/strong> <\/div>\n<h4>Do come by!<\/h4>\n","protected":false},"excerpt":{"rendered":"<p>In less than a month I&#8217;ll be giving these two talks at Percona Live: common_schema: DBA&#8217;s framework for MySQL If you are still unfamiliar with common_schema, this will make for a good introduction. I&#8217;ll give you multiple reasons why you would want to use it, and how it would come to immediate use at your [&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":true,"jetpack_social_options":{"image_generator_settings":{"template":"highway","default_image_id":0,"enabled":false},"version":2}},"categories":[5],"tags":[67,120,105,57,90,70],"class_list":["post-6769","post","type-post","status-publish","format-standard","hentry","category-mysql","tag-common_schema","tag-development","tag-devops","tag-open-source","tag-perconalive","tag-speaking"],"jetpack_publicize_connections":[],"jetpack_featured_media_url":"","jetpack_sharing_enabled":true,"jetpack_shortlink":"https:\/\/wp.me\/p2bZZp-1Lb","_links":{"self":[{"href":"https:\/\/code.openark.org\/blog\/wp-json\/wp\/v2\/posts\/6769","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=6769"}],"version-history":[{"count":14,"href":"https:\/\/code.openark.org\/blog\/wp-json\/wp\/v2\/posts\/6769\/revisions"}],"predecessor-version":[{"id":6800,"href":"https:\/\/code.openark.org\/blog\/wp-json\/wp\/v2\/posts\/6769\/revisions\/6800"}],"wp:attachment":[{"href":"https:\/\/code.openark.org\/blog\/wp-json\/wp\/v2\/media?parent=6769"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/code.openark.org\/blog\/wp-json\/wp\/v2\/categories?post=6769"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/code.openark.org\/blog\/wp-json\/wp\/v2\/tags?post=6769"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}