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!

Monday Aug 25, 2014

Learn All About MySQL Cluster

Just released - the all new MySQL Cluster training course.

This MySQL Cluster training teaches you how to install and configure a real-time database cluster at the core of your application. Expert instructors will teach you how to design and maintain your clusters for high availability and scalability by using MySQL Cluster's open-source and enterprise components.

This 4-day training course is a must for those who want to learn about MySQL Cluster as you will not only learn about the concepts and features but you will get extensive hands-on experience. You can follow this training course from your own desk via a live-virtual training or by traveling to an education center to follow this course.

Be the first to influence the schedule for this newly released course by registering your interest on the Oracle University portal.

For more information about the authentic MySQL curriculum, go to http://education.oracle.com/mysql

Monday Aug 18, 2014

Items Affecting Performance of the MySQL Database

To learn about the many factors that can affect the performance of the MySQL Database, take the MySQL Performance Tuning course.

You will learn:

  • How your hardware and operating system can affect performance
  • How to set up and logging to improve performance
  • Best practices for backup and recovery
  • And much more

You can take this 4-day instructor-led course through the following formats:

  • Training-on-Demand: Start training within 24 hours of registering for training, following lectures at your own pace through streaming video and booking time on a lab environment to suit your schedule.
  • Live-Virtual Event: Attend a live event from your own desk, no travel required. Choose from a selection of events on the schedule to suit different time-zones.
  • In-Class Event: Travel to an education center to attend this course. Below is a selection of events already on the schedule.

 Location

 Date

 Delivery Language

 Brussels, Beligum

 10 November 2014

 English

 Sao Paolo, Brazil

 25 August 2014

 Brazilian Portuguese

 London, England

 20 October 2014

 English

 Milan, Italy

 20 October 2014

 Italian

 Rome, Italy

 1 December 2014

 Italian

 Riga, Latvia

 29 September 2014

 Latvian

 Petaling Jaya, Malaysia

 22 September 2014

 English

 Utrecht, Netherlands

 10 November 2014

 English

 Warsaw, Poland

 1 September 2014

 Polish

 Barcelona, Spain

 14 October 2014

 Spanish

To register for an event, request an additional event, or learn more about the authentic MySQL Curriculum, go to http://education.oracle.com/mysql.

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!

Monday Aug 11, 2014

Database Modelling is Key to Getting Started on the MySQL Database

Database modelling is the process of defining the logical structure of a database. This structure determines how data is stored, organized and manipulated. This enables you to:

  • Understand your data before building the database
  • Consider what questions your data must answer

The entity relationship model (ERM) is the most common model for an RDBMS.

Learn more about database modelling, design and much more in the MySQL for Beginners training course.

You can take this 4-day instructor-led training course via the following formats:

  • Training-on-Demand: Start training within 24 hours of registration. Follow lectures at your own pace through streaming video. Book time on a lab environment to suit your own schedule.
  • Live-Virtual Event: Attend a live event from your own desk, no travel required. Choose from a selection of events already on the schedule to suit different timezones.
  • In-Class Event: Travel to an education center to attend this course. Below is a selection of the in-class events already on the schedule.

 Location

 Date

 Delivery Language

 Brussels, Belgium

 8 September 2014

 English

 Sao Paolo, Brazil

 6 October 2014

 Brazilian Portuguese

 Cairo, Egypt

 14 September 2014

 Arabic

 London, England

 11 November 2014

 English

 Rome, Italy

 3 November 2014

 Italian

 Dehli, India

 19 August 2014

 English

 Nairobi, Kenya

 8 September 2014

 English

 Riga, Latvia

 3 November 2014

 Latvian

 Petaling Jaya, Malaysia

 20 October 2014

 English

 San Pedro Garza Garcia

 24 November 2014

 Spanish

 Utrecht, Netherlands

 8 September 2014

 English

 Lisbon, Portugal

 22 September 2014

 European Portuguese

 Porto, Portugal

 22 September 2014

 European Portuguese

