Guide to MySQL Embedded

50 %
50 %
Information about Guide to MySQL Embedded

Published on November 16, 2016

Author: VladAlexandru10

Source: slideshare.net

1. Copyright © 2016, Oracle and/or its affiliates. All rights reserved. Guide to MySQL as an Embedded Database: For Software, Hardware and SaaS Vendors A MySQL® White Paper

2. Copyright © 2016, Oracle and/or its affiliates. All rights reserved. 2 Table of Contents Introduction....................................................................................................... 3 Evaluating Embedded Databases ....................................................................... 3 Reduced Risk...................................................................................................... 4 A Proven Solution ................................................................................................................... 4 Oracle Provides Strong Backing.............................................................................................. 5 World-Class Support............................................................................................................... 6 MySQL Embedded vs. DIY....................................................................................................... 6 MySQL Included vs. Customer Supplied................................................................................. 6 Increased Revenue and Customer Satisfaction .................................................. 7 Performance and Scalability................................................................................................... 7 High Availability ...................................................................................................................... 9 Reliability and Fault Tolerance ............................................................................................. 10 Data Protection and Security................................................................................................ 11 Flexibility to Meet Current and Future Needs...................................................................... 12 Lower Product COGs ........................................................................................ 13 Cost-Effective........................................................................................................................ 14 Ease of Development and Faster Time to Market................................................................ 14 Powerful Tools...................................................................................................................... 15 Lower Customer TCO............................................................................................................ 17 Conclusion ....................................................................................................... 18 Resources......................................................................................................... 19

3. Copyright © 2016, Oracle and/or its affiliates. All rights reserved. 3 Introduction MySQL is the world’s most popular open source database. Though best known as the #1 database, for the Web, MySQL has always also been an extremely popular product-bundled and embedded database (hereafter, “embedded database”). Software, Hardware and SaaS vendors, including eight of the top ten largest software companies1 , 5 of top 5 largest telecoms equipment providers2 , and numerous high-growth startups, rely on MySQL as their products’ embedded database. This paper examines the ways in which using MySQL as an embedded database can impact the three most fundamental determinants of software, hardware and SaaS business success - Revenue, Cost and Risk. For additional details on the benefits of using MySQL for SaaS please see “Guide to Using MySQL for SaaS” white paper. Evaluating Embedded Databases Selecting the right database can be vital to your product’s success:  To most of your customers an embedded database is simply a feature of your product.  Your product will generally perform only as well as its database.  Your choice of embedded database is not easily changed In other words, your customers’ satisfaction with your product is dependent on their experience with its database, good or bad. And, migrating from one database to another is rarely easy, especially when multiplied by tens, hundreds, or thousands of customers. As with any business decision, it’s useful to assess its impact on the elements that contribute most to your profitability, and ultimate success:  Risk – Are there any aspects of the database, such as vendor viability, or availability of support services, that constitute risk to your product? Or are you planning build your own, or support your customers’ database?  Revenue – Does the database have the capabilities to help your product compete and win in its intended market(s) – now? in five years?  Costs – How will the database affect your COGS (cost of goods sold) and your customer’s TCO (total cost of ownership) over the entire lifecycle of your product? In the remainder of this paper, we will examine how using MySQL as your embedded database can positively impact your products’ and business success. 1 https://en.wikipedia.org/wiki/List_of_the_largest_software_companies#Forbes_Global_2000 2 https://en.wikipedia.org/wiki/Telecommunications_equipment#Vendors

4. Copyright © 2016, Oracle and/or its affiliates. All rights reserved. 4 Reduced Risk Starting with an assessment of database risk is often a good first step as it may eliminate the need to proceed with an in-depth technical evaluation, or point you in another direction entirely. Embedded database risk can come in the form of:  New, unproven technologies, or a small customer base.  Vendor instability, which can lead to under-investment in the technology, and an uncertain future. The risk of vendor instability increases if it’s not the clear leader, or if the market is fragmented among many vendors.  Not using support, or relying on support from an unproven vendor, or one with limited hours / geographical reach.  Building, maintaining and supporting your own data store.  Supporting your customers’ multiple databases. Using Oracle MySQL carries none of these risks and provides assurances other options simply cannot. A Proven Solution There are conservatively over 14 million active MySQL installations around the globe, and tens of thousands of new downloads from the mysql.com every day. This large installed base provides a testing and feedback loop that contributes to MySQL’s continuing quality and reliability. It also assures that, whatever your application, hundreds or thousands have probably used MySQL in the same way.  The majority of the top 100 most heavily trafficked Web sites in the world3 rely on MySQL, including Facebook, Google, and Baidu.com.  MySQL is a leading Cloud database used in Amazon WebServices, Microsoft Azure and Google cloud to name a few.  Global companies such as Shinsei Bank, Lufthansa, and Walmart rely on MySQL for their day- to-day business.  Leading Software, Hardware and SaaS vendors entrust their products to MySQL as their embedded database. Shown below are just a few of MySQL’s ISV and OEM customers. 3 From Alexa’s list of the Top 500 Sites on the Web http://www.alexa.com/topsites/global;0

