HA with RelStorage and Postgres

Apr 29, 2014Download as pptx, pdf

4 likes1,682 views

The document discusses high availability (HA) solutions using PostgreSQL with a focus on eliminating single points of failure, maintaining reliable failover, and failure detection. It introduces repmgr as a tool for managing replication and failover processes, emphasizing its functionalities and potential pitfalls. Additionally, it outlines common failure scenarios and best practices for monitoring and maintaining database reliability.

Software Technology

Harder, better, faster, stronger.
HA with RelStorage and Postgres
abstract @ PLOG 2014simone.deponti@abstract.it /

HA?
From the not-very-realiable Wikipedia page
about it:
A = Ut / Tt
Where Ut is the uptime and Tt the total time

Three rules of HA
1. Eliminate single points of failure
2. Have a reliable failover
3. Detect failures as they occur

Two elephants in a cluster
1. Use PostgreSQL’s native Streaming
Replication
2. Means explicit master/slave roles at any
given time
3. Manual failover (slave promotion) or use
repmgr

repmgr
1. Developed by phoenicians 2ndQuadrant
2. Works in addition to streaming replication
3. Acts as watchdog and can take automatic
actions (run bash scripts)
4. You run it on the slave node
(https://github.com/2ndQuadrant/repmgr)

How it works
1. Continuously and compulsively checks
twitter that the master is alive
2. If the master is unreachable for more than
N seconds, runs a bash script
It also offers convenient command line tools
to check status of cluster, promote nodes,
syncronize.

repmgr’s gotchas
1. Create a database to store replication info
(do not follow the bad example of the
documentation)
2. The suggested wal_keep_segments
setting is too high, will use up to 78GB,
can be reduced with -w option
3. Use custom promote and follow scripts
4. Launch daemon with with --monitoring-
history

Fail scenarios
1. One node has a catastrophic failure
(easy)
2. There is a total network outage (when the
network goes up again, you have a split
brain)
3. There is network partitioning (similar to
above, can be worst)
repmgr and streaming replication do no
perform too well in cases 2 and 3

Our work is never over
1. Always notify when a failure is detected
2. Investigate ASAP, even if automatic
action was taken
3. Have the slave try to exclude the master
upon promotion
Example of #3:
The slave upon promotion contacts all the
clients and tells them to avoid talking to master

RelStorage and PostgreSQL
It has a smal issue with connections IDLE IN
TRANSACTION.
Check with:
SELECT datname, usename,
query_start, state_change, state,
query
FROM pg_stat_activity;
It’s not fatal, but might result in locks during
backups.

Simone Deponti
simone.deponti@abstract.it

The document discusses test-driven development (TDD) and the three laws of TDD. It begins with the author explaining their initial experiences with TDD and some challenges they faced. It then presents the three laws of TDD which state that you must write a failing test before production code, only write enough test code to fail, and only write enough production code to pass the test. The document provides examples of using TDD with small steps and emphasizes writing one test at a time and improving the code base. It concludes by inviting the reader to try TDD and provides some additional resources on transformations and the transformation priority premise.

vbench: lightweight performance testing for PythonWes McKinney

��

161027robo_lab

��

This document provides an overview of the software and tools used in the Robotics Laboratory at Wakayama University Graduate School of System Engineering. It details the use of 3 Kinect sensors, CNN, TensorFlow, Caffe and other deep learning tools. It also lists the software installed including Ubuntu 16.04, ROS Kinetic, Blender 2.76, Python 2.7 and 3.5, Pyenv, Anaconda and the MORSE simulator for developing and testing robotics applications.

Atlas campJames Winters

��

Atlas camp 1James Winters

��

Implementation of Multilayer Perceptron from ScratchEng Teong Cheah

��

The document provides a guide on implementing a multilayer perceptron from scratch, covering key topics such as initializing model parameters, activation functions, the model structure, the loss function, and training processes. It concludes with an invitation for questions and includes links to a Twitter account and a blog for further resources. The document is aimed at those interested in deep learning.

Coursera Machine Learning으로 기계학습 배우기 : week5Kwangsik Lee

��

Automated dependency updatesJamie Magee

��

On The Building Of A PostgreSQL ClusterSrihari Sriraman

��

The document discusses lessons learned from setting up and maintaining a PostgreSQL cluster for a data analytics platform. It describes four stories where problems arose: 1) Implementing automatic failover using Repmgr when the master node failed, 2) The disk filling up faster than expected due to PostgreSQL's MVCC implementation, 3) Being unable to add a new standby node due to missing WAL segments, and 4) Long running queries on the standby node causing conflicts with replication. The key lessons are around using the right tools like Repmgr for replication management, tuning autovacuum, archiving WALs, and addressing hardware limitations for analytics workloads.

