PlanetMysql.ru — информация о СУБД MySQL

Day 1 is the fist official day of the Percona Live MySQL Conference; the day began with two mini-keynotes by Peter Zaitev and Baron Schwarz of Percona talking about the history of MySQL and how he got started in the open source movement respectively. Very nostalgic and I’m sure it brought a tear to a [...]
PlanetMySQL Voting: Vote UP / Vote DOWN

Day 1 is the fist official day of the Percona Live MySQL Conference; the day began with two mini-keynotes by Peter Zaitev and Baron Schwarz of Percona talking about the history of MySQL and how he got started in the open source movement respectively. Very nostalgic and I’m sure it brought a tear to a [...]
PlanetMySQL Voting: Vote UP / Vote DOWN

Day 0 of the MySQL Conference is a day unlike any other day, it is in fact tutorial day. While regular days of the Percona Live MySQL Conference feature 50 minute sessions, usually split into 40 minute talk and a 5-10 minute question period, tutorials are 3 hour long sessions (with a generous 10 minute break in the [...]
PlanetMySQL Voting: Vote UP / Vote DOWN

Day 0 of the MySQL Conference is a day unlike any other day, it is in fact tutorial day. While regular days of the Percona Live MySQL Conference feature 50 minute sessions, usually split into 40 minute talk and a 5-10 minute question period, tutorials are 3 hour long sessions (with a generous 10 minute break in the [...]
PlanetMySQL Voting: Vote UP / Vote DOWN

The Percona Live MySQL Conference and Expo 2012 is over. Together with the SkySQL solutions day, it has kept me occupied for 4 full days, from early morning to late at night.

I have to say that I am pleased. The quality of the organization was very high, with a very good lineup of speakers and an excellent technical support.

As usual, I have learned a lot during this week, either directly, by attending talks, or indirectly, by meeting people who told me what was juicy at the talks that I had missed.And I have met new interesting people, and caught up with the people that I know already.

This conference was particularly intense also because I got myself involved in 5 talks, which was probably more than I should have. How did I end up with such a task? It's a long story.

It all started when the CfP opened. In the review committee, we all knew that Oracle was not eager to participate, but we hoped that it would change its mind and send someone in the end. So we planned ahead, and some of us proposed talks aimed at beginner and intermediate users, with topics that are usually best covered by the people who work at the MySQL team. I proposed Replication 101 and What's new in MySQL 5.5 and 5.6 replication, with the idea that I would hand them over to a couple of Oracle engineers, or have them as co-speakers. That, however, didn't happen. So I had to prepare and present these two talks, in addition to the one that I wanted to do on my own (Testing MySQL creatively in a sandbox).

That makes 3 talks. Then I got tasked with organizing the lightning Talks, which is not a big deal per se, but it adds to the global effort. 4 talks.

And finally, SkySQL organized another beautiful conference on Friday, and I got to present a fifth talk. I enjoyed every bit of them, but boy! the conference was intense!.

I have learned not only from the talks that I have attended, but also from the preparation of my own talks. The biggest source of surprises was my talk about MySQL 5.6 replication. I was expecting a mature release, but I found a collection of features that don't play very well together, and can sometimes lead to an unstable server. Since I was trying to get my demos working, rather than isolating the bugs, I didn't submit any reports, but I will come back to that version and do a more thorough analysis as soon as I catch up with my day-by-day work.

Speaking about demos, it's quite common for me to include a demo in a technical talk. First, because getting a demo done will make me better acquainted with the features that I am presenting, and also because a presentation with a demo conveys the idea of a mature and reliable product (or the idea that I, as the speaker, know what I am talking about). Either way, I know prepare a demo for every talk where I have sufficient time to show one, and sometimes even for a lightning talk. So it was surprising to hear comments that praised my talks because they contain demos. Is this practice so unusual? I should start taking count of how often this is done.

My most satisfactory demo (and the one that almost got me in trouble) happened at the last talk, on Friday, when I had to show features from three different Tungsten topologies, using three separate remote clusters. For these demos to be successful, I needed good internet connection, a solid confidence in the product and the strength of its tests, and to remember the sequence of operations for each demo. To my surprise, everything went so smoothly, that someone in the audience thought that I was running a simulation in my laptop, instead of interacting with servers that were 10,000 Km away. So much for my rehearsals! I must remember to add at least a tiny mistake in an otherwise perfect sequence of tasks, to make the audience aware that I am playing live.

The slides for my presentations are available at Slideshare.

PlanetMySQL Voting: Vote UP / Vote DOWN

If you are following news regarding openSUSE and MySQL, you probably already know, that we have both MySQL and MariaDB in openSUSE to allow users to choose what they want to use. And if these two options are not enough, we’ve got server:database repository with newest and greatest development versions of both and MySQL Cluster on to of that. I think all this is great and awesome, that we have all of that.

Now to the not so great part. Unfortunately I’m bare human, I have to eat, sleep and I have some work, some bugs that takes a lot more time that I expected, some school duties to take care of and of course openSUSE Conference to organize! So as a result of all that, I can’t polish MySQL and MariaDB as much I would love to. And on top of that, I’m not expert in MySQL configuration. Part of that is that it just works and I never had any server where MySQL was slowing things down. But there is plenty of skilled MySQL administrators out there in community! So I’m calling out for help. You skilled MySQL admins probably have a lot of interesting tweaks you are applying to default configuration file. So take a look at them and think what could be useful for everybody, not just in your specific use-case. And either send me snippet with short explanation in the comments, or create .cnf file add it to the flavor directory and send me pull request on github! I’ll keep credits and your explanation of the snippet inside, so people will know, who came with this cool option and what does it do

Oh, and don’t get discouraged if I don’t include it right away, it may take me some time to get to it, but I’ll appreciate every suggestion

PlanetMySQL Voting: Vote UP / Vote DOWN

The Ubuntu Developer Summit takes place at The Oakland Marriott City Center, Oakland, California from 7–11 May 2012. 

If your attending this event, you will have a few different MySQL opportunities to attend:

• MySQL RoundTable
• Utilities to work with MySQL

Oracle is proud to also be a Sponsor of the Ubuntu Developer Summit. A full schedule of the event is available here.

 Join us as we help support and grow the MySQL Communities. 

PlanetMySQL Voting: Vote UP / Vote DOWN

The Ubuntu Developer Summit takes place at The Oakland Marriott City Center, Oakland, California from 7–11 May 2012. 

If your attending this event, you will have a few different MySQL opportunities to attend:

• MySQL RoundTable
• Utilities to work with MySQL

Oracle is proud to also be a Sponsor of the Ubuntu Developer Summit. A full schedule of the event is available here.

 Join us as we help support and grow the MySQL Communities. 

PlanetMySQL Voting: Vote UP / Vote DOWN

Mark Callaghan of Facebook: “What Comes Next for MySQL” focus on Large, sharded deployments Interesting numbers from their deployment (MySQL with Innodb): 60M QPS and 1.5B rows read/second in production MySQL with InnoDB is “web scale” scaled to 10x more data on the same servers by: Start with MySQL 5.1, flashcache, find and fix stalls, [...]
PlanetMySQL Voting: Vote UP / Vote DOWN

Winners of the 2012 MySQL Community Awards were announced at the Percona Live MySQL Conference and Expo just a few hours ago:

...

In terms of continuing with MySQL traditions, it has been my privilege the past years to be the secretary of the MySQL Community Awards panel. We have so many amazing persons, products and companies in this community. One of the nicest thing we can do to each other, and what really builds and fuels a community, is to show appreciation and say thanks to people that really deserve it.

read more

PlanetMySQL Voting: Vote UP / Vote DOWN