To register for an event, request an additional event or learn more about the authentic MySQL curriculum, go to http://education.oracle.com/mysql.

Monday Aug 04, 2014

Handling Error Messages and Warnings with MySQL

To ensure that your MySQL Database works as efficiently as possible, it is important to know how to handle error messages and warnings.

Error messages have three components:

  • A MySQL-specific error code, such as 1146
  • A SQLSTATE error code. These codes are defined by standard SQL and the ODBC standard.
  • A text message that describes the problem

MySQL Server generates a warning when it is not fully able to comply with a request or when an action has possibly unintended side effects. You can display these warnings with the SHOW WARNINGS statement.

To learn about handling error messages and warnings along with other developer topics, consider taking the MySQL for Developers training course.

You can take this 5-day course as a:

  • Live-virtual event: Attend a live training event from your own desk, no travel required. Choose from a selection of events on the schedule to suti different timezones.
  • In-class event: Travel to an education center to attend a class. Below is a selection of the events already on the schedule.

 Locaation

 Date

 Delivery Languaage

 Vienna, Austria

 27 November 2014

 German

 Brussels, Belgium

 8 December 2014

 English

 Sao Paolo, Brazil

 13 October 2014

 Brazilian Portuguese

 London, England

 29 September 2014

 English

 Belfast, Ireland

 6 October 2014

 English

 Dublin, Ireland

 27 October 2014

 English

 Milan, Italy

 10 November 2014

 Italian

 Rome, Italy

 13 October 2014

 Italian

 Nairobi, Kenya

 15 September 2014

 English

 Petaling Jaya, Malaysia

 25 August 2014

 English

 Utrecht, Netherlands

 8 December 2014

 English

 Makati City, Phillippines

 29 September 2014

 English

 Warsaw, Poland

 25 August 2014

 Polish

 Lisbon, Portugal

 13 October 2014

 European Portuguese

 Porto, Portugal

 13 October 2014

 European Portuguese

 Barcelona, Spain

 29 October 2014

 Spanish

 Madrid, Spain

 3 November 2014

 Spanish

 Valencia, Spain

 24 November 2014

 Spanish

 Basel, Switzerland

 13 October 2014

 German

 Bern, Switzerland

 13 October 2014

 German

 Zurick, Switzerland

 13 October 2014

 German

The MySQL for Developers course is the recommended training for the MySQL 5.6 Developers OCP certification exam.

To register for the MySQL for Developers course, request an additional event, or learn more about the authentic MySQL curriculum, go to http://education.oracle.com/mysql.

Monday Jul 14, 2014

Save 20% With MySQL Training and Certification Packages

Get the best from both worlds with bundled packages: a training course and a certification exam voucher. You save 20% when you buy training and certification in discount packages.

Training helps you acquire product expertise. Certification proves this expertise to your future employers.

There are two MySQL Discount Packages: MySQL Database Administration and MySQL Developer.

For more information about the authentic MySQL curriculum, go to http://education.oracle.com/mysql.

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!

Monday Jul 07, 2014

MySQL Cluster High Availability Through Data Replicas

MySQL Cluster enables high availability by storing data replicas on multiple hosts. MySQL Cluster maintains connections between data nodes by using high-speed interconnects over TCP/IP - standard or direct connections - or SCI (Scalable Coherent Interface) sockets.

To learn more about MySQL Cluster, take the MySQL Cluster training course.

This course is currently scheduled for the following locations:

 Location

 Date

 Delivery Language

 Sao Paulo, Brazil

 28 July 2014

 Brazilian Portuguese

 Berlin, Germany

 11 August 2014

 German

 Hamburg, Germany

 29 September 2014

 German

 Munich, Germany

 15 December 2014

 German

 Rome, Italy

 8 September 2014

 Italian

Seoul, Korea