Streaming Replication Made Easy in v9.3Sameer Kumar

��

This document discusses setting up streaming replication in PostgreSQL v9.3 to enable high availability. It covers preparing primary and standby servers, configuring wal_level and max_wal_senders on the primary, taking a backup and restoring on the standby, creating a recovery.conf file, starting the servers to test replication, triggering failover by promoting the standby, handling multiple replicas without rebuilding, and rebuilding the original primary as a new standby. Monitoring replication status is also addressed using views like pg_stat_replication.

PostgreSQL HAharoonm

��

The document presents an agenda for a talk on PostgreSQL high availability (HA) by Muhammad Haroon, touching on topics like disaster recovery workflows, availability levels (RTO and RPO), and PostgreSQL's replication methods. It discusses the importance of planned and unplanned downtime, backup strategies, and failover scenarios with multiple standby servers. Additionally, it highlights available tools and services for PostgreSQL support and customization.

PGDay.Amsterdam 2018 - Stefan Fercot - Save your data with pgBackRestPGDay.Amsterdam

��

Out of the box replication in postgres 9.4(pg confus)Denish Patel

��

This document contains notes from a presentation on PostgreSQL replication. It discusses write-ahead logs (WAL), replication history in PostgreSQL from versions 7.0 to 9.4, how to set up basic replication, tools for backups and monitoring replication, and demonstrates setting up replication without third party tools using pg_basebackup, replication slots, and pg_receivexlog. It also includes contact information for the presenter and an invitation to join the PostgreSQL Slack channel.

Out of the Box Replication in Postgres 9.4(PgConfUS)Denish Patel

��

This document contains notes from a presentation on PostgreSQL replication. It discusses write-ahead logs (WAL), replication history in PostgreSQL from versions 7.0 to 9.4, how to set up basic replication, tools for backups and monitoring replication, and demonstrates setting up replication without third party tools using pg_basebackup, replication slots, and pg_receivexlog. Contact information is provided for the presenter and information on their employer, Medallia, is included at the end.

Building tungsten-clusters-with-postgre sql-hot-standby-and-streaming-replica...Command Prompt., Inc

��

The document discusses the integration of Tungsten with PostgreSQL, highlighting its capabilities for high availability, continuous data replication, and improved resource utilization. It outlines the differences between warm and hot standby configurations, demonstrating how streaming replication enhances PostgreSQL's functionality. Additionally, it details the setup, management, and value propositions of Tungsten for PostgreSQL users, emphasizing its user-friendly features and efficient failover processes.

Out of the Box Replication in Postgres 9.4(pgconfsf)Denish Patel

��

Denish Patel gave a presentation on PostgreSQL replication. He began by introducing himself and his background. He then discussed PostgreSQL write-ahead logging (WAL), replication history, and how replication is currently setup. The presentation covered replication slots, demoing replication without external tools using pg_basebackup, streaming replication with slots, and pg_receivexlog. Patel also discussed monitoring replication and answered questions from the audience.

Built in physical and logical replication in postgresql-Firat GulecFIRAT GULEC

��

The document details a presentation by Fırat Güleç on built-in physical and logical replication in PostgreSQL, covering key topics such as the purpose of replication, configuration of master and standby servers, and the benefits of streaming and logical replication. It outlines the steps for setting up various replication types, including cascading replication, and includes discussions on the limitations of logical replication as well as their use cases. The talk also includes a quiz for participants with prizes based on their performance.

PostgreSQL Sharding and HA: Theory and Practice (PGConf.ASIA 2017)Aleksander Alekseev

��

This document summarizes Aleksander Alekseev's talk on PostgreSQL sharding and high availability. The talk introduces replication in PostgreSQL, including physical and logical replication. It discusses solutions for high availability like Stolon and PostgreSQL Multimaster, as well as existing solutions for sharding like manual sharding, Citus, Greenplum, and pg_shardman. It also briefly covers other databases like Amazon Aurora and CockroachDB that are inspired by PostgreSQL but with additional distributed functionality.

PostgreSQL High Availability in a Containerized WorldJignesh Shah

��

