Wednesday Dec 05, 2012

MySQL December Webinars

We'll be running 3 webinars next week and hope many of you will be able to join us:

MySQL Replication: Simplifying Scaling and HA with GTIDs

Wednesday, December 12, at 15.00 Central European Time

Join the MySQL replication developers for a deep dive into the design and implementation of Global Transaction Identifiers (GTIDs) and how they enable users to simplify MySQL scaling and HA. GTIDs are one of the most significant new replication capabilities in MySQL 5.6, making it simple to track and compare replication progress between the master and slave servers.

Register Now

MySQL 5.6: Building the Next Generation of Web/Cloud/SaaS/Embedded Applications and Services

Thursday, December 13, at 9.00 am Pacific Time

As the world's most popular web database, MySQL has quickly become the leading cloud database, with most providers offering MySQL-based services. Indeed, built to deliver web-based applications and to scale out, MySQL's architecture and features make the database a great fit to deliver cloud-based applications. In this webinar we will focus on the improvements in MySQL 5.6 performance, scalability, and availability designed to enable DBA and developer agility in building the next generation of web-based applications.

Register Now

Getting the Best MySQL Performance in Your Products: Part IV, Partitioning

Friday, December 14, at 9.00 am Pacific Time

We're adding Partitioning to our extremely popular "Getting the Best MySQL Performance in Your Products" webinar series. Partitioning can greatly increase the performance of your queries, especially when doing full table scans over large tables. Partitioning is also an excellent way to manage very large tables. It's one of the best ways to build higher performance into your product's embedded or bundled MySQL, and particularly for hardware-constrained appliances and devices.

Register Now

We have live Q&A during all webinars so you'll get the opportunity to ask your questions!

Monday Oct 15, 2012

HERMES Medical Solutions Helps Save Lives with MySQL

HERMES Medical Solutions was established in 1976 in Stockholm, Sweden, and is a leading innovator in medical imaging hardware/software products for health care facilities worldwide. HERMES delivers a plethora of different medical imaging solutions to optimize hospital workflow.

HERMES advanced algorithms make it possible to detect the smallest changes under therapies important and necessary to optimize different therapeutic methods and doses.


  • Fighting illness & disease requires state-of-the-art imaging modalities and software in order to diagnose accurately, stage disease appropriately and select the best treatment available.
  • Selecting and implementing a new database platform that would deliver the needed performance, reliability, security and flexibility required by the high-end medical solutions offered by HERMES.


  • Decision to migrate from in-house database to an embedded SQL database powering the HERMES products, delivered either as software, integrated hardware and software solutions, or via the cloud in a software-as-a-service configuration.
  • Evaluation of several databases and selection of MySQL based on its high performance, ease of use and integration, and low Total Cost of Ownership.
  • On average, between 4 and 12 Terabytes of data are stored in MySQL databases underpinning the HERMES solutions. The data generated by each medical study is indeed stored during 10 years or more after the treatment was performed.
  • MySQL-based HERMES systems also allow doctors worldwide to conduct new drug research projects leveraging the large amount of medical data collected.
  • Hospitals and other HERMES customers worldwide highly value the “zero administration” capabilities and reliability of MySQL, enabling them to perform medical analysis without any downtime.
  • Relying on MySQL as their embedded database, the HERMES team has been able to increase their focus on further developing their clinical applications.
  • HERMES Medical Solutions could leverage the Oracle Financing payment plan to spread its investment over time and make the MySQL choice even more valuable.

MySQL has proven to be an excellent database choice for us. We offer high-end medical solutions, and MySQL delivers the reliability, security and performance such solutions require.” Jan Bertling, CEO.

Tuesday Sep 25, 2012

MySQL Connect in 4 Days - Sessions From Users and Customers

Let’s review today the conference sessions where users and customers will describe their use of MySQL as well as best practices.

Remember you can plan your schedule with Schedule Builder.

Saturday, 11.30 am, Room Golden Gate 7:

MySQL and Hadoop—Chris Schneider,

Saturday, 1.00 pm, Room Golden Gate 7:

Thriving in a MySQL Replicated World—Ed Presz and Andrew Yee, Ticketmaster

Saturday, 1.00 pm, Room Golden Gate 8:

Rick’s RoTs (Rules of Thumb)—Rick James, Yahoo!

Saturday, 2.30 pm, Room Golden Gate 3:

Scaling Pinterest—Yashwanth Nelapati and Evrhet Milam, Pinterest

Saturday, 4.00 pm, Room Golden Gate 3:

MySQL Pool Scanner: An Automated Service for Host Management—Levi Junkert, Facebook

Sunday, 10.15 am, Room Golden Gate 3:

Big Data Is a Big Scam (Most of the Time)—Daniel Austin, PayPal

