Shulou(Shulou.com)06/01 Report--

Chapter 1 introduction and deployment of MySQL 1.1 introduction to 1.1.1 what is data

Data refers to the symbols that record objective events and can be identified. it is the physical symbols or the combination of these physical symbols that record the nature, state and interrelationship of objective things. It is a recognizable, abstract symbol.

1.1.2 types of database management systems-relational

Advantages:

Powerful query function

Strong consistency

Secondary index

RDBMS:Oracle, MySQL, mssql (SQL Server), PG (postgresql)

Applicable scenarios: application scenarios with high data security requirements

1.1.3 types of database management systems-non-relational

Advantages:

Flexible mode

Expansibility

Performance

NoSQL:redis 、 mongodb 、 memcache 、 Hbase 、 neo4j

Applicable scenarios: for scenarios where the performance requirement is high and the data security requirement is not too high, it is usually a product used with RDBMS

1.2 MySQL deployment 1.2.1 installation method

1. Rpm or yum installation: easy to install, fast to install and cannot be customized

2. Binary: it can be used without installation and decompression, and the function cannot be customized.

3. Compilation and installation: customizable, slow installation speed (before version 5.5:. / configure make make install | after 5.5: cmake gmake)

1.2.2 compilation and installation 1.2.3 preparation of the installation environment

System version: Linux Centos-6.9 2.6.32-696.23.1.el6.x86_64

MySQL software version: 5.6.38

IP address and hostname: 10.0.0.51 db01

1.2.4 how to obtain MySQL software package

Download from https://downloads.mysql.com/archives/community/ # official website

1.2.5 start installation

(1) install the dependency package:

Yum install-y ncurses-devel libaio-devel gcc-c++ gcc ncurses-devel freeglut-devel

(2) install cmake

Yum install-y cmake

(3) create a mysql user to manage mysql

Useradd-s / sbin/nologin-M mysql

(4) decompress the software package

Tar xf mysql-5.6.38.tar.gz

(5) start compilation and installation

Cd mysql-5.6.38 # update user set password=password ("new_pass") where user= "root"

> flush privileges

Kill MySQL again and start MySQL in the normal way.

+

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.