Bitly URL: http://bit.ly/1UrRLGp
Tweet this document:
Follow us on Twitter:
Visit the EMC store:
DBAs and Application Owners Need Scheduling
As a DBA for many years I began to appreciate automation. Like most database administrators I have a toolkit that can be used with CRON (job scheduler) to automate database cloning, reporting, and many other things. One example, is scheduling a database copy during evening. The next morning the DBA team runs post clone steps and we are ready to present the development database to the business by lunch. DBA teams have this down to a science and can consistently clone databases but the challenge is time. One of the most common concerns DBAs have today is accelerating and automating database cloning. The challenge is moving from a process that can take a long time to a predictable fast model that automates the copy process thus offering a big time savings.
XtremIO Snapshot Scheduling
XtremIO saves time by enabling the DBA team to schedule instant snapshots. The XtremIO snapshot scheduler can be used to schedule the instant copy of a database and/or applications. In the case multiple LUNs have to be copied at the same time XtremIO support consistency groups. A consistency group is the logical grouping of LUNs that comprise a database or more complex implementations like enterprise applications. Using consistency groups all the LUNs are instantly
Figure 1 shows the Snapshot Scheduler and all the options the administrator has to schedule database copies. If you have used other scheduling applications then this scheduler will be easy for you to use. We can either create the schedule with a fixed interval or with a definite time as has been demonstrated in figure 1.
Figure 1. Snapshot scheduler
In the above diagram we see different parameters for Snapshot Scheduler like Scheduler state, Scheduler creation intervals and frequencies and lastly the retention policy. The retention policy can be set to hold a specific amount of snapshots prior to deletion or a specific time interval with up to the maximum allowed limit of Snapshots per LUN (512). This must conform to the maximum allowed number of volumes in the
Scenario: Multiple Databases Refreshed Over the Weekend
Many of us understand the necessity of scheduling databases for refresh during Friday evening and having to check the status on Saturday or Sunday morning. As we all know that family time is important and having to check-in on the progress of refreshing a database(s) takes away that time spent with the family.
Using the XtremIO Snapshot Scheduler changes the game. Here’s how:
Using XtremIO it is very fast to schedule the refresh of databases and other applications. I’ve been using the term refresh and it’s important I mention that this as this is a new feature in XtremIO 4.0. You may watch a demo on XtremIO 4.0 snapshots here.
In summary, we derive the following benefits from Snapshot scheduler:-