1、 Brother Feng PG-DBA Training 15: PostgreSQL Cluster Solution and Stream Replication Project
Course objectives:
This course is a series of courses based on PostgreSQL database released by Brother Feng. This course belongs to the practical battle of PostgreSQL cluster solution and stream replication project in the stage of PostgreSQL master-slave replication and high availability cluster. After learning this course, you can master PostgreSQL cluster and high availability architecture solution, and PostgreSQL dual machine hot standby HA solution, PostgreSQL master-slave replication and read-write separation solution, PostgreSQL distributed cluster solution, PostgreSQL master-slave flow replication technology architecture, PostgreSQL master-slave flow replication asynchronous replication, PostgreSQL master-slave replication environment preparation, PostgreSQL master-slave flow replication setup (1 active 1 standby), PostgreSQL master-slave flow replication master-slave switch (1 active 1 standby), PostgreSQL master-slave flow replication adds a deletion node (1 master-slave), master-slave switchover (1 master-slave switchover) under normal PostgreSQL conditions, master-slave switchover (1 master-slave failover switchover) under abnormal PostgreSQL conditions, PostgreSQL master-slave flow replication+deferred standby database configuration, custom tablespace usage for PostgreSQL master-slave flow replication, and cascade replication of PostgreSQL master-slave flow replication, The combination of synchronous replication and asynchronous replication of PostgreSQL master and slave stream replication, as well as precautions in the use of PostgreSQL stream replication, is suitable for operation and maintenance personnel/database/developers, and can be used in business production environments.
Welcome to:
51CTO school style brother Oracle/MySQL/PG database learning dedicated QQ group: 454129134, 925203979
II Brother Feng PG-DBA training 15: PostgreSQL cluster solution and stream replication project
1. PostgreSQL cluster and high availability architecture solution
(*) PostgreSQL dual machine hot standby HA solution
(*) PostgreSQL master-slave replication and read-write separation solution
(*) PostgreSQL distributed cluster solution
(*) PostgreSQL high availability cluster planning and actual combat environment preparation
2. PostgreSQL master slave stream replication technology architecture
3. Asynchronous replication of PostgreSQL master slave flow replication
(*) PostgreSQL master slave replication environment preparation
(*) PostgreSQL master slave stream replication setup (1 active and 1 standby)
(*) PostgreSQL master-slave flow replication master-slave switch (1 active and 1 standby)
(*) Adding and deleting nodes (1 master and 2 slave) for PostgreSQL master slave stream replication
(*) The active/standby switchover of PostgreSQL under normal conditions (1 active and 2 slave switchover)
(*) Active/standby switchover under abnormal PostgreSQL conditions (1 active/2 slave failover)
(*) PostgreSQL master slave stream replication+deferred standby database configuration
(*) PostgreSQL master/slave stream replication custom tablespace usage
4. Cascade replication of PostgreSQL master slave flow replication
5. PostgreSQL master slave stream replication: synchronous replication+asynchronous replication
6. Precautions during the use of PostgreSQL stream replication
3、 Fengge Oracle/MySQL/NoSQL training class series courses (system, case, actual combat)
one ) Oracle Cloud database engineer training course _ Study Guide _ Career planning _ treatment
Free audition: https://edu.51cto.com/course/7015.html
Registration consultation: https://edu.51cto.com/mic-position/131.html
two ) MySQL Database Engineer Training Course _ Study Guide _ Career planning _ treatment
Free audition: https://edu.51cto.com/course/7015.html
Registration consultation: https://edu.51cto.com/mic-position/303.html
three )Dual database (Oracle+MySQL) Sharing of series of training courses one point five (regularly updated)
http://www.fgedu.net.cn/oracle.html
4、 Xinchuang. Domestic Database Engineer Training Topic 2.0 (8 databases in total)
--------------------------------------------------------------------------------
Address: https://edu.51cto.com/topic/5452.html
Xinchuang. Domestic Database Engineer Training Topic 2.0 (including: Da Meng, NPC Jincang, Nanda GM, Huawei Gauss openGauss、TiDB,TDSQL,OceanBase)
5、 Big Data Operation and Maintenance Architects Practical Training Topic 2.0
--------------------------------------------------------------------------------
Address: https://edu.51cto.com/topic/4539.html
Familiar with Hadoop big data ecological technology framework, including Cloudera CDH HDFS、Yarn、Hbase、Hive、
Zookeeper, Kafka, Spark, Flink, Flume, Sqoop, ETL/Kettle, ELK, Azkaban and other groups
Component installation configuration and daily maintenance management. Including the construction and maintenance of OLAP database platforms such as Elastic Search, ClickHouse, GreenPlum, TiDB, etc.