'common_schema' Tag

  • Speaking at Percona Live: common_schema, MySQL DevOps

    March 10, 2014

    In less than a month I'll be giving these two talks at Percona Live: common_schema: DBA's framework for MySQL If you are still unfamiliar with common_schema, this will make for a good introduction. I'll give you multiple reasons why you would want to use it, and how it would come to immediate use at your […]

  • Why delegating code to MySQL Stored Routines is poor engineering practice

    February 6, 2014

    I happen to use stored routines with MySQL. In fact, my open source project common_schema heavily utilizes them. DBA-wise, I think they provide with a lot of power (alas, the ANSI:SQL 2003 syntax feels more like COBOL than a sane programming language, which is why I use QueryScript instead). However I wish to discuss the […]

  • common_schema: speaking at Percona Live London, Nov. 2013

    November 4, 2013

    In one week's time I'll be presenting common_schema: DBA's framework for MySQL at Percona Live, London. This talk introduces the rich toolset known as common_schema. It is free, open source, extremely useful in solving DBA & developer tasks, and is the next best thing ever invented next to SQL pie charts. I'll introduce: Views, with […]

  • Converting an OLAP database to TokuDB, part 3: operational stuff

    October 14, 2013

    This is the third post in a series of posts describing our experience in migrating a large DWH server to TokuDB (see 1st and 2nd parts). This post discusses operations; namely ALTER TABLE operations in TokuDB. We ran into quite a few use cases by this time that we can shed light on. Quick recap: […]

  • Converting an OLAP database to TokuDB, part 2: the process of migration

    September 9, 2013

    This is a second in a series of posts describing our experience in migrating a large DWH server to TokuDB. This post discusses the process of migration itself. As a quick recap (read part 1 here), we have a 2TB compressed InnoDB (4TB uncompressed) based DWH server. Space is running low, and we're looking at […]

  • Converting an OLAP database to TokuDB, part 1

    September 3, 2013

    This is the first in a series of posts describing my impressions of converting a large OLAP server to TokuDB. There's a lot to tell, and the experiment is not yet complete, so this is an ongoing blogging. In this post I will describe the case at hand and out initial reasons for looking at […]

  • common_schema 2.2: better QueryScript isolation & cleanup; TokuDB; table_rotate, split params

    August 13, 2013

    common_schema 2.2 is released. This is shortly after the 2.1 release; it was only meant as bug fixes release but some interesting things came up, leading to new functionality. Highlights of the 2.2 release: Better QueryScript isolation & cleanup: isolation improved across replication topology, cleanup done even on error Added TokuDB related views split with […]

  • common_schema roadmap thoughts

    July 22, 2013

    I'm happy with common_schema; it is in fact a tool I use myself on an almost daily basis. I'm also happy to see that it gains traction; which is why I'm exposing a little bit of my thoughts on general future development. I'd love to get feedback. Supported versions At this moment, common_schema supports MySQL […]

  • common_schema 2.1 released: advanced & improved split(), persistent script tables, more schema analysis, and (ahem) charts!

    July 17, 2013

    common_schema 2.1 is released! common_schema is your free & open source companion schema within your MySQL server, providing with a function library, scripting capabilities, powerful routines and ready-to-apply information and recommendations. New and noteworthy in version 2.1: Better QueryScript's split() functionality Persistent tables for QueryScript: no long held temporary tables Index creation analysis, further range […]

  • common_schema & openark-kit in the media: #DBHangOps, OurSQL

    June 26, 2013

    #DBHangOps I had the pleasure of joining into @DBHangOps today, and speak about common_schema and openark-kit. What was meant to be a 15 minute session turned to be 50 -- sorry, people, I don't talk as much at home, but when it comes to my pet projects... I also realized I was missing on a […]

 
Powered by Wordpress and MySQL. Theme by openark.org