Tuesday Aug 26, 2014

MySQL at the Malaysian OpenSource Conference

MySQL team attends and speaks at the MOSC 2014 on September 24-25, 2014 in Kuala Lumpur, Malaysia. We are having a MySQL booth and above that our local colleague Ricky Setyawan has secured one 45 minutes talk scheduled for Wed, Sep 24 @2:15-3:00pm on the MySQL Web Reference Architecture.

We will also run two hours workshop on MySQL Fabric scheduled for Thursday, Sep 25 @2:30-4:30pm. If you are around do not forget to come to our booth and/or visit our MySQL session & workshop!

Tuesday Aug 12, 2014

Top 10 Reasons to Attend MySQL Central @ OpenWorld

MySQL Central @ OpenWorld is less than 7 weeks away, have you registered?

The event represents a unique opportunity to boost your MySQL skills and hear from Oracle's MySQL engineers along with customers, partners and MySQL community members.

Here are the top 10 reasons why you should join us:

  • Better understand Oracle's MySQL strategy. Hear straight from the source how Oracle is driving MySQL innovation, and what are the latest news and plans.
  • Meet the engineers developing and supporting the MySQL products. You'll have the opportunity to ask them all your questions, which can save you significant time and money.
  • Learn about real-world experiences from other organizations. You'll hear from MySQL experts at Facebook, Twitter, Dropbox, Booking.com, Ticketmaster, Yahoo! and others.
  • Acquire in-depth knowledge about InnoDB, best of both worlds "SQL & NoSQL" strategies, MySQL Fabric, MySQL Cluster, performance and scalability tuning, security and numerous other topics.
  • Take a deep dive into MySQL Fabric, MySQL Replication, Getting started with MySQL and more with 6 tutorials.
  • Get hands-on experience using MySQL EXPLAIN, MySQL Utilities or the new MySQL Workbench performance tools with eight different Hands-On Labs.
  • Express your ideas and engage into great discussions during six Birds-of-a-feather sessions about InnoDB, High Availability, Backup, GIS and other topics.
  • Immerse yourself into the MySQL universe and network with MySQL experts for several days. You’ll love the passion and the energy, and you’ll likely get many new ideas.
  • Access all of the Oracle OpenWorld keynotes and extensive content.
  • Have fun! You’ll meet both old and new faces, have a lot of fun during the OpenWorld and MySQL receptions, and be able to enjoy world-class entertainment.

Don’t miss out on this great opportunity, Register Now to save US$200 over the onsite price!

We look forward to seeing you at MySQL Central @ OpenWorld!

Tuesday Jul 08, 2014

MySQL Central @ OpenWorld Keynotes

A few weeks ago we announced the availability of the MySQL Central @ OpenWorld content catalog.

We're now pleased to announce additional keynotes delivered by MySQL power users. They will follow the "State of The Dolphin" keynote address by Oracle's Chief Corporate Architect Edward Screven and VP of MySQL Engineering Tomas Ulin, and include:

High Speed Event Logging at Booking.com
Nicolai Plum, Senior Systems Architect, will provide an overview of Booking.com's MySQL-based event logging application, recording data from all customer interactions in order to develop the best customer experience.

MySQL at Dropbox
You’ll learn about MySQL at Dropbox with Renjish Abraham, Tech Lead DBA.

MySQL 5.6 at Twitter
Calvin Sun, Senior Engineering Manager, will walk us through Twitter's upgrade to MySQL 5.6. How did they do it, and what are the results?

The keynotes will take place on Monday, September 29, from 4.15 pm to 6.15 pm.

Check out all the MySQL Central @ OpenWorld sessions and Register Now if you haven't yet! You can save US$500 with the Early Bird Discount until July 18!

We look forward to seeing you at MySQL Central @ OpenWorld!

Wednesday Jun 25, 2014

Genoscope Makes Genomic Data Available to Scientists with MySQL Enterprise Edition

