MySQL

The master-slave architecture based on the principle of MySQL logical replication often results in inconsistent master-slave data due to some reasons, which causes the master-slave copy process to interrupt the error. Instead of checking the status

I. OverviewThe previous article about MySQL installation and basic use of MySQL, this article is a follow-up supplement, mainly for MySQL or mariadb backup and restore, it is well known that the data is the most important, so usually to the

OneThe first thing to explain is what LNMP,LNMP originated from Lamp,lamp is the abbreviation for Linux+apache+mysql/mariadb+perl/php/python, which replaces the Web server's Apache with less resource consumption, More stable Nginx, so LNMP is the

Recently due to compare MySQL and its branches mariadb, Percona performance, understand a few of these tools, including: Mysqlslap Sysbench Tpcc-mysql, do a collation, memo, share1, MysqlslapInstallation: Simple, with MySQL on it.Function: Simulates

Remote access to the MySQL database on the server, the discovery root remote connection is not on, prompt error: "1045-access denied for user [email protected]"The workaround is as follows, execute the command:mysql> use MySQL;Mysql> selecthost,user

ObjectiveIn the event of failover, frequently encountered problems are synchronous error, the following is the most recent collection of error information. Record deletion failedDelete a record on master, not found on slaveLast_SQL_Error:

MySQL Extensibility architecture Practice N Library to 2N library expansion, 2 to 4, 4 to 8http://geek.csdn.net/news/detail/5207058 the same city Shenjianhttp://www.99cankao.com/algebra/modulo-calculator.phpModulo calculatorExtensibility is also a

today we are mainly talking about Linux forgetMySQLPassword processing method, the following provides 5 kinds of Linux forgot MySQL password recovery method Oh.Method One (Enter root permission first):#/etc/init.d/mysql Stop# Mysqld_safe--user=mysql-

id,mol,ip,port,name,t.desc,maxac,maxi,mini,maxw,status Select from t_sys_thorfd t order by status Desc A simple query statement has been an error in the location of Desc, at first thought it wasORDER BY Status Desc error, check

In the previous blog, a Linux server cluster with LVS-DR mode was deployed, and the use of it was described in this blog post, and the experiment was done by deploying WordPress in the cluster.First, the deployment of experimental environmentFirst

After using MySQL, no matter the capacity, found that more than two other (SQL Server, Oracle) more useful, all of a sudden like. Below for those who do not know how to get the children's shoes to write down the specific method steps.(I write a bit

PrefaceIn addition to the regular join statements, there is a class of query statements that are also used more frequently, that is, orderby,group by and distinct. Considering that all three types of queries involve the sorting of data, I put them

First, online installation 1,Yum install drivers onlineYum Install Yuminstall MYSQL-CONNECTOR-ODBC2. Configuration Driver(1) Viewing driver-related informationcat /etc//************************************************# Example Driver definitions#

Installation and use of MySQL benchmark tool tpcc-mysql1.tpcc-mysql Introduction:TPC (Tracsaction processing Performance Council) Transaction Performance Association is a non-profit organization that evaluates the hardware and software performance

I haven't had time to write. I knew one months would not be over, temporarily added work is always dragged down.。。MySQL cluster docker installed MySQL cluster error. It's my image that has less perl. Be honest with me. The image is not small again.

There are two general questions, one is Apache configuration, and the other is MySQL export and import. And some of the problem-solving processes and methods that are encountered after migration.A machine for the old server. b for new server,a

Today found in bulk INSERT, the self-increment primary key is not continuous ....InnoDB auto_increment Lock ModesThis section describes AUTO_INCREMENT the behavior of lock modes used to generate auto-increment values, and how each lock mode aff ECTS

Mysql master-slave replication principle and configuration, mysql master-slave Principle Mysql master-slave replication principle and Configuration 1.OverviewThe built-in replication function of Mysql is the basis for building large and

Translation: Identifier Name, identifier naming rules This article is a translation of the mariadb official manual: Identifier Names. Original article:

MySQL binary log (binary log) Summary, mysqlbinary   Source: http://www.cnblogs.com/wy123/p/7182356.html(The Source retained is not the right of original works. My work is far from reaching this level, just to link to the original article, because