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

IOUG has a free series of three webinars on upgrading MySQL. Each webinar is an hour long, and it starts with a webinar by me tomorrow at 12 noon Central time (GMT-5) on “Why and How to Upgrade to MySQL 5.1″. The webinar assumes you are upgrading from MySQL 5.0 to MySQL 5.1, and talks a little bit about the new features, server variables, and what you need to know when upgrading to MySQL 5.1.

The software used is GoToWebinar (formerly GoToMeeting), so you will need to install that software. To register, use the links on the IOUG MySQL Upgrade Webinar Series page.

The complete list of webinars in the MySQL Upgrade Series is:
* MySQL 5.1: Why and How to Upgrade
Sheeri Cabral, The Pythian Group
Tuesday, July 27, 12:00 p.m. – 1:00 p.m. CT (GMT-5)

* MySQL Upgrades With No Downtime
Sean Hull, Heavyweight Internet Group
Wednesday, July 28, 12:00 p.m. – 1:00 p.m. CT (GMT-5)

* MySQL Upgrade Best Practices
Matt Yonkovit, Percona
Thursday, July 29, 12:00 p.m. – 1:00 p.m. CT (GMT-5)

(note, I am not sure if it is free for everyone or just free for IOUG members; my apologies if it is the latter)

Ronald Bradford and I produced a successful MySQL track at Kaleidoscope (hereinafter referred to as Kscope). With a speaker list of Philip Antoniades, Josh Sled and Craig Sylvester of Oracle, Laine Campbell of PalominoDB, Patrick Galbraith of Northscale, Sarah Novotny of Blue Gecko, Padrig O’Sullivan of Akiba, Dossy Shiobara of Panoptic.com and Matt Yonkovic of Percona, we knew the technical content was going to be great.

As someone who’s helped organize all the OpenSQLCamps, a few MySQL Camps, and the Boston MySQL User Group, I know that participation at an event such as this can be small. Despite planning the MySQL track at the last minute, we had top-notch speakers with appropriate content for the audience, which was mostly Oracle crossovers. We had several registrants who came solely for the MySQL content, with all but 2 of the 27 sessions having 10-25 audience members. According to a few different folks, this is the same amount as the SOA and BPM track receives, and that track was not planned at the last minute. The ODTUG conference committee and board were happy with the turnout as well. I can’t wait to see the results of the evaluations!

As someone who’s sat on not-for-profit boards in the past as well as organized events while being on the board, I know how crazy it can be to plan conferences, and I also know that there are some organizations and personalities that are difficult to work with. I am happy to report that ODTUG has been very welcoming, accommodating, and hands-off, letting us do what we need. When I spoke with Edward Roske, the conference chair for Kscope 2011, he said, “You know what the needs for MySQL much better than I do, so just run the MySQL track as if you’re an executive of a corporation.” I know we are all worried about content being controlled by marketing folks, and I am very happy to report that ODTUG’s Kaleidoscope conference is of, by and for the people. There is one slot for a vendor presentation, and it is clearly marked, and there was an expo hall with over 20 booths, so there are opportunities for marketing; but all in all this is a technical conference.

Slides from presentations:
From Ronald:
Increasing MySQL Productivity from Design to Implementation (3-hour presentation)

MySQL idiosyncrasies that bite

From Matt Yonkovit:
The Five Minute DBA

From me:
Importing and Exporting Data with MySQL
What do you mean, SQL syntax error? – a 90-minute look into how MySQL’s SQL extends and deviates from the ANSI/ISO SQL:2003 standard.

Stored
Procedures & Functions and
Triggers and Views.

I also gave Jay Pipes’ Join-fu: the Art of SQL part one and Join-fu: the Art of SQL part two as Jay was unable to attend at the last minute.

My huge thanks to all the speakers and all the attendees; the MySQL track at Kaleidoscope was a success! I am already imagining what we can do next year in Long Beach, CA at the end of June.

Today at Kaleidoscope I will be doing a 90-minute session comparing MySQL’s SQL syntax to the ANSI/ISO SQL:2003 standard, entitled What Do You Mean, “SQL Syntax Error”?

You can download the PDF slides now.

For those that may be following along the presentation later today (4 pm Eastern time), here are some links that I may throw out during the session:

• SQL 2003 standard – actually it is “Information taken from the Final Committee Draft (FCD) of ISO/IEC 9075-2:2003″ but it’s extremely close to the actual standard. The actual standard is a document that costs a non-trivial amount of money to get, and cannot be republished.
  
