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

The blog is only to record the learning process. Don't spray if you don't like it

Mysql Community Edition: open source is free, does not provide technical support, and needs to be used with open source tools.

Mysql Enterprise Edition: like the community version code, it provides additional features through plug-ins and adds threading plug-ins and audit plug-ins compared to the community version. And other additional functional features.

Mysql cluseter cge Cluster Business Edition. Is a real-time open source transaction database designed for fast, permanent access to data under high throughput conditions. Support, parallel distributed query engine. Automatic partition scaling, in-memory real-time database, etc.

Mysql installation can use docker to generate container deployment using images, which has advantages of fast speed and disadvantages. Docker uses images to generate containers, and the stability of containers is poor. Need to use K8s and other choreography tools for container layout. The security is poor. Docker shares the kernel and file system with the host. And need to update the official cve vulnerability patches from time to time.

New features of mysql8.0

1 document storage uses a single database to develop SQL and NoSQL document applications.

2 the transaction data dictionary is implemented as a set of SQL tables stored in a single InnoDB tablespace.

3 the SQL role is used to grant and deny permissions to user groups, which greatly reduces the security workload.

4 for richer mobile applications and international character sets, the default is the utf8mb4 character set.

Common table expressions, also known as WITH queries, have been added in 5 MySQL 8.0.

6 window functions can reduce code complexity and help developers improve their productivity.

7 invisible indexes to better manage software upgrades and database changes for round-the-clock applications

8 descending indexing to eliminate the need to sort results and lead to performance improvement

Mysql binary installation linux-generic

According to the official 8.0 reference manual, the installation address is as follows

Https://dev.mysql.com/doc/refman/8.0/en/binary-installation.html

Uninstall mariadb before installation

Rpm-qa | grep mairadb

Rpm-e-- nodes uninstall

The first step is to download and upload version 8.0 to the server for decompression.

I am unzipping to / opt directory

Tar-Jxvf mysql-8.0.12-linux-glibc2.12-x86_64.tar.xz

First turn off the selinux and the firewall.

Setenforce 0

Systemctl stop firewalld.service

Mysql depends on libaio library files to install libaio. (it will fail if you do not install initialization. The yum source of Ali Cloud easy is fast, and the centos7 system is installed by default.)

Yum clean all

Rm-rf / etc/yum.repos.d/C*

Wget http://mirrors.163.com/.help/CentOS7-Base-163.repo

Mv CentOS7-Base-163.repo / etc/yum.repos.d/netease.repo

Yum makecache

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

Create mysql users and groups and set up the no login system

Groupadd mysql

Useradd-r-g mysql-s / bin/false mysql

Create a directory link

Cd / opt/

Ln-s / opt/mysql-8.0.12-linux-glibc2.12-x86_64/ mysql

Create a data directory and log directory

Cd / opt

Mkdir data

Mkdir log

Chmod 755 / opt/mysql/log

Chmod 755 / opt/mysql/data

Configure my.cnf

[mysqld]

Port=3306

Datadir=/opt/mysql/data

Log-error=/opt/mysql/mysql-err.log

User=mysql

Default_authentication_plugin=mysql_native_password

[client]

Socket=/tmp/mysql.sock

Configure environment variables

Echo "export PATH=$PATH:/opt/mysql/bin" > > / etc/profile

Source / etc/profile

Initialize the database

/ opt/mysql/bin/mysqld-- initialize-- user=mysql remember the initialization password

Set up the startup file

/ opt/mysql/support-files/mysql.server / etc/init.d/mysqld

Vim / etc/init.d/mysqld

Change basedir = / opt/mysql/

Datadir = / opt/mysql/data

Change execution permissions chmod+755 / etc/init.d/mysqld

Systemctl restart mysqld Startup Service

Or use mysql_safe to start

Mysqld_safe-user=mysql

Log in to the database using the password you just recorded, and change the password

ALTER user 'root'@'localhost' IDENTIFIED BY' mysql'

FLUSH PRIVILEGES

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.