Category: MySQL

MySQL related posts

common_schema booth on Percona Live 2013

MySQL
common_schema booth in Percona Live 2013
common_schema booth in Percona Live 2013 (someone left their soup on our table)
Allen Kinnard

Yay! I got a booth!

I confess it was mostly deserted. My hero Allen Kinnard, whom I’ve never met before, was kind enough to volunteer to occupy the booth.
So between him and me, both of course also looking to visit other booths and talk to people, the common_schema booth was only moderately attended.

Well, this was the DotOrg Pavilion: free booths for free & open source projects (e.g. OpenStack, PhpMyAdmin, etc.).
We both did our best to explain common_schema to the visitors.

The booth was actually titled “common_schema & openark-kit”. However I don’t recall that anyone asked me about openark-kit. Most were just interested in what common_schema was. I get that openark-kit is well known by now to many.

We did not have so many visitors, which played well with our occasional absence. But this was a last moment arrangement. In future events I may try to get things on top and have an army of volunteers to help me out (and I hope that by next time common_schema is widely used).

cookie_monster

Now for the criminal department: practically all other DotOrg booths came prepared, with printed material, giveaway stuff and the like. We were like way beyond “the minimalist”. We were “the poor and the pitiful”. So I asked Kortney if she could arrange me some decorations (pulling some strings – yeah!). We were thinking a bowl of candies or something. Eventually she brought a few dozen candies (no bowl) and laid them nicely on the table; very nice touch! Good mixture of colors, nice wave design.

And guess what? Visitors actually thought they may take one of our candies! Oh, I schooled them.
But on Wednesday, when we arrived to the booth, a horrid sight stroke us: someone stole (and probably ate) 80% of our candies!
Well, I hope you’ve got bellyache, and next time you should know there will be surveillance, candy-thief!

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

MySQL

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 of people.

You can find my slide either on Percona Live’s website, or on Slideshare, as well as embedded right here.

I set two aims to my talk:

  1. To have the audience know how to download and install common_schema (Check!)
  2. Have everyone in the audience find one tool from common_schema that will make their day better. Quick raise of hands at the end of presentation: Check! All hands are up!

As I’ve noted following a question, rdebug is still in alpha. It modifies one’s routines in such way that does not alter the routine’s behavior, except:

  • Affecting the value returned by ROW_COUNT() (I have no immediate solution to that)
  • Also affecting result of LAST_INSERT_ID() (I expect to have this solved).

Thank you again; give common_schema a try. Best ways to support: submit bug reports, ideas, and above all: spread the word. common_schema for world domination!

common_schema 2.0: DBA's Framework for MySQL from Shlomi Noach

Impressions from Percona Live 2013

MySQL

At the airport, trying to sum up my impressions from Percona Live 2013 conference in Santa Clara.

Woo! Hard to sum up four excellent days. Shall I review the great talks I’ve been to? The keynotes? The well organized events?

You know what, skip it. There was ONE thing that overshadowed everything. It was the ONE thing for me that was the pure essence of the conference and its greatest joy:

Meeting and talking to a great many great people!

I was fortunate to meet up with so many people; none that I planned; things just went in such way that I engaged in so many conversations with so many people. I found myself talking about hamsters, peacocks, living in the village, living in the city, working from home, commute, relocation, working with your spouse, life in Israel, life in Argentina, prisons in the US, having many children, gun control, politics (heaven forbid!), fruit, vegetables, breakfasts, open source, community, buying (non-expensive) presents to your kids, new ventures, zen, philosophy, capitalism, socialism, books, being who you are, weddings, Java, scripting, NoSQL, how to contribute to an open source project, … the list goes on.

I was “adopted” by the PalominoDB team at Pedro’s, crash-partied on Pythian fellows, talked technical (or non technical) with Tokutek guys, meeting up with Oracle people (finally I get the faces behind the names!); the companies do not matter, I’m just throwing in names. The people are awesome! Representing their companies on the technical side, and being purely interesting people on the personal side, I met with men and women from all over the community. Apologies: impossible to list all nor account for!

It’s great to have a place and time where we all meet together.

The bottom line? I am fortunate to have my current profession: I enjoy my work, and the people I meet are fantastic and of the highest quality!

Thanks all with whom I’ve met, and for all of those with whom I haven’t had the chance to speak: see you next time!

Speaking at Percona Live 2013: common_schema, lightning talks

MySQL

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, letting room for cool stuff. I will discuss common_schema‘s various views, interesting and useful routines, the power of QueryScript, and a brief intro to the newcomer rdebug, debugger and debugging API for MySQL. If you’re not familiar with common_schema, it’s a good time to pick up on what I (being most biased) consider to be your smart assistant to MySQL maintenance and administration!
  • The query which is the peak of my career: this is a 6 minute lightning talk. You’re bound to attend if you’re at the community reception (which you are), so I don’t need to do promotional. You already payed the ticket and the doors will be locked. No escapees.

As far as I’m concerned the conference can be closed down the moment I provide these two talks, and we can all go to the beach.

