MySQL PITR The Fastest Way With DevOps
Point In Time Recovery - is a nightmare for DBAs if the MySQL clusters are self managed. It was 10PM, after had my dinner I was simply watching some shows in YouTube. And my phone was ringing, the customer on other side. Due to some bad queries, one of the main table get updated without where clause. Then suddenly everyone joined the call and asking me to bring the data back. That day it took 6 to 8 Hours to bring the data. Yes, every DBAs will do one or two biggest mistakes. In my carrier I would say this was that day. So here is my MySQL PITR the fastest way with DevOps.
MySQL Exact Row Count For All The Tables
MySQL With DevOps 1 - Automate Database Archive
Create Aurora Read Replica With AWS CLI/Lambda Python
AWS DocumentDB - A NoSQL Equivalent For Aurora
Automation Script For Percona Xtrabackup FULL/Incremental
RunDeck Series 5 - Encrypt Key Files And Passwords In RunDeck
RunDeck Series 4 - Configure RunDeck SMTP With AWS SES
RunDeck Series 3 - Configure Nginx ProxyPass For RunDeck
RunDeck Series 2 - Add Nodes to the Rundeck
Add nodes to the Rundeck Server is very next step after installation. Here we are going to see adding Linux nodes to Rundeck. After Rudeck 3.0+ the resources.xml file will not create automatically. In previous versions, this file was automatically created while creating a project. We’ll node nodes details in this file. But in latest versions, it’s not creating automatically.