postgresql-replication-high-availability-ha-and-scalability

PostgreSQL\ 0:00 Why Scale PostgreSQL 1:26 Vertical Scaling 2:40 Horizontal Scaling 5:22 CAP Theorem Explained 9:10 PostgreSQL vs. NoSQL 11:09 Use case Consistent and Available System 12:20 Use case Available and Partition-tolerant System 13:22 Read Versus Write Bound Workload 16:07 How statistics will answer to all questions 17:23 Enable Statistics 22:03 Replication 23:30 Load Balancing 25:00 Connection Pooling 26:21 Queuing 27:14 Partitioning 27:51 Sharding 28:40 Multi-master Replication\ 30:25 What is Streaming Replication 32:37 Asynchronous vs. Synchronous Replication 35:10 Hands-on - Initialise Primary Database 36:39 Configuring the Primary for Replication 40:26 Configuring the Replica Instance 43:27 Testing Replication Setup Replication\ 46:1 What is Logical Replication in Postgres 52:1 Setting-up Postgres Servers for Logical Replication 56:5 Selective Copy of the Data 1:00:1 Create the Publication 1:00:5 Create the Subscription 1:04:0 Limitations of Logical Replication 1:06:2 Monitoring Logical Replication 1:09:3 Best use-cases for Logical Replication \ 1:11:23 Introduction 1:12:15 Fundamental concepts of connection pooling 1:14:38 Building a PgBouncer Setup 1:16:38 Installing and Configure PgBouncer 1:17:15 Creating a basic configuration file for PgBouncer 1:20:30 Connecting to PgBouncer 1:21:44 Advanced Settings for Performance 1:24:39 Pool Modes 1:26:31 A simple benchmark PostgreSQL with Google Cloud and HAProxy\ 1:30:28 Introduction 1:30:55 Key Components 1:31:33 Key Characteristics of the Architecture 1:32:30 Creating PostgreSQL Instances on Google Cloud 1:37:07 Creating a GCE for HAProxy 1:41:07 Configure HAProxy for Load-Balancing 1:47:22 Testing Load-Balancing \ 1:51:12 Introduction 1:52:10 Which Tables Need Partitioning 1:54:16 How should the Tables be Partitioned 1:56:03 Declarative vs. Inheritance Partitioning 1:56:48 Creating a Partitioned Table 2:01:10 Partitioning Methods \ 2:02:55 Introduction 2:05:58 Pain Points of Sharding 2:10:14 How to Partition Data in PostgreSQL 2:13:37 Second Level Sharding 2:15:43 Querying Across Shards High Availability\ 2:17:21 Why High Availability 2:18:00 Steps to achieve High Availability 2:19:57 Essential Questions to set-up High Availability 2:25:17 Log-Shipping Replication 2:26:40 Streaming Replication and Logical Replication 2:29:11 Cascading Replication 2:30:28 Synchronous vs. Asynchronous Replication 2:32:33 Automatic Failover and Always-on Strategy 2:33:53 Simple HA Solution Example 2:34:44 Better HA Solution Example II\ 2:36:26 Introduction 2:37:04 Pgpool-II Features 2:40:22 Configure Pgpool-II with Streaming Replication 2:41:29 Setting up Streaming Replication 2:47:22 Configuring Pgpool-II for Load Balancing 2:54:03 Testing load-balancing & readwrite separation 2:57:28 Configure Pgpool for PostgreSQL High-Availability 2:58:26 Configuring PostgreSQL Primary Server 3:00:59 Configuring Pgpool-II Server 3:03:24 Configuring PostgreSQL Replica Server 3:04:47 Testing The Failover 3:06:59 Restoring failed nodes