MySQL

1. Synchronizing a small number of librariesBinlog-do-db=db_pxREPLICATE-DO-DB=DB_PX---If you need to update across databases and you do not want to replicate these and new, you should use this optionREPLICATE-DO-TABLE=DB_PX----Allow cross-database

To create a MySQL group and users:-r-g mysql-s/bin/false MySQLTo create a related directory:mkdir -p/data/mysql/mysql3306/{data,logs,tmp}chown -R mysql.mysql/data/mysqlInitialize MySQL:LN -s/opt/mysql-5.7. -LINUX-GLIBC2.

Why does the master copy from? Master-slave replication allows the primary database of the MySQL database master server to replicate to one or more MySQL slave servers from the database, enabling real-time disaster preparedness for disaster

ZhuqzLinks: https://www.zhihu.com/question/19719997/answer/81930332Source: KnowCopyright belongs to the author. Commercial reprint please contact the author for authorization, non-commercial reprint please specify the source.Many people's first

First, Preface: The basic principle of reading and writing separationThe basic principle of MySQL's read-write separation is to have master (the primary database) respond to transactional operations,Let slave (from the database) respond to select

Use of 1.insert_select: Copy data from one table to anotherINSERT into students (name,sex,likebooksnum,likesportnum,average)SELECTName,sex,likebooksnum,likesportnum,averageFrom Students_copy;2.regexp: Use of regular expressions, BINARY is a

Master-Slave synchronization, the essence is the use of database logs, the main library data copy to the library, in essence, the use of data replication technology.This article outlines Basic configuration of the main library Basic

MySQL log is divided into error log, binary log, slow query log, query log 1. The error log can be used to view the file of the error log through the following command: Show variables like ' Log_error '; the above command can be used to locate the

The table was previously updated with SQL Server, UPDATE statement:Update a set a.xx= (select yy from B); Yes, I can.However, in MySQL, you cannot directly use the result of the set Select,UPDATE ecs_users_copySET ' user_name ' = (SELECT'

Why to build an index In most cases, not using indexes, trying to improve performance by other means is a waste of time (from the inside of MySQL Technology Insider). How does the index raise the performance? The index can get

Windows environment configuration Mysql 5.7.21 windowx64.zip installation-free tutorial details, 1.download mysql-5.7.21-windowx64.zip mysql from the official website 2. decompress the package to the appropriate location (E: \ mysql). I changed the

Optimize MySQL three simple minor adjustments and mysql adjustments I don't want to be an expert DBA, But when I optimize MySQL, I respect the 80/20 principle, specifically by simply adjusting some configurations, you can squeeze out performance

MySQL advanced query,   Advanced Query Keyword writing sequence keyword execution sequenceSelect: Projection result 1 5 From: locate Table 2 1 Where: first filter 3 2 before grouping Group by: group 4 3 Having: The second filter after grouping 5

MySQL Group Replication configuration, mysqlreplicationMySQL Group Replication MySQL group replication implements Multi-master Update (single-master mode) based on the replication protocol ). A replication group consists of multiple server members,

Summary of execution issues between mysql max and where, mysqlmax Execution problem between mysql max and where Execute SQL: Create table 'grades' ('id' int (20) not null AUTO_INCREMENT, 'student _ id' int (20) not null, 'subobject' varchar (20)

Installation and configuration tutorial for mysql 5.7.20 \ 5.7.21 without installation, 5.7.205.7.21 Download and install mysql 5.7.20/5.7.21 for your reference. The specific content is as follows: 1. Download mysql, Select the operating system and

A Preliminary Study on MySQL statistics and estimation methods, and a preliminary study on mysql statistics   The statistical information in the database describes the data distribution in the table to varying degrees. The execution plan obtains the

Add, delete, modify, and query MySQL DML and DQL, dmldql Add, delete, modify, and query DML and DQL   SELECT * FROM grade -- Add insert -- Adds three data entries to the grade Table.Insert into grade (gradeID, gradeName) VALUES (4, '4 ');Insert into

Advanced query (1), advanced query ( Data TypeInteger intDecimal doubleHigh Precision --- Decimal)Corresponding to the type BigDecimal in Java String: nvarchar (32) varchar charChar: fixed-length string (once the length is set, the space of the

MySQL basic statement and MySQL statement Create a table If it is a keyword, use the key below the back quotation mark ''esc Create table [if not exists] table Name (Field 1 Data Type [constraints, indexes, comments],Field 2 Data Type [constraints,