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!

Monday Aug 27, 2012

Tap into MySQL's Amazing Performance Results with the Performance Tuning Course

Want to leverage the high-speed load utilities, distinctive memory caches, full text indexes, and other performance-enhancing mechanisms that MySQL offers to fuel today's critical business systems.

The authentic MySQL Performance Tuning course, in 4 days, teaches you to evaluate the MySQL architecture, learn to use the tools, configure the database for performance, tune application and SQL code, tune the server, examine the storage engines, assess the application architecture, and learn general tuning concepts.

You can take this course in one the following three ways:

  • Training-on-Demand: Access the streaming video, instructor delivery of this course from your own desk, at your own pace. Book time for hands-on practice when it suits you.
  • Live-Virtual Class: Take this instructor-led class live from your own desk. With 700 events on the schedule you are sure to find a time and date to suit you!
  • In-Class: Travel to a classroom to take this class. A sample of events on the schedule are as follows.

 Location

 Date

 Delivery Language

 Hamburg, Germany

 22 October 2012

 German

 Prague, Czech Republic

 1 October 2012

 Czech

 Warsaw, Poland

 3 December 2012

 Polish

 London, England

 19 November 2012

 English

 Rome, Italy

 23 October 2012

 Italian

Lisbon, Portugal 

6 November 2012 

European Portugese 

Aix en Provence, France 

4 September 2012 

 French

 Strasbourg, France

16 October 2012 

 French

 Nieuwegein, Netherlands

26 November 2012 

 Dutch

 Madrid, Spain

17 December 2012 

 Spanish

 Mechelen, Belgium

 1 October 2012

 English

 Riga, Latvia

 10 December 2012

 Latvian

 Petaling Jaya, Malaysia

 10 September 2012

English 

 Edmonton, Canada

10 December 2012 

 English

 Vancouver, Canada

10 December 2012 

 English

 Ottawa, Canada

26 November 2012 

 English

 Toronto, Canada

26 November 2012 

 English

 Montreal, Canada

26 November 2012 

 English

 Mexico City, Mexico

10 September 2012 

 Spanish

 Sao Paolo, Brazil

26 November 2012 

Brazilian Portugese 

 Tokyo, Japan

19 November 2012 

 Japanese

 Tokyo, Japan

 19 November 2012

 Japanese

For further information on this class, or to register your interest in additional events, go to the Oracle University Portal: http://oracle.com/education/mysql

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!


Tuesday Aug 21, 2012

Upcoming MySQL Events in EMEA

Oracle’s MySQL team is running a series of 10 events across EMEA in the fall with the theme "Scale with MySQL".

The dates and countries are as follows, and detailed information is provided on each individual event’s page:

We hope to see you there!

Additionally, remember to register for MySQL Connect if you haven’t done so yet. You can still save US$ 500 by signing up before Friday August 24 – Register Now!

Monday Aug 20, 2012

Learn about the Real-Time Performance and High Availability of MySQL Cluster

If you need 99.999% availability, real-time performance, auto-sharding and write scalability, geographic replication - using SQL and NoSQL applications then you should learn more about MySQL Cluster.

The authentic MySQL Cluster course brings you key conceptual and configuration information in a 3 day instructor led class.

Examples of class events already on the schedule:

 Location

 Date

 Delivery Language

 Prague, Czech Republic

 10 December 2012

 Czech

 Warsaw, Poland

 3 September 2012

 Polish

 London, England

 12 December 2012

 England

 Lisbon, Portugal

 3 December 2012

 European Portugese

 Nice, France

 8 October 2012

 French

Barcelona, Spain 

 25 September 2012

 Spanish

 Madrid, Spain

6 November 2012 

Spanish 

 Denver, Colorado

 17 October 2012

 English

 Petaling Jaya, Malaysia

 10 October 2012

 English

 Singapore

 19 September 2012

 English

 Sao Paolo, Brazil

 24 September 2012

 Brazilian Portugese

To see the full schedule and course details or to register interest in an additional event, go to http://oracle.com/education/mysql

Thursday Aug 16, 2012

Meet The MySQL Experts Podcast: SQL Server Migration Tool

We recently released a new migration tool for Microsoft SQL Server to MySQL, along with additional tools and features improving the MySQL user experience on Windows.

In the latest episode of our "Meet The MySQL Experts" podcast, Alfredo Kojima, Senior Software Development Manager, talks to us about the new migration tool.

Enjoy the podcast!

To learn more about SQL Server to MySQL migrations, MySQL on Windows and numerous other MySQL topics, register for MySQL Connect if you haven’t done so yet. You can still save US$ 500 by signing up before Friday August 24 – Register Now!

Wednesday Aug 15, 2012

Plan Your MySQL Connect Conference With Schedule Builder

Schedule Builder allows you to effectively plan your conference and pre-enroll in MySQL Connect sessions. For instance, don’t miss the keynotes including:

The State of The Dolphin

Join Oracle Executive Vice President Edward Screven and MySQL Vice President of Engineering Tomas Ulin to hear about Oracle’s MySQL strategy, and the key latest developments including product releases, roadmap and community.

 

MySQL Perspectives

