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