Pgpool-II Tutorial
ฝัง
- เผยแพร่เมื่อ 30 มิ.ย. 2024
- 0:00 - Introduction
0:41 - Pgpool-II Features
3:57 - Configure Pgpool-II with Streaming Replication
5:04 - Setting up Streaming Replication
10:57 - Configuring Pgpool-II for Load Balancing
17:38 - Testing load-balancing & read/write separation
21:03 - Configure Pgpool for PostgreSQL High-Availability
22:01 - Configuring PostgreSQL Primary Server
24:34 - Configuring Pgpool-II Server
26:59 - Configuring PostgreSQL Replica Server
28:23 - Testing The Failover
30:34 - Restoring failed nodes
🐘 Want to find out MORE about Scaling PostgreSQL?
Use the link below to get 60% OFF on the Entire Course.
www.udemy.com/course/postgres... - วิทยาศาสตร์และเทคโนโลยี
incredibilly well done tutorial.
keep up the good work!
Thank you very much for this brilliant and comprehensive tutorial.
Thank you for this video. It makes me more confident to join my new team !
Its so clear and crystal.
thank you for this high quality - top level programming course's
very very good job sir. you helped me a lot. keep up the good work.
This video saved my life.
Nice explanation... appreciated 👏👏
Very nicely explained...keep it up the good work.. it will be good if same can be explained for pgbouncer..
This is high quality.
Thank you so muchh!, your video is very helpfull!!!
Hey mate, great tutorials on Postgres & pgpool.
I have a question, if I may. I would like to run pgpool on a server separate to the one(s) running Postgres. Do I need to install Postgres server& create a cluster in the server running pgpool? When I run pgpool on a standalone server as user postgres (which gets created during install), it keeps looking for /var/run/postgres directory!Thanks.
Thank you!🙂
vow hatsoff you have explianed too good
Your video gives a great idea of HA using pgpool, congrats! I’m trying to implement this but in a more real use case where master and standby are different machines. I saw in documentation that pgpool deals with virtual IP. It’s not clear to me if pgpool manages the virtual IP itself or if I need to configure keepalived together with pgpool.
wonderful !!! please share repmgr and other high availability examples. warm and hot replicas
Awesome content. I would suggest to make the sound louder, as I am using headphones and need to watch my online learning videos in silence.
Thanks!
Really nice tutorial !
Straghtforward and clean one ! love it.
But i still got a quick question, in case of distributed cluster (3 nodes, on 3 machines) should i setup a pgpool on each of the postgres nodes ?
Thanks !
thank you sir , can you please make complete video on postgres HA data replication with failover and load balancing using HAProxy also with latest postgres version like 14 or 15
Can you also create tutorial to setup two pgpool servers to pgpool HA please?
this is very well
Thanks!!
can you describe more details about automatic failover? i am using docker/kubernetes to deploy the database, so it would be kind of you to show me how. Thank you a lot
Very nice tutorial, if possible make a video on citusdata
man you are awesome! thank you!
great tutorial video, but perhaps you can provide using VM with bridge network configuration to simulate multiple hosts for next video
thanks anyway
thankyou
@high-performance programming, on 15:03 of your video. how can I enter in pgpool.conf (backend_data_directory0) the path of the “data” folder of my pgsql if it is in windows environment? I am your one of your student in udemy.
This is amazing. Thank you for the video. Can you give me little bit explenation how to do this with remote database clusters. For example DigitalOcean Managed Database Clusters. I am having trouble with it. Please.
👏
Executed exactly as shown and postgresql.conf is missing in the replica (postgresql 15.1, Debian 11.5)
is streaming replication mandatory for automatic failover?
How are you stoped Pgpool not to do steaming replication as you are configuring replication manually.
pgpool2 is repeatedly searching for primary node and has only detected standby node i have already tried restarting pgpool what should i do
guys i have a question, how i can download pgpool in windows ?
After watching it multiple times: Please next time make it a bit louder. Also a transcript would be nice, to be able to copy the commands for example.
Kindly help, have configured standby in pgpool.conf as you explained, but its not detecting. What could be the possibility.
2023-01-02 20:39:12.466: main pid 2971668: DETAIL: socket(::) failed: "Address family not supported by protocol"
2023-01-02 20:39:12.474: main pid 2971668: LOG: find_primary_node_repeatedly: waiting for finding a primary node
2023-01-02 20:39:12.479: main pid 2971668: LOG: find_primary_node: primary node is 0
2023-01-02 20:39:12.480: main pid 2971668: LOG: pgpool-II successfully started. version 4.3.3 (tamahomeboshi)
2023-01-02 20:39:12.480: main pid 2971668: LOG: node status[0]: 1
2023-01-02 20:39:12.480: main pid 2971668: LOG: node status[1]: 0
2023-01-02 20:39:12.481: pcp_main pid 2971705: LOG: PCP process: 2971705 started
2023-01-02 20:39:12.481: sr_check_worker pid 2971706: LOG: process started
2023-01-02 20:39:12.481: health_check pid 2971707: LOG: process started
i have the same probleme did u find a solution?
incredibilly well done tutorial.
keep up the good work!