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

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!

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.

Enjoy!

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

Agenda

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.



Challenges

  • Deliver Software-as-a-Service (SaaS) based solutions with a Web interface to oil and gas operators. The database powering the applications needed to store and deliver fast access to a large amount of information, including all components necessary for the construction and the maintenance of oil rigs. Product catalogs are updated on a continuous basis with manufacturers, product numbering, data templates and documentation. They contain information captured over an 18-year period, including products no longer in production but still installed at thousands of assets.
  • Implement an enterprise-class database to power the supply chain solutions. They had initially been developed with a Microsoft Access back-end, and had outgrown its capabilities.
  • Maintain a low Total Cost of Ownership over time.

Solution
  • Evaluated several databases and selected MySQL to power the Sharecat applications. The team particularly valued its performance and scalability in addition to the opportunity to reduce database TCO by 90% compared to Microsoft SQL Server. "MySQL allowed us to build a professional solution to serve our global clients at low cost. It fulfilled our requirements extremely well."  said Tom-Kenneth Fossheim, Chief Technology Officer.
  • The Sharecat products run in a Windows-based virtualized environment. MySQL Replication is used both for High Availability and to scale-out read operations.
  • While MySQL 5.5 is currently in use with a mix of InnoDB and MyISAM tables, the company plans to upgrade to MySQL 5.6 and solely rely on the InnoDB storage engine.
  • Sharecat subscribed to MySQL Enterprise Edition in order to take advantage of the MySQL Enterprise Monitor and MySQL Enterprise Backup functionalities. They also wanted to be able to rely on Oracle's MySQL support team. "We’re very happy with Oracle’s MySQL support, the engineers are really good, and we get fast answers." said Eirik Andersen, Database Administrator.
  • The software is currently hosted in-house, but the company is evaluating the opportunity to migrate to a public cloud in order to benefit from increased flexibility and reliability, and to further reduce costs.

"MySQL just works, it’s a very stable, high performance and cost-effective database. In addition, we get great service from Oracle."
Tom-Kenneth Fossheim, Chief Technology Officer, Sharecat

Wednesday Mar 26, 2014

MySQL Powers AlSego's Solutions

Based in Luxembourg, AlSego is an Independent Software Vendor delivering Web, e-Commerce and financial applications including:
  • A Rapid Application Development (RAD) and Business Process Oriented (BPO) Web Server Platform.
  • E-payment and e-banking "Plug & Play" solutions.
  • Archiving solutions for the banks' SWIFT data.

AlSego counts some of the largest banks in Luxembourg, Belgium and Switzerland among its clients and partners.



Challenges

  • Supporting multiple database platforms for its products' master repositories generated a relatively high number of technical support incidents as end-users did not always master the various technologies involved. This in turn increased costs for both customers and AlSego, and negatively impacted the customer experience.
  • The company wanted to offer its clients turnkey solutions delivering the desired results out of the box, without requiring significant tuning for each new and different environment, nor an expensive and complex infrastructure.
  • The database underpinning the AlSego applications needed to deliver very high performance and reliability, paramount criteria for financial applications.


Solution

  • Decision to standardize on one database for all its products' master repositories in order to cost-effectively deliver the best customer experience. Customers would get a turnkey solution, optimized to deliver outstanding performance out of the box. Additionally, they would only have one company to turn to should they encounter any issue.
  • Evaluated several databases and decided to standardize on MySQL based on the following criteria:
    • Features: Among many others, stored procedures, views and triggers were essentials, and MySQL had all the needed features.
    • Ability to handle large volumes of data: e-banking solutions generate a significant volume of transactions and related data, and some data may need to be archived for over 10 years.
    • Performance: Financial institutions have typically been very pleasantly surprised and delighted by the MySQL performance during Proofs of Concept.
    • Flexibility: MySQL demonstrated the fairly unique ability to deliver excellent performance in different environments with minimal and predictable configurations changes. Additionally, when compared to other databases it did not require an expensive infrastructure to deliver the needed performance and scalability.
  • AlSego’s e-banking solutions are typically able to handle millions of system transactions per day, and store up to a Terabyte of data in large banks.
  • Developments and tests for the AlSego products integrating MySQL are often conducted on either Linux or Windows platforms, while production environments tend to also include UNIX-based or Mainframe-based platforms, running for example on Oracle Solaris or IBM zOS.
  • MySQL enabled AlSego to deliver solutions that were simpler to use and faster to implement, while reducing the Total Cost of Ownership (TCO) of its customers.
  • To make it even easier for its clients, AlSego is now evaluating the opportunity to integrate MySQL more deeply, embedding it within its core solutions.


