An article about TiDB disaster recovery

1, Background High availability is another major feature of TiDB. All three components of TiDB/TiKV/PD can tolerate partial instance failure without affecting the availability of the whole cluster. The following describes the availability of these three components, the consequences of a single instance failure, and how to recover. TiDB T ...

Posted by billynastie on Thu, 21 May 2020 06:23:27 +0200

Basic query of MySQL database

1. Query every s in fruits table_ All f corresponding to ID_ Name value #Compact in groups mysql> select s_id,group_concat(f_name) as name from fruits group by s_id having count(f_name) > 1; 2. Same statistics s_ What are the rows of ID values? mysql> select s_id,count(*) as total from fruits group by s_id with rollup; Note: the role ...

Posted by puritania on Mon, 18 May 2020 15:05:43 +0200

Technology sharing | MySQL group replication data consistency management analysis

Author: Yang Taotao Senior database expert, specializing in MySQL for more than ten years. Good at mysql, PostgreSQL, MongoDB and other open-source database related backup and recovery, SQL tuning, monitoring operation and maintenance, high availability architecture design, etc. At present, he is working in aikesheng, providing MySQL related ...

Posted by trent2800 on Mon, 18 May 2020 11:20:05 +0200

PageHelper paging plug-in

<dependency> <groupId>com.github.pagehelper</groupId> <artifactId>pagehelper</artifactId> <version>5.1.8</version> </dependency> <dependency> <groupId>com.github.pagehelper</groupId> <artifactId ...

Posted by robwilson on Sun, 17 May 2020 17:35:48 +0200

Is it difficult to separate reading from writing?SpringBoot is implemented simply with aop

Preface It's been a month since I joined the new company, I've finished the work at hand, and the last few days I finally have time to research the code for my old project.During the process of researching the code, I found that Spring Aop was used in the project to separate the database from reading and writing, and to learn in my own way (I d ...

Posted by BraniffNET on Tue, 12 May 2020 18:48:39 +0200

centos7 builds wordpress blog

Install apache yum install -y httpd Start apache systemctl start httpd Set apache to power on automatically systemctl enable httpd Access public network address to check whether apache is normal Install MySQL database wget -i http://dev.mysql.com/get/mysql57-community-release-el7-10.noarch.rpm yum -y install mysql57-community-release-el7-10 ...

Posted by pedroteixeira07 on Mon, 11 May 2020 19:01:44 +0200

11. MySQL View Learning Notes (Detailed)

view Meaning: Understand as a virtual table and use it like a regular table A new feature of MySQL version 5.1 is data generated dynamically from tables For example: a comparison between a dance class and an ordinary class Differences between views and tables: Name Create Grammar Keyword Use Occupy physical space view ...

Posted by coolbeansdude51 on Sun, 10 May 2020 09:10:57 +0200

PHP-7.1.6 source compilation and installation

Explain php5 and php7 can be installed in an apache server at the same time, but only one of them can run. The other needs to comment out the corresponding LoadModule in the apache configuration file 1. Download and install [root@dl-001 src]# wget http://cn2.php.net/distributions/php-7.1.6.tar.gz [root@dl-001 s ...

Posted by cdinca on Tue, 05 May 2020 20:06:12 +0200

Compile and install MariaDB-10.1.30

Environment related: OS: CentOS release 6.9 IP: 192.168.1.10 CPU: 4 cores MEM: 2G DISK: 50G 1. Experiment host clone Refer to "CentOS6 experimental machine template building and deployment" Clone an experimental machine, adjust the memory to 2G and the CPU to 4 cores, and further configure the host na ...

Posted by geus on Tue, 05 May 2020 08:37:43 +0200

Slow log of MySQL Event scheduled tasks

Preface Recently, we are trying to use a log system, graylog, to collect the slow query log of mysql for subsequent analysis, monitoring and alarm. The test steps have been completed and the logs have been collected successfully. During the test, you need to brush some slow query logs. In order to brush more logs and not have a greater impact o ...

Posted by murp32 on Mon, 04 May 2020 13:43:41 +0200