ClusterLabs / ClusterLabs/striker

Disable triggers and hold access when running ScanCore's update_db()

Open
#76 0 comments 0 reactions 0 assignees View on GitHub
enhancement Low Priority Issue Pre v2.1
Dominant language
Perl
Stars
27
Forks
12
PR merge metrics
No merged PRs in 30d

Description

Set a 'variables' entry to mark an ongoing DB update and have connect_to_db() check and, if set, loop until the variable is released (with a sane timeout).

Then setup the ScanCore schema to allow the Striker user to set/release 'session_replication_role'. See C. Keane's reply in this thread: https://forums.aws.amazon.com/thread.jspa?messageID=561509.

Contributor guide

No contributing guide indexed for this repository

Research direction

Start at update_db() and connect_to_db(), then inspect the ScanCore schema and the referenced AWS forum reply. The work is done when an update marks the database as busy, connections wait with a sane timeout, and the Striker user can set and release session_replication_role as required.

Written by the indexing model from the issue text.

Assessment

Tech stack
perl, postgresql
Domain
backend, databases
Issue type
Feature
Difficulty
4/5
Estimated time
3-5 days
Activity status
Stale
Clarity
Mostly clear
Newbie friendliness
35/100

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.