"MySQL is one of the most mature and stable database products on the market. It is clear that Oracle understands the need to continuously develop the database, adding new features and making it a better solution for its various and different customers." Marc Van Oost, CEO, AlSego

Tuesday Mar 25, 2014

Upcoming EMEA Events with MySQL in 2014 - Continued

As an update to the previous announcement from Feb 27, 2014 we would like to update you on the conferences which MySQL Community team is supporting with an attendance of MySQL technical staff and sometimes with Java, Oracle VM and Oracle Linux experts as well. You are invited to meet our engineers at any of the event below.  

EMEA 

  • NEW! Open Source Days 2014, Bielsko, Poland, March 28-30, 2014
  • NEW! LOADays, Antwerp, Belgium, April 5-6, 2014
    • This is the first time we are attending also this small Belgian event focused on admins. MySQL is attending this time together with Oracle Linux team which will be talking about Ksplice during their submitted talks. Do not miss this presentation by Oracle Linux as well as other MySQL ones.
  • OpenSUSE Conference - Dubrovnik, Croatia, April 24-28, 2014
    • You can meet the MySQL team at our booth or at any of approved talks. Schedule for this event is not yet published. The Sneak Preview of oSC14 Sessions can be found here.
  • JavaScript UnConference, Hamburg, Germany, Apr 26, 2014
    • Ulf Wendel from MySQL team will attend & talk at the conference. Please come to meet him either at our table or at his talk.
  • PHP UnConference, Island of Majorka, May 17-18, 2014
    • There is no schedule set for such events as UnConference. This event is mostly for PHP experts and engineers and the whole schedule is done usually on the place. MySQL is presented by Ulf Wendel for sure! 
  • Solutions Linux & Open Source, Paris, France, May 27-28, 2014
    • Meet our MySQL, Oracle VM and Oracle Linux staff at our booth in the exhibition area!
    • The schedule is not yet announced, please watch the organizers' website.
  • NEW! PHP Tour Lyon, France, June 23-24, 2014
    • MySQL team is going to be part of this show as well, we are not going to have a booth here but very active networking by our french MySQL team around the event. Come to meet us and talk to us!
  • NEW! Froscon 2014, St.Augustin, Germany, August 23-24, 2014
    • As usual MySQL will be part of this great event in St.Augustin. You can find and talk to our MySQL engineers at our booth as well as during MySQL talks. The schedule for this event is not yet published, so watch the Froscon website for any news.  
  • DrupalCon Amsterdam, Holland, Sep 30 - Oct 3, 2014
    • Come to meet our MySQL team at our booth in Amsterdam!
    • The schedule is not yet announced, please watch the DrupalCon website for news.
  • NEW! All Your Base, Oxford, UK, October 17, 2014
    • Our local MySQL team is going to attend the one day database conference for web developers - All Your Base hold in the UK. Come to visit our MySQL booth and talk to our MySQL experts, you can also find MySQL presentations in the conference schedule once announced. Check the organizers’ website for upcoming updates on the schedule and other information. 

APAC

  • Update! Open Source Developers' Conference 2014, Taipei, Taiwan, April 11-12, 2014
    • It is first time when MySQL Community team with a help of local MySQL team supports the Open Source Developers Conference in Taiwan. You can find our MySQL staff at our booth or attend any of following presentations submitted:
      • Sharding and Scale-out using MySQL Fabric
        • Speaker: Ryusuke Kajiyama - Oracle MySQL JAPAC Sales Consultant Manager
        • Agenda: MySQL Fabric is an open-source solution released by the MySQL Engineering team at Oracle. It make management of farms of MySQL servers easy and available for both applications with small and large number of servers. MySQL Fabric organizes the servers in groups and deploys high-availability solutions within each group.
      • MySQL Utilities
        • Speaker: Ivan Tu - Oracle MySQL Sales Consultant
        • Agenda: MySQL Utilities works can  help you to perform many crucial MySQL operations such as copying data between databases without, compare data, set the master-slave replication, and fail-over/back between master and slave servers atomically, thus enhance the usability and availability of your MySQL Databases. This talk would show the features, and use case of MySQL Utilities.
  • NEW! Open Source Conference Japan, Hokkaido, June 13-14, 2014
    • Our local MySQL team is looking forward to talking to you during this conference. You can either find us at your MySQL booth or during the MySQL talks. The schedule is not yet announced, so please watch the conference website for any update.
  • NEW! Ruby Kaigi, Tokyo, Japan, September 18-20, 2014
    • Another event MySQL supports and attends in APAC region. Ruby Kaigi is the international Ruby Conference in Japan, Tokyo. Ruby started in Japan, so Ruby Kaigi has excellent speakers and developers! MySQL team is going to be present at this conference with MySQL talks and active networking around the venue. We are looking forward to seeing you at Ruby Kaigi!.
