MySQL

MySQL master-slave replication and semi-synchronous replication principle1, master-slave replication is mainly based on the binary log (binlog), the binary logging is a complete event.2. Take the binary log of the primary server and run it again

The login account used does not have permission to log on remotely, so it can only be logged on the server via the command line.The solution is as follows:1. Log on to MySQL on the server via the command line or client;2. Perform the following

Timestamp data storage1, timestamp value range is '1970-01-01 00:00:01' UTC to '2038-01-19 03:14:07 ' UTC;2, convert data to UTC time zone when storing timestamp data, then calculate the millisecond value, then store it in the table;3, The data is

Nginx Series-2. Configure LNMP (Linux, Nginx, MySQL, PHP) schema directory-Nginx series Nginx Series -1.linux Installation NginxNginx Series-2. Configuring the Lnmp (Linux, Nginx, MySQL, PHP) architectureNginx Series-3. Configuring Nginx

Main content:　　Introduction and use of NAVICAT tools　　1. Introduction and download Installation IntroductionNavicat is a visual management tool for MySQL database development that operates the MySQL database as a graphical interface. However, it is

 1. Download linkNavicat for MySQL ClientLink: Https://pan.baidu.com/s/1dGbzgbR Password: i43gMySQL serverLink: Https://pan.baidu.com/s/1qYE01BI Password: qz9s2. Install MySQL and navicatNavicat for MySQL, downloaded itself is an app, do not have to

Like operatorTo use wildcard characters in a search clause, you must use the LIKE operator.Note: When is the operator not an operator? The answer is when it is used as a predicate. Percent percent (%) wildcard character % indicates any

Reprint Address: http://blog.itechol.com/space.php?uid=33&do=blog&id=66811, in the MySQL statement "'" function: To avoid the indication, the field name and MySQL existing "reserved word" conflict, causing an unknown error.2, so we build tables and

MySQL transaction autocommit Auto-commitThe MySQL default mode of operation is autocommit auto-commit mode. This means that unless a transaction is explicitly started, each query is executed automatically as a separate transaction. We can change

First, Galera cluster introduction 1, galera cluster: 集成了Galera插件的MySQL集群，是一种新型的，数据不共享的，高度冗余的高可用方案，目前Galera Cluster有两个版本，分别是Percona Xtradb Cluster及MariaDB Cluster，Galera本身是具有多主特性的，即采用multi-master的集群架构，是一个既稳健，又在数据一致性、完整性及高性能方面有出色表现的高可用解决方案。

August 10, 2018 08:53:50How the general production order number is1, use time + random number 1+ random number 2Disadvantage, it is possible to repeat in the concurrency, the solution is to add a unique index, when the data inserted into the query

I. OverviewIn general, deadlock is an application design problem, by adjusting the business process, database object design, transaction size, and access to the database of SQL statements, the vast majority of deadlocks can be avoided, the following

Check out the "engine" concept first. Engine is the core component of a development program or system on an electronic platform. Using the engine, developers can quickly build, lay out the functions required by the program, or take

1. Installing the JDK 1.8 environment1.1 Download JDK 1.8 installation Package jdk-8u181-linux-x64.rpm: http://www.oracle.com/technetwork/java/javase/downloads/jdk8-downloads-2133151.html1.2 InstallationRPM-IVH jdk-8u181-linux-x64.rpm1.3 Testing#

PrefaceUsing anemometer to visualize the MySQL slow query log, you can more easily query the slow query log, and based on the time stamp of historical query. The following is a stand-alone version of the Anemometer deployment demonstration, in

First, the installation of Docker:Check if your own amount is above 3.10, or Centos71. Uname-r2. Install Docker command: Yum -y install docker-io 3. Start the Docker command: Service Docker startSecond, install MySQL on the Docker1. Docker pull

In more cases, the data we are querying comes from multiple tables, and it is necessary to have a look at the connection queries in MySQL.SQL divides connection queries into four categories: cross-joins, inner joins, outer joins, and natural

First, uninstall and delete MySQL 1 sudo apt-get autoremove--purge mysql-server-5.02 sudo apt-get remove mysql-server3 sudo apt-get autoremove mysql- Server4 sudo apt-get remove Mysql-common (very important)   Some of the above is redundant, it is

Requirements Description :In MySQL, if you want to see the day of the week, you can use the Date_format function, which is documented here.Operation Process :1. Use the Date_format function to see if a date is the day of the weekMysql>

DescriptionWhen you turn on MySQL database master and slave, there will be a lot of files such as mysql-bin.00000* log, which will consume your hard disk space.mysql-bin.000001mysql-bin.000002mysql-bin.000003mysql-bin.000004mysql-bin.000005...There