Jul
18
2017
--

Backups and Disaster Recovery

Backups and Disaster Recovery

Backups and Disaster RecoveryIn this post, we’ll look at strategies for backups and disaster recovery.

Note: I am giving a talk on Backups and Disaster Recovery Best Practices on July 27th.

When discussing disaster recovery, it’s important to take your business’ continuity plan into consideration. Backup and recovery processes are a critical part of any application infrastructure.

A well-tested backup and recovery system can be the difference between a minor outage and the end of your business.

You will want to take three things into consideration when planning your disaster recovery strategy: recovery time objective, recovery point objective and risk mitigation.

Recovery time objective (RTO) is how long it takes to restore your backups. Recovery point objective (RPO) is what point in time you want to recover (in other words, how much data you can afford to lose after recovery). Finally, you need to understand what risks you are trying to mitigate. Risks to your data include (but are not limited to) bad actors, data corruption, user error, host failure and data center failure.

Recommended Backup Strategies

We recommend that you use both physical (Percona XtraBackup, RDS/LVM Snapshots, MySQL Enterprise Backup) and logical backups (mysqldump, mydumper, mysqlpump). Logical backups protect against the loss of single data points, while physical backups protect against total data loss or host failure.

The best practice is running Percona XtraBackup nightly, followed by mysqldump (or in 5.7+, mysqlpump). Percona XtraBackup enables you to quickly restore a server, and mysqldump enables you to quickly restore data points. These address recovery time objectives.

For point-in-time recovery, it is recommended that you download binlogs on a regular basis (once an hour, for example).

Another option is binlog streaming. You can find more information on binlog streaming in our blog: Backing up binary log files with mysqlbinlog.

There is also a whitepaper that is the basis of my webinar here: MySQL Backup and Recovery Best Practices.

Delayed Slave

One way to save on operational overhead is to create a 24-hour delayed slave. This takes the place of the logical backup (mysqldump) as well as the binlog streaming. You want to ensure that you stop the delayed slave immediately following any issues. This ensures that the data does not get corrupted on the backup as well.

A delayed slave is created in 5.6 and above with:

CHANGE MASTER TO MASTER_DELAY = N;

After a disaster, you would issue:

STOP SLAVE;

Then, in order to get a point-in-time, you can use:

START SLAVE UNTIL MASTER_LOG_FILE = 'log_name', MASTER_LOG_POS = log_pos;

Restore

It is a good idea to test your backups at least once a quarter. Backups do not exist unless you know you can restore them. There are some recent high-profile cases where developers dropped tables or schemas, or data was corrupted in production, and in one case five different backup types were not viable to use to restore.

The best case scenario is an automated restore test that runs after your backup, and gives you information on how long it takes to restore (RTO) and how much data you can restore (RPO).

For more details on backups and disaster recovery, come to my webinar.

Jul
18
2017
--

Google launches new security features to protect users from unverified apps

 Google has been steadily adding new security features for its G Suite users over the course of the last few months, including new anti-phishing tools and OAuth apps whitelisting, as well as an enhanced app review process. Today, it’s adding another layer on top of this with the launch of a new “unverified app” screen for new web applications and Apps Scripts. This new screen… Read More

Jul
18
2017
--

Rackspace partners with Pivotal to launch managed services for Cloud Foundry

 Rackspace, which strongly focuses on managed services these days, today announced a partnership with Pivotal, the company behind the open source Cloud Foundry platform as a service project. Rackspace already offers managed services for AWS, Microsoft Azure, Google Cloud Platform, VMware, OpenStack and it is now adding Pivotal Cloud Foundry to this mix. Rackspace, which made the announcement at… Read More

Jul
18
2017
--

Workflow automation startup Workato announces $10m Series A

 It’s a big day for Workato as the startup announced a $10 million Series A, and the latest release of its workflow automation platform dubbed ‘Turing.’ The round was led by Storm Ventures with participation from strategic investors Salesforce Ventures and Workday Ventures. The four year old company has now raised a total of $16 million. Workato helps companies simplify… Read More

Jul
18
2017
--

Google Glass is back with hardware focused on the enterprise

 Google Glass arguably always only made sense as an enterprise-focused product, but now it’s officially back and customized for those applications, with Glass Enterprise Edition (EE). The wearable head-mounted display has long had a place in the enterprise, even as its death as an experimental consumer product was being widely reported, but now we know a bit more about the EE hardware… Read More

Jul
18
2017
--

Upcoming Webinar Wednesday, July 19, 2017: Learning MySQL 5.7

MySQL 5.7

MySQL 5.7Join Percona’s, Technical Services Manager, Jervin Real as he presents Learning MySQL 5.7 on Wednesday, July 19, 2017 at 10:00 am PDT / 1:00 pm EDT (UTC-7).

MySQL 5.7 has a lot of new features. If you’ve dabbled with an older version of MySQL, it is worth learning what new features exist and how to use them. This webinar teaches you about new features such as multi-source replication, global transaction IDs (GTIDs), security improvements and more.

We’ll also discuss logical decoding. Logical decoding is one of the features under the BDR implementation, which allows bidirectional streams of data between Postgres instances. Also, it allows you to stream data outside Postgres into many other data systems.

Register for the webinar here.

MySQL 5.7Jervin Real, Technical Services Manager

Jervin is a member of the Technical Services at Percona, where he partners with customers to build reliable and highly-performant MySQL infrastructures, He also does other fun stuff like watching cat videos on the internet, reading bugs for novels and playing around servers for numbers. Jervin joined Percona in April of 2010.
Written by in: MySQL,Zend Developer |
Jul
18
2017
--

Google launches Hire, a new service for helping businesses recruit

 Google today announced the launch of Hire, a new service that helps businesses more effectively manage their internal recruiting process. Hire offers businesses a cohesive applicant tracking service that’s deeply integrated with G Suite to make it easier for businesses to communicate with their candidates and track their progress through the interview process. Earlier this year,… Read More

Jul
18
2017
--

Taavet Hinrikus hands over CEO reins at TransferWise to cofounder Kristo Kaarmann

 A changing of the guard at TransferWise, the unicorn startup based out of London that specialises in providing money-transfer services, typically with better rates than banks and other incumbent providers. The company’s CEO and co-founder Taavet Hinrikus announced that he is stepping down and staying on in a part-time role as chairman and board member. He will be replaced by his… Read More

Jul
18
2017
--

Corelight closes $9.2M Series A to help enterprises battle ransomware

 It’s already been a year of multiple high profile ransomware attacks and now cybersecurity startup Corelight has bagged a $9.2 million Series A round, led by Accel Partners. Read More

Jul
18
2017
--

Privitar raises $16M to help ensure privacy in big data analytics

Data flying over group of laptops to illustrate data integration/sharing. As data protection — a set of laws and practices created across different markets to ensure that our sensitive information does not get leaked or shared without our permission — continues to gain priority in our rapidly expanding digital world, a UK startup called Privitar that is building tools to help organizations keep that data private has picked up $16 million in funding… Read More

Powered by WordPress | Theme: Aeros 2.0 by TheBuckmaker.com