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.

Wednesday Mar 19, 2014

MySQL Connect @ OpenWorld Call for Proposals Open

We announced yesterday that the call for proposals for MySQL Connect @ OpenWorld 2014 is now open!



Part of Oracle OpenWorld 2014, MySQL Connect @ OpenWorld will be held September 29 - October 2 in San Francisco.

We encourage MySQL customers, partners and community members to submit proposals to present best practices, case studies and insights you’ve gained working with MySQL. Proposals can be submitted for conference sessions, Birds-of-a-Feather sessions and tutorials.

MySQL Connect @ OpenWorld will feature five tracks:

  • Performance and Scalability
  • High Availability and Replication
  • Cloud and Big Data
  • Database Administration and DevOps
  • Architecture and Application Development


Details and submission guidelines are available at: http://www.oracle.com/openworld/call-for-papers/index.html

The call for proposals will be open until April 15, 2014. We look forward to your submissions!

Tuesday Mar 04, 2014

Update on the MySQL Connect 2014 Call for Papers

In January we encouraged you to prepare for the MySQL Connect Call for Papers, indicating how.


While dates are still subject to change, we wanted to let you know that the CFP (for MySQL Connect and Oracle OpenWorld overall) will likely open around March 18th. Remember to prepare your submissions in advance in order to swiftly submit them during the 4 to 5 weeks that the CFP will remain open!

Thursday Feb 27, 2014

SIG - MySQL meeting in Berlin, Germany!

We are pleased to announce the SIG MySQL meeting taking place in Berlin, Germany next month! Come to hear news not only from the MySQL world but also on the other topics!

Event details:

Event Name: SIG MySQL

Date: March 27, 2014

Time: 9:30 - 17:30

Place: DOAG e.V. Geschäftsstelle Tempelhofer Weg 64 12347 Berlin  

Event URL & Agenda

We are looking to seeing you there! 

Tuesday Feb 18, 2014

Zyme Relies on MySQL Enterprise Edition to Deliver High Quality Global Channel Insights to Customers

Zyme, based in Redwood Shores, California, is the global leading provider of Channel Data Management (CDM) solutions to companies selling through indirect channels. For high tech and consumer electronic products alone, over $1 trillion USD worth of goods are flowing through those indirect sales channels every year. However, when companies sell products through multi-tier channel partners and retailers around the world, it has proven to be challenging in acquiring global, standardized channel inventory and sales data cost-effectively. As a result, companies lacking of such critical information often miss the opportunities to make timely and accurate business decisions either to increase revenue, reduce costs or to prevent losses.

Having a vision to solve such channel visibility problems for customers including Symantec, Logitech, Seagate and Xerox, Zyme built its channel data management solutions that not only get reliable, high-quality channel data from thousands of partners worldwide, but also have the capability to integrate with customers’ existing on-premise or cloud CRM, Data Warehousing or Business Intelligence systems to bring such channel visibility and information to the field sales and marketing teams and drive better business results.

The Business Challenge 

Zyme was founded with a mission to improve channel visibility after witnessing the following issues:

  • Lack of a cost-effective infrastructure to capture channel activities globally
  • Lack of a global standard for channel data reporting, such as point-of-sales (POS) data
  • Poor partner compliance and low quality of data reporting 

To build a system that is capable of handling critical channel data across continents cost-effectively, Zyme was looking for a database to support its solution that automatically captures, validates, cleanses and synchronizes the channel data, which then provides a high-quality view of data that correctly reflects Zyme’s customers’ sales and inventory activities on a daily and weekly basis. In addition, the database has to support millions of transactions every day given the huge volume of channel data flowing into Zyme’s channel solution from all over the world.

The MySQL Solution 

Zyme selected MySQL since the launch of its products because it met all the following requirements Zyme needed for its mission-critical channel data solution:

  • ACID compliant
  • Ease of use and administration
  • Open source
  • Cost-effective support services backed by a well-recognized company  

Currently MySQL stores 2.5 Terabytes data, composed by 1 billion records Zyme collects from retailers and distributors across the globe. Deploying the master-slave replication topology, Zyme makes the master MySQL database in charge of receiving incoming data and processing over 50 million transactions per month, with two layers of slave databases handling reporting and backups respectively.  

To ensure the channel activities are captured consistently and correctly, one of the critical missions for Zyme’s DBA team is to minimize unplanned downtime and data corruption, and to restore the data to a previous time in the rare case that something goes wrong. The team had tried out various backup solutions, both commercial and open source ones; however those tools either provided merely file-level backup or required a lot of manual setup and configuration processes which made backup very difficult. Moreover, Zyme has a unique need of creating a lot of temporary tables, as many as 200 to 300 on top of its 600GB to 800GB database, and the other backup tools just couldn’t keep up with the volume of data Zyme needed to archive. MySQL Enterprise Backup, with its “point-in-time recovery” feature, allows Zyme to recover data to a previous time easily when an error happens, without taking the system down. Furthermore, MySQL Enterprise Backup provides many additional benefits to Zyme, including: 

  • One single utility for both backup and recovery
  • Easy-to-find, easy-to-configure backup options
  • Adjustable read, write and compression speeds for better flexibility
  • Easy automation for backup processes
  • Easy-to-access backup data which is stored right in the database – no need for a separate repository
  • Incremental backup for InnoDB tables to save disk space
  • Backward compatibility – using InnoDB Plug-in, the complete backup and recovery features can be used by databases still on MySQL 5.1