Sunday, 11.45 am, Room Golden Gate 3:

MySQL at Twitter: Development and Deployment—Jeremy Cole and Davi Arnaut, Twitter

Sunday, 1.15 pm, Room Golden Gate 3:

CERN’s MySQL-as-a-Service Deployment with Oracle VM: Empowering Users—Dawid Wojcik and Eric Grancher, DBA, CERN

Sunday, 2.45 pm, Room Golden Gate 3:

Database Scaling at Mozilla—Sheeri Cabral, Mozilla

Sunday, 5.45 pm, Room Golden Gate 4:

MySQL Cluster Carrier Grade Edition @ El Chavo, Latin America’s #1 Facebook Game—Carlos Morales, Playful Play

You can check out the full program here as well as in the September edition of the MySQL newsletter.

Not registered yet? You can still save US$ 300 over the on-site fee – Register Now!

Monday Sep 24, 2012

MySQL Connect in Only 5 Days – Some Fun Stuff!

We’ve recently blogged about the various MySQL Connect sessions focused on MySQL Cluster, InnoDB, the MySQL Optimizer and MySQL Replication. But we also wanted to draw your attention to some great opportunities to network and have fun! That’s also part of what makes a good conference...

MySQL Connect Reception

San Francisco Hilton - Continental Ballroom

6:30 p.m.–8:30 p.m.

A great opportunity to network with Oracle’s MySQL engineers, partners having a booth in the exhibition hall and just about everyone at MySQL Connect. Long time MySQL users will see many familiar faces, and new users will be able to build valuable relationships. A must attend reception for sure!

Taylor Street Open House

7:00 p.m.–9:00 p.m.

After two intense days at MySQL Connect, you’ll get the chance to relax and continue networking at the Taylor Street Café Open House on Sunday evening. Perhaps recharging batteries for a full week at Oracle OpenWorld…

The Oracle OpenWorld Music Festival

Starting on Sunday eve and running through the entire duration of Oracle OpenWorld, the first Oracle OpenWorld Musical Festival features some of today’s breakthrough musicians. It’s five nights of back-to-back performances in the heart of San Francisco. Registered Oracle conference attendees get free admission, so remember your badge when you head to a show. More information here.

You can check out the full MySQL Connect program here as well as in the September edition of the MySQL newsletter.

Not registered yet? You can still save US$ 300 over the on-site fee – Register Now!

Wednesday Aug 29, 2012

MySQL: Best of Breed Database

Oracle offers best of breed technology at every layer of the stack, from servers and storage to applications.

Discover why MySQL is a best of breed database solution for:

  • Web-based applications, including the next generation of highly demanding web, cloud, mobile and social application
  • Distributed applications requiring a powerful and reliable embedded database
  • Custom and departmental enterprise applications on Windows and other platforms

Check out our Resource Center to get access to white papers and other resources.

And, remember to register for MySQL Connect if you haven’t done so yet. You can still save US$ 300 over the on-site fee – Register Now!

Friday Aug 24, 2012

Interview with Lenz Grimmer about MySQL Connect

Keith Larson: Thank you for allowing me to do this interview with you.  I have been talking with a few different Oracle ACEs   about the MySQL Connect Conference. I figured the MySQL community might be missing you as well. You have been very busy with Oracle Linux but I know you still have an eye on the MySQL Community. How have things been?

Lenz Grimmer: Thanks for including me in this series of interviews, I feel honored! I've read the other interviews, and really liked them. I still try to follow what's going on over in the MySQL community and it's good to see that many of the familiar faces are still around. Over the course of the 9 years that I was involved with MySQL, many colleagues and contacts turned into good friends and we still maintain close relationships.

It's been almost 1.5 years ago that I moved into my new role here in the Linux team at Oracle, and I really enjoy working on a Linux distribution again (I worked for SUSE before I joined MySQL AB in 2002). I'm still learning a lot - Linux in the data center has greatly evolved in so many ways and there are a lot of new and exciting technologies to explore.

Keith Larson: What were your thoughts when you heard that Oracle was going to deliver the MySQL Connect conference to the MySQL Community?

Lenz Grimmer: I think it's testament to the fact that Oracle deeply cares about MySQL, despite what many skeptics may say. What started as "MySQL Sunday" two years ago has now evolved into a full-blown sub-conference, with 80 sessions at one of the largest corporate IT events in the world. I find this quite telling, not many products at Oracle enjoy this level of exposure! So it certainly makes me feel proud to see how far MySQL has come.

Keith Larson: Have you had a chance to look over the sessions? What are your thoughts on them?

Lenz Grimmer: I did indeed look at the final schedule.The content committee did a great job with selecting these sessions. I'm glad to see that the content selection was influenced by involving well-known and respected members of the MySQL community. The sessions cover a broad range of topics and technologies, both covering established topics as well as recent developments.

