Why Use MySQL? The Top Reasons Users, CIOs and DBAs/SysAdmins Do
MySQL is a multi-faceted open source database that many users will find more than meets their needs. In general, consider the appeal the solution has overall:
Scalability and Flexibility: can handle deeply embedded applications with a 1MB footprint, or massive, multi-terabyte data warehouses, running Linux, UNIX and Windows with potential for complete customization
High Performance: enables configurations specific to particular applications
High Availability: includes various options ranging from high-speed master/slave replication configurations to specialized Cluster servers offering instant failover, to third party vendors offering unique high-availability solutions for the MySQL database server
Robust Transactional Support: features complete ACID (atomic, consistent, isolated, durable) transaction support, unlimited row-level locking, distributed transaction capability, and multi-version transaction support where readers never block writers and vice-versa. Full data integrity is also assured through server-enforced referential integrity, specialized transaction isolation levels, and instant deadlock detection.
Web and Data Warehouse Strengths: a high-performance query engine, tremendously fast data insert capability, and strong support for specialized web functions like fast full text searches plus uses in data warehousing environments make MySQL a strong standout for both web and business intelligence applications.
Strong Data Protection: MySQL provides the ability to block users down to the client machine level plus SSH and SSL support; granular object privilege framework limits users to only the data they need; data encryption and decryption functions protect sensitive data; backup and recovery utilities allow for complete logical and physical backup as well as full and point-in-time recovery.
Comprehensive Application Development: provides comprehensive support for every application development need -- stored procedures, triggers, functions, views, cursors, ANSI-standard SQL; plug-in libraries are available to embed MySQL database support into nearly any application.; MySQL also provides connectors and drivers (ODBC, JDBC, etc.) that allow all forms of applications to make use of MySQL as a preferred data management server.
Management Ease: less than 15 minutes elapsed time from software download to complete installation on all OSes; automatic space expansion, auto-restart, and dynamic configuration changes ease database management tasks; DBA can manage, troubleshoot, and control the operation of many MySQL servers from a single workstation, even with many third party software vendor tools
Open Source Freedom and 24 x 7 Support: MySQL provides complete around-the-clock support as well as indemnification available through MySQL Network;
Lowest Total Cost of Ownership: potential cost savings can run to seven figures
The CIO should consider these reasons for choosing MySQL:
Dramatic reduction in database TCO by as much as 90% over proprietary alternatives like Oracle, Microsoft, and Sybase with no up-front licensing costs and lower ongoing operational costs
Lower downtime with support for all stages of the application lifecycle
Deliver on SLA commitments with MySQL Network Monitoring and Advisory Service enables enforcement of global SLAs across an entire enterprise
Improve productivity with MySQL Network Monitoring and Advisory Service
Modernize IT infrastructure with a proven LAMP stack (Linux, Apache, MySQL, PHP/Perl/Python), which offers organizations key advantages including lower cost of operations, improved reliability and performance, better quality and higher security.
Scale IT infrastructure incrementally with scale-out architectures that provide the flexibility to add capacity on an as-needed basis
Cost-effectively extend existing infrastructure with scale-out architecture that enables addition of capacity to Oracle applications, for example
Improve customer satisfaction by using LAMP to build web-based self-service applications.
Endorsed by Industry Analysts such as Gartner, Forrester, IDC, Meta Group, and Hurwitz
MySQL AB is an established company, in business for over 10 years
Trusted, secure and reliable, over 50,000 downloads every day
Modernize IT skills, attract new staff with the latest generation of languages (e.g. PHP/Perl/Python, Java, C#, Ruby, Groovy, AJAX)
Capitalize on new business opportunities faster by getting applications and services to market quickly
Avoid vendor lock-in by choosing open source products and open standards
Trusted Global 2000 Organizations such as Bank of America, Macy’s, Sabre Holdings, Suzuki, Lufthansa, and Alcatel as users
Trusted partner network of Certified ISVs, System Integrators, and Resellers that includes ISVs such as RedHat, Novell, Sun, Business Objects and Quest Software
Develop, Deploy, and Manage high-volume applications with monthly rapid-updates and quarterly service-packs
Identify and fix problems before they become cost outages with MySQL Network Advisors (e.g. Performance, Replication, Security, Schema, and Administration)
Enforce MySQL recommended best practices by configuring accounts, fixing Sub-optimal Query Cache Hit Rates, and improving Slave Lag Time
Manage multiple servers by application, data center, or function each with different threshold settings
Gain in-depth visibility into the health of all of every MySQL server in the enterprise with a single, at-a-glance view into the health, availability, security and performance of all of each, using a color-coded heat chart, complete with visual Up/Down indicators, that directs you to the source of the issue
Discover tuning opportunities you cannot find yourself to ensure peak performance
Build custom, extensible MySQL Rules tailored to the needs of your particular MySQL environment
Receive new Advisors and Rules to enforce the latest MySQL recommended best practices
24x7 Problem Resolution Support from the engineers who develop the MySQL Enterprise Server
24x7 Consultative Support with the deep knowledge of the MySQL Support Team
Leverage existing DBA skills with MySQL, an easy to use, low administration database that provides visual tools that proactively advise you on how to find and fix trouble spots.
Become a MySQL DBA and expand your career opportunities through using the MySQL Network Monitoring and Advisory Service, your "Virtual DBA Assistant"
Customized news reports about Sun Microsystems. Just the news you need, none of what you don't. 50,000+ Members. 20,000+ Articles Published since 1998.
Print Friendly
Email this article
Why Use MySQL?
