MySQL Server : Open Source Database : MySQL Introduction

• MySQL Intro
• Why MySQL?
• Features and Benefits of MySQL
• MySQL Products
• MySQL Certification Program
• MySQL Website
• MySQL Architecture

MySQL Database : Open Source Database solution

-The MySQL Database powers the most demanding Web, E-commerce and Online Transaction Processing (OLTP) applications.
-It is a fully integrated transaction-safe, ACID compliant database with full commit, rollback, crash recovery and row level locking capabilities.
-MySQL delivers the ease of use, scalability, and performance that has made MySQL the world’s most popular open source database.
-Some of the world’s most trafficked websites like Facebook, Google, ticketmaster, and eBay rely on MySQL for their business critical applications.

MySQL ( /mai eskju:’el/ “My S-Q-L”,officially, but also called /mai ‘si:kwel/ “My Sequel”) is the world’s most used open source relational database management system (RDBMS) as of now that runs as a server providing multi-user access to a number of databases.

• The MySQL® database has become the world’s most popular open source database because of its consistent fast performance, high reliability and ease of use.
• It’s used on every continent — Yes, even Antarctica!
• Used by industry leaders such as Yahoo!, Alcatel-Lucent, Google, Nokia, YouTube, and Zappos.com.
• it’s also become the database of choice for a new generation of applications built on the LAMP stack (Linux, Apache, MySQL, PHP / Perl / Python.)
• MySQL runs on more than 20 platforms including Linux, Windows, Mac OS, Solaris, HP-UX, IBM AIX, giving you the kind of flexibility that puts you in control.

MySQL reduces the total cost of ownership of database software by reducing database licensing costs by over 90 percent and cutting systems downtime by 60 percent.

At the same time, it lowers hardware expenditures by 70 percent and reduces administration, engineering, and support costs by up to 50 percent.

MySQL Enterprise

The MySQL Enterprise subscription is the only comprehensive offering of production support, monitoring tools and MySQL database software to deliver optimal performance, reliability, security, and uptime. MySQL Enterprise includes:

• MySQL Enterprise Server
• MySQL Enterprise Monitor
• MySQL Production Support

MySQL Cluster

MySQL Cluster delivers a fault tolerant database clustering architecture for deploying highly available mission-critical database applications.

MySQL Embedded Database

The MySQL Embedded Database is the most popular choice for OEMs/ISVs who want to cost-effectively embed or bundle a reliable and high-performance relational database.

MySQL Connectors

MySQL provides standards-based database drivers for JDBC, ODBC, and .Net enabling developers to build database applications in their language of choice.

MySQL Workbench (GUI Tool)

MySQL Workbench enables a DBA, developer, or data architect to visually design, generate, and manage all types of databases including Web, OLTP, and data warehouse databases.

MySQL Certification Program

Oracle offers the following MySQL professional certifications aligned to technology area and role:

MySQL certifications are available for Developers, DBAs and for those specializing in MySQL Cluster technologies.

Click here to open mysql official Website http://www.mysql.com

MySQL Architecture with Pluggable Storage Engines

The MySQL pluggable storage engine architecture enables a database professional to select a specialized storage engine for a particular application need while being completely shielded from the need to manage any specific application coding requirements. The MySQL server architecture isolates the application programmer and DBA from all of the low-level implementation details at the storage level, providing a consistent and easy application model and API. Thus, although there are different capabilities across different storage engines, the application is shielded from these differences.

The pluggable storage engine architecture provides a standard set of management and support services that are common among all underlying storage engines. The storage engines themselves are the components of the database server that actually perform actions on the underlying data that is maintained at the physical server level.

This efficient and modular architecture provides huge benefits for those wishing to specifically target a particular application need-such as data warehousing, transaction processing, or high availability situations-while enjoying the advantage of utilizing a set of interfaces and services that are independent of any one storage engine.

The application programmer and DBA interact with the MySQL database through Connector APIs and service layers that are above the storage engines. If application changes bring about requirements that demand the underlying storage engine change, or that one or more storage engines be added to support new needs, no significant coding or process changes are required to make things work. The MySQL server architecture shields the application from the underlying complexity of the storage engine by presenting a consistent and easy-to-use API that applies across storage engines.

MySQL Storage Engine Architecture

• For an individual table, the .frm file contains information about the table structure – effectively, an internal representation of the CREATE TABLE statement.
• The .MYD file contains the row data, and
• the .MYI contains any indexes belonging with this table, as well as some statistics about the table. The data file contains only row data, with minimal overhead.