Keith Larson: When you get a chance, what sessions do you plan on attending?

Lenz Grimmer: I will actually be manning the Oracle booth in the exhibition area on one of these days, so I'm not sure if I'll have a lot of time attending sessions. But if I do, I'd love to see the keynotes and catch some of the sessions that talk about recent developments and new features in MySQL, High Availability and Clustering . Quite a lot has happened and it's hard to keep up with this constant flow of new MySQL releases.

In particular, the following sessions caught my attention:

Keith Larson: So I will ask you just like I have asked the others I have interviewed, any tips that you would give to people for handling the long hours at conferences?

Lenz Grimmer: Wear comfortable shoes and make sure to drink a lot! Also prepare a plan of the sessions you would like to attend beforehand and familiarize yourself with the venue, so you can get to the next talk in time without scrambling to find the location. The good thing about piggybacking on such a large conference like Oracle OpenWorld is that you benefit from the whole infrastructure. For example, there is a nice schedule builder that helps you to keep track of your sessions of interest. Other than that, bring enough business cards and talk to people, build up your network among your peers and other MySQL professionals!

Keith Larson: What features of the MySQL 5.6 release do you look forward to the most ?

Lenz Grimmer: There has been solid progress in so many areas like the InnoDB Storage Engine, the Optimizer, Replication or Performance Schema, it's hard for me to really highlight anything in particular. All in all, MySQL 5.6 sounds like a very promising release. I'm confident it will follow the tradition that Oracle already established with MySQL 5.5, which received a lot of praise even from very critical members of the MySQL community. If I had to name a single feature, I'm particularly and personally happy that the precise GIS functions have finally made it into a GA release - that was long overdue.

Keith Larson:  In your opinion what is the best reason for someone to attend this event?

Lenz Grimmer: This conference is an excellent opportunity to get in touch with the key people in the MySQL community and ecosystem and to get facts and information from the domain experts and developers that work on MySQL. The broad range of topics should attract people from a variety of roles and relations to MySQL, beginning with Developers and DBAs, to CIOs considering MySQL as a viable solution for their requirements.

Keith Larson: You will be attending MySQL Connect and have some Oracle Linux Demos, do you see a growing demand for MySQL on Oracle Linux ?

Lenz Grimmer: Yes! Oracle Linux is our recommended Linux distribution and we have a good relationship to the MySQL engineering group. They use Oracle Linux as a base Linux platform for development and QA, so we make sure that MySQL and Oracle Linux are well tested together. Setting up a MySQL server on Oracle Linux can be done very quickly, and many customers recognize the benefits of using them both in combination.

Because Oracle Linux is available for free (including free bug fixes and errata), it's an ideal choice for running MySQL in your data center. You can run the same Linux distribution on both your development/staging systems as well as on the production machines, you decide which of these should be covered by a support subscription and at which level of support. This gives you flexibility and provides some really attractive cost-saving opportunities.

Keith Larson: Since I am a Linux user and fan, what is on the horizon for  Oracle Linux?

Lenz Grimmer: We're working hard on broadening the ecosystem around Oracle Linux, building up partnerships with ISVs and IHVs to certify Oracle Linux as a fully supported platform for their products. We also continue to collaborate closely with the Linux kernel community on various projects, to make sure that Linux scales and performs well on large systems and meets the demands of today's data centers. These improvements and enhancements will then rolled into the Unbreakable Enterprise Kernel, which is the key ingredient that sets Oracle Linux apart from other distributions. We also have a number of ongoing projects which are making good progress, and I'm sure you'll hear more about this at the upcoming OpenWorld conference :)

Keith Larson: What is something that more people should be aware of when it comes to Oracle Linux and MySQL ?

Lenz Grimmer: Many people assume that Oracle Linux is just tuned for Oracle products, such as the Oracle Database or our Engineered Systems. While it's of course true that we do a lot of testing and optimization for these workloads, Oracle Linux is and will remain a general-purpose Linux distribution that is a very good foundation for setting up a LAMP-Stack, for example. We also provide MySQL RPM packages for Oracle Linux, so you can easily stay up to date if you need something newer than what's included in the stock distribution.

One more thing that is really unique to Oracle Linux is Ksplice, which allows you to apply security patches to the running Linux kernel, without having to reboot. This ensures that your MySQL database server keeps up and running and is not affected by any downtime.

Keith Larson: What else would you like to add ?

Lenz Grimmer: Thanks again for getting in touch with me, I appreciated the opportunity. I'm looking forward to MySQL Connect and Oracle OpenWorld and to meet you and many other people from the MySQL community that I haven't seen for quite some time!

Keith Larson:  Thank you Lenz!

Friday Aug 10, 2012