5. Copyright © 2016, Oracle and/or its affiliates. All rights reserved. 5 Figure 1: MySQL ISV and OEM Customers To learn more about MySQL’s customers, why they selected MySQL and how they’re using it please check out our customer site. Oracle Provides Strong Backing MySQL AB was acquired by Sun Microsystems, Inc. in January of 2008, which in turn was acquired by Oracle Corporation two years later in January 2010. Some wondered about the fate of MySQL under Oracle. When assessing the acquisition of a technology, it’s helpful to look at the strength of the acquiring company in that technology, and most importantly, how the technology has fared under the new owner. Oracle holds 46.2% of the RDBMS market, equal to its next 6 closest competitors combined 4. According to DB Engines ranking, Oracle Database and MySQL are the #1 and #2 most popular databases in the world.5 Oracle’s Investment in MySQL and Results Since acquiring MySQL in 2010, Oracle has made significant investments in MySQL.  The MySQL Engineering and MySQL Support teams have doubled in size.  The MySQL QA team has grown by a factor of three.  The impact of this investment can be seen in the number, quality, and scope of MySQL releases under Oracle, which are unsurpassed in the history of MySQL. - MySQL Product Versions - Timeline - What’s New in MySQL 5.5 - What’s New in MySQL 5.6 - What’s New in MySQL 5.7 4 IDC, “Worldwide RDBMS 2014 Vendor Analysis: Top 10 Vendor License Revenue”, December 2015. 5 http://db-engines.com/en/ranking

6. Copyright © 2016, Oracle and/or its affiliates. All rights reserved. 6 World-Class Support Oracle offers Premier, 24x7, global support for MySQL in 29 languages from the largest team of MySQL support engineers. Only Oracle MySQL support can provide direct access to the engineers who create MySQL. Oracle Premier Support for MySQL includes:  Unlimited support incidents  Knowledge Base  Maintenance releases, bug fixes, patches and updates  SQL Consultative Support MySQL Consultatative Support services include: Performance Tuning and Code, Query, Schema, and Partitioning Reviews that can help you ensure MySQL is optimized for your product before it ships. The result is better customers experience and problem prevention.. In surveys collected upon resolution of all support issues, 95% of MySQL customers report satisfaction with MySQL Support’s services. - Oracle Premier Support - MySQL Consultative Support MySQL Embedded vs. DIY Creating, maintaining, and supporting your own database often carries high opportunity cost and risk. Using an established embedded relational database like MySQL can help reduce cost and risk by enabling you to:  Focus on Core Competencies - By embedding MySQL, you avoid the high cost of developing and maintaining software that is outside your development team’s core competencies and can focus instead on differentiating your product.  Accelerate Time to Market - By effectively outsourcing your database, you can get new release into the market more quickly.  Limit Risk to Engineering Schedule – By embedding MySQL you eliminate the risk to your product delivery schedule that’s inherent in learning and developing noncore technologies. MySQL Included vs. Customer Supplied Including MySQL database with your product is usually more cost-effective and carries less risk than supporting your customers’ databases’. By including MySQL you can:  Lower the Total Cost of Your Solution Databases can be expensive, even more expensive than your application. By including low- cost, zero administration MySQL with your product, your customers are not burdened with buying, installing, configuring, administering, tuning, or maintaining the database, which can significantly reduce the overall cost of your solution.

