'Development' 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 […]

  • On MySQL plugin configuration

    October 1, 2013

    MySQL offers plugin API, with which you can add different types of plugins to the server. The API is roughly the same for all plugin types: you implement an init() function, a deinit(); you declare status variables and global variables associated with your plugin, and of course you implement the particular implementation of plugin call. […]

  • Introducing audit_login: simple MySQL login logfile based auditing

    September 17, 2013

    audit_login is a simple MySQL login auditing plugin, logging any login or login attempt to log file in JSON format. It seems that audit plugins are all the rage lately... We've developed out simple plugin a month ago as part of our database securing efforts; by auditing any login or login attempt we could either […]

  • 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 […]

  • mycheckpoint revision 231 released

    May 23, 2013

    A new release for mycheckpoint: lightweight, SQL oriented MySQL monitoring solution. If you're unfamiliar with mycheckpoint, well, the one minute sales pitch is: it's a free and open source monitoring tool for MySQL, which is extremely easy to install and execute, and which includes custom queries, alerts (via emails), and out of the box HTTP […]

  • opeark-kit revision 196 released

    May 7, 2013

    This is a long due maintenance release of openark-kit. This release includes bugfixes and some enhancements, mainly to oak-online-alter-table. oak-online-alter-table Changes / bug fixes include: Support for keyword-named columns Use of FORCE INDEX due to lack of MySQL's ability for figure out the chunking key at all times --sleep-ratio option added; allows for sleep time […]

  • common_schema 2.0.0-alpha: rdebug, GPL

    April 9, 2013

    A new release for common_schema: an alpha version of rdebug: MySQL Debugger and Debugging API is now included with common_schema. With a different license in mind for rdebug, common_schema changes license to GPL (2 or above). common_schema 2.0 is ready for download. All things rdebug, it is alpha -- otherwise it's a stable release. rdebug […]

 
Powered by Wordpress and MySQL. Theme by openark.org