• The MySQL Administrator’s Bible, from which this content was taken from.
  
• The MySQL Manual page for sql_mode values.
  
• Information about and examples of quoting in MySQL
  
• The MySQL Manual page for CREATE TABLE which contains all the special extensions MySQL has for tables.
  
• The MySQL Manual page for PROCEDURE ANALYSE().
  
• The MySQL Manual page for the SHOW extension
  
• PDF slides for an EXPLAIN presentation I have done, and the EXPLAIN Cheatsheet.
  

OpenSQLCamp is less than 4 months away, and I have finally gotten around to updating the site. Special thanks go to Bradley Kuzsmaul and the folks at Tokutek for getting the ball rolling and making the reservation at MIT. Using MIT means that we will have *free* reliable wireless guest access and projects.

OpenSQL Camp is a free unconference for people interested in open source databases (MySQL, SQLite, Postgres, Drizzle), including non-relational databases, database alternatives like NoSQL stores, and database tools such as Gearman. We are not focusing on any one project, and hope to see representatives from a variety of open source database projects attend. As usual I am one of the main organizers of Open SQL Camp (in previous years, Baron Schwartz, Selena Deckelmann and Eric Day have been main organizers too; this year Bradley Kuzsmaul is the other main organizer). The target audience are users and developers, but others are encouraged to attend too. There will be both presentations and hackathons, with plenty of opportunities to learn, contribute, and collaborate!

I have updated the main Boston 2010 page at http://opensqlcamp.org/Events/Boston2010/ with travel and logistics information, including links to:

Register — it’s free and easy, and you can always change your mind later!

Maybe you have an idea for a session you would like to see, or a session you would like to give? If so, you can note it on the sessions page. This will give everyone a sense of what type of presentations will be there. I have started by putting 2 sessions I am willing to give and a third at the bottom for one I’d like to see, to give everyone an idea of both types of descriptions.

Probably the most important link right now is the way we keep OpenSQLCamp free for all attendees – sponsor or donate to the conference! Any donation amount is accepted, and all donations are tax-exempt to the fullest extent of the law. Businesses and organizations will be listed as sponsors if they make a donation of $250 or more, and individuals will be listed as sponsors if they make a donation of $100 or more. More information on sponsor benefits, including where to send a graphic to, at the link.

There is a preliminary schedule, up until the conference itself it will only show the agenda of the conference — how many rooms and what time the presentations are supposed to be. During and after the conference we will update this schedule page with the titles, presenters and links to any notes/videos/audio taken.

If you have any questions, please do not hesitate to ask on the mailing list or by posting a comment here.

By now you know that there is a MySQL Track during next week’s ODTUG Kaleidoscope in Washington, DC. Ronald Bradford and I organized the schedule at the last minute (Ronald did a lot of the work!). It was difficult to fill a schedule with 19 sessions that are either 1 hour or 1.5 hours long, and to do it I ended up with three presentations.

At each presentation I will be giving away a copy of The MySQL Administrator’s Bible, so be sure to show up! All MySQL track sessions are in Maryland C, and all times are Eastern.

On Monday, June 28th from 4 pm – 5:30 pm I will be presenting “What do you mean, SQL Syntax Error?”, a presentation about how MySQL’s SQL syntax extends and deviates from the ANSI/ISO SQL:2003 standard. There is an 80-page PDF accompaniment that will be given out for free during this session.

On Tuesday, June 29th from 11 am to 12 noon I will be presenting Importing and Exporting Data with MySQL, about the many tools to load and bulk load data, and how to export data for regular and bulk loads. I will also be going over which storage engines are particularly well-suited for bulk loading, and the caveats to watch out for. This session is useful for those who know MySQL as well as those asking the question, “What’s the equivalent of Oracle’s SQL Loader for MySQL?”

On Wednesday, June 30th from 8:30 am to 9:30 am I will be presenting Navigating MySQL Stored Procedures & Functions, Views and Triggers, which covers all the ways stored procedures, stored functions, views and triggers can be used, including a highlight of Oracle differences.

I hope to see you there!

On Monday, Ronald Bradford posted that the independent Oracle Developer Tools User Group had opened up their Kaleidoscope Conference, well-known throughout the Oracle community for in-depth technical sessions for developers, to the MySQL community. Giuseppe Maxia posted his thoughts on Tuesday.