7. Copyright © 2016, Oracle and/or its affiliates. All rights reserved. 7 “The Product Team had performed a comprehensive product cost analysis that showed the majority of our development, quality assurance, and documentation cycles and dollars were being spent on supporting our customers’ Microsoft SQL Server configurations. In addition, we found that one out of every five trouble tickets had been opened against issues dealing with the integration to Microsoft SQL Server. Because of this, and in response to our customers’ requests to include a database, we decided to use MySQL [embedded] for its performance, ease of use, stability and reliability. We achieved 100% ROI in under nine months through lowered development, QA, tech pubs, training and support costs alone.” Dell  Cut Development, Documentation, Quality Assurance, and Support Costs Developing, testing, documenting, and supporting the use of your product with just MySQL vs. the long list of databases and multiple versions your customers may use, can substantially reduce your COGs throughout your product’s lifecycle.  Shorten Sales Cycles, Win Competitive Comparisons Sales cycles can speed up dramatically when database selection and costs are eliminated. Proofs of Concept (PoCs) can be run in a fraction of the time with MySQL pre-integrated, tuned for your application, and installed automatically. In addition, your application can perform optimally out of the box, providing a significant advantage in competitive situations.  Increase Customer Satisfaction Including MySQL provides your customers with a better experience – initially and over time. Your customers can get your product into production much faster, and enjoy better performance without the burden of administration, maintenance, support, or a high-cost DBA. Increased Revenue and Customer Satisfaction The following section reviews some of MySQL’s key capabilities that can help your product compete and win, and meet your customers’ current and future data management needs. Performance and Scalability MySQL’s is renowned for its ability to perform and to scale horizontally across commodity hardware, which has made it the database of choice for the largest Web properties, the Cloud, and some of the most demanding industries, such as Telecommunications and Security. These customers substantiate MySQL’s ability to meet some of the most demanding performance and scalability requirements. For example, Facebook deploys thousands of MySQL servers and has scaled MySQL to handle over 1.3 billion active users. MySQL’s performance and scalability has improved significantly with each new release as evidenced in the benchmark results, below.

8. Copyright © 2016, Oracle and/or its affiliates. All rights reserved. 8 Intel(R) Xeon(R) CPU E7-8890 v3, 4 sockets x 18 cores-HT (144 CPU threads), 2.5 Ghz, 512GB RAM, Linux kernel 3.16 Figure 7: MySQL Sysbench Benchmark MySQL Performance and Scalability Features MySQL Replication - Replication is the most popular and cost-effective way most users achieve higher levels of performance and scalability. Using MySQL Replication, your high growth customers can scale-out their database environments by easily and inexpensively adding more MySQL servers on low-cost commodity hardware. In MySQL 5.6 and 5.7, MySQL Replication advanced significantly adding support for Multi-Threaded Slaves Bin-Log Group Commit and Optimized Row-based Replication, and many other capabilities. Partitioning – MySQL’s Partitioning capabilities significantly increase the performance and simplify the management of very large databases. MySQL offers multiple partitioning methods including Range, List, Column, Hash (and Linear Hash), Key, Sub-Partitioning, and Partition Pruning. Thread Pool - MySQL Thread Pool reduces overhead in managing client connections and statement execution threads so MySQL’s high performance is maintained even with thousands of concurrent users. Memcached Plug-in for NoSQL Access – MySQL’s NoSQL option maintains all the advantages MySQL’s relational database infrastructure while providing blazing fast performance for simple queries. Using MySQL memcached plug-in provides direct access to the InnoDB storage engine without transformations to SQL (i.e., “NoSQL”), ensuring low latency and high throughput for read/write queries. Operations such as SQL parsing are eliminated and more of the server's hardware resources (CPU, memory and I/O) are dedicated to servicing the query within the storage engine itself. MySQL Fabric for Scale-out - MySQL Fabric is an extensible framework for managing farms of MySQL Servers that provides scale-out using data sharding. When nearing the capacity or write performance

