High availability | repmgr build PostgreSQL high availability cluster deployment document [recommended collection]

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

Flink CDC Series - Build Streaming ETL on MySQL and Postgres

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

mysql implementation of high availability architecture MHA     catalogue 1, Introduction 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

MySQL online enable & disable GTID mode Basic overview We know that MySQL has two ways to specify replication and synchronization: Specifying method based on binlog file name and location -Anonymous_gtid_log_event 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

SpringBoot+vue imitation Netease cloud music website - database design

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 container technology and LXC configuration

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 ...

Posted on Wed, 01 Dec 2021 01:27:32 -0500 by 758

Running away from stores? Not rollback? MySQL creates and manages tables, modifies empty tables, MySQL8 features DDL atomization, complete and detailed collection

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

Additions and deletions of MySQL data processing, new features of MySQL8 computed columns, complete details can be collected

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 VALUES (value1,value2,....); 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

Day465. Trigger & other new features of mysql 8 mysql

trigger 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

Dream, MySQL view, virtual and real table, complete and detailed, collectable

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