We have confirmed that there will be an entire MySQL track at Kaleidoscope! Because Kaleidoscope is less than 8 weeks away, we could not go through a standard call for papers. Ronald and I have been working to come up with appropriate topics and speakers for an audience that uses MySQL but is probably more familiar with Oracle. We contacted folks we thought would be interested, and who we thought could make it logistically, as the conference is in Washington, D.C.

We have (almost) finalized the list of speakers; the session abstracts will be finalized in the next few days. You can see the speakers at Kaleidoscope’s MySQL page, but I’ve also listed them below (alpha by last name):

Philip Antoniades, Sun/MySQL
Ronald Bradford, 42SQL
Sheeri K. Cabral, The Pythian Group
Laine Campbell, PalominoDB
Patrick Galbraith, Northscale
Sarah Novotny, Blue Gecko
Padraig O’Sullivan, Akiba Technologies Inc.
Jay Pipes, Rackspace Cloud
Dossy Shiobara, Panoptic.com
Matt Yonkovic, Percona

There are one or two more speakers we are waiting to hear back from. There will be 19 sessions, so some speakers will have more than one session.

I am very excited that MySQL has its own track at Kaleidoscope. In addition, Ronald and I will be able to attend our very first event as Oracle ACE Directors – the Sundown Sessions are a Birds-of-a-Feather-type discussion, with the Oracle ACE Directors being the panelists and the community asking questions. Immediately after the Sundown Sessions is a “Meet the Oracle ACE” event, the only part of the conference officially sponsored by Oracle.

As the the Icelandic volcano ashes are clearing out and we finally have high hopes of flight home, I want to post the slides of the two presentations I did.

My first presentation was a double slot session about Oracle Clusterware internals. Presenting first thing in the morning on the first day is not easy at this event. Miracle Open World traditionally organized as 160% conference with 80% of technical content and 80% of networking and social interactions. Of course, the last 80% go deep into the night. Needless to say that 5am wake up call was tough — I had to craft few more slides to add some 11gR2 information and publish the first production of We Do Not Use TV Studio.

But I felt surprisingly well and fresh. The presentation itself was quite dynamic and all demos worked as planned except pausing OPROCD — 50/50 that eviction happens during my actions and it took me 10 time to repeat it. I couldn’t recall that I was lucky more than twice in a row until that session but… things happen. You can see the slides below for the reference. However, without the text and demos behind the slides, they are not very useful I’m afraid.

The second presentations was way more difficult for me to carry — not only because it was the topic that I much less proficient with but because the previous night was even longer and more intense with waterpark adventures (and I tell you, it was the best waterpark ever — well done!). The good news is that both I and Graham Wood went to bed at the same time and we had our presentations at the same slot (and I think we consumed comparable amount of magic liquids). Of course, we woke up synchronously and been in sync the whole day including our conditions that we managed to significantly improve before 11:30am when our sessions started. I was afraid that it may turn into disaster but it turned out to be reasonably well especially that I had an excuse if I couldn’t remember what I was talking about — I just reached out for the water and everyone could understand. :)

So my second presentation was about how we designed and run 1TB MySQL database in high availability setup. I’m not a hardcore MySQL DBA but learned enough about it to talk smart things and thanks to my special interest in everything HA, I actually could talk real deal. Slides are here for your reference.

Perhaps, I manage to publish more details and photos from that fantastic conference later so stay tuned. For now, I could tell that it was the longest Oracle conference ever.

Here’s a sneak peek at a video matrix — this is all the videos that include Pythian Group employees at the MySQL conference. I hope to have all the rest of the videos processed and uploaded within 24 hours, with a matrix similar to the one below (but of course with many more sessions).

I’m looking forward to traveling to San Jose for this year’s MySQL Conference. If there’s anything that can trump the drama of conf two years ago, where we observed how Sun would handle it’s new property, and then the drama of last year, where we observed how Oracle would handle the pending acquisition, it’s going to be the drama around this one — the first MySQLConf since the Oracle/Sun merger has been finalized and approved.

I think there is some finality to the changing of the guard this time, since there aren’t really that many companies that could conceivably swallow up Oracle itself! (Maybe I shouldn’t say that — next thing you know they’ll spin it off heh.) But regardless, I am looking forward to getting to know Edward Screven and getting a sense from the keynote and other communications exactly what he’s planning to … DO … with MySQL.

Much as the United Kingdom’s Union Flag is composed of St George’s cross of England layered over St Patrick’s Cross of Ireland, itself layered over St Andrew’s cross of Scotland (look it up it’s cool), Pythian’s history has several technologies and database platforms within it, and Oracle features large in our history as does MySQL.