9. Copyright © 2016, Oracle and/or its affiliates. All rights reserved. 9 “MySQL handles 20,000 write operations per second from the NetHawk network monitoring system and generates up to 8 terabytes of data comprising 10-20 billion rows per month, all accessed by multiple client systems. MySQL embedded efficiently partitions tables and indexes, enabling our product to better manage and perform with those massive data sets.” NetHawk “Using MySQL with partitioning, we took our product from a maximum of 3,500 records per second to 22,000 records per second, for a 6x performance gain. We’re now at 10x (1,000%) performance of pre-partitioning levels and still haven’t reached the max simply because we haven’t had enough test machines.” F5 limit of a single MySQL Server (or HA group), MySQL Fabric can be used to scale-out the database servers by partitioning the data across multiple MySQL Server "groups". Query Performance Optimization MySQL Optimizer and Parser have undergone considerable refactoring in recent releases, using a more efficient query cost-model that, in effect, determines the cost/benefit of various query execution paths and executes the one that will result in the highest possible performance. Just a few of the additions and improvements are:  Query Re-write Plug-in  More efficient Sub-Query processing  Use of EXPLAIN to analyze and improve long-running queries  Support for Optimizer “Hints” - MySQL Replication - MySQL Partitioning - MySQL ThreadPool - NoSQL via InnoDB memcached plug-in - MySQL Fabric High Availability Few things can damage customer satisfaction like the inability to transact business and the associated loss of revenue and productivity. MySQL has a number of high availability solutions: the right one depends on the mission-criticality of your application and number of “nines” availability your customers require. Listed from lower to higher availability options they are: Replication – Replication is the most popular MySQL high availability (HA) solution in addition to being the most popular performance and scalability solution. It uses Master/Slave Replication to enable database operations to manually fail-over to another server in the event of a hardware or software problem. Better Fail-over with Replication GTIDs, and more - MySQL 5.6 added support for GTIDs (Global

10. Copyright © 2016, Oracle and/or its affiliates. All rights reserved. 10 Transaction Identifiers), unique ids for each transaction that can be used across a replication topology. They make failover simpler and more reliable even when a slave is out of sync, or the master hasn’t completed all writes. Other replication enhancements include support for Semi-sync Replication, Dynamic Reconfiguration Support, and more. MySQL Group, “Multi-Master” Replication - MySQL Group Replication is a MySQL plugin based on MySQL 5.7.10 that brings multi-master updates everywhere, creating a seamlessly distributed and replicated database over a set of MySQL servers that cooperate to keep the replicated state strongly consistent. It’s available from MySQL Labs before its 1.0 GA. MySQL Fabric - While MySQL Replication duplicates data to ensure its safety, MySQL Fabric add two additional components for a complete HA solution:  Failure detection and promotion - MySQL Fabric monitors the Master within an HA group and should that server fail then it selects one of the Slaves and promotes it to Master.  Routing of database requests – MySQL Fabric automatically routes writes to the Master and load balances reads across the slaves, even when the topology changes during failover. MySQL Cluster CGE (Carrier Grade Edition) - MySQL Cluster enables organizations to deliver up to 5 Nines (99.999%) availability using parallel server architecture with no single point of failure. MySQL Cluster supports in-memory or disk-based data and synchronously replicates data to all data nodes in the cluster. This results in sub-second real-time responses and extremely fast failover. MySQL cluster automates data partitioning, fail-over and recover. MySQL Cluster offers Auto-Sharding for write-scalability, SQL and NoSQL APIs, Geo-Replication for Multi-Site Clusters, On-line Scaling and Schema Upgrades. Cluster is used by many of the world’s leading telecom equipment providers including Alcatel-Lucent, Ericsson, Juniper and Huawei. MySQL Cluster CGE is available separately. - MySQL Replication - MySQL Enterprise High Availability - MySQL Fabric - MySQL Cluster Reliability and Fault Tolerance The same reliability has allowed Telcos and other “always-on” businesses to standardize on MySQL is available to ISVs and OEMs as well, whether they’re like Symantec, addressing the needs of the Fortune 1000, or like Sage Accounting, targeting thousands of SMBs. As the most popular open source database, MySQL is stress-tested by many thousands of users who provide invaluable feedback. MySQL server also undergoes extensive internal and external quality assurance testing to ensure its code is of the highest quality.

