Closed
Bug 949010
Opened 10 years ago
Closed 10 years ago
Backup posgtgres paas databases
Categories
(Data & BI Services Team :: DB: MySQL, task)
Tracking
(Not tracked)
RESOLVED
FIXED
People
(Reporter: scabral, Assigned: mpressman)
Details
(Whiteboard: [2014q2] April)
pg and mysql paas databases should be backed up if they are not already.
Reporter | ||
Comment 1•10 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•10 years ago
|
Whiteboard: [2014q1] → [2014q1] March
Comment 2•10 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)
Reporter | ||
Comment 3•10 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 | ||
Comment 4•10 years ago
|
||
r 82268 and 82269 have puppet updates for this backup, will initially live on backup4 in scl3.
Reporter | ||
Comment 5•10 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•10 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•10 years ago
|
||
Thanks for the quick response, Sheeri. That sounds great to me. :)
Reporter | ||
Updated•10 years ago
|
Assignee: server-ops-database → mpressman
Summary: Backup paas databases → Backup posgtgres paas databases
Reporter | ||
Updated•10 years ago
|
Whiteboard: [2014q1] March → [2014q2] April
Reporter | ||
Comment 8•10 years ago
|
||
If you could write up documentation on this, I can test it out by backing up the postgres paas databases.
Assignee | ||
Comment 9•10 years ago
|
||
Added user access from backup6.db.scl3 to puppet in revision 86764
Assignee | ||
Comment 10•10 years ago
|
||
Added node backup6.db.scl3 in revision 86755 to dbbackups.pp
Assignee | ||
Comment 11•10 years ago
|
||
Weekly pg_dumps and daily base backups running successfully on backup6.db.scl3
Status: NEW → RESOLVED
Closed: 10 years ago
Resolution: --- → FIXED
Updated•10 years ago
|
Product: mozilla.org → Data & BI Services Team
You need to log in
before you can comment on or make changes to this bug.
Description
•