Wait, no, I will also be at the DotOrg Pavillion at the Exhibit Hall, where I present common_schema and openark-kit. Come by to hear more about these!

Taking common_schema’s rdebug to a test-drive

MySQL

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…

Command line geeks, this one’s for you. GUI lovers, this is actually an API; I am hoping for someone wrap it up with a plugin for your favorite GUI editor.

Requirements:

  • Install common_schema 2.0 or above (at this time of writing 2.0.0-alpha is released).
  • Get sample data & routine file [download id=”4″ format=”1″]
  • mysql> SOURCE rdebug_demo.sql_.txt
    • You should now have a table called color_count in the test database, along with two routines: review_colors() and review_single_color().
  • Open two sessions. We call them the debugger session and the worker session. The worker session will execute the routine; the debugger session will control it.

Walk-through: preparation

Walk this thing with me. We will alternate between the debugger and the worker. Continue reading » “Taking common_schema’s rdebug to a test-drive”

common_schema 2.0.0-alpha: rdebug, GPL

MySQL

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

I’m very happy to release this alpha version of rdebug, and urge everyone to try it out.

The idea is to have an open, free, server side debugger and debugging API for MySQL stored routines. To elaborate:

  • It’s server side by that it’s implemented by stored routines. Not by a connector; not an emulator; not a GUI tool hack. The entire functionality lies within common_schema, a schema in your server.
  • It’s a debugger: you can debug your own stored routines (with limitations)
  • It’s a debugging API: there’s a distinct specification and a set of calls which makes for a debugging process
  • It’s open since the source code is yours to browse.
  • It’s free as in free beer.
  • It’s free as it makes you independent of a specific debugger. It provides an API that anyone can use. You can run the API yourself from the command line; or plugins for your favorite GUI editor can be developed to use this API.

On a separate blog post I will take you to a rdebug test drive.

As always, nothing is released before extensive documentation is in place.

I’d love to get input on this. Continue reading » “common_schema 2.0.0-alpha: rdebug, GPL”

Percona Live 2013 schedule & events summary

MySQL

Here’s the (hopefully) complete list of events throughout and following the upcoming Percona Live MySQL Conference & Expo, 2013.

The schedule is quite packed! Make sure to take a deep breath beforehand:

Monday, April 22

09:30 – 16:30: Tutorials

16:30 – 18:30: Welcome reception in Expo Hall

18:30 – 20:30: MySQL Community Reception by Oracle

Tuesday, April 23

09:00 – 11:00: Keynotes

11:00 – 17:40: Sessions

18:00 – 19:00: Birds of a Feather

19:00 – 22:00: Community dinner at Pedro’s

Wednesday, April 24

09:00 – 10:35: Keynotes

11:10 – 17:20: sessions

17:30 – 20:30: Community Networking Welcome Reception (in Expo Hall) MySQL Community Awards & Lightning Talks

Thursday, April 25

09:00 – 10:35: Keynotes

11:00 – 16:00: Sessions

16:00 – 16:45: Wrap-up

Following the conference, you can find:

Friday, April 26:

SkySQL and MariaDB’s 2nd Annual MySQL & Cloud Solutions Day

Assistance wanted: DotOrg Pavilion on Percona Live 2013

MySQL

I’m looking for assistance in manning a DotOrg Pavilion on the upcoming Percona Live conference in Santa Clara.

As you may or may not know, free and open source projects are eligible to ask for a free booth on the Expo hall. This is a good chance to promote one’s project.

Of course, someone must stand behind the counter and answer [technical] questions.

I should like to have a booth for common_schema & openark-kit, but am limited in resources — namely the number of bodies I can occupy simultaneously, just one at this time. Along with some duties I have throughout the conference I do not expect to be able to be present for long periods behind the counter.

Are you familiar with common_schema/openark-kit? Would you like to lend a hand and contribute some hours at the conference?

For a full time attendee I can lend a hand and provide with a free conference pass + my gratitude.

Please comment below if you are willing to commit yourself to this task — thank you!

Speaking on the media: OurSQL, Reversim

MySQL

I had the pleasure of speaking on two excellent podcasts:

OurSQL

No need for me to introduce this podcast. I just have to say it was only when I interviewed that I realized the amount of work taken for producing one single cast. Kudos to Sheeri & Gerry and Rich Goyette the sound producer and thank you for your kind hospitality!

You can find the cast on OurSQL Episode 129: New and Extended, where we speak about the upcoming Percona Live MySQL Conference & Expo, 2013.

Reversim

This is an Israeli, Hebrew speaking podcast, and is undoubtedly the queen of Software Development podcasts here. Run by two enthusiast, veteran, open source keen developers, this is a must hear podcast if your Hebrew isn’t rusty 😉 Thanks Ori & Ran for having me again!

I was honored to be interviewed for the 3rd time there, again speaking about MySQL and its ecosystem. In this recent podcast, I speak about the new 5.6 release, highlighting some features; about MariaDB; the Galera cluster technology; LGPL connectors; Percona Live 2013.

Find the cast on the reversim website: 171 MySQL 5.6

My next speaking event will be at the conference itself; more on that later.