If you would like to see also other conferences which MySQL engineering & MySQL Community team attend, please check the MySQL wikis, with a complete list of events in EMEA, APAC and US where you can find our people.

Monday Mar 24, 2014

Just Published! MySQL March Newsletter

Have you read the MySQL March Newsletter? Check it out to learn more about the Call of Papers for MySQL Connect @ OpenWorld 2014, MySQL in action in the finance, retail and channel management sectors, as well as numerous technical tips written by MySQL experts at Oracle and in the community. The highlights in this edition include:

  • Submit Sessions for MySQL Connect @ OpenWorld 2014
  • MySQL Connector/NET 6.8.3 Available as Official MySQL NuGet Packages
  • New Case Studies: MySQL in Action in Finance, Retail, and Channel Management
  • New White Paper: Guide to the MySQL Workbench Migration Wizard: From Microsoft SQL Server to MySQL
  • Featured Video: How to Export Your Database with MySQL for Visual Studio
  • Blog: Today's Practical Use Case for MySQL Performance Schema
  • Blog: Repos and Distros: Upstream and Downstream

You can read it online or subscribe to it to receive the latest copy in your inbox automatically every month. Watch this tutorial to learn step-by-step instructions for newsletter subscription.

Enjoy!

Thursday Mar 20, 2014

Buongiorno Relies on MySQL Enterprise Edition to Power its Mobile Services

Buongiorno is known in the worldwide mobile ecosystem for developing and managing paid applications and content that help consumers get greater enjoyment from their mobile devices.


Buongiorno’s strategic goal is to deliver directly to consumers around the world a broad portfolio of content & services on all their personal devices, exploiting social and location based propositions, and letting telecom operators be in control of the billing. With direct connections to more than 130 telecom operators in 25 countries, over 10 years’ experience and a team of 600 professionals, Buongiorno makes the mobile internet experience happen for consumers globally. Buongiorno’s web apps brands include Gamifive, MuchGossip, Fingerbooks, Appsfuel HTML5 Marketplace, Winga, Play.me and the mobile payments solution Cashlog.




Challenges

  • Rely on a database delivering high performance and scalability to power Buongiorno’s mobile services. The database additionally needed to be very easy to use in order to rapidly launch and easily manage new fast growing applications.
  • Implement an effective monitoring solution in order to increase Dev-Ops productivity and focus resources on strategic operations.
  • Maintain a low Total Cost of Ownership (TCO) for its infrastructure, both initially and over time.

Solution
  • Selected MySQL to power Buongiorno’s platform.  The team especially valued its performance and scalability for mobile applications, including the ability to very quickly open and close connections to the database. MySQL was moreover extremely easy to use, and would allow the company to cost-effectively scale-out, adding more database servers at low cost to fuel its growing business.
  • MySQL instances are hosted on virtualized servers. The architecture currently consists of over 50 MySQL database instances including:
    • Over 40 “MySQL chains” as illustrated in the below diagram with circular replication between master and slave servers (or "Master Backup") to ensure High Availability, and replication to a second slave server for reporting purposes.
    • Over 10 additional similar MySQL chains without replication to another slave server for reporting needs.

  • More than 8 TB of data are stored in the MySQL master servers (excluding the replicas). The application handles:
    • Over 50,000 queries/second
    • Over 15,000 transactions/second
  • While several MySQL versions are still in use in the platform, all servers are being migrated to MySQL 5.6 in order to take advantage of the latest features.
  • Standardized on MySQL Enterprise Edition. Relying on the MySQL Enterprise Monitor Visual dashboard to monitor all MySQL databases at a glance. Automated alerts enable the Buongiorno DBAs to immediately focus on potential problems and fix them before they impact the system.
  • Leveraging Oracle’s MySQL Technical support to assist their team. "We turn to the support team whenever we don’t know the answer, they are extremely good and really responsive" said Carmine Giordano, DBA Manager.
  • Planning to use MySQL Enterprise Backup, that now integrates with their central company backup solution.


"MySQL is an excellent database to deliver mobile applications; it’s really fast, reliable and easy to use. I highly recommend MySQL Enterprise Edition; the latest version of the MySQL Enterprise Monitor is extremely useful and saves us a lot of time and efforts." Carmine Giordano, DBA Manager, Buongiorno

MySQL Enterprise Monitor provides real-time visibility into the performance and availability of all your MySQL databases. Learn More.

About

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

Twitter


Facebook

Search

Archives
« April 2015
SunMonTueWedThuFriSat
   
1
3
4
5
7
8
9
10
11
12
14
16
17
18
19
21
22
23
25
26
27
28
29
30
  
       
Today