11. Copyright © 2016, Oracle and/or its affiliates. All rights reserved. 11 “Xceedium GateKeeper is actually used in live combat zones and may not be shut down cleanly. The product must come back up regardless. MySQL was the best at self-repair, with the ability to fix any corruption and come back after induced crashes. We just couldn't break it.” Xceedium “Our overall experience with MySQL has been extremely positive. MySQL just runs and runs – our customers have never had to reboot. We haven’t had one sub-case that could be traced back to MySQL. We have also been impressed that with new releases of MySQL nothing has ever broken; we have just got improved features.” F5 Data Protection and Security The data generated by your application, and stored and managed by its database, is likely to be one of your customers’ most valued assets. MySQL offers safeguards to help insure against data loss, whether by system or operator error, or by malicious acts, and to maintain legal and standards compliance. They include: Transactional Support - The InnoDB transactional storage engine assures data integrity and provides ACID-compliant transactions, MVCC or multi-version currency control, foreign keys and much more. Online Backup – MySQL Enterprise Backup performs online or “hot”, non-blocking backups of your MySQL databases, safely restoring your data from a full backup. MySQL Enterprise Backup also supports Point-in-Time Recovery (PITR). You have the option of performing Full, Incremental, Partial, Selective, or “Optimistic” Backups. MySQL Enterprise Backup can also create compressed backup files, typically reducing backup size from 70% to over 90%, greatly reducing storage and other costs. In addition, you can Backup and Restore directly to/from S3 and other Cloud Storage using the AWS S3 API, and backups can be encrypted using AES 256. User Authentication - MySQL Enterprise Edition provides ready to use external authentication modules that easily integrate with other security infrastructures including LDAP and Windows. MySQL users can be authenticated using Pluggable Authentication Modules (“PAM”) or native Windows OS services. Audit – MySQL Enterprise Audit is an easy to use, policy-based auditing solution that tracks who does what to which piece of data. It allows you to:  Dynamically enable/disable the audit stream  Implement policies that log all or only selected login or query activities  Automatically rotate audit log files based on size  Integrate XML-based audit log stream with MySQL, Oracle and other third party solutions

12. Copyright © 2016, Oracle and/or its affiliates. All rights reserved. 12 Encryption - MySQL Enterprise Encryption provides encryption, key generation, digital signatures and other cryptographic features to help protect confidential data and comply with regulatory requirements including HIPAA, Sarbanes-Oxley, and the PCI Data Security Standard. Firewall - MySQL Enterprise Firewall runs transparently in your application to provide real-time protection against database specific attacks, such as an SQL Injection. MySQL Enterprise Firewall monitors for database threats, automatically creates a whitelist of approved SQL statements, and blocks unauthorized database activity. - MySQL InnoDB Storage Engine - MySQL Enterprise Backup - MySQL Enterprise Security - Authentication - MySQL Enterprise Audit - MySQL Enterprise Encryption - MySQL Enterprise Firewall Flexibility to Meet Current and Future Needs Document Store and RDBMS - MySQL 5.7 added Native JSON Support, which means it can operate as a transaction-safe document store and/or an RDBMS. You don’t have to choose between RDBMS or Document Store, or run two different databases, or risk data loss to get document store benefits. MySQL supports a Native JSON data type that enables: Automatic Validation of JSON documents, an Optimized Storage Format and More Efficient Access. GIS Support for Location-Based Services – MySQL has added a highly sophisticated set of GIS (Geographic information Systems) capabilities to InnoD, including support for: Boost Geometry, native GEOMETRY data type, SPATIAL INDEX (using Rtree), Geohash and GeoJSON. MySQL’s GIS capabilities can be used for: location-based services; Insight into and management of physical; and much more. With it, MySQL enables you to provide your customers richer, and “stickier” applications. SQL or NoSQL – As noted earlier, with MySQL you have a choice of using either or both SQL and NoSQL access to the same dataset. MySQL’s Multi-Language Support assures you can use whatever development is best suited for your application and development team. Multi-Platform Support means MySQL will never lock you in. Though MySQL is best known as the “M” in LAMP, Oracle has invested heavily in MySQL’s Windows capabilities. It’s resulted in tremendous MySQL performance gains on Window as well as rich tools and capabilities. Open Source - With access to the MySQL source code base, ISVs and OEMs have the flexibility to tailor MySQL to meet your application and customers’ specific needs. Your developers also benefit from one of the world’s largest and most active open source ecosystems with a huge community of users who work with the product daily submitting bug issues and reports, and contributing ideas back to MySQL.