Interview with Giuseppe Maxia "the datacharmer" about MySQL Connect

Keith Larson: Thank you for allowing me to do this interview with you. What have you and Continuent been up to lately?

Giuseppe Maxia:  Hi Keith. It's my pleasure.  I (and the whole team at Continuent) have been quite busy releasing version 1.5.1 of our flagship clustering and HA product, Tungsten Enterprise. Apart from the pleasure of the growing business that makes us all very happy, we enjoy the rare geeky joy of working at a product at the highest levels of innovation and technical effectiveness.

 I am also happy, at a personal level, because my current job keeps me in touch with the MySQL community. The products that we develop, both the open source and the commercial solutions, depend heavily on the ubiquity of MySQL. When I dedicate some time to the MySQL community, I am doing at the same time something that I like and that is ultimately beneficial for my company's business. For this reason, my company has no objections to my work in open source projects that I started long ago, such as MySQL Sandbox.

Keith Larson: MySQL Sandbox is great, thank you for that!

Giuseppe Maxia:You're welcome! This one of the many MySQL related open projects that are maintained by community members. The MySQL world is a better place thanks to this distributed effort.

Keith Larson: What were your thoughts when you heard that Oracle was going to provide the community the MySQL Conference ?

Giuseppe Maxia: I had mixed feelings. On one hand, I was happy that Oracle has dedicated more attention to the MySQL community, by creating this event. On the other hand, I was a bit taken aback, because the decision to organize MySQL Connect came at the same time when Oracle made it known that it was not sending anyone to the April conference in Santa Clara. I understand very well the reasoning. That conference is organized by a competitor, and Oracle didn't want to help a competing business. However, there were more than one thousand MySQL users at that event, and many of them would have been quite pleased to meet and listen to Oracle engineers.

I also understand that Oracle wants to give the MySQL community a proper home within its conference infrastructure. All in all, I consider MySQL Connect a positive step in the right direction. I hope and expect that MySQL Connect will grow in next editions, and that Oracle will offer an event that matches the scope of MySQL conferences that we are used to in the past.

Keith Larson: Since you are part of the content committee, what did you think of the submissions that were received during call for papers?

Giuseppe Maxia:  Reviewing the submissions for this event was a difficult task. We had to limit the entries to the allotted number of sessions (56), and thus we had to leave out many proposals that would have been quite nice to have in a conference. The level of the proposals was quite high. In my initial screening, I found about 90 sessions that I wanted to get in, and the hard was to cut off the ones over the quota.

Keith Larson: What sessions do you look forwarding to attending?

Giuseppe Maxia: Surely I will attend most of the sessions where Oracle engineers explain the latest features and improvements of MySQL products. I will also attend sessions by other professionals who talk about my fields of interest, namely replication, high availability, performance, cloud integration.

Keith Larson: How do you feel the MySQL Community has changed in the recent years ? Do you feel it is different outside of the United States?

Giuseppe Maxia: The MySQL community has grown. In several directions. The community has followed many leads. There were some prophets of doom that announced the death of MySQL. They gathered credit because sometimes the ones who shout louder get more followers, regardless of their merits.
 There were more people, including several Oracle competitors, who believed that Oracle doesn't have any interest in killing MySQL, and instead it will be better off keeping MySQL alive and thriving. Which is what Oracle has been doing in the last few years, quite effectively so! The way I see it, the MySQL community is getting the message that MySQL is improving under Oracle stewardship, and concentrating on practicalities rather than philosophical diatribes.

 The places where the masses are less inclined to being practical and keep pursuing forks and changes for the sake of it are in the associated communities, those that depend in some extent by MySQL, or where MySQL is an important component, like content management projects, Linux distros, language infrastructures. I often see discussions that say "we should abandon MySQL and use instead a fork, because Oracle can't be depended upon for keeping the project alive." There is no amount of reasoning that can be injected in discussion that start by denying the current evidence, so I know that the community will keep this state of fluidity for a while.
 I haven't attended many events in Europe this year, so my feelings are based on what I see online. I feel that the community in the US is being more empirical than in Europe.

 My personal stand is that as long as Oracle keeps the work on MySQL to the current level, there is no need to worry for the open source community about the fate of MySQL.

Keith Larson: What features of MySQL 5.6 do you look forward to the most ?

Giuseppe Maxia: The improvement on the binary logging API and replication are among the most interesting ones. There are the obvious advances in performance, which everyone should expect from a new MySQL release. I have tested MySQL 5.6 replication features quite a lot. At the time of my testing (in April), there were some gaps in the integration between the main features. I hope such gaps will be filled in the final release.

Keith Larson: Would you consider the MySQL 5.6 release a major/big step forward in terms of Replication ?