As a result, unlike some more tentative members of the MySQL Community, I actually love Oracle, the company. I first started using Oracle in 1993 and my specialization in this technology has served me incredibly well in my career. How? Because Oracle has succeeded beyond any possible expectations I had in 1993, and those of us who were there in the early days have grown in our careers alongside the company. Oracle has earned and deserved its’ success in the marketplace, having gotten there by product managing, developing, shipping, marketing and selling software better than any other Enterprise IT software company. It’s been nice to win with Oracle, as a user, as a community member, and as a service provider. They win because they’re great.

I love Sun as well (I owned my first Sun workstation as a 17 year old in 1989. It’s hugeness dominated my tiny University dormroom.) Although I was devastated when Sun jettisoned my beloved SunOS 4.2 for that AT&T derived monstrosity, (a project led by my friend Gordon Kass now at Yahoo by the way – HISS GORDON), my love for the Sun platforms and technologies abides.

Finally, and most importantly in a MySQLConf context, I love MySQL. Pythian first started using MySQL internally in 1998 in the first revision of our Support Track tool. We could not have launched Pythian if we had needed to license Oracle at that juncture! Our formal commercial services launched in 2002 as the dot-com community that we serviced adapted to the realities of the post-bust era. We are, to my knowledge, the only database services vendor who was a Platinum Partner of Sun MySQL unit before the Oracle acquisition and who also has such deep and longstanding roots in the Oracle community (we are an OPN Platinum Partner with many specializations).

I’ve had an idea in mind for a while of a go-forward game plan for Oracle that I felt worked very well with the overall Oracle RDBMS strategy. They’ve made a few moves I expected and a few that I didn’t, so I can’t guess what their exact next move is going to be (but I still have my predictions…). I’ll be waiting, and watching very closely, as I’m sure the rest of you are — it’s going to be very exciting next few months. And as the story unfolds you’ll hear it here first.

Regardless, I think we have some very interesting news pending for announcement at the show, including some announcements about Drizzle. At least, I get the sense Brian’s cooking something up he’s not yet telling me about.

Finally, I’m looking forward to taking the pulse of the community and finding out first hand how we all feel about Oracle, the MySQL organization within Oracle, and the various viable forks including of course our friends Drizzle fork I mentioned above, our friend Monty Widenius’ MariaDB and the builds from our friends at Percona.

These are exciting times for the MySQL Community. I’m incredibly excited about being right in the middle of it, and watching as things unfold from here.

And finally, I am looking forward to catching up and reacquainting myself with old friends and colleagues in the community, and making new friends and colleagues too. If you want to catch up with me at the show, I’ll be easy to find, and generally on top of my email and twitter. Rest assured I’m looking forward to seeing you and do not hesitate to reach out.

A few more notes of note

We’ve got a number of Pythians speaking this year. This post would have been way too long to list them, so we’ve created a separate listing here. As a special side note, we’ll be giving away copies of The MySQL Administrator’s Bible at all of Pythian’s sessions, authored by our very own Sheeri Cabral. Don’t miss out on your chance to win a copy of this must have tool. At the same time, you can shake Sheeri’s hand and congratulate her on becoming the first Oracle ACE Director for MySQL expertise.

We’ll be twittering away at this conference, as we usually are. At least those of us who twitter will be. I always find twitter far more useful during conferences anyway, and since I’ve been able to convert (with some help from @alexgorbachev that is) at least one twitter curmudgeon to using twitter during shows, I may be able to prevail on Rob too!

Anyway, our twitter pages:

• @paulvallee
• @singerwang
• @sheeri

… and I’ll keep you posted as to whether I can get Rob to play ball.

Another good option is just to add our @pythian/tweeters list to your twitter lists (or just click that link), I’m sure during the show most of what we’ll be on about will be conf.

Hope to see you there!

Paul

Last month at the Boston MySQL User Group, I went through the meanings of INNER, LEFT/RIGHT OUTER, CROSS, NATURAL joins, how to do a FULL OUTER JOIN in MySQL, and what STRAIGHT_JOIN means. I also explained how to recognize when you want those types of joins, and best practices for the semantics of writing joins and design patterns. Subqueries were explained in this session, and some examples of how to think differently so that you end up writing JOINs instead of subqueries. The slides (slightly different from the slides in the video — due to error correction) can be found at http://technocation.org/files/doc/2010_01MySQLJoins.pdf.

Here’s the video: