Author: Yanbo Qingyun technology database R & D Engineer
At present, he is engaged in the development of PostgreSQL products and is keen on the study and research of PostgreSQL database
In the last issue, we introduced the PG cluster replication management tool repmgr, which can easily build a highly available cluster of PostgreSQL. After ...
Posted on Fri, 03 Dec 2021 05:40:53 -0500 by Promark
This tutorial will show you how to quickly build streaming ETL for MySQL and Postgres based on Flink CDC.Flink-CDC project address:https://github.com/ververica/flink-cdc-connectorsThis tutorial's demo is based on a Docker environment and will be done in the Flink SQL CLI, involving only SQL, without a single line of Java/Scala code, or with an ...
Posted on Wed, 01 Dec 2021 23:09:41 -0500 by abhishek
mysql implementation of high availability architecture MHA
2, MHA services
2.1 service role
2.2 tools provided
2.3 working principle
3, Implementation process
3.1 prepare Replication environment for Mysql experiment
3.1.1 relevant configuration
3.1.2 configuration of the initial master node
3.1.3 conf ...
Posted on Wed, 01 Dec 2021 21:30:52 -0500 by We Must Design
MySQL online enable & disable GTID mode
We know that MySQL has two ways to specify replication and synchronization:
Specifying method based on binlog file name and location
Specifying method based on gtid (global transaction ID)
-GTID transaction (Gtid_log_event)
On the one hand, the GTID based ...
Posted on Wed, 01 Dec 2021 11:33:26 -0500 by Phirus
1, Demand analysis
Imitate Netease cloud, then follow Netease cloud music if you need it. First of all, you can listen to songs and view singers. Singers have corresponding albums. There are users. Users can create song lists and collect song lists. Song lists can add or delete songs. Users can also comment on songs, albums, song lists and fan ...
Posted on Wed, 01 Dec 2021 04:55:32 -0500 by xgrewellx
Introduction to docker
First, let's introduce the difference between container and virtualization VM(VMware) creates virtual layer, virtualized operating system and virtualized warehouse on the basis of host machine and host machine operating system, and then installs applications;
Docker creates a docker engine on the operating system of the ...
1. Basic knowledge
1.1 A procedure for data storage Storing data is the first step in processing data. Data can only be stored correctly for efficient processing and analysis. Otherwise, it can only be a mess, unable to start. So how can we store all kinds of business-related and complex data in an orderly and efficient way? In MySQL, a ...
Posted on Tue, 30 Nov 2021 22:35:36 -0500 by rsnell
1. Insert Data
1.1 Mode 1: Add by VALUES
Case 1: Insert data in default order for all fields of a table
INSERT INTO Table Name
Each field in the table needs to be assigned a value in the value list, and the order of values must be the same as the order in which the fields in the data table are defined. ...
Posted on Tue, 30 Nov 2021 18:49:43 -0500 by essjay_d12
In actual development, we often encounter such situations: there are two or more interrelated tables, such as commodity information and inventory information stored in two different data tables respectively. When we add a new commodity record, in order to ensure the integrity of the data, we must add an inventory record to the invent ...
Posted on Tue, 30 Nov 2021 10:22:34 -0500 by matt86
1. Database object
2. View overview
2.1 why use views? On the one hand, views can help us use some tables instead of all tables. On the other hand, they can also make different query views for different users. For example, for a salesperson of a company, we only want to show him some data, but some special data, such as purchase p ...
Posted on Mon, 29 Nov 2021 07:41:45 -0500 by SnakeO