28 July 2014 

 Korean 

Petaling Jaya, Malaysia

16 July 2014 

English 

Warsaw, Poland

28 July 2014 

Polish 

Singapore

 29 July 2014

 English 

Edison, NJ, United States

18 August 2014 

English 

San Francisco, CA, United States

13 August 2014 

English 

To register for an event, request an additional event, or learn more about the authentic MySQL Curriculum, go to http://education.oracle.com/mysql.

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.



Challenges

  • 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.

Solution
  • 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.



Défis

  • 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.

Solution

  • 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

Monday Jun 23, 2014

InnoDB, The Choice for High Concurrency Database Systems

InnoDB has proven to be a reliable data storage engine for modern, high concurrency database systems. It is fully ACID compliant, and supports a wide range of isolation modes, from READ-UNCOMMITEED to SERIALIZABLE.

InnoDB multiversion concurrency control (MVCC) enables records and tables to be updated without the overhead associated with row-level locking mechanisms. The MVCC implementation in InnoDB largely eliminates the need to lock tables or rows during updates, and enables good performance for high concurrency workloads.

To learn more about this subject and related performance tuning topics tuning, take the MySQL Performance Tuning training course. This 4-day, instructor-led course is available as:

  • Training-on-Demand: Start training within 24 hours of registration. You will follow lecture material at your own pace through streaming video and you can book time on a lab environment to suit your schedule.
  • Live-Virtual Events: Attend a live class from your own desk, no travel required. Choose from a selection of events on the schedule to suit different timezones.
  • In-Class Events: Travel to an education center to take this class. Below is a selection of the in-class events already on the schedule.

 Location

 Date

 Delivery Language

 Sao Paulo, Brazil

 24 June 2014

Brazilian Portuguese 

 Brussels, Belgium

 4 August 2014

English 

 Shanghai, China

 5 August 2014

Simplified Chinese 

 London, England

 20 October 2014

English 

Milan, Italy 

 28 July 2014

Italian 

 Riga, Latvia

 29 September 2014

 Latvian

Petaling Jaya, Malaysia 

22 September 2014  

 English

 Utrecht, Netherlands

4 August 2014  

 English 

 Warsaw, Poland

 14 July 2014 

 Polish

 Barcelona, Spain

 14 October 2014

 Spanish

 Istanbul, Turkey

 4 August 2014

 Turkish

To register for this class, request an additional event or learn more about the authentic MySQL Curriculum, go to http://education.oracle.com/mysql.

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:

Keynotes:

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


Tutorials:

  • 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!

Monday Jun 16, 2014

Normalize Your MySQL Database For Efficient Data Access, Query Flexibility and Maintenance

Before you start creating database entities, spend some time designing your database to ensure that it is fit for your purpose. The time you invest in this process saves a lot of time and trouble later. Professional database designers fine-tune their design using a process called 'normalization'. The normalization process takes your database design through a number of 'normal forms', which aim to ensure efficient data access, greater query flexibility, and easier maintenance.

For example, the First Normal Form (or '1NF') ensures that all your database columns contain only a single value. A column that contains multiple data values is difficult to access and keep up to date. It also ensures that each table row only represents a single 'real world' item. Like all the other normal forms, this encourages you to split your data across multiple tables, with less rows in each table. You can quickly see the benefits of this approach as your database grows.

To learn more about normalization and other topics that help you get started with the MySQL database, take the MySQL for Beginners training course. You can take this 4-day training course as:

  • Training-on-Demand: Start training within 24 hours of registering. Follow lectures through streaming video at your own pace and book time on a lab environment to suit your own schedule.
  • Live-Virtual Event: Attend a live event from your own desk, no travel required. Choose from a selection of events on the schedule to suit different timezones.
  • In-Class Event: Travel to an education center to attend this class. Below is a selection of the events already on the schedule.

 Location  Date  Delivery Language
 Brussels, Belgium
 7 July 2014
 English
 Sao Paulo, Brazil
 23 June 2014
 Brazilian Portuguese
 Cairo, Egypt
 14 September 2014