Zyme also takes advantage of the audit functionality in MySQL Enterprise Audit to audit users who log into the system. The DBA team is currently in the process of upgrading production servers from MySQL 5.1 to MySQL 5.5 so the audit plug-in, supported in MySQL 5.5.28 and above, can be used more broadly to improve overall database security. In the next phase, the production servers will be upgraded again to MySQL 5.6, the most current GA version of MySQL, to fully leverage the latest features and further enhance the performance, security and reliability of Zyme’s MySQL databases.

“As a DBA, it’s my job to always make sure we have a consistent backup, a good monitoring solution, plus an audit tool to maintain data integrity, performance and security, and that’s why I strongly advocate MySQL Enterprise Edition, where I can find all the features I need in one place, to support the MySQL environment at Zyme”. Prasad Gowda, Associate Director - DBA, Zyme

MySQL Enterprise Backup is a powerful, yet very easy-to-use tool. It offers one utility for both backup and recovery, layouts the options that are easy to find, understand and configure, and provides great flexibility with backup customizations. It’s as easy as using a cookie-cutter: just setting the parameters, pointing to the instances, taking the snapshots, and we got the backup done. More importantly, we achieved much better results with MySQL Enterprise Backup, using less than 10 percent of the time we used to spend just researching other backup tools in the market. It has become an indispensable tool for the DBA team at Zyme”. Prasad Gowda, Associate Director - DBA, Zyme

Learn More about Zyme: http://www.zymesolutions.com/ 
Read more MySQL customer stories: http://www.mysql.com/customers/ 

Friday Jan 31, 2014

Upcoming MySQL Tech Tours

Oracle’s MySQL team is running Tech Tours in multiple cities across the US and Europe during the upcoming months. Register now for the following free events:


We look forward to seeing you there!

Thursday Jan 30, 2014

Gina Tricot Scales Online Sales with MySQL Enterprise Edition

Gina Tricot is a family-owned, Swedish fashion chain that consists of over 180 stores across the following five markets: Sweden, Norway, Denmark, Finland and Germany. Combined with growing online sales, the company reaches fashion-conscious women in 28 countries across Europe. In 2012, Gina Tricot reported sales of SEK 2.3 billion.

http://mosseporten.no/wp-content/uploads/2010/10/gina_tricot.jpg


Challenges

  • Implement a reliable and scalable infrastructure to drive online sales both in countries with a physical presence via stores and in countries where the company sells exclusively online.
  • Outsource the day-to-day administration of the e-commerce system, including the databases, to a local partner while maintaining overall overview and control of the system.

Solution
  • Selected MySQL to power Gina Tricot’s e-commerce application based on its reputation as default database for web-based transactional applications, its low Total Cost of Ownership (TCO) and the recommendation of the local partner in charge of the implementation.
  • Decided to outsource both the physical infrastructure to a public cloud services provider and the day-to-day database administration to Oracle partner Emineo in Sweden.
  • Implemented MySQL replication to improve performance and scalability. While the system was initially built using MySQL Community Edition, upgraded to MySQL Enterprise Edition in order to ensure better performance, reliability and security. The MySQL Enterprise Monitor visual dashboard furthermore provides the Gina Tricot IT managers with an overview of the health of the databases at any point in time.
  • Using the MySQL Enterprise Monitor and MySQL Query Analyzer to detect poorly performing queries and to fix both existing and potential issues before they impact the application.
  • Achieved objective of maintaining visibility on all key database performance indicators and control over the application while delegating the execution of the database administration tasks to a partner.

"MySQL Enterprise Edition enables us to expand and grow online sales in both existing and new countries while maintaining a low TCO. It is a high performance, scalable and easy to monitor database; we’re extremely pleased with it." Nicklas Griphem, Manager Server & Infrastructure, Gina Tricot


Wednesday Jan 29, 2014

Atos Manages Transaction Clearing for the Euronext Markets in Continental Europe with MySQL Enterprise Edition

Atos is an international information technology services company with annual revenue of EUR 8.8 billion and 77,100 employees in 52 countries. Serving a global client base, it delivers IT services in 3 domains, Consulting & Technology Services, Systems Integration and Managed Services & BPO and transactional services through Worldline.

In 2009 Atos was asked to drastically reduce the costs of the UCS application (Universal Clearing System): the compensation engine for the Euronext Cash (stocks and bonds) and derivatives markets in the Euro zone. In the financial sector, clearing is exercised by aggregating all purchases and sales by the type of product/assets held by each account holder, resulting in a balance of net payables or receivables as well as the net flows of securities delivered or received.