Task #2227
closed
test replication tools for postgres
Added by Lucio Lelii about 9 years ago. Updated almost 9 years ago.
100%
Description
install and test one of the tools for postgreSQL replication reported here https://wiki.postgresql.org/wiki/Replication,_Clustering,_and_Connection_Pooling
Pgpool-II looks interesting
Related issues
Updated by Pasquale Pagano about 9 years ago
- Priority changed from Urgent to Immediate
@tommaso.piccioli@isti.cnr.it please react asap since we need to move forward on this activity.
Updated by Tommaso Piccioli about 9 years ago
- % Done changed from 0 to 20
New empty VM created:
postgres1-d-d4s.d4science.org
postgres2-d-d4s.d4science.org
ubuntu 14.04
Updated by Andrea Dell'Amico about 9 years ago
- Assignee changed from _InfraScience Systems Engineer to Andrea Dell'Amico
I'm taking it.
Updated by Andrea Dell'Amico about 9 years ago
- Status changed from New to In Progress
Updated by Andrea Dell'Amico about 9 years ago
- % Done changed from 20 to 40
pgpool II and postres are installed on both machines. I'm studying the pgpool configuration to make it usable.
Updated by Andrea Dell'Amico about 9 years ago
- % Done changed from 40 to 50
pgpool is actually running on postgres1-d-d4s.d4science.org. It's configured to run on replication mode and the load balancer is active.
I don't have configured the cache memory yet, nor I did touch the connection pool parameters.
The failover capabilities are also not configured.
Updated by Andrea Dell'Amico about 9 years ago
- % Done changed from 50 to 60
The pgpool main configuration file is now a template, and we have a set of tasks to configure the authentication.
Updated by Andrea Dell'Amico about 9 years ago
- Status changed from In Progress to Feedback
Updated by Andrea Dell'Amico about 9 years ago
- Status changed from Feedback to In Progress
The replication scripts need more testing. And we need some automated tools to remove the WAL archives regularly because they grow fast.
Updated by Andrea Dell'Amico almost 9 years ago
- Assignee changed from Andrea Dell'Amico to _InfraScience Systems Engineer
I need two different VMs to test the replication without breaking the actual instances.
Updated by Andrea Dell'Amico almost 9 years ago
- Blocked by Task #4144: Two VMs are needed to test the pgpool replication functionalities added
Updated by Andrea Dell'Amico almost 9 years ago
@lucio.lelii@isti.cnr.it I need a short downtime to update the pgpool configuration on those hosts to be identical to the one seen on #4144, otherwise the recovery is not going to work.
Updated by Lucio Lelii almost 9 years ago
you can restart the node with pgpool, we are not using it yet.
Updated by Andrea Dell'Amico almost 9 years ago
- Status changed from In Progress to Feedback
- % Done changed from 60 to 100
The two servers are now up to date.
Updated by Andrea Dell'Amico almost 9 years ago
- Status changed from Feedback to Closed
Updated by Andrea Dell'Amico almost 9 years ago
Added ganglia monitoring, within a general "D4Science Development servers" cluster. http://monitoring.research-infrastructures.eu/ganglia/?c=D4Science%20Development%20servers&m=load_one&r=hour&s=by%20name&hc=4&mc=2