Giuseppe Maxia: MySQL 5.6 is certainly a big step forward. I am cautious about its final outcome, as I have mentioned above, since I wait to see if the new features will become better integrated among them and with the rest of the server. There are great features, but you surely know that MySQL has historically had integration problems with new code, which sometimes resulted in the so-called "half-baked features."  I am not saying that this is the case with 5.6, but my first tests show that some features do not play well with the others in the same release. To give you an example: we have Global Transaction ID (GTID) and multi-thread slaves. If you enable GTID, the multi thread slaves still keep track of their work using binary log file names and position. This is the status for 5.6.5. I don't know if it has already been addressed.

Keith Larson:You attend a lot of conferences. What would you recommend for people who attend this conference.

Giuseppe Maxia: There are two main benefits by attending this kind of conferences: the first and most obvious is what you get by attending well selected sessions. The second, and sometimes more productive benefit is given by meeting other people who share your interests, and exchanging views with them. I would say that I have learned as much during social events and corridor chats as at the sessions themselves. The greatest benefit of this conference is the chance of talking with the people who work at the products that we use on a daily basis, and give them feedback about our experience.

Keith Larson: Since your often speaker at conference, what would you consider the ideal audience? What do you want or prefer from them?

Giuseppe Maxia: I am a geek. As such, I love talking to technically oriented users. It's very rewarding when you can address an advanced audience about demanding topics. But I also like explaining things to beginners. I remember my learning curve when I was a rookie, and I try to give my audience what I would have liked to get when I was in their position. So, while my ideal audience is a crowd of hackers, I feel perfectly at home talking to a roomful of motivated beginners.
 What I would like from my audience is to be inquisitive, and not to take anything for granted. When I talk at a conference, I often learn something new from the audience questions. For this reason, I encourage questions at any time during my presentations, unless the time is really short.

Keith Larson: So any tips you would give to people for handling the long hours at conferences?

Giuseppe Maxia: The first thing to do is getting organized by knowing what sessions you want to attend. Once you prioritize what you can't possibly miss, you can start organizing the rest of the time. There is no obligation to attend a session if there is nothing that appeals to you in a give slot. No need to feel guilty if you skip one slot to do something else, like visiting the expo hall or meeting friends. However, you should get organized, so you won't waste time.
 It's quite effective using Twitter with appropriate hashtags before and during the conference, to find people you know and to meet new ones with the same interests. Reading blogs and forums in the weeks before the conference will give you most of the ideas. For the ones who didn't do their homework, hanging around the MySQL community booth can give you useful information about who's there, what's going on, and what you can do productively in the next 50 minutes.

Keith Larson: What would you consider to be the top argument to persuade a boss to allow you to attend MySQL Connect?

Giuseppe Maxia:  It's the conference where we meet the creators of MySQL. If this is the main tool for our company, that's the place where we need to go to get first hand information. Besides, San Francisco is a great place!

Keith Larson: Anything else you want to add...

Giuseppe Maxia:  I am glad that Oracle is keeping the doors open for the MySQL community. My personal opinion is that it can open way more than that, and I hope that such further opening will happen in the time being. As an Oracle ACE Director, I feel it's my duty to smooth the path in that direction, by advising Oracle on what the community expects, and by giving objective and useful information to my fellow community members.
 I wish to see a 4 days MySQL event next year!

Friday Jul 27, 2012

Interview with Sarah Novotny about MySQL Connect

Dave Stokes and I tracked down Sarah Novotny Sunday night at the early bird registration for OSCON 2012. We had a few moments to interview her about MySQL Connect and her recent endeavors. I hope you enjoy:

Keith Larson: Thank you for joining us today.

Sarah Novotny: I am glad to be here.

Keith Larson: First just a general question, What were your thoughts when you heard that Oracle was going to do MySQL Connect ?

Sarah Novotny: I was very excited about it. I didn't expect Oracle to give us our own space. Even thought JavaOne had gotten that . JavaOne has existed as it's own conference before, and with the O'Reilly Conference no longer happening,  I didn't expect it and I was surprised. I know the first year after Oracle purchased MySQL, we had MySQL Sunday, which was great. We were told that this was such a big deal and it is really only a transition thing and with 140+ products nobody gets a big name like that. So when MySQL Connect came out I was very excited.

Keith Larson: Since we pulled you in as part of the MySQL Committee, what did you think of all the sessions that you saw or reviewed.

Sarah Novotny: The session looked very good. I always hope for more sessions and more opportunities to look through good sessions. That is one of the reasons I sit on conference committees, so I can learn about all the cool stuff people are working on. The sessions where pretty broadly varied and I was very excited to be able to also build some little story arcs within topics. So you could have a couple of replication sessions or a couple of backup sessions that all feed onto one another. So from story point, from the creation of the conference, there was some very interesting threads to follow through in order to get a really robust experience for people, both beginner, intermediate and advanced levels.