Genoscope, the French National Sequencing Center, was created in 1997 and is one of the largest sequencing centers in Europe. Its mission is to acquire, to "sequence" and to analyze the genetic information of various organisms presenting a scientific, medical or economic interest. DNA sequencing is the process of determining the precise order of nucleotides within a DNA molecule. Genoscope produces various types of data, such as complete or partial genome sequences, that are then compared and analyzed. Following its role as a major actor in the Human Genome Project, Genoscope has changed its orientation toward environmental genomics. Since 2007, Genoscope is part of CEA, the French Alternative Energies and Atomic Energy Commission.


  • Make a large amount of scientific data available to biologists worldwide via a database combining performance, ease of use and cross-platform availability.
  • Rapidly and easily deploy new database applications to address the constantly growing needs of genomic analysis.

  • Genoscope initially relied on Sybase for its database applications but faced a number of constraints, especially in terms of ease of use and administration as well as of cross-platform availability.
  • Evaluation and selection of MySQL as new database standard to eliminate those constraints.
  • About 300 MySQL databases storing 8 terabytes of data have been deployed so far by the sequencing center, including :
    • 250 MySQL databases enabling the scientific community to access genomic data via web applications. Each application is dedicated to a specific type of data, for example "metagenomes" or the comparison of different genomes. The most important one handles over 5 terabytes of data, relying on approximately 30 MySQL databases.
    • About 50 MySQL databases are used for Business Intelligence as well as project management applications.
  • Genoscope relies on MySQL 5.6 for new applications; and on MySQL Workbench for their design and development. Sylvain Bonneval, DBA in the Genoscope systems team underlines "Beyond the performance and ease of use of MySQL, we particularly appreciate the fast pace of innovations delivered by Oracle. MySQL 5.6 integrates numerous very useful new features, and there’s no doubt that tremendous progress is being made with MySQL."
  • MySQL Enterprise Edition was implemented to allow the teams to access Oracle’s MySQL technical support, and to benefit from monitoring tools including the MySQL Enterprise Monitor and MySQL Query Analyzer.

"MySQL allowed us to significantly increase database usage in our organization. It is a tool perfectly suited to public research applications considering both its performance and open source nature." Sylvain Bonneval, DBA, Genoscope

Le Genoscope met les données génomiques à disposition des scientifiques avec MySQL Enterprise Edition

Créé en 1997, le Genoscope - Centre National de Séquençage - est un grand équipement au service de la communauté scientifique. Sa mission est d'acquérir, de "séquencer", et d'analyser l'information génétique de divers organismes d'intérêt scientifique, médical ou économique. Concrètement, le séquençage consiste à déterminer l'ordre dans lequel s'enchaînent les molécules élémentaires qui constituent les molécules d'ADN. Le Genoscope produit des données de nature diverse - séquences entières ou partielles de génomes ou de produits d'expression des gènes - qu'il compare et interprète. Après avoir été l'un des acteurs du projet génome humain, le Genoscope met aujourd'hui le cap vers la génomique environnementale. Depuis 2007, le Genoscope est intégré à l'institut de Génomique du CEA, le Commissariat à l'énergie atomique et aux énergies alternatives.


  • Mettre un volume important de données scientifiques à disposition des biologistes du monde entier via une base de données alliant performance, portabilité et simplicité d’utilisation.
  • Rapidement et simplement déployer de nouvelles applications de bases de données pour répondre aux besoins croissants d’analyse génomique.


  • Le Genoscope a initialement utilisé Sybase comme base de données mais faisait face à plusieurs contraintes, notamment en termes de portabilité sur différentes plateformes ainsi que de simplicité d’utilisation et d’administration.
  • Evaluation et sélection de MySQL comme nouveau standard de base de données pour répondre à ces contraintes.
  • Environ 300 bases MySQL contenant 8 téraoctets de données sont déployées par l’institut à ce jour, incluant:
    • 250 bases MySQL utilisées pour mettre les données génomiques à disposition de la communauté scientifique via des applications Web. Chaque application est dédiée à un type particulier de données, par exemple les "métagénomes" ou la comparaison de différents génomes. L’application la plus importante gère plus de 5 téraoctets de données, s’appuyant sur une trentaine de bases MySQL.
    • Une cinquantaine de bases de données MySQL utilisées pour des applications d’informatique décisionnelle et de gestion de projets.
  • Le Genoscope utilise MySQL 5.6 pour les nouvelles applications, ainsi que MySQL Workbench pour leur modélisation et développement. Sylvain Bonneval, DBA de l’équipe système, souligne "Outre la performance et la simplicité d’utilisation de MySQL, nous apprécions particulièrement le rythme des innovations délivrées par Oracle. MySQL 5.6 intègre de nombreuses nouvelles fonctionnalités très utiles et nous constatons à quel point MySQL est une base de données en pleine progression."
  • MySQL Enterprise Edition a été mis en place pour permettre aux équipes de bénéficier de l’accès au support technique MySQL d’Oracle ainsi que des outils de monitoring comme le MySQL Enterprise Monitor et MySQL Query Analyzer.

