Download MySQL 5.7 Two package[[email protected] ~]# wget https://dev.mysql.com/get/Downloads/MySQL-5.7/mysql-5.7.21-linux-glibc2.5-x86_64.tar.gz
Unzip the MySQL 5.7 binary package to the specified directory[[email protected] ~]# tar zxvf mysql-5.7
First look at the entire process of sending and receiving requests from the MySQL databaseMySQL logical architecture is divided into three layers, the top layer is the client tier, not unique to MySQL, such as: Connection processing, authorization
experimental Environment, suppose the company wants to run a MySQL server for a period of time, do a primary master replication architecture to improve the database read and write ability.
Old server with M0
Test database: MySQL DatabaseINSTR (STR,SUBSTR) searches for the specified character (SUBSTR) in a string (STR) and returns the position (INDEX) of the specified character;STR is searched for stringSUBSTR the string you want to searchConclusion: In
Based on the mysql5.7.21 versionAside: Some commands if not available, please refer to the official version of the document, because, some of the command format, in the slowly obsolete (such as: IDENTIFIED BY PASSWORD ), or not recommended (such as:
Installation of MySQL in Linux environment
sudo yum install Mysql-server
Modifying a configuration file
Vim/etc/my.cnf
Add default-character-set = UTF8
Set up MySQL to start automatically
M-sPrimary server: Master1The first step: Open the Bin-log log, set as follows:Vim/etc/my.cnfLog_binServer-id=1Gtid_mode=onEnforce_gtid_consistency=1Step two: Access to the database authorized usersMysql-uroot-p ' Password 'Grant Replication
MySQL User management1. Create User: Grant commandmysql> grant all on *.* to ‘user1‘@‘127.0.0.1‘ identified by ‘123456a‘;Query OK, 0 rows affected (0.00 sec)Test[[email protected] mysql]# mysql -uuser1 -p123456a -h127.0.0.1Warning: Using a password
Technology selection:I. Project CONSTRUCTION:1) Create a MAVEN project (I have an introduction in my blog)Choose Aptach's Maven-archetype-webappFill in Groupidhe Artifactid, etc.Confirm Project NameThe Maven plugin automatically generates the
Set Change mysqlroot passwordEnter MySQL database for the first time,!The MySQL absolute path can be added to the environment variable,You can also set the boot load,Reload environment variable for MySQL to take effectRe-login to Mysql-urootAdd a
MySQL server has gone awayScene:MySQL Backup to import times this mistakeReason:The imported data is too large to exceed the MySQL default size limitSolve:To view MySQL settings:
Show global variables like ' max_allowed_packet ';
Adjust
MySQL only provides the union, does not provide the difference set, and the intersection, but we can use the Union to achieve the intersection and the difference, the following is the implementation method:First create two tables:ERROR 1064
Of course, to solve the problem, we have to have the environment first.A master one from the configuration flow:Main: Configure DNS resolution first, the experimental environment can use/etc/hosts parsingVim/etc/hosts192.168.122.45 Master1192.168.122
First, the origin of database management softwareBased on what we've learned before, data is stored in a file for permanent preservation, without a doubt that a file can only exist on a single machine.If we ignore the efficiency of accessing data
Digital type
Type
Size
Range (signed)
Range (unsigned)
Use
TINYINT
1 bytes
(-128,127)
(0,255)
Small integer value
SMALLINT
2 bytes
(-32 768,32 767)
(0,65
Mysql has the problem that the table 'xxxxx' is full, mysqlxxxxx
When this problem occurs, the first response is that the table is full and the disk is full, but the server is not long before it is started. No,
Then my friend sent me an article ..
Mysql database index optimization and Practice (I), mysql IndexPreface
Mysql database is currently the most widely used database system. Dealing with databases is one of the daily work of every Java programmer. index optimization is one of the
Translation: select into Statement (submitted to the MariaDB official Manual), intomariadb
This article is the translation of the mariadb official manual: select.
Original article:
How to modify the default mysql character set to utf8 in MAC, mysqlutf8
1. Check the character set of the default installed mysql
Mysql> show variables like '% char % ';+ -------------------------- + --------------------------------------------------
The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion;
products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the
content of the page makes you feel confusing, please write us an email, we will handle the problem
within 5 days after receiving your email.
If you find any instances of plagiarism from the community, please send an email to:
info-contact@alibabacloud.com
and provide relevant evidence. A staff member will contact you within 5 working days.
A Free Trial That Lets You Build Big!
Start building with 50+ products and up to 12 months usage for Elastic Compute Service