Keith Larson: So based on the story arcs you spoke of and saw, what type of session do you look forward to attending while your there?

Sarah Novotny: I am a total replication geek, because that is the way that you can maintain sanity within MySQL, making sure you have good replication. I love seeing all the way that people can replicate, really interesting architectures in order to meet the needs that they have for their application. So with the new replication features coming out in 5.6 it is very exciting. So the focus for me is MySQL 5.6 and the replication features in it.

Keith Larson: So I was going to ask what features do you look forward to the most in MySQL 5.6, I assume replication is it.

Sarah Novotny: Replication is a big one. There have been a lot of enhancements that have been a long time coming. We've seen them in the code tree and out there for integration to mainline someday and now we see them coming to fruition. So it is very exciting for me.

Keith Larson: You obviously travel a tremendous about of time and attend a lot of conferences. What would you recommend for people who attend this conference.

Sarah Novotny: I would recommend a couple of things. One, find that story that you want to learn at a conference. Maybe it is replication so you find three or four talks about that. Understanding what your goal is out of a conference is very important. Then making sure you have time to meet people,interact with people, ask questions, teach someone something, be able to have those interactions face to face with the community members that you know from blog posts or your support roles with Oracle. So, make sure that you make time to interact with people directly and always take advantage of the speakers. Most of the speakers who are up in front of an audience want to be engaging of the audience, you want to be understanding of what they need from your talk, and then how to engage with them to make a better talk next time.

Keith Larson: As a speaker at many events, you encourage the people to ask questions and ask questions afterwards.

Sarah Novotny: Absolutely, I actually have a couple of talks on giving presentations to technologists, to and by technologists. In those I often talk a lot about looking at the people that are engaged and even the disengaged ones. But not to spend to much time on the disengaged ones, they might have a sick kid and that is why they are texting and it has nothing to do with you. As an audience, being engaged with the speaker is part of your responsibility as well. Making sure you get what you need out of it, which could be asking questions afterwards or sending a note saying you liked it or that you didn't it, or I was interested in more things like this.

Keith Larson: So any additional tips you would give to people for handling the long hours at conferences, we typically have BOFs and after hour events as well so...

Sarah Novotny: I will give you my trick for surviving OSCON, which for me is like a ten day extravaganza . I start resting up the weekend up before. I make sure I get ten to twelve hours of sleep the two or three nights before OSCON. Then midweek I make sure I have night that I carve out time for myself. I put nothing on it. The other thing is, and this might sound absurd, but stay hydrated eat your vegetables. A salad will do wonders for your stamina in the middle of the week. It is very much just about taking care of your robot in that sense. Your brain might be willing and excited but if your body can't do it then your not going to enjoy it or even retain it. For the introverts among us, make sure you carve out quite time for you. It is important, otherwise I get way overloaded.

Keith Larson: So you have been very busy as of lately, we caught you after the big sale.

Sarah Novotny: I have, I have a couple of new exciting things yes. Blue Gecko was sold to datAvail which is very exciting. For me it is a very lovely , I founded it, I helped run it, I sold. It looks like a very nice little bow on the resume . We are making sure it is a smooth transition for the Blue Gecko internal staff as well as the external customers. We worked a long time to be able to sell this and yet still be able to maintain our culture.

Keith Larson: So are you going to go buy an island now?

Sarah Novotny: OH we will see... Terms have been undisclosed. (laughter) On a serious note, my day job which has been keeping me busy for the rest of my time, is of course Video Game Publishing. Which is going to be a lot of fun and really exciting. It is a big left turn for me but looks to be fun.

David Stokes: So if your Joe or Josephine DBA and trying to make the case to your boss to attend MySQL Connect. What is the killer argument as a boss that you would take from an employee to attend this show.

Sarah Novotny: I think what I would actually say is that this is a very important element of professional development for a few different reasons. One I get exposed to new content. Two I find additional resources that could include new people I meet that help me learn more about new content or websites or blogs I should read. Three, it gives me an opportunity to be an evangelist for my company. Four, I can recruit, trying to find a new DBA is harder than finding the Easter bunny. Everyone I know has changed jobs in the last year for reasonably large increases in salary so they are not going to jump again. It is like pulling hen's teeth.

David Stokes: Yes I have recruiters that offer money if I know anyone and I just don't.

Sarah Novotny: Yes I get that like four times a week and I just don't know anyone who is looking.

David Stokes: Anything else you want to add...

Sarah Novotny: Rock on ! I do want to say thank you to you guys for doing the community work that you do and pulling us all together.

Keith Larson & David Stokes: Oh no, thank you.

Wednesday Jun 27, 2012

Interview with Ronald Bradford about MySQL Connect