"MySQL nous a permis de largement accroître l'usage des bases de données au sein de notre organisation. C’est un outil parfaitement adapté aux applications de recherche publique, tant par sa performance que par sa nature open source." Sylvain Bonneval, DBA, Le Genoscope

Thursday Jun 19, 2014

Discover the MySQL Central @ OpenWorld Content Catalog

MySQL Central @ OpenWorld, taking place in San Francisco September 28 - October 2, will feature keynotes, conference sessions, tutorials, hands-on labs, as well as birds-of-a-feather sessions.

The Content catalog listing the MySQL Central @ OpenWorld sessions is available here.

Some of the sessions you will be able to attend include:


The State of the Dolphin
Join Edward Screven, Oracle’s Chief Corporate Architect, and Tomas Ulin, vice president of MySQL Engineering, for the “State of the Dolphin” keynote address. You’ll learn about Oracle’s MySQL strategy as well as the latest MySQL innovations and plans.

We will shortly announce additional customer keynotes, stay tuned!

Conference Sessions:

  • MySQL 5.7: InnoDB, What’s New - Sunny Bains, Oracle
  • The MySQL SYS Schema - Mark Leith, Oracle
  • MySQL 5.6 and WebScaleSQL at Facebook - Yoshinori Matsunobu, Facebook
  • User Management in MySQL @ Twitter – Thomas Krouper, Twitter
  • NoSQL and MySQL: Dynamic Schemas - Sheeri Cabral, Mozilla
  • Elastic Scalability in MySQL Fabric Using OpenStack - Mats Kindahl, Oracle Corporation
  • MySQL@ King, Scaling Candy Crush – Olle Nilsson, King
  • MySQL Performance: Demystified Tuning & Best Practices - Dimitri Kravtchuk, Oracle
  • MySQL Cluster Scaling For the Masses - Bernhard Ocklin, Oracle
  • Yahoo!: Performance Monitoring and Tuning at Scale - Ashwin Nellore & Xiang Rao, Yahoo!
  • Basic MySQL troubleshooting for Oracle DBAs - Svetlana Smirnova, Oracle
  • and a lot more


  • MySQL Fabric Tutorial – Lars Thalmann, Oracle Corporation
  • A hands-on exploration of InnoDB on-disk storage with innodb_ruby – Davi Arnaut, LinkedIn & Jeremy Cole, Google
  • MySQL Replication Tips and Tricks – Luis Soares, Oracle  
  • and more

Birds-of-a-Feather Sessions:

  • MySQL & GIS – Alexander Rubin, Percona
  • MySQL High Availability & Backup – Oracle team
  • MySQL Server (InnoDB, Optimizer & more) – Oracle team
  • and more