This document discusses PostgreSQL high availability in a containerized environment. It begins with an overview of containers and their advantages like lower footprint and density. It then covers enterprise needs for high availability like recovery time objectives. Common approaches to PostgreSQL high availability are discussed like replication, shared storage, and using projects like Patroni and Stolon. Modern trends with containers are highlighted like separating data and binaries. Kubernetes is presented as a production-grade orchestrator that can provide horizontal scaling and self-healing capabilities. The discussion concludes with challenges of multi-region deployments and how service discovery with Consul can help address those challenges.

How to Replicate PostgreSQL DatabaseSangJin Kang

��

This document provides an overview of replicating a PostgreSQL database. It discusses setting up a primary server for reads and writes and standby servers that are kept in sync with the primary to serve as backups. The primary server writes data to its write-ahead log (WAL) files, which are streamed in real-time to the standby servers via WAL shipping. This allows the standby servers to keep an identical copy of the database. The document also covers configuration of both the primary and standby servers for replication as well as tools for testing the replication setup.

ProstgreSQLFailoverConfigurationSuyog Shirgaonkar

��

The document describes how to set up PostgreSQL replication with load balancing using pgpool. Key steps include: 1. Configure streaming replication between a primary and standby PostgreSQL node. Repmgr is used to manage replication. 2. Install and configure pgpool to distribute read queries to primary and standby nodes, and trigger failover if needed. 3. Test replication, failover, and recovery of the primary-standby setup. The standby is promoted to primary and replication is reestablished when the original primary is recovered.

Fail over fail_backPostgreSQL Experts, Inc.

��

1) Automated failover involves detecting failure of the primary database, promoting a replica to be the new primary, and failing over applications to connect to the new primary. 2) Detecting failure involves multiple checks like connecting to the primary, checking processes, and using pg_isready. Promoting a replica requires choosing the most up-to-date one and running pg_ctl promote. 3) Failing over applications can be done by updating a configuration system and restarting apps, using a tool like Zookeeper, or by failing over a virtual IP with Pacemaker. Proxies can also be used to fail over connections.

High Availability PostgreSQL with Zalando PatroniZalando Technology

��

The document discusses the high availability of PostgreSQL using Patroni, including master election, streaming replication, and failover management. It explains components like etcd for leader election and consensus, configuration parameters for Patroni, and the use of pg_rewind for recovering from master failures. Additionally, it outlines the implementation details and provides guidance on setting up the system, including HAProxy configuration and user-defined scripts.

PostgreSQL Streaming Replication CheatsheetAlexey Lesovsky

��

The document provides configuration instructions and guidelines for setting up streaming replication between a PostgreSQL master and standby server, including setting parameter values for wal_level, max_wal_senders, wal_keep_segments, creating a dedicated replication role, using pg_basebackup to initialize the standby, and various recovery target options to control the standby's behavior. It also discusses synchronous replication using replication slots and monitoring the replication process on both the master and standby servers.

Patroni - HA PostgreSQL made easyAlexander Kukushkin

��

This document discusses Patroni, an open-source tool for managing high availability PostgreSQL clusters. It describes how Patroni uses a distributed configuration system like Etcd or Zookeeper to provide automated failover for PostgreSQL databases. Key features of Patroni include manual and scheduled failover, synchronous replication, dynamic configuration updates, and integration with backup tools like WAL-E. The document also covers some of the challenges of building automatic failover systems and how Patroni addresses issues like choosing a new master node and reattaching failed nodes.

Out of the box replication in postgres 9.4Denish Patel

��

This document provides an overview of setting up out of the box replication in PostgreSQL 9.4 without third party tools. It discusses write-ahead logs (WAL), replication slots, pg_basebackup, and pg_receivexlog. The document then demonstrates setting up replication on VMs with pg_basebackup to initialize a standby server, configuration of primary and standby servers, and monitoring of replication.

Out of the Box Replication in Postgres 9.4(PgCon)Denish Patel

��

The document provides an overview of out-of-the-box replication in PostgreSQL 9.4. It discusses PostgreSQL write-ahead logging (WAL), setting up basic streaming replication between a primary and standby server, taking base backups with pg_basebackup, and using replication slots and pg_receivexlog to archive WAL files without external tools. The presentation includes steps to set up a demo of this replication method on a virtual machine.

Out of the Box Replication in Postgres 9.4(PgCon)Denish Patel

��

