Mysql DBA Advanced Operations Learning Note-MYSQL database Getting Started knowledge

2.1 MySQL Database Introduction

2.1.1 MySQL Database introduction

MySQL is a relational database management system, the characteristics of the relational database is to keep the data in different tables, the tables in different databases, instead of all the data in a large warehouse, so that the design increases the MySQL read speed, flexibility manageability has been greatly improved, The most common standardized language for accessing and managing MySQL databases is the SQL Structured Query language.

2.1.2 Why choose MySQL Database

What are the advantages and characteristics of MySQL database, so that everyone can choose it?

There are several possible reasons for this:

(1) MySQL performance is excellent, service is stable, there are few abnormal downtime.

(2) MySQL open source code and no copyright restrictions, autonomy and low cost of use.

(3) MySQL has a long history, the community and users are very active, encountered problems, can seek help.

(4) MySQL software is small in size, easy to install and use, easy to maintain, low in installation and maintenance.

(5) MySQL brand word-of-mouth effect, so that enterprises do not have to consider the direct use of LAMP, Lnmp (LEMP) popular architecture.

(6) MySQL supports a variety of operating systems, provides a variety of API interface, support a variety of development languages, especially for the popular PHP language has a good support.

2.2 Mysql Database Classification and version upgrade

The official website for MySQL database is http://www.mysql.com.

Divided into community and commercial editions and these two editions are divided into four versions, one release at a time, with four versions: Alpha, Beta, RC, and GA versions.

The explanations and differences between the four release versions are as follows:

(1) Alpha version
The alpha version is generally only run within the company that is being developed and not publicly available. The main developers are testing their own products.

(2) Beta version
The beta version is generally done after the development of the functionality and all of the testing work after the product, there will be no large functionality or performance bugs, invitations or offers to the user to experience and test, in order to more comprehensive test software deficiencies or existing problems.

(3) RC version
RC version belongs to a production environment before the release of a small version or a candidate, is the beta version of the test results collected by the bug or defect of the collected information, to repair and improve the product after.

(4) GA version:
GA version belongs to the release of software products, also known as production version of the product, in general, the production environment of the enterprise will choose the GA version of the MySQL software.

Mysql DBA Advanced Operations Learning Note-MYSQL database Getting Started knowledge