Additionally, we will also run 8 Hands-on Labs. Those will soon get listed in the content catalog as well and they include:

  • MySQL Troubleshooting with the Performance Schema – Svetlana Smirnova, Oracle 
  • Using MySQL Workbench Performance Tools – Alfredo Kojima, Oracle  
  • DevOps Made Easy with MySQL Utilities - Chuck Bell, Oracle
  • MySQL EXPLAIN in Practice  - Øystein Grøvlen, Oracle
  • …and more
And, you also get access to all the Oracle OpenWorld keynotes and extensive content!

Finally, not only will you have the opportunity to meet Oracle’s MySQL engineers and ask all your questions but you’ll also have ample time to network with your peers during several social events:

  • The Oracle OpenWorld Welcome Reception on Sunday night
  • The MySQL Community Reception on Tuesday
  • The Appreciation Event on Wednesday

Thank you very much to the MySQL Central @ OpenWorld content committee, especially our external members, for their efforts and help to build this fantastic program.

Register Now if you haven’t yet! You can save US$500 with the Early Bird Discount until July 18!

We look forward to seeing you at MySQL Central @ OpenWorld!

Thursday May 15, 2014

MySQL May Newsletter is Available!

Here comes the MySQL May Newsletter! As always it's packed with latest product news, technical articles, and not-to-be missed webinars and events where you'll get first-hand information directly from the MySQL experts at Oracle. The highlights in this edition include:

  • Join Us at MySQL Central @ OpenWorld 2014
  • Dr. Dobb's: NoSQL with MySQL
  • Live Webinar: Upgrading to MySQL 5.6 - Best Practices
  • Featured Video: MySQL for Excel Introduction
  • Blog: Why VividCortex Uses MySQL
  • Blog: Importing Raster-Based Spatial Data into MySQL 5.7

You can read it online or subscribe to it to receive the latest copy in your inbox every month. Just sign-in to your oracle.com account and find the MySQL newsletter under "Technology" in the subscription center in your profile.


Friday May 02, 2014

Name Change: MySQL Connect Becomes "MySQL Central @ OpenWorld"

Oracle OpenWorld, taking place Sept 28-Oct 2, 2014 in San Francisco, is the world’s largest gathering of technology and business professionals. The conference includes several dedicated programs focused on specific technologies and solutions, such as Human Capital Management, Customer Experience, and MySQL.

In order to bring more consistency, clarity and visibility to those programs, they have all been renamed "Central". MySQL Connect therefore becomes "MySQL Central @ OpenWorld", and we will use this name moving forward.

MySQL Central @ OpenWorld offers you the opportunity to hear directly from Oracle’s MySQL engineers about the latest MySQL features, enhancements and plans. Best Practices sessions by MySQL customers, community members and partners will help you understand how to make the most of MySQL.

MySQL Central @ OpenWorld includes:

  • Keynotes by Oracle executives, community members and customers
  • Breakout conference sessions
  • Hands-on labs
  • Birds-of-a-Feather sessions
  • Tutorials
  • Demos
  • Social events and informal networking
  • Plus, all the Oracle OpenWorld keynotes, sessions, hands-on labs, exhibition halls and appreciation event

Don’t miss this opportunity and register now! We look forward to seeing you there.

Tuesday Apr 29, 2014

MySQL Tech Day, Paris France on May 22, 2014

Want to know more about recent MySQL ads? If so, and if you are closed to Paris, join us for the MySQL Tech Day scheduled for May 22nd, 2014

You will have an opportunity to hear the latest MySQL news, InnoDB new features and MySQL Performance Schema given by the key MySQL experts. Also this event is constructed as the interactive one, so you will have a chance to discuss and ask questions at this free event. Please review the detailed agenda below and here (in French).

Event Details:

Date: May 22, 2014

Time: 10:00 - 17:30 

