Backup posgtgres paas databases

RESOLVED FIXED

Status

Data & BI Services Team
DB: MySQL
RESOLVED FIXED
4 years ago
3 years ago

People

(Reporter: sheeri, Assigned: mpressman)

Tracking

Details

(Whiteboard: [2014q2] April)

(Reporter)

Description

4 years ago
pg and mysql paas databases should be backed up if they are not already.
(Reporter)

Comment 1

4 years ago
As per bug 949005, 

"backup6.db.scl3.mozilla.com has been kickstarted, BIOS updated, puppetized, and basic nagios monitoring added. I did format the storage blade in RAID 6 just to make sure everything is operating, but is not currently mounted on the server as you might have other plans."

This would be for the postgres backups.
(Reporter)

Updated

4 years ago
Whiteboard: [2014q1] → [2014q1] March

Comment 2

4 years ago
Can you please confirm that the mysql databases for apps on the production paas are being backed up? What is the backup schedule?
Flags: needinfo?(scabral)
Blocks: 874202
(Reporter)

Comment 3

4 years ago
I can confirm MySQL is not currently being backed up, but I can fast-track it for this week. The main limitation is the netflow, which I'll request now.
Flags: needinfo?(scabral)
(Reporter)

Updated

4 years ago
Depends on: 970522
(Reporter)

Comment 4

4 years ago
r 82268 and 82269 have puppet updates for this backup, will initially live on backup4 in scl3.
(Reporter)

Comment 5

4 years ago
mysql paas is being backed up. As with everything else in this data center, backups are kept for 3 days.
(Reporter)

Comment 6

4 years ago
The backups schedule is once daily there is a logical backup (sql export, one per database) and once daily there is a raw backup (file copy). This way we can restore one database as easily as we can restore all of them, and we have 2 copies of the database in different formats in case one does not work for some reason.

We also have an HA setup for both MySQL and Postgres in the PaaS - we have a replicated copy of the master to the slave. So if the MySQL master dies, we have options.

Does this address your needs? If you have others, please let me know.

Comment 7

4 years ago
Thanks for the quick response, Sheeri. That sounds great to me. :)
(Reporter)

Updated

4 years ago
Assignee: server-ops-database → mpressman
Summary: Backup paas databases → Backup posgtgres paas databases
No longer blocks: 874202
(Reporter)

Updated

4 years ago
Whiteboard: [2014q1] March → [2014q2] April
(Reporter)

Comment 8

4 years ago
If you could write up documentation on this, I can test it out by backing up the postgres paas databases.
(Assignee)

Updated

4 years ago
Depends on: 1000615
(Assignee)

Comment 9

4 years ago
Added user access from backup6.db.scl3 to puppet in revision 86764
(Assignee)

Comment 10

4 years ago
Added node backup6.db.scl3 in revision 86755 to dbbackups.pp
(Assignee)

Comment 11

4 years ago
Weekly pg_dumps and daily base backups running successfully on backup6.db.scl3
Status: NEW → RESOLVED
Last Resolved: 4 years ago
Resolution: --- → FIXED
Product: mozilla.org → Data & BI Services Team
You need to log in before you can comment on or make changes to this bug.