This document provides an overview of setting up out of the box replication in PostgreSQL 9.4 without third party tools. It discusses write-ahead logs (WAL), replication slots, pg_basebackup, pg_receivexlog and monitoring replication. The presenter then demonstrates setting up replication on VMs with pg_basebackup to initialize a standby, configuration of primary and standby servers, and monitoring replication status.

Milwaukee Marketo User Group June 2025 - Optimize and Enhance Efficiency - Sm...BradBedford3

��

Inspired by the Adobe Summit hands-on lab, Optimize Your Marketo Instance Performance, review the recording from June 5th to learn best practices that can optimize your smart campaign and smart list processing time, inefficient practices to try to avoid, and tips and tricks for keeping your instance running smooth! You will learn: How smart campaign queueing works, how flow steps are prioritized, and configurations that slow down smart campaign processing. Best practices for smart list and smart campaign configurations that yield greater reliability and processing efficiencies. Generally recommended timelines for reviewing instance performance: walk away from this session with a guideline of what to review in Marketo and how often to review it. This session will be helpful for any Marketo administrator looking for opportunities to improve and streamline their instance performance. Be sure to watch to learn best practices and connect with your local Marketo peers!

Best MLM Compensation Plans for Network Marketing Success in 2025LETSCMS Pvt. Ltd.

��

More Related Content

Recently uploaded (20)

Milwaukee Marketo User Group June 2025 - Optimize and Enhance Efficiency - Sm...BradBedford3

��

Best MLM Compensation Plans for Network Marketing Success in 2025LETSCMS Pvt. Ltd.

��

OpenChain Webinar - AboutCode - Practical Compliance in One Stack – Licensing...Shane Coughlan

��

Foundations of Marketo Engage - Programs, Campaigns & Beyond - June 2025BradBedford3

��

Join us for an exciting introductory session on, Foundations of Marketo Engage: Programs, Campaigns & Beyond. Ideal for new and early-stage users looking to build confidence and capability in Marketo Engage. Our speakers for this session will be: AJ Navarro Marketing Operations Manager - Sprout Social Bobby Coppola Marketing Manager - Blue Yonder This event will guide you through the essential steps to build strong, scalable Programs, Channels, Tags, Smart Campaigns, and Reporting Basics in Marketo Engage. Attendees will gain practical knowledge on how to structure and launch marketing initiatives, leverage templates for efficiency, and implement best practices for campaign execution and measurement. You'll leave with actionable insights you can immediately apply to your own Marketo instance to improve organization, automation, and reporting. Marketo Engage. Learn how to create impactful programs and understand the best practices for seamless campaign management and effective reporting. Don’t miss out on this opportunity to gain hands-on guidance from experienced practitioners and to connect with peers who are also new to the platform. Secure your spot today and start building your path to becoming a Marketo pro! Please feel free to invite colleagues who you think would also benefit from this session.

Sysinfo OST to PST Converter InfographicSysInfo Tools

��

Canva Pro Crack Free Download 2025-FREE LATESTgrete1122g

��

Folding Cheat Sheet # 9 - List Unfolding 𝑢𝑛𝑓𝑜𝑙𝑑 as the Computational Dual of ...Philip Schwarz

��

Making significant Software Architecture decisionsBert Jan Schrijver

��

SAP PM Module Level-IV Training Complete.pptMuhammadShaheryar36

��

Who will create the languages of the future?Jordi Cabot

��

Will future languages be created by language engineers? Can you "vibe" a DSL? In this talk, we will explore the changing landscape of language engineering and discuss how Artificial Intelligence and low-code/no-code techniques can play a role in this future by helping in the definition, use, execution, and testing of new languages. Even empowering non-tech users to create their own language infrastructure. Maybe without them even realizing.

openSAP_s4h27_Week_1_2025_All_�ݺ�ߣs.pdfThomas Qiao

��

Porting Qt 5 QML Modules to Qt 6 WebinarICS

��

Have you upgraded your application from Qt 5 to Qt 6? If so, your QML modules might still be stuck in the old Qt 5 style—technically compatible, but far from optimal. Qt 6 introduces a modernized approach to QML modules that offers better integration with CMake, enhanced maintainability, and significant productivity gains. In this webinar, we’ll walk you through the benefits of adopting Qt 6 style QML modules and show you how to make the transition. You'll learn how to leverage the new module system to reduce boilerplate, simplify builds, and modernize your application architecture. Whether you're planning a full migration or just exploring what's new, this session will help you get the most out of your move to Qt 6.