Join us for an exciting keynote featuring power users of MySQL, including speakers from PayPal, Twitter, and Verizon, who will share with you their experiences and perspectives.

 


Search the content catalog to find out about the different conference sessions, Birds-of-a-Feather, Hands-On Labs and reserve your seat.

Not registered for MySQL Connect yet? You can still save US$500 by signing up before Friday August 24! Don’t Miss this opportunity to boost your MySQL skills – Register Now!

Sponsorship and exhibit opportunities are still available for the conference. You will find more information here.

Monday Aug 13, 2012

Start Here on MySQL

Get started on the world's most popular open source database by taking the MySQL for Beginners training course. Students who have taken this 4 day course have described it as "perfect", "very useful", "just what I needed".

This instructor-led hands-on class covers the fundamentals of SQL and relational databases, introducing you to MySQL tools and features.

Take this class at a time and place adapted to you:

  • From your home or office at a time suits you: With Training-on-Demand you can get started within 24-hrs with instructor delivery and hands-on exercises when you choose
  • From your home or office at one of the 528! scheduled events: With the Live-Virtual delivery you attend a live instructor delivery without any travel costs
  • At a teaching center: A sample of the events scheduled in different locations/languages is shown below:

 Location

 Date

 Delivery Language

 Warsaw, Poland

 24 September 2012

 Polish

 Dublin, Ireland

 15 October 2012

 English

 London, England

 11 September 2012

 English

 Rome, Italy

 5 November 2012

 Italian

 Hamburg, Germany

 3 December 2012

 German

 Lisbon, Portugal

 5 November 2012

 European Portugese

 Amsterdam, Netherlands

 10 December 2012

 Dutch

 Barcelona, Spain

 5 November 2012

 Spanish

 Riga, Latvia

 12 November 2012

 Latvian

 Petaling Jaya, Malaysia

 22 October 2012

 English

 Ottawa, Canada

 17 December 2012

 English

 Toronto, Canada

 17 December 2012

 English

 Montreal, Canada

 17 December 2012

 English

 Sao Paolo, Brazil

 11 September 2012

 Brazilian Portugese

For further information on the MySQL curriculum, visit the Oracle University portal at http://oracle.com/education/mysql

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!

Monday Aug 06, 2012

Take the Authentic MySQL for DBA Course Near You!

The MySQL for Database Administrator course teaches you to secure users privileges, set resource limitations, access controls and describe backup and recovery basics. You also learn to create and use stored procedures, triggers, views and more. For the full course description go to the Oracle University portal and click on MySQL.

You can take this course:

- From your desk, at your own pace, as a Training-on-Demand offering - streaming video of instructor delivery, plus access to course environment to perform lab exercises

- From your desk, as a Live-Virtual Class - connecting with the instructor and other students through webex and phone, with access to course environment for lab exercises. There are hundreds of events scheduled so you can choose the date, timezone and language that suits you. See the full schedule on the Oracle University portal.

- In a classroom, with a sample of locations, dates and delivery language for scheduled events below:

 Location

 Date

 Delivery Language

 Budapest, Hungary

 3 December, 2012

 Hungarian

 Prague, Czech Republic

 27 August, 2012

 Czech

 Warsaw, Poland

 3 September, 2012

 Polish

 Istanbul, Turkey

 27 August, 2012

 Turkish

 Belfast, Ireland

 26 November, 2012

 English

 Bristol, England

 8 October, 2012

 English

 London, England

 1 October, 2012

 English

 Nice, France

 24 September, 2012

 French

 Paris, France

 24 September, 2012

 French

 Milan, Italy

 3 September, 2012

 Italian

 Rome, Italy

 17 September, 2012

 Italian

 Turin, Italy

 8 October, 2012

 Italian

 Lisbon, Portugal

 3 September, 2012

 European Portugese

 Oslo, Norway

 10 September, 2012

 English

 Nieuwegein, Netherlands

 1 October, 2012

 Dutch

 Barcelona, Spain

 3 September, 2012

 Spanish

 Madrid, Spain

 19 November, 2012

 Spanish

 Windhof, Luxembourg

 26 November, 2012

 English

 Petaling Jaya, Malaysia

 26 September, 2012

 English

 Auckland, New Zealand

 10 September, 2012

 English

 Brisbane, Australia

 24 September, 2012

 English

 Melbourne, Australia

 27 August, 2012

 English

 Edmonton, Canada

 10 September, 2012

 English

 Vancouver, Canada

 10 September, 2012

 English

 Ottawa, Canada

 22 October, 2012

 English

 Toronto, Canada

 22 October, 2012

 English

 Montreal, Canada

 22 October, 2012

 English

 Caracas, Venezuela

 20 August, 2012

 Spanish

 Sao Paulo, Brazil

 13 August, 2012

 Brazilian Portugese

 Mexico City, Mexico

 27 August, 2012

 Spanish

For more information on the Authentic MySQL Curriculum or to register interest in an additional event, go to the OU portal and choose MySQL.

About

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

Twitter


Facebook

Search

Archives
« August 2012 »
SunMonTueWedThuFriSat
   
1
2
3
4
5
7
8
9
11
12
14
17
18
19
22
23
25
26
28
30
31
 
       
Today