MySQL

Server IP Address planning (10.x analog public address, 192.x private network address, 172.x private network address)NFS：192.168.30.33WEB1:192.168.30.17WEB2:192.168.30.27LVS:192.168.30.7 VIP:10.0.0.100DNS:172.20.42.27Mysql:192.168.30.30Route:192.168.

One, MySQL two kinds of login methodsIP-based sign-in modeMysql-uroot-proot-h 127.0.0.1# -uroot user name root## - H 127.0.0.1 IP : 127.0.0.1. Do not fill default is localhostSocket-based sign-in modeMysql-uroot-proot-s/tmp/mysql.lockIi. user

Initiating a request from the database to the primary databasePrimary database validation request, if authentication is passed, turn on I/O threadSending bits files from a database to the primary databaseThe primary database matches the value of the

This example uses a table task with the following structuremysql> desc Task;+-------------+------------+------+-----+-------------------+-------+| Field | Type | Null | Key | Default | Extra |+-------------+------------+------+-----+-----------------

MySQL Rights ManagementPermission categories:Management classProgram ClassDatabase levelTable levelField levelMySQL User and Rights ManagementManagement classes:CREATE Temporary TABLESCREATE USERFILESUPERSHOW DATABASESRELOADSHUTDOWNREPLICATION

Scene:When writing data in bulk, MySQL server has gone awayWorkaround:Set the Max_allowed_packet parameter a little larger in My.ini　　　Show global variables like ' max_allowed_packet ';　　The above workaround does not solve the problem, other reasons

In response to the company's needs, to create a more secure MySQL cluster, to achieve MySQL failover after the switch, the study of a few days finally have the results, share.First, introduce the function of this cluster scheme.1, MySQL server after

1) Download the installation package,version 5.7 needs to download a boost C + + 1.59.0, (slow download)#cd/data/soft# wget https://dev.mysql.com/get/Downloads/MySQL-5.7/mysql-5.7.21.tar.gz# tar-xfzf mysql-5.7.21.tar.gz# wget

First, configure the MHA working environment192.168.2.130 Machine Operation:1.1. Create the working directory of the MHA and create the relevant configuration file(There is a sample configuration file in the directory after the package decompression)

If you need to add a MySQL user, you only need to add new users to the user table in the MySQL database.The following is an instance of adding a user named Qi, a password python , and an authorized user to SELECT , INSERT , UPDATE , DELETE , CREATE ,

Common components of a relational databaseDatabases: DatabaseTables: TableRow: RowColumns: ColumnIndexes: IndexTrying to: viewUsers: UserPermissions: Privilege 存储过程：procedure 存储函数：function 触发器：

Database table Introduction: Inventory table' ID ' int (11) ' Item ID, unique identifier ',' Name ' varchar (255) ' Item names ',' Level ' int (11) ' Item class category, gift Pack for top 1, Category 2, detailed item 3 ',' ParentID ' int (11) '

Note The order of Where,group by, having,order by, and limit.The primary table is the table that is bound, the child table is the table with the foreign key added, note that you can add a foreign key when creating the table, or you can add a foreign

Install MySQL using brew installation MySQL.Under console input MySQL, press TAB twicemysql mysql_upgrade mysqldumpslowmysql.server mysqladmin mysqlimportmysql_client_test

Method 1:1. Stop the MySQL service# Kill ' Cat/var/run/mysqld/mysqld.pid 'Or# Pkill Mysqld2. Create a text file for a password assignment statement# VI Mysql-initALTER USER ' root ' @ ' localhost ' identified by ' mynewpass!6 ';Resets the password

The implementation principle of database replication replication1. The primary server, where the statement is run, produces a binary log binlog2. Continuously read the binlog of the master server from the server3. Binlog translated from the master

1. Download the appropriate version of the website https://dev.mysql.com/downloads/mysql/5.6.html#downloads2. Extracting filestar -zxvf mysql-5.6. -LINUX-GLIBC2. A3. Copy the extracted MySQL files to the system local software directoryCP mysql-5.6.

Master-Slave replication principle:When Master receives a write request, the complete process of the current completion event is logged to the Binlog log, notifying the slave event update, at which time the IO thread is generated from the server and

1 procdure stored procedure with cursor loopBEGINDECLARE DEVSN varchar (+) default null;DECLARE Serialno varchar (+) default null;DECLARE Fcloor Int (one) DEFAULT NULL;DECLARE nextintime dateTime default null;Declare modelname varchar ($) default

SQL statements need to be compiled and executed, and stored procedures (Stored Procedure) are a set of SQL statements that are compiled in order to accomplish a particular function, stored in a database after compilation, and invoked by the user by