mysql 5.7 master slave synchronization gtid

Environment: 1. linux centOS 7 64 bit2. (slave) linux centOS 7 64 bit3. (mysql) it's better to have the same version. It's recommended that the slave database be no higher than the master database. 5.7 is recommended centos 7 silently installs mariadb. For mysql 5.7 installation, please refer to the following link documents:centos 7 installs m ...

Posted by suavebum on Wed, 13 Nov 2019 10:43:46 -0800

Java8 flow API intermediate operation

Stream Trilogy - create stream Flow can be divided into two types: finite flow and infinite flow. Finite flow refers to the finite number of elements in the flow and infinite flow refers to the infinite number of elements in the flow. No matter finite flow or infinite flow, there will be no intermediate operation before termi ...

Posted by vomitbomb on Wed, 13 Nov 2019 10:12:50 -0800

Implement like query with elastic search

problem The elastic search query needs to achieve the like query effect similar to mysql. For example, the record with the value of hello China 233 can be queried either through China or through llo. However, the query of elastic search is based on word segmentation. The default word segmentation of hello China 233 is hello, C ...

Posted by VDarkAzN on Wed, 13 Nov 2019 10:03:24 -0800

php7 compile and install PDO ﹣ msql module

Compiling and installing PDO MySQL extension of php7 Note the execution path of all the following codes. If your file is not in the path of the sample code, please execute it in the corresponding path of your own file The premise is that php7 is already installed using source code. Otherwise, you need to download the source code of PDO MySQL ...

Posted by vornn on Wed, 13 Nov 2019 09:52:47 -0800

Connect MySQL with JDBC

Existing configuration: install IntelliJ (Java IDE) and MySQL. Then use MySQL Installer to install Connector/J. Open Intelli, create a new Project, and create a MySQL demo class. The code is as follows. The code comes from https://www.runoob.com/java/java-mysql-connect.html Some of them need to be changed into the contents ...

Posted by 8ta8ta on Wed, 13 Nov 2019 09:49:11 -0800

MySQL series: MySQL 8.X installation under Windows

MySQL 5.7 has been used before, but since MySQL has added some new features, it has chosen to update. Download MySQL Enter the MySQL official website download address, select windows (x86, 64 bit), zip archive. Download address: https://dev.mysql.com/downloads/mysql/ You can skip without logging in. Download process may be lost slowly, wait pa ...

Posted by andymoo on Wed, 13 Nov 2019 08:12:05 -0800

k8s grafana data persistence

Problem: as soon as the kfana container built by k8s is restarted, the configured dashboard and added users will be reset. As a result, there is no data persistence in grafana.Solve: 1. Establish persistent flower storage pvc in the cluster first Then hang it in the container / var directory volumeMounts: - mountPath: /var name: ...

Posted by Mystis on Wed, 13 Nov 2019 07:08:25 -0800

[daily] gocron source reading - use go mod to manage and start gocron depending on source code

Starting from Go1.11, golang officially supports the new dependency management tool, go modgo mod download: download the dependent module s to the local cachego mod edit: edit go.modgo mod graph: print module dependency graphgo mod init: initialize go.mod in the current directory (that is, a new go.mod file will be created)Go module tidy: reorg ...

Posted by dineshthakur on Wed, 13 Nov 2019 06:44:41 -0800

Docker from entry to drop: building SpringBoot microservices based on docker

This is the second chapter from the introduction to Docker: building SpringBoot microservices based on Docker. You'd better read it before Docker from entry to drop After that, read this article. In the previous article, I introduced how to deploy some common basic environments based on the docker container, such as MySQL and Redis. In this art ...

Posted by darkside_3k on Tue, 12 Nov 2019 21:40:36 -0800

Mysql/Mariadb master-slave replication

concept What is Mysql/Mariadb master-slave replication?      Mysql/Mariadb Master-slave replication: when the Master database changes, the changes will be synchronized to the slave database in real time; Similar to: Samba shared file (C/S), NFS network file share (C/S), when the Server changes, the client data content will change accord ...

Posted by lalov1 on Tue, 12 Nov 2019 02:42:11 -0800