Place: Oracle France, 15 Boulevard Charles de Gaulle, 92715 Colombes Cedex, Paris, France

Entrance fee: Free of charge

Registration: Please register yourself here

Event info: in French available here


10:10 - Registration and Welcome Coffee

10:30 - Overview of the latest MySQL news by Xavier GERARD, Key Account Manager, MySQL France

11:45 - Dimitri KRAVTCHUK, Performance Architect will talk about:

  • Detailed presentation of the MySQL Performance improvements & InnoDB internal architecture
  • Solutions applied to MySQL versions 5.5, MySQL 5.6 and MySQL 5.7
  • Comparison with evidence and benchmark results
  • Internal architecture of InnoDB: flushing and purging

13:00 - Lunch

14:00 - Mark LEITH, Senior Software Development Manager will talk about:

  • Detailed review of the MySQL Performance Schema, Part 1
  • Presentation of MySQL Enterprise Monitor, use cases and demonstration
  • Presentation of MySQL Performance Schema, implementation and configuration
  • Advanced Use of MySQL Performance Schema

15:30 - Coffee break

16:00 - Mark LEITH, Senior Software Development Manager will continue talking about:

  • Detailed review of the MySQL Performance Schema, Part 2
  • Presentation of MySQL Enterprise Monitor, use cases and demonstration
  • Presentation of MySQL Performance Schema, implementation and configuration
  • Advanced Use of MySQL Performance Schema

17:30 - End of event, Q&A

We are looking forward to seeing you on May 22nd!

Tuesday Apr 22, 2014

MySQL April Newsletter: Latest MySQL Product Releases and More

MySQL April Newsletter is now available! Read this edition to learn more details about the abundant product announcements we made recently, including MySQL 5.7 Development Milestone Release, MySQL Workbench 6.1 GA, as well as the Release Candidate of MySQL Fabric. You'll also find information regarding the latest white papers, upcoming webinars and events, and technical blogs for tips and tricks using MySQL.

Enjoy and hope you find it informative! 

Tuesday Apr 08, 2014

Summary of Announcements, Blogs, and more...

Considering last week was very rich in terms of announcements, we thought it might be useful to provide a summary of the information we shared, including the blogs from Oracle’s MySQL Engineers aggregated for easier access:

We sent out this press release last Monday to announce:

  • The latest development milestone release of MySQL 5.7, 2x faster than MySQL 5.6 and 3x faster than MySQL 5.5
  • The Release Candidate of MySQL Fabric, providing high availability management and scale out through sharding (included in the Release Candidate version of MySQL Utilities 1.4.2).
  • The General Availability of MySQL Workbench 6.1, delivering additional capabilities for performance assessment and query optimization.
  • Early access to features under development via labs.mysql.com including Geographic Information System (GIS), multi-source replication improvements, and a preview of MySQL Cluster 7.4 for community testing and feedback.

The news generated a number of press articles, such as:

Oracle doubles the speed of MySQL query handling

Oracle MySQL 5.7 Release Boosts Performance, Scalability

Oracle’s VP of MySQL Engineering Tomas Ulin delivered a keynote at the Percona Live conference entitled: "Raising the MySQL Bar". Tomas demonstrates how Oracle keeps raising the bar for MySQL, and talks about the latest news and developments. He also took the opportunity to welcome "WebScaleSQL", a fantastic initiative from Facebook, Google, LinkedIn, and Twitter announced the week before.

You can access the video here and the slides here.

Oracle’s MySQL Engineers have been actively blogging about what’s new and their blogs are aggregated below:

The MySQL 5.7.4 Milestone Release is available

MySQL 5.7 just rocks! ;-)

InnoDB Crash Recovery Improvements in MySQL 5.7
MySQL 5.7.4 now supports Transportable Tablespaces for InnoDB Partitions
InnoDB Spatial Indexes in 5.7.4 LAB release
InnoDB Transparent PageIO Compression