Arabic
 London, England
 28 July 2014
 English
 Milan, Italy
 14 July 2014
 Italian
 Nairobi, Kenya
 7 July 2014
English
Riga, Latvia
 3 November 2014
Latvian
 Petaling Jaya, Malaysia
 14 July 2014
 English
 Utrecht, Netherlands
 7 July 2014
 English
 Lisbon Portugal
 22 September 2014
 European Portuguese
 Porto, Portugal
 22 September 2014
 European Portuguese

To register for an event, request an additional event or learn more about the authentic MySQL curriculum, go to http://education.oracle.com/mysql.

Thursday Jun 12, 2014

FairWarning Privacy Monitoring Solutions Rely on MySQL to Secure Patient Data

FairWarning® solutions have audited well over 120 billion events, each of which was processed and stored in a MySQL database. FairWarning is the world's leading supplier of privacy monitoring solutions for electronic health records, relied on by over 1,200 Hospitals and 5,000 Clinics to keep their patients' data safe. In January 2014, FairWarning was awarded the highest commendation in healthcare IT as the first ever Category Leader for Patient Privacy Monitoring in the "2013 Best in KLAS: Software & Services" report[1].

FairWarning has used MySQL as their solutions’ database from their start in 2005 to worldwide expansion and market leadership. FairWarning recently migrated their solutions from MyISAM to InnoDB and updated from MySQL 5.5 to 5.6. Following are some of benefits they’ve had as a result of those changes and reasons for their continued reliance on MySQL (from FairWarning MySQL Case Study).

Scalability to Handle Terabytes of Data FairWarning's customers have a lot of data:

  • On average, FairWarning customers receive over 700,000 events to be processed daily.
  • Over 25% of their customers receive over 30 million events per day, which equates to over 1 billion events and nearly one terabyte (TB) of new data each month.
  • Databases range in size from a few hundred GBs to 10+ TBs for enterprise deployments (data are rolled off after 13 months).

Low or Zero Admin = Few DBAs "MySQL has not required a lot of administration. After it's been tuned, configured, and optimized for size on initial setup, we have very low administrative costs. I can scale and add more customers without adding DBAs. This has had a big, positive impact on our business.”
- Chris Arnold, FairWarning Vice President of Product Management and Engineering.

Performance Schema  As the size of FairWarning's customers has increased, so have their tables and data volumes. MySQL 5.6’ new maintenance and management features have helped FairWarning keep up. In particular, MySQL 5.6 performance schema’s low-level metrics have provided critical insight into how the system is performing and why.

Support for Mutli-CPU Threads MySQL 5.6' support for multiple concurrent CPU threads, and FairWarning's custom data loader allow multiple files to load into a single table simultaneously vs. one at a time. As a result, their data load time has been reduced by 500%.

MySQL Enterprise Hot Backup Because hospitals and clinics never stop, FairWarning solutions can’t either. FairWarning changed from using mysqldump to MySQL Enterprise Hot Backup, which has reduced downtime, restore time, and storage requirements. For many of their larger customers, restore time has decreased by 80%.

MySQL Enterprise Edition and Product Roadmap Provide Complete Solution "MySQL's product roadmap fully addresses our needs. We like the fact that MySQL Enterprise Edition has everything included; there's no need to purchase separate modules."  - Chris Arnold

Learn More>>


[1] 2013 Best in KLAS: Software & Services report, January, 2014. © 2014 KLAS Enterprises, LLC. All rights reserved.

About

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

Twitter


Facebook

Search

Archives
« March 2015
SunMonTueWedThuFriSat
1
3
4
5
6
7
8
10
11
12
13
14
15
17
18
19
21
22
24
25
27
28
29
30
31
    
       
Today