Threat Modeling a Batch Job Framework - Teri Radichel - AWS re:Inforce 20252nd Sight Lab

��

This presentation is similar to another presentation I gave earlier in the year at the AWS Community Security Day, except that I had less time to present and incorporated some AI slides into the presentation. In this presentation I explain what batch jobs are, how to use them, and that AI Agents are essentially batch jobs. All the same security controls that apply to batch jobs also apply to AI agents. In addition, we have more concerns with AI agents because AI is based on a statistical model. That means that depending on where and how AI is used we lose some of the reliability that we would get from a traditional batch job. That needs to be taken into consideration when selecting how and when to use AI Agents as batch jobs and whether we should use AI to trigger an Agent. As I mention on one side - I don't want you to predict what my bank statement should look like. I want it to be right! By looking at various data breaches we can determine how those attacks worked and whether the system we are building is susceptible to a similar attack or not.

Emvigo Capability Deck 2025: Accelerating Innovation Through Intelligent Soft...Emvigo Technologies

��

Welcome to Emvigo’s Capability Deck for 2025 – a comprehensive overview of how we help businesses launch, scale, and sustain digital success through cutting-edge technology solutions. With 13+ years of experience and a presence across the UK, UAE, and India, Emvigo is an ISO-certified software company trusted by leading global organizations including the NHS, Verra, London Business School, and George Washington University. 🔧 What We Do We specialize in: Rapid MVP development (go from idea to launch in just 4 weeks) Custom software development Gen AI applications and AI-as-a-Service (AIaaS) Enterprise cloud architecture DevOps, CI/CD, and infrastructure automation QA and test automation E-commerce platforms and performance optimization Digital marketing and analytics integrations 🧠 AI at the Core Our delivery model is infused with AI – from workflow optimization to proactive risk management. We leverage GenAI, NLP, and ML to make your software smarter, faster, and more secure. 📈 Impact in Numbers 500+ successful projects delivered 200+ web and mobile apps launched 42-month average client engagement 30+ active projects at any time 🌍 Industries We Serve Fintech Healthcare Education (E-Learning) Sustainability & Compliance Real Estate Energy Customer Experience platforms ⚙️ Flexible Engagement Models Whether you're looking for dedicated teams, fixed-cost projects, or time-and-materials models, we deliver with agility and transparency. 📢 Why Clients Choose Emvigo ✅ AI-accelerated delivery ✅ Strong focus on long-term partnerships ✅ Highly rated on Clutch and Google Reviews ✅ Proactive and adaptable to change ✅ Fully GDPR-compliant and security-conscious 🔗 Visit: emvigotech.com 📬 Contact: sales@emvigotech.com 📞 Ready to scale your tech with confidence? Let’s build the future, together.

Decipher SEO Solutions for your startup needs.mathai2

��

A solution deck that gives you an idea of how you can use Decipher SEO to target keywords, build authority and generate high ranking content. With features like images to product you can create a E-commerce pipeline that is optimized to help your store rank. With integrations with shopify, woocommerce and wordpress theres a seamless way get your content to your website or storefront. View more at decipherseo.com

Download Adobe Illustrator Crack free for Windows 2025?grete1122g

��

Heat Treatment Process Automation in IndiaReckers Mechatronics

��

Y - Recursion The Hard Way GopherCon EU 2025Eleanor McHugh

��

In most modern programming languages, including Go, it's possible for a function to call itself recursively. It's such a mainstream technique that we've come to take it for granted. But what if functions couldn't call themselves? There's a branch of mathematics called Combinatorics which answers just these kinds of questions, and this presentation takes these ideas and phrases them in Go to teach a deeper view of computation through the medium of code.

Women in Tech: Marketo Engage User Group - June 2025 - AJO with AWSBradBedford3

��

Creating meaningful, real-time engagement across channels is essential to building lasting business relationships. Discover how AWS, in collaboration with Deloitte, set up one of Adobe's first instances of Journey Optimizer B2B Edition to revolutionize customer journeys for B2B audiences. This session will share the use cases the AWS team has the implemented leveraging Adobe's Journey Optimizer B2B alongside Marketo Engage and Real-Time CDP B2B to deliver unified, personalized experiences and drive impactful engagement. They will discuss how they are positioning AJO B2B in their marketing strategy and how AWS is imagining AJO B2B and Marketo will continue to work together in the future. Whether you’re looking to enhance customer journeys or scale your B2B marketing efforts, you’ll leave with a clear view of what can be achieved to help transform your own approach. Speakers: Britney Young Senior Technical Product Manager, AWS Erine de Leeuw Technical Product Manager, AWS

