MySQL Backup | Easy Way To Find Login Details for ZRM on AWS S3 Backup

MySQL Backup | How To Find Login Details for ZRM on AWS

Are you tired of following complicated procedures to complete simple tasks? We at Zmanda understand your dilemma all too well.  MySQL Backup: ZRM for MySQL simplifies the life of a database administrator in using AWS S3 backup. It offers an easy-to-use yet flexible and robust backup and recovery solution for MySQL servers. It complements the capabilities of AWS S3 backup software including resources like Amazon S3 bucket.

Amazon Storage Gateway provides a storage gateway to the Amazon S3 Cloud by asynchronously replicating the volume in the data center to an Amazon Elastic Block Storage (EBS) volume in the cloud. In addition, you can achieve point in time restores of AWS S3 backup bucket.  Amazon Storage Gateway can be used to replicate the ZRM configuration and ZRM for MySQL backup images from the storage volume in the data center to the AWS backup S3 cloud. The MySQL database restores can be performed from the backup data stored in the local data center for quick recovery of databases.

Watch the Step by Step Video Here

youtube-video-thumbnail

ZRM MySQL Backups and Amazon Storage Gateway for AWS S3 Backup

In case of catastrophic data center failures, the ZRM server configuration and backup data can be recovered either to a physical or virtual machine in the local data center or to Amazon EC2 virtual machine in the cloud. After ZRM server recovery, all MySQL databases can be restored and brought online.

How to Find the Login Details for ZRM (MySQL Backup) on AWS?

Let’s have a look at the steps:

  1. Login to AWS Console.
  2. Click on the EC2 Service- Compute.
  3. Click on instances on the Navbar–> Click on Launch instance.

Launch instance for implementing AWS S3 backup | Zmanda

4. Type ZRM in the search bar and press enter.

Choosing an Amazon Machine Image (AMI) for AWS S3 backup | Zmanda 5. Click on Zmanda Recovery Manager (ZRM) in AWS Marketplace.
6. Click Select.
7. Click Continue.

Usage instructions for ZRM in implementing AWS S3 backup | Zmanda
8. Select instance type, the default one is t2.medium.
9. Set to default VPC.
10. Click to Add Storage,  the default storage is 30GB.

Add Storage step in implementing AWS S3 backup | Zmanda
  11. Click Add Tags provide a valid key-value pair.

Add Tags step in implementing AWS S3 backup | Zmanda
12. Configure security group defaults with Type/Port values as ssh/22,http/80, and https/443.

Configure Security Group step in implementing AWS S3 backup | Zmanda
13. Click Review and Launch.

Review Instance Launch step in implementing AWS S3 backup | Zmanda
14. Create new key-pair or choose an existing key-pair with your private key.
15. Click Launch instances.

Note: Allow the instances to be launched and all status checks to be green. Depending on your location it may take up to 2 minutes.

16. Click on EC2 dashboard.
17. Click on the ZRM server that was launched previously

Note: The Public DNS (IPV4 IP address)

18. Launch the IP address in a new browser tab. It will redirect to a security page (With the message ‘Your connection is not private’ displayed prominently)-> Click on Advanced-> Click on Proceed (IP will be displayed along with ‘Proceed’).

Note: This will open the Zmanda Recovery Management Console web UI.

Zmanda Recovery Management Console web UI for AWS S3 backup| Zmanda

19. Open a command terminal on your Windows or Unix box.

20. ssh into the Zmanda server that was launched.

example:

ssh -i “zmanda.pem” [email protected]

Note: This should log you into the instance we just created.

21. vi /tmp/ MySQL ZRMpassword.txt

MySQL ZRM password.txt for implementing AWS S3 backup | Zmanda

22. Copy password from this file.

23. Use the credentials default Username as ‘admin’ and the text you just retrieved from step 22 as password for login. Log into ZRM in AWS.

What Are The Other Features of ZRM for MySQL?

  • Customize your backup schedules with both full and incremental backups of your MySQL database as needed.
  • Start immediate backup or postpone scheduled backups based on thresholds defined by you.
  • Experience convenience with the flexibility of logical or faster raw backups of your database.
  • Perform backups that is the best match for your storage engine and your MySQL configuration.

AWS S3 backup of MySQL database via firewall | Zmanda

  • Backup your remote MySQL database through a firewall.
  • Configure on-the-fly compression and/or encryption of your MySQL backups to meet your storage and security needs.
  • Get e-mail notification of the status of your backups and receive MySQL backup reports via RSS feed. Never miss important updates ever again.
  • Monitor and browse your backups.
  • Define retention policies and automatically delete backups that have expired. Let automation make your life easy.
  • Recover a database easily to any point in time or to any particular transaction, e.g. just before a user made an error.
  • Parse binary logs to search and filter MySQL logs for operational and security reasons.

Snapshot support for multiple platforms in AWS S3 Backup | Zmanda

  • Snapshot live MySQL with Linux LVM, Windows VSS, Solaris ZFS, NetApp SnapManager, and Veritas VxFS to minimize locking on the database. This allows you to backup mission-critical MySQL production environments without interrupting online data access.
  • Globally manage backup and recovery of hundreds of MySQL databases via a single web-based Zmanda Management Console.

To learn more about ZRM and to see a comprehensive quick start guide click here.

Conclusion

Please follow the above steps to find Login Details for ZRM (MySQL Backup) on AWS S3 backup. In case you get stuck in the process of backup to AWS S3, kindly contact our team.

You can reach us @ [email protected] or call us @ 888-496-2632 (U.S.)/ 408-732-3208 (INTL) to learn more about amazon s3 glacier.

 

Also, be sure to check out Rutgers Case Study: How the University Saved Tens of Thousands of Dollars


Explore More Topics