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/ 

Monday Nov 05, 2012

MySQL Policy-Based Auditing Webinar Recording Now Availabile

For those who missed the live event, the recording of the "How to Add Policy-Based Auditing to your MySQL Applications" webinar is now available.  You can view it here.

This presentation builds on my earlier blog post on MySQL Enterprise Audit that was announced at MySQL Connect in late September.  The web presentation expands on the introductory blog and covers:

  • The regulatory problem to be solved (internal audit, PCI, Sarbanes-Oxley, HIPAA, others)
  • MySQL Audit solutions for both Community and Enterprise users:
    • General Log - use the basic features of the MySQL server
    • MySQL 5.5 open audit API - or use your time and talent to build your own solution
    • MySQL Enterprise Audit - or use the out of the box, ready for production solution from MySQL
  • Simple, step-by-step process for installing, enabling and configuring the MySQL Enterprise Audit plugin for use with existing apps
  • New variables and options for tuning the MySQL Enterprise Audit plugin for your specific use case
  • Best practices for securing and managing audit log files and archived images
  • Roadmap for adding an integrated solution around MySQL Enterprise Audit for MySQL only and Oracle/MySQL shops

You can learn all the technical details on MySQL Enterprise Audit in the MySQL docs and learn all about MySQL Enterprise Edition and Auditing here.

As always, thanks for your support of MySQL!

Tuesday Oct 30, 2012

How to Add Policy-based Audit Compliance to your existing MySQL applications

As a follow up to an earlier blog on the subject, please join us today at 0900 US PT to learn how to easily add policy-based auditing compliance to your existing MySQL applications.  This brief, informative session will provide an overview of the new MySQL Enterprise Audit plugin and will include a simple, practical step-by-step "how to" approach to get up and running with the new functionality.

You can learn more and secure your seat for the presentation here.

 Thanks for your continued support of MySQL!


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




« July 2016