MySQL Replication – Multi-Threaded Slave just got a whole lot faster
MySQL-5.7.4- Change master without stopping slave altogether

MySQL Performance Schema : Prepared Statements Instrumentation

A new dimension to MySQL query optimizations:

SQL parser refactoring in 5.7.4 LAB release

Server-side SELECT statement timeouts

Building MySQL with Boost
Why Boost.Geometry in MySQL?

Password expiration policy in MySQL Server 5.7

Test improvements in MySQL 5.7.4

MySQL Fabric 1.4.2 Released
MySQL Fabric RC - Adding High Availability and/or Scaling to MySQL
Configuring and running MySQL Fabric 1.4.2

New! MySQL Utilities release-1.4.2-RC
New MySQL Utility: Replication Synchronization Checker
Announcing MySQL Multi-Source Replication Utility

What’s New in MySQL Workbench 6.1

Data Encryption with MySQL Enterprise Backup 3.10

MySQL Cluster 7.4.0 Labs Release
MySQL Cluster 7.4.0 Lab Release Improvements

Fusion-io made the following announcement:
Fusion-io Collaborates with Oracle to Double Usable Capacity for MySQL

Last but not least, we were very pleased to receive the Corporate Contributor of the year award at the Percona Live 2014 MySQL Community awards ceremony.

It is a very exciting time for MySQL, and we look forward to a great MySQL Connect @ OpenWorld! Remember the call for papers is open until April 15, don’t miss the opportunity to submit sessions.

Friday Apr 04, 2014

MySQL at OpenSource Developer Conference, Taiwan (Apr 11-12, 2014)

It is our pleasure to announce MySQL presence at the OpenSource Developer Conference in Taipei, Taiwan next week. MySQL has secured 2 talks and the booth where you can meet our MySQL experts. Please mark your calendars for April 11-12, 2014, especially for following MySQL talks:

  • Sharding and Scale-out Using MySQL Fabric by Ryusuke Kajiyama, the OSS specialist with over 10 years of experience in system design utilizing MySQL and Open Source solutions. His talk is scheduled for Apr 11 @ 10:20-10:50.
  • MySQL Utilities by Ivan Tu, the MySQL Sales Consultant in Taipei. Ivan has Java programming background and is experienced in both, MySQL and Oracle database. His talk is scheduled for Apr 11 @ 11:50-12:20.
We are looking forward to talking to you at the OSDC next week!

Tuesday Apr 01, 2014

New MySQL 5.7 DMR, MySQL Fabric RC, MySQL Workbench 6.1 GA...and more

We were very pleased to make the following announcement yesterday:

"Oracle Improves Database Performance with Latest Development Milestone Release for MySQL 5.7
New Release of the World’s Most Popular Open Source Database is 2x Faster than MySQL 5.6 and Over 3x Faster than MySQL 5.5 in Benchmark Tests

News Summary: Continuing to lead MySQL innovation, Oracle announced the immediate availability of a new Development Milestone Release for MySQL 5.7. To meet the demands of today’s web, cloud, and embedded applications, the new release extends the performance, scalability and reliability of MySQL, the world’s most popular open source database, while also enhancing management capabilities. In addition, Oracle announced the availability of several other MySQL product releases and early access features."

The full press release is available here.

Oracle’s MySQL Engineers have then provided more detailed information via a number of blog posts and articles including:

Enjoy the information and watch out for more blog posts on Planet MySQL during the next few days!

Friday Mar 28, 2014

Sharecat Enables Oil and Gas Supply Chain Management with MySQL Enterprise Edition

Sharecat provides supply chain management solutions to oil and gas operators, delivering an innovative collaborative environment which includes the manufacturers' equipment catalogues and technical information. The products provide visibility and fully validated content to all parties in the plant lifecycle. Based in Norway, the company has offices in the UK, Australia and the United States.