MySQL

Preface: First introduce the MHA, quoted from the network.MHA (Master high availability) is currently a relatively mature solution for MySQL's highly available areas.The software consists of two parts: MHA Manager (Management node) and MHA node

MySQL index create, view, delete, and use examples1. Create an index:ALTER table is used to create a normal index, a unique index, or a primary key index.ALTER TABLE ADD INDEX index_name (column_list) ALTER TABLE ADD UNIQUE (column_list) ALTER TABLE

First, table design1. Library name, table name, field name use lowercase letters, "_" split.2. The Library name, table name, field name is not more than 12 characters.3. The Library name, table name, field name are known, try to use nouns rather

A transaction did not commit to the B transaction is equal to not do get the previous dataBut the query in a transaction is the data after the operation.Data that is not submitted is only visible to itself and is not being update to the

Log in to MySQL:MYSQL-H host name-u user name-P-H: This command is used to specify the MySQL hostname that the client wants to log on, and the parameter can be omitted when logging on to the current machine;-U: The name of the user to log in;-P:

First, Origin:As soon as I got to work today, I heard that Error-log recorded a lot ofERROR 1820 (HY000): Must reset your password using ALTER USER statement before executing this statement.　　Second, the MySQL user password expires processing:1,

Original link: MySQL View database related informationWhen using MySQL, you need to know the current database, such as the current database size, character set, user, and so on. Here's a summary of some commands for viewing database-related

The first method: more detailedThe following article mainly introduces the MySQL database to open the time of the remote connection operation process, in fact, the actual operation of the remote connection to the MySQL database is not difficult, the

In the previous chapter, the method of transmitting values between HTML and PHP is described in this chapter, which will be used by MySQL in Wamp for the next chapter of PHP call data preparation. Again, the author's wamp version is 3.0.6 64bitTo

Summary: Data recovery is a very important task that the DBA does not do much, but I have to understandBackground: Data mis-operation can be broadly divided into two categories1 DML operations (such as non-conditional update deletions)2 DDL

1Copy the F:\phptools\php5.5\php.ini-production and rename it to php.ini;2Add F:\phptools\php5.5 and F:\phptools\php5.5\ext to the environment variable path, select Computer, right-click Properties--Advanced system settings--environment

MySQL BinlogTo sync MySQL data to ES via MySQL Binlog, we can only use row mode Binlog. If you use statement or mixed format, we can only know the corresponding query in the Binlog, it is completely impossible to know what this statement changed the

First of all, MySQL Phantom read is not "a transaction within two times the same operation actually got a different result", because it is not possible at the RR isolation level using the Read VIEW/MVCC, the definition of this magic is more suitable

Server environment:Main mysql:192.168.1.163From mysql:192.168.1.126vip:192.168.1.50First, MySQL configuration master-Slave synchronization1. Configure the primary MySQL serverVim/etc/my.confEstablish an account and authorize slaveLock the main

Detailed analysis of SQL Execution steps and SQL Execution steps Detailed analysis of SQL Execution steps First, let's look at the sequence of statements executed. (8)select (9)distinct A (1)from Ta (3)join Tb (2)on XXX (4)where XXX (5)group by XXX (

Optimization tips for slow subquery efficiency of mysql in statements, mysql examples The table structure is as follows. There are only 690 articles. Article table article (id, title, content) label table tag (tid, tag_name) label intermediate table

SQL and MySQL statement execution sequence analysis, sqlmysql statement Sequence Today, I encountered a problem: Can I use the as alias in the insert into, update, and delete statements of mysql? I am still looking at it, but I found some useful

Solve mysql logon warning and mysql logon warningI. Preface We often see a warning when logging on to mysql: Warning: Using a password on the command line interface can be insecure. This makes people look uncomfortable, and when writing a script,

The concept of cluster and high availability (HA), clusterha Reposted from: http://www.cnblogs.com/blackwizard2016/p/5143816.html, which is used only for learning. 1.1 What isCluster To put it simply,Cluster (ClusterIs a group of computers,They

Use mysqlfrm to restore the frm table structure and mysqlfrmfrm table structure 1. Install mysqlfrm ----------------------------- Because mysqlfrm is part of the mysql-utilities tool, we can install mysql-utilities, download the corresponding source