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 published by Brother Feng. This course belongs to the practical battle of PostgreSQL cluster solution and stream replication project in the stage of master-slave replication and high availability cluster of PostgreSQL. After learning this course, you can master the solution of PostgreSQL cluster and high availability architecture, 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 and 1 standby), PostgreSQL master-slave flow replication master-slave switch (1 active and 1 standby), PostgreSQL master-slave flow replication adds delete nodes (1 active and 2 slave), PostgreSQL normal master-slave switch (1 active and 2 slave switch), PostgreSQL abnormal master-slave switch (1 active and 2 slave failover switch), PostgreSQL master slave flow replication+deferred standby database configuration, custom tablespace usage of PostgreSQL master slave flow replication, cascade replication of PostgreSQL master slave flow replication, combination of synchronous replication and asynchronous replication of PostgreSQL master slave flow replication, precautions in the use of PostgreSQL stream replication and other technical contents are 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 Topic 2.0 of training for domestic database engineers (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.