Ronald Bradford,  an Oracle ACE Director has been busy working with  database consulting, book writing (EffectiveMySQL) while traveling and speaking around the world in support of MySQL. I was able to take some of his time to get an interview on this thoughts about theMySQL Connect conference.

Keith Larson: What where your thoughts when you heard that Oracle was going to provide the community the MySQL Conference ?

Ronald Bradford: Oracle has already been providing various different local community events including OTN Tech Days and  MySQL community days. These are great for local regions both in the US and abroad.  In previous years there has been an increase of content at Oracle Open World, however that benefits the Oracle community far more then the MySQL community.  It is good to see that Oracle is realizing the benefit in providing a large scale dedicated event for the MySQL community that includes speakers from the MySQL development teams, invested companies in the ecosystem and other community evangelists.

I fully expect a successful event and look forward to hopefully seeing MySQL Connect at the upcoming Brazil and Japan OOW conferences and perhaps an event on the East Coast.

Keith Larson: Since you are part of the content committee, what did you think of the submissions that were received during call for papers?

Ronald Bradford: There was a large number of quality submissions to the number of available presentation sessions. As with the previous years as a committee member for the annual MySQL conference, there is always a large variety of common cornerstone MySQL features as well as new products and upcoming companies sharing their MySQL experiences.

All of the usual major players in the ecosystem will in presenting at MySQL Connect including Facebook, Twitter, Yahoo, Continuent, Percona, Tokutek, Sphinx and Amazon to name a few.  This is ensuring the event will have a large number of quality speakers and a difficult time in choosing what to attend.

Keith Larson: What sessions do you look forwarding to attending?

Ronald Bradford: As with most quality conferences you can only be in one place at one time, so with multiple tracks per session it is always difficult to decide. The continued work and success with MySQL Cluster, and with a number of sessions I am sure will be popular. The features that interest me the most are around the optimizer, where there are several sessions on new features, and on the importance of backups. There are three presentations in this area to choose from.

Keith Larson: Are you going to cover any of the content in your books at your MySQL Connect sessions?

Ronald Bradford: I will be giving two presentations at MySQL Connect. The first will include the techniques available for creating better indexes where I will be touching on some aspects of the first Effective MySQL book on Optimizing SQL Statements.  In my second presentation from experiences of managing 500+ AWS MySQL instances, I will be touching on areas including SQL tuning, backup and recovery and scale out with replication.   These are the key topics of the initial books in the Effective MySQL series that focus on performance, scalability and business continuity.  The books however cover a far greater amount of detail then can be presented in a 1 hour session.

Keith Larson: What features of MySQL 5.6 do you look forward to the most ?

Ronald Bradford: I am very impressed with the optimizer trace feature. The ability to see exposed information is invaluable not just for MySQL 5.6, but to also apply information discerned for optimizing SQL statements in earlier versions of MySQL.  Not everybody understands that it is easy to deploy a MySQL 5.6 slave into an existing topology running an older version if MySQL for evaluation of many new features.  You can use the new mysqlbinlog streaming feature for duplicating master binary logs on an older version with a MySQL 5.6 slave.  The improvements in instrumentation in the Performance Schema are exciting.   However, as with my upcoming Replication Techniques in Depth title, that will be available for sale at MySQL Connect, there are numerous replication features, some long overdue with provide significant management benefits. Crash Save Slaves, Global transaction Identifiers (GTID)  and checksums just to mention a few.

Keith Larson: You have been to numerous conferences, what would you recommend for people at the conference?

Ronald Bradford: Make the time to meet and introduce yourself to the speakers that cover the topics that most interest you. The MySQL ecosystem has a very strong community.  The relationships you build with presenters, developers and architects in MySQL can be invaluable, however they are created over time. Get to know these people, interact with them over time.  This is the opportunity to learn more then just the content from a 1 hour session.

Keith Larson: Any additional tips to handling the long hours ?

Ronald Bradford: Conferences can be hard, especially with all the post event drinking.  This is a two day event and I am sure will include additional events on Friday and Saturday night so come well prepared, and leave work behind. Take the time to learn something new.   You can always catchup on sleep later.

Keith Larson: Thank you so much for taking some time to do this I look forward to seeing you at the MySQL Connect conference.

 Please stay tuned here for more updates on MySQL. 

Monday Jun 25, 2012

Meet The MySQL Experts Podcast: MySQL Utilities

Managing a MySQL database server can become a full time job. In many occasions, one MySQL DBA needs to manage multiple, even tens of, MySQL servers, and tools that bundle a set of related tasks into a common utility can be a big time saver, allowing you spend more time improving performance and less time executing repeating tasks. While there are several such utility libraries to choose, it is often the case that you need to customize them to your needs. The MySQL Utilities library is the answer to that need. It is open source so you can modify and expand it as you see fit.

