'common_schema' Tag

• Slides from my talk: common_schema, DBA's Framework for MySQL

  April 26, 2013

  I've just uploaded the slides from my talk: common_schema: DBA's framework for MySQL My talk was well attended, and I was fortunate to have a warm and engaged audience. Thank you to all those who attended, and thank you for those who provided feedback! Was happy to be able to present my work a great group [...]

  posted in MySQL by shlomi

• Speaking at Percona Live 2013: common_schema, lightning talks

  April 11, 2013

  In two weeks time I will be giving these talks at Percona Live: common_schema: DBA's framework for MySQL: an introduction to common_schema, my evolving server side solutions project. This will be a revised version of the talk I gave at Percona Live London; I have felt some weaknesses during that talk, which I've thrown out, [...]

  posted in MySQL by shlomi

• Taking common_schema's rdebug to a test-drive

  April 9, 2013

  This is a simple step-by-step introduction to rdebug: Debugger and Debugging API for MySQL Stored Routines, as part of common_schema. In other words: let me take you through the steps for debugging your stored routines on your own server. We will step into, step over, step out, modify variables, set a breakpoint, run to breakpoint... [...]

  posted in MySQL by shlomi

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

  posted in MySQL by shlomi

• MySQL Stored Routines Debugger & Debugging API: sneak preview II, video

  March 21, 2013

  This is the 2nd sneak preview of common_schema's rdebug: debugger & debugging API for MySQL stored routines (see 1st preview here). rdebug will be released as part of common_schema, free and open sourced. In this sneak preview I present: Compiling multiple routines with debug info Starting/stopping a debug session Step-over, step-in, step-out Showing stack trace [...]

  posted in MySQL by shlomi

• MySQL Stored Routines Debugger & Debugging API: sneak preview video

  February 19, 2013

  This is a sneak peek video introduction/preview of an in-development free and open source server side debugger & debugging API for MySQL stored routines. MySQL does not provide server side debugging capabilities for stored routines. Some tools exist, including MySQL's own, that assist in stored routine debugging. These are all GUI based and, to the [...]

  posted in MySQL by shlomi

• MySQL security tasks easily solved with common_schema

  January 17, 2013

  Here are three security tasks I handled, which I'm happy to say were easily solved with common_schema's views and routines (with no prior planning). Two are so easy, that I actually now integrated them into common_schema 1.3: Duplicate a user (create new user with same privileges as another's) Find users with identical set of grants [...]

  posted in MySQL by shlomi

• common_schema: 1.3: security goodies, parameterized split(), json-to-xml, query checksum

  January 14, 2013

  common_schema 1.3 is released and is available for download. New and noteworthy in this version: Parameterized split(): take further control over huge transactions by breaking them down into smaller chunks, now manually tunable if needed duplicate_grantee(): copy+paste existing accounts along with their full set of privileges similar_grants: find which accounts share the exact same set [...]

  posted in MySQL by shlomi

• common_schema over traditional scripts

  December 12, 2012

  If you are familiar with both openark kit and common_schema, you'll notice I've incorporated some functionality already working in openark kit into common_schema, essentially rewriting what used to be a Python script into SQL/QueryScript. What was my reasoning for rewriting good code? I wish to explain that, and provide with a couple examples. I'm generally [...]

  posted in MySQL by shlomi

• Slides from my talk: common_schema, DBA's framework for MySQL

  December 4, 2012

  Thank you to all who attended my talk at Percona Live London! The slides from my talk are now made available, following: . Also available on slideshare. They should also be on the Percona Live site within a few days.

  posted in MySQL by shlomi