LibertaCasa/system
9
0
Fork 0
Code Issues 3 Pull Requests 1 Projects Releases Wiki Activity

Install off-site MySQL slave #3

New Issue
Closed
opened 2021-08-14 22:57:40 +02:00 by Georg · 2 comments
Georg commented 2021-08-14 22:57:40 +02:00
Owner
Copy Link

The current Percona XtraDB multi-master cluster is distributed across the same physical location. We should install a read-only node in a different country that syncs on a shedule.

The current Percona XtraDB multi-master cluster is distributed across the same physical location. We should install a read-only node in a different country that syncs on a shedule.
Georg commented 2021-08-30 20:12:42 +02:00
Author
Owner
Copy Link

Installed standalone node with Percona Server in Warsaw, but haven’t written a sync script to put in a cronjob yet. Originally intended to use MySQL replication, but figured it’d be good to have one that survives longer WAN connectivity issues with no manual intervention.

Installed standalone node with Percona Server in Warsaw, but haven't written a sync script to put in a cronjob yet. Originally intended to use MySQL replication, but figured it'd be good to have one that survives longer WAN connectivity issues with no manual intervention.
Georg commented 2021-08-31 13:35:27 +02:00
Author
Owner
Copy Link

Used native MySQL replication instead now. Added a simple daily monitoring run via 73405432c9, if it turns out to be inconsistent we’ll ditch it and add a plain sync shedule.

Used native MySQL replication instead now. Added a simple daily monitoring run via https://git.com.de/LibertaCasa/system/commit/73405432c9c982189dffc62d436a30ccac8cc100, if it turns out to be inconsistent we'll ditch it and add a plain sync shedule.
Georg closed this issue 2021-08-31 13:35:35 +02:00
Sign in to join this conversation.
No Branch/Tag Specified
Branches Tags
Labels
Clear labels
Priority: Critical
Priority: High
Priority: Low
Priority: Medium
Type: Sprinkle
Write yaml to salt
No Label
Milestone
No items
No Milestone
Projects
Clear projects
No project
Assignees
Clear assignees
coderobe Georg grapple Mikaela nish pratyush pytoxic samsepi0l
No Assignees
1 Participants
Notifications
Due Date
No due date set.
Dependencies

No dependencies set.

Reference: LibertaCasa/system#3
No description provided.
Delete Branch "%!s()"

Deleting a branch is permanent. Although the deleted branch may continue to exist for a short time before it actually gets removed, it CANNOT be undone in most cases. Continue?