In the latest episode of the "Meet the MySQL Experts" podcast series, Chuck Bell, Sr. MySQL Software Developer at Oracle, introduces a variety of recently released MySQL Utilities, and how DBAs can save significant time using the utilities.

Listen to the podcast and learn the highlights in 10 minutes. If you want to gain further details, attend the on-demand webinar for a more complete introduction, including:

  • Use cases for each utility
  • How to group utilities for even more usability
  • How to modify utilities for your needs
  • How to develop and contribute new utilities


Wednesday May 23, 2012

Thanks to the MySQL Connect Content Committee

A big thanks goes out to everyone involved with the MySQL Connect Content Committee. We had a great response to the call for papers and realize that it took a considerable amount of time and effort to review the submitted sessions and BOFs. While Oracle employees aided with this effort, the MySQL Community deserves to be acknowledged for the time they took out of their busy schedules to help with our conference. Their input was invaluable to the support of the MySQL Community. Continued support such as this from the community is another reason that MySQL continues to be #1 open source database. We'll keep you posted as we finalize and publish the sessions, BoFs and HOLs for MySQL Connect.

Thanks to the following committee members:

MySQL Community:

Oracle Employees:

Wednesday May 09, 2012

Case Study: Waiting Room Solutions Relies on MySQL for Web-Based Medical Management Systems

Waiting Room Solutions (WRS) is an award-winning web-based Electronic Medical Records (EMR) and Practice Management System for physicians’ offices. Based in Goshen, NY, WRS serves almost 3,000 users for their needs in charting, medical record filing, payment tracking, prescription and reporting via the SaaS (Software as a Service) model, and WRS has sent over 20,000 electronic prescriptions a month over its secure network.

The Business Challenge

WRS was looking for a robust database for enterprise-class web-based applications with the following features:

1. Security

Medical records and health information are highly confidential, and WRS expected to be fully incompliance with privacy regulations such as the HIPAA Privacy Rule.

2. Data Integrity

It is important to minimize data corruption and inconsistency for medical records, because they directly impact critical medical judgment and decisions.

3. Speed/Performance

Doctors work in a fast-paced environment and are not known for being patient. WRS was looking for a database with high performance, and was aiming to deliver the speed of an on-premise system with the SaaS model.

4. Low Cost and Scalability

WRS serves customers ranging from small practices to large enterprises. Therefore, WRS needed a database solution that was affordable to the smallest healthcare provider, while being able to scale to meet the demands of the largest providers who have hundreds of facilities.

The MySQL Solution

WRS evaluated both MySQL and PostgreSQL for its EMR and Practice Management System, and decided to use MySQL for the following reasons:

1. Ubiquity

MySQL is the world’s most popular open-source database with millions of installations. It is widely used and is a proven technology.

2. Better Support

In addition to the community users who actively share knowledge and best practices, it was also important for WRS to know that there is an enterprise behind the product that they can turn to for help if needed. MySQL was created by MySQL AB, and subsequently was developed and improved by Sun Microsystems and now Oracle through acquisitions.It provides WRS with Scalability.

3. Open Source / Open Standard

MySQL is the “M” in the open-source LAMP (Linux, Apache, MySQL and PHP/Python/Perl) stack. By leveraging and integrating the existing open-source technology, WRS was able to develop products and features more quickly, and with better interoperability.

WRS uses MySQL replication to achieve scalability, deploying the master-slave topology. “With MySQL, we can scale as we need. I can install it on many machines and handle any required volume,” said Brad Hall, Systems Administrator at WRS. “This gives us far more flexibility with hardware.” Three primary slaves all have to handle the volume of over 6,000 queries per second throughout the day, and WRS uses partitioning to increase speed.

With MySQL, WRS was able to develop a modular EMR and Practice Management solution to support thousands of medical practices, with the following features: electronic medical and health records; billing; scheduling; electronic prescriptions; online patient registration; practice website; messaging; order tracking; transcription; document management; and disease management. “We required an open source solution that was well maintained, stable, and actively growing. In addition, we required a solution that offered access to enterprise support when needed. MySQL was the right choice for us,” said Hall. “The performance, scalability, and reliability delivered by MySQL with InnoDB has been excellent.”

Learn more about Waiting Room Solutions:

Read more MySQL customer stories:

Monday Apr 30, 2012

OTN Developer Day: MySQL - New York

If you have not signed up yet for the OTN Developer Day: MySQL in NYC, hurry time is running out! This is shaping up to be one of the largest developer days yet. We have a great line up of speakers. I look forward to seeing them and a great community turn out Wednesday.

You can review the agenda here and register here.

Friday Apr 13, 2012

The Ubuntu Developer Summit

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:

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. 


Get the latest updates on products, technology, news, events, webcasts, customers and more.




« July 2016