Categories

Mysql

wget http://repo.mysql.com/mysql-community-release-el7-5.noarch.rpm rpm -ivh mysql-community-release-el7-5.noarch.rpm yum update yum install mysql-server

systemctl start mysqld

[root@clusterserver1 ~]# systemctl start mysqld [root@clusterserver1 ~]# systemctl enable mysqld [root@clusterserver1 ~]# systemctl status mysqld

[root@clusterserver1 ~]# mysql_secure_installation

NOTE: RUNNING ALL PARTS OF THIS SCRIPT IS RECOMMENDED FOR ALL MySQL SERVERS IN PRODUCTION USE! PLEASE READ EACH STEP CAREFULLY!

In order to […]

Replication Features in MySQL 8.0.1

MySQL 8.0.1 has just been released with a wonderful set of features across the board. Specifically in replication, there is plenty of new and exciting functionality as well as performance improvements.  In this post I am going to summarize the replication features of this development milestone release.

The Group Replication plugin. You can now use Group Replication together […]

MySQL 5.7 vs MySQL 8.0 – What’s new in MySQL 8.0?

MySQL is arguably the most popular and common RDBMS. The last major release was MySQL 5.7 back in 2013.

As of today, several development milestones were declared for MySQL v8.0, but there is no official release available yet.

Tip: Do not click here if all your SQL queries are fast as lightning!

Even though there is no official software […]

mysqlcheck

[root@clusterserver1 software]# mysqlcheck mysql -uroot -p Enter password: mysql.columns_priv error : Table upgrade required. Please do “REPAIR TABLE `columns_priv`” or dump/reload to fix it! mysql.db OK mysql.event error : Table upgrade required. Please do “REPAIR TABLE `event`” or dump/reload to fix it! mysql.func OK mysql.general_log error : Table upgrade required. Please do “REPAIR TABLE `general_log`” […]

CENTOS 7 MySQL 5.7

CENTOS 7 MySQL 5.7

 

wget http://dev.mysql.com/get/mysql57-community-release-el7-7.noarch.rpm

yum install -y mysql-community-server

 

systemctl start mysqld.service

[root@clusterserver1 software]# systemctl start mysqld.service [root@clusterserver1 software]# mysql -uroot -p Enter password: Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 3 Server version: 5.7.19 MySQL Community Server (GPL)

Copyright (c) 2000, 2017, […]

MySQL InnoDB engine B + tree index simple finishing instructions

There are several types of InnoDB engine tables in MySQL (the following index, no special instructions, refers to the InnoDB engine table index.) 0 = Secondary Index, 2-level index, 1 = Clustered Index, clustered index 2 = Unique Index, Unique Index 3 = Primary Index, Primary Key Index 32 = Full-text Index, Full Index 64 […]

Realize MySQL database automatic backup under Linux

1.Linux under MySQL to create a user backup role, and granted the role of SELECT, RELOAD, SHOW DATABASES, LOCK TABLES and other permissions.

 

mysql> create user ‘backuper’@’localhost’ identified by ‘********’; Query OK, 0 rows affected (0.00 sec) mysql> grant SELECT, RELOAD, SHOW DATABASES, LOCK TABLES on *.* to backuper@localhost; Query OK, 0 rows affected […]

MySQL 5.7 forget the root password

surroundings

CentOS 6.6 X86_64

background

Forget how to do root, forget to initialize MySQL generated when the random password how to do, or simply did not register that random password, do not tell me to clear all the data under data, reinitialize, of course, you have to be so wayward can also be. Do not pull, […]

MySQL 5.7 multi-instance installation deployment instance

1. Background MySQL database centralized operation and maintenance, through a server, the deployment of running multiple MySQL service process, through a different socket to monitor different service ports to provide their services. Each instance is independent of each other, each instance of the datadir, port, socket, pid are different.

2. Multi-instance features * Effective use of […]

CentOS 7 rpm installed under the MySQL 5.6.36

CentOS 7 under the local installation of MySQL 5.7, but the springboot integration jpa will appear hibernateException, do not know why, for a MySQL5.6 version of MySQL, source installation, cmake has been through, and later into rpm installation.

Local installation of mysql5.7, but the integration of springboot jpa will appear hibernateException, do not know why, for […]

Page 1 of 712345...Last »