13. Copyright © 2016, Oracle and/or its affiliates. All rights reserved. 13 “With MySQL, we’re in a much better place than when we started. Customer satisfaction is even higher now. The Simply Accounting by Sage Enterprise version was made possible because of MySQL, and we are able to scale with our customers’ needs.” Sage "For over 12 years MySQL has provided us with solutions for our growing data needs. We've never found a competitor that can match it," ScienceLogic SaaS and/or On-Premise – MySQL is the #1 open source database in the Cloud and Web, and a leading product-embedded database, relied on by 8 of the top 10 software vendors. You can use the same MySQL database in your on-premise application or appliance and in your SaaS application. Using the same database can save you a lot time, money, and even headcount. Start out and Stay with MySQL - MySQL is both full-featured and low cost. You can keep pace with your customers’ data needs as they increase over time, saving you and your customers the expense and hassle of migrating your product and their data to a new database. And, uou can extend your products’ reach to more sophisticated users and higher value markets, easily adding “enterprise” editions to your product line and MySQL also provides margin flexibility to more effectively compete at the opposite end of the market, in cost-sensitive, high volume markets without sacrificing profitability. MySQL’s ease of use / zero admin is another advantage in meeting the needs of these markets, which are often comprised of non-technical users. Lower Product COGs Since its inception, MySQL has been designed to keep costs low for both product vendors and their customers throughout a product’s lifecycle. Using MySQL, you can devote fewer resources to your products’ database and more toward improving and differentiating your products. You can also gain the margin flexibility to improve profitability or compete in more cost-sensitive markets. .

14. Copyright © 2016, Oracle and/or its affiliates. All rights reserved. 14 “Most of our engineers were already familiar with MySQL. We could draw on existing expertise, saving us the substantial investment in time and money it would have required to come up to speed on another database.” Xceedium “It took us less than one day to fully integrate MySQL with our products, which is a small fraction of the time it’s taken us just to research how to integrate with other databases.“ Fixmo Cost-Effective MySQL’s cost effectiveness can be seen quantitative analyses. In a comparison of total costs over a three-year period, MySQL is over 90% less expensive than Microsoft SQL Server. Hardware Configuration: Intel x86_64 Servers: 4, CPUs/Server: 4, Cores/CPU: 4 Figure 3: Three Year Database TCO Comparison You can customize the same TCO Calculator to estimate your cost savings. - MySQL TCO calculator Ease of Development and Faster Time to Market MySQL’s low learning curve and ease of development have contributed greatly to its adoption and popularity. There are few developers who are not already familiar with MySQL so most ISVs / OEMs do not need to hire in new skills to use MySQL. Developers can get up to speed quickly using MySQL’s quality documentation and active user forums in addition to help from MySQL Consultative Support. The result is reduced database development time, increased focus on your application, and accelerated time to market.

15. Copyright © 2016, Oracle and/or its affiliates. All rights reserved. 15 “MySQL Workbench has allowed our team to improve productivity and deliver products on time and within budget. The tool is very intuitive and our new staff’s ramp up time minimal. This tool has reduced the task time of our data modeling significantly. This leaves more time to concentrate on quality and eliminates defects early in our development phase.” B-Three Solutions Powerful Tools MySQL Workbench MySQL Workbench is a visual database modeling and design tool, a SQL editor, and an administrative tool. MySQL Workbench enables developers to visually design, generate models, and manage databases. It helps create complex ER models, includes forward and reverse engineering, and eases change management and documentation tasks that normally require significant time and effort. In addition, MySQL Workbench delivers visual tools for creating, executing, and optimizing SQL queries. The SQL Editor provides color syntax highlighting, auto-complete, reuse of SQL snippets, and execution history of SQL. The Database Connections Panel enables developers to easily manage standard database connections, including MySQL Fabric. The Object Browser provides instant access to database schema and objects. Figure 4: MySQL Workbench – Visual Database Design - MySQL Workbench

16. Copyright © 2016, Oracle and/or its affiliates. All rights reserved. 16 MySQL Enterprise Monitor MySQL Enterprise Monitor is a monitoring and analysis tool that can be used as a  QA and testing tool  Value-added support service to monitor, optimize or troubleshoot your customer’s installations, either remotely or on-premise  Bundled monitoring or management tool for your customers’ use  SaaS monitoring and management tool to lower your total costs and ensure SLAs. Figure 5: MySQL Enteprise Monitor’s Query Analyzer Using MySQL Enterprise Monitor, you can:  Optimize your database design and queries before they are built into your product.  Set MySQL variables to ensure your application achieves maximum performance.  Forecast future capacity requirements using trend analysis and projections.  Configure MySQL servers to scale as your customers’ data needs grow over time.  Identify security vulnerabilities in your application’s MySQL servers.  Detect security alterations in your customers’ MySQL servers.  Remotely monitor MySQL in the Cloud without the need for remote agents.  See at-a-glance and receive notifications when a server is down or performing poorly.  Receive instant, expert advice from over 250 Best Practice Advisors created by MySQL Developers. - MySQL Enterprise Monitor