arctitecture application system design os dsaza241967

��

Milwaukee Marketo User Group June 2025 - Optimize and Enhance Efficiency - Sm...BradBedford3

��

Best MLM Compensation Plans for Network Marketing Success in 2025LETSCMS Pvt. Ltd.

��

OpenChain Webinar - AboutCode - Practical Compliance in One Stack – Licensing...Shane Coughlan

��

Foundations of Marketo Engage - Programs, Campaigns & Beyond - June 2025BradBedford3

��

Sysinfo OST to PST Converter InfographicSysInfo Tools

��

Canva Pro Crack Free Download 2025-FREE LATESTgrete1122g

��

Folding Cheat Sheet # 9 - List Unfolding 𝑢𝑛𝑓𝑜𝑙𝑑 as the Computational Dual of ...Philip Schwarz

��

Making significant Software Architecture decisionsBert Jan Schrijver

��

SAP PM Module Level-IV Training Complete.pptMuhammadShaheryar36

��

Who will create the languages of the future?Jordi Cabot

��

openSAP_s4h27_Week_1_2025_All_�ݺ�ߣs.pdfThomas Qiao

��

Porting Qt 5 QML Modules to Qt 6 WebinarICS

��

Threat Modeling a Batch Job Framework - Teri Radichel - AWS re:Inforce 20252nd Sight Lab

��

Emvigo Capability Deck 2025: Accelerating Innovation Through Intelligent Soft...Emvigo Technologies

��

Decipher SEO Solutions for your startup needs.mathai2

��

Download Adobe Illustrator Crack free for Windows 2025?grete1122g

��

Heat Treatment Process Automation in IndiaReckers Mechatronics

��

Y - Recursion The Hard Way GopherCon EU 2025Eleanor McHugh

��

Women in Tech: Marketo Engage User Group - June 2025 - AJO with AWSBradBedford3

��

arctitecture application system design os dsaza241967

��

HA with RelStorage and Postgres

1. Harder, better, faster, stronger. HA with RelStorage and Postgres abstract @ PLOG 2014simone.deponti@abstract.it /

2. HA? From the not-very-realiable Wikipedia page about it: A = Ut / Tt Where Ut is the uptime and Tt the total time

3. Three rules of HA 1. Eliminate single points of failure 2. Have a reliable failover 3. Detect failures as they occur

4. It’s a short way to HA

5. Two elephants in a cluster 1. Use PostgreSQL’s native Streaming Replication 2. Means explicit master/slave roles at any given time 3. Manual failover (slave promotion) or use repmgr

6. repmgr 1. Developed by phoenicians 2ndQuadrant 2. Works in addition to streaming replication 3. Acts as watchdog and can take automatic actions (run bash scripts) 4. You run it on the slave node (https://github.com/2ndQuadrant/repmgr)

7. How it works 1. Continuously and compulsively checks twitter that the master is alive 2. If the master is unreachable for more than N seconds, runs a bash script It also offers convenient command line tools to check status of cluster, promote nodes, syncronize.

8. repmgr’s gotchas 1. Create a database to store replication info (do not follow the bad example of the documentation) 2. The suggested wal_keep_segments setting is too high, will use up to 78GB, can be reduced with -w option 3. Use custom promote and follow scripts 4. Launch daemon with with --monitoring- history

9. Fail scenarios 1. One node has a catastrophic failure (easy) 2. There is a total network outage (when the network goes up again, you have a split brain) 3. There is network partitioning (similar to above, can be worst) repmgr and streaming replication do no perform too well in cases 2 and 3

10. Our work is never over 1. Always notify when a failure is detected 2. Investigate ASAP, even if automatic action was taken 3. Have the slave try to exclude the master upon promotion Example of #3: The slave upon promotion contacts all the clients and tells them to avoid talking to master

11. RelStorage and PostgreSQL It has a smal issue with connections IDLE IN TRANSACTION. Check with: SELECT datname, usename, query_start, state_change, state, query FROM pg_stat_activity; It’s not fatal, but might result in locks during backups.

12. Simone Deponti simone.deponti@abstract.it

�ݺ�ߣ

HA with RelStorage and Postgres

Recommended

More Related Content

Similar to HA with RelStorage and Postgres (20)

Recently uploaded (20)

HA with RelStorage and Postgres