MySQL Enterprise Database _ MySQL-mysql tutorial

MySQL Enterprise Edition database MySQL is a leading open source enterprise and one of the world's fastest growing open source database developers. As the world's most popular open source database software, MySQL Enterprise Edition is the company's flagship product, including software tested, active monitoring tools and gold support services. Many of the world's largest and fastest growing enterprises and institutions, including industry leaders such as Yahoo, Alcatel-Lucent, Google, Nokia, YouTube, and Booking.com, all adopt MySQL products, create a large number of websites, key business systems, and package software in a time-saving and cost-saving manner. MySQL open-source databases are widely deployed in all major operating systems, with a wide range of hardware users, regions, application industries, and application types. MySQL's high-performance open-source database software has been downloaded and released by more than 0.1 billion sets, and is increasing by 50 thousand sets of downloads every day.

MySQL open-source database is the "M" in the LAMP architecture (consisting of Linux, Apache, MySQL, and PHP/Perl, which is generally regarded as the Internet basis ". Databases from MySQL, OpenSolaris and GlassFish, plus Sun's Java platform and NetBeans community, will create a powerful Web application platform for customers who transfer applications to the Web.

MySQL Enterprise Server is the most reliable, secure, and updated MySQL Enterprise-level Server database. It provides cost-effective e-commerce and online transaction processing (OLTP) and gigabit data warehouse applications. It is a secure database that processes transactions and adapts to ACID. It provides complete commit, reverse, crash recovery, and RoW-level locking functions. Because of its ease of use, scalability, and high performance, MySQL database has become the world's most popular open-source database.

MySQL Enterprise Server 5.0 provides new Enterprise-level product features, including:

ACID transaction processing: used to establish reliable and secure key applications

Stored Procedures: improves the efficiency of developers

Trigger: enables users to complete complex business logic at the database level

View: ensures that sensitive data is not stolen

Information plan: provides a quick way to query metadata

Distributed Processing: it supports complex transaction processing across multiple databases

Pluggable storage engine architecture: provides great flexibility for database design and implementation

Archive Storage Engine: Provides a management platform for historical data and audit data.

Federated Storage Engine: Allows you to create data on multiple different servers to a unified logical database.

MySQL also provides a full set of database drivers and drawing tools to help developers and database administrators establish and manage their MySQL applications, as shown below:

(1) MySQL driver

MySQL Native C Library

MySQL Drivers for ODBC, JDBC,. NET

Community Drivers for PHP, Perl, Python, Ruby, etc

MySQL Connector/MXJ for deployment as a JMX MBean

(2) MySQL graphics tools

MySQL Workbench

MySQL Query Browser

MySQL Administrator

MySQL Migration Toolkit