MySQL Database < two >

Installing the MySQL database

As we all know, the data is very important, once the data is lost, can not explain to the company, you may not be able to go down, so select the database must choose the public, we all use.

Communication found that most of the Internet company database is used MySQL, why do we all choose MySQL database?

2. 
   

4. Reasons to choose MySQL database:

   1. Excellent performance, stable service, very few downtime phenomenon;

   2. Open source code, and no copyright restrictions, autonomy and low cost of use;

   3. Has a long history, and the community and users are very active, encounter problems easy to seek help;

   4. The software is small in size, easy to install and easy to maintain, low cost of use.

   5. Word-of-mouth effect, applicable to lamp, LNMP architecture;

   6. Support a variety of operating systems, provide a variety of API interface, support a variety of development languages, the PHP language has a good help;

6. Database Version Upgrade:

   1) is generally a logical upgrade, the data is exported in the form of SQL statements, and then imported, but there are functional changes between the different versions, need to be tested beforehand.

   2) Select the stable version; Select the mainstream product line; If there is no business requirements, do not go with the tide to upgrade, the site is afraid of upgrading, an upgrade on a variety of issues, not half a year to solve the problem; continuous release of the same version of the new version of the software, are more dangerous; The general companies are first selected after development In this way the general database is stereotyped;----to communicate well with development;

   Remark: The leader must use the newest, must persuade him, otherwise has the problem not to deal with;

8. MySQL Database simple Introduction

   MySQL database is a relational database.

   See: http://7826443.blog.51cto.com/7816443/1706078

10. MySQL Database installation

1) Installation Method:

Yum Installation http://7826443.blog.51cto.com/7816443/1706107

• Binary Installation http://7826443.blog.51cto.com/7816443/1706133

CMake Compiling and installing http://7826443.blog.51cto.com/7816443/1706125

• Compile and install first, then package, and then Yum batch install. [refer to MySQL installation +rpm making +yum Warehouse]

2) Configure MySQL multi-instance

3) Configure MySQL master-slave synchronization

4) MySQL High availability cluster

5.MYSQL Database SQL statements

http://7826443.blog.51cto.com/7816443/1567485

This article is from the "Lanzhi" blog, make sure to keep this source http://7826443.blog.51cto.com/7816443/1706177

MySQL Database < two >