17. Copyright © 2016, Oracle and/or its affiliates. All rights reserved. 17 Lower Customer TCO In MySQL’s annual surveys, lower cost is consistently shown to be the number one reason why users choose to use MySQL. An IDC study showed that there are multiple components that contribute to a database’s costs, as shown in Figure 2, and to your products’ TCO. Figure 6: IDC’s TCO Breakdown of Database Costs Using MySQL helps reduce each one of these cost components through  Affordable licenses, which can lower your product license fees (Software)  Optimization for use on commodity systems (Hardware)  Ease of development, and ease of use (Staffing)  Ease of use, availability of skills, documentation, and a huge, active user community (Training)  High reliability, scalability, and an array of HA solutions (Downtime) Easy Installation and Deployment MySQL installs in just minutes on virtually any platform and can be easily integrated into application installation processes. As an embedded database, you can set MySQL to install silently or to run as an executable process within your application. Zero Administration The MySQL database does an excellent job of administering and maintaining itself. MySQL automatically manages all of the underlying storage of the database, its memory caches, connection pools, and other such things. MySQL has a number of built-in management aids, such as a job scheduler, that lessen the need for any outside intervention. As a result, your customers will not require a dedicated DBA and, if embedded in your application, won’t need to do anything beyond your product’s administration and maintenance. This is especially important if you’re targeting SMBs, or non-technical users such as students or healthcare providers. MySQL’s low or zero administration requirements make it ideal for use in all-in-one appliances and devices. MySQL’s automatic installation and zero administration and maintenance also mean that you won’t be burdened with costly database-related support calls.

18. Copyright © 2016, Oracle and/or its affiliates. All rights reserved. 18 “We tried multiple database solutions. Based on price, performance and functionality, there were no databases that could compete with MySQL.” FairWarning “MySQL embodies what we’re trying to do with our appliances – it just works.” Dell “The benefits that MySQL brings the Brightmail product are its rock-solid quality and performance, its reliability, its robustness, and its very low administrative cost.” Symantec “MySQL’s low administrative requirements allowed Scholastic to ship products that work out of the box and don’t require school districts to hire high-cost, dedicated DBAs.” Scholastic “We only touch our appliances when we do another release, so maintenance must be simple. We’ve never had to do anything more than this once-a-release form of maintenance on MySQL.” Xceedium Conclusion As illustrated throughout this paper, using MySQL as an embedded database can lower COGs increase customer satisfaction, and lower risk simultaneously to help contribute to your product and business success. It is the #1 open source database, backed by the #1 database company. Moreover, MySQL ISV, OEM and SaaS customers consistently report high satisfaction with MySQL.

19. Copyright © 2016, Oracle and/or its affiliates. All rights reserved. 19 Resources  MySQL Products for ISVs and OEMs http://www.mysql.com/oem/  MySQL Embedded Resources - White Papers, Case Studies, Presentations and Webinars, http://www.mysql.com/why-mysql/#en-0-  MySQL Events http://www.mysql.com/news-and-events/events/  MySQL Documentation http://dev.mysql.com/doc/  MySQL Support http://mysql.com/support/  MySQL Consulting http://mysql.com/consulting  MySQL User Forums http://forums.mysql.com/  MySQL Newsletter www.mysql.com/news-and-events/newsletter/  MySQL Blogs http://blogs.oracle.com/MySQL/  MySQL on Facebook http://www.facebook.com/mysql  MySQL on Twitter http://twitter.com/#!/mysql  MySQL YouTube Channel http://www.youtube.com/user/MySQLChannel  MySQL Downloads http://dev.mysql.com/downloads/  MySQL Downloads of Commercial Binaries https://edelivery.oracle.com/  Contact On-line: http://www.mysql.com/about/contact/

Add a comment