Find Communities by: Category | Product

facebook_button-30.pngtwitter_button-25.pngemail_button-30.pnglinkedin_button-30.png

 

XtremIO 4.0 has advanced the ease of refreshing databases copies. In XtremIO we call this “refreshing a volume” but I prefer refreshing database copies because of my DBA background. It works like this:

  • DBA team need to refresh an existing copy of production from production
  • DBA dismounts the ASM diskgroups
  • On XtremIO the refresh operation replaces any outdated storage object with an updated version WITHOUT changing the SCSI face (NAA).
  • DBA remounts the ASM diskgroups

It’s that simple and it can be done in seconds! In fact Kevin Closson has a paper coming out that shows this process and more. The image below was created from reading the paper: it took 13 seconds to refresh a copy of production from production with the majority of time spent of mounting the ASM diskgroups and opening the database.

abc1.png

I was part of a good customer discussion with the biggest ecommerce copy in India and we were talking about the need to accelerate database provisioning. There is no value for the DBA and the business in spending time creating database copies. Time spent on database provisioning is time wasted as the DBA could be working on new initiatives, learning new features, performance tuning or just about anything else of greater value. Lengthy provisioning times impact the competitive delivery of services to the business. The future is here and there isn’t the need to waste time on creating database copies.

 

Scenario One: Production Down

This is the worst case scenario and one most DBAs have had the unfortunate experience in resolving. I’ll call upon worst production down my experience as an example. I was consulting for a small company when in the early evening their E-Business database went down. There was no backup of the production database and no means to quickly make a backup. The customer requested I apply a patch recommended by Oracle Support. Talk about being in the hot seat with all the risk and no assurances of a backup or testing of the patch.

Had the business been using XtremIO’s Started X-Brick we could have made a copy of production in seconds without taking any initial capacity (thanks inline deduplication!). The XtremIO Starter X-Brick has 3.74 TB of usable space but thanks to all the included features (at no extra charge) like inline compression and deduplication the logical usable space easily doubles to 7 TB. For DBAs in a production down scenario the ability to create instance copies of production can mean fast analysis without risk. So you might be wondering what happened? We were lucky in that the patch fixed the issue and I spent a long time that evening explaining to the customer why database backups are important.

Some other examples of scenarios in which fast provisioning can transform how DBAs work:

  • Functional disruption
  • Applying untested new patches
  • Reducing upgrade windows
  • Reporting

Lets go through some steps to show how easy it is to refresh copies of databases:

abc2.png

Figure 1 : Conditions for the creation of initial Snapshots

 

abc3.png

 

Figure 1a : Starting Environment for creating XtremIO Snapshot

 

XtremIO Snapshots creation starts by the creation of volumes. If they do not exist then we will have to create them in order to use any snapshot feature. Another creation object is the initiator groups and initiators which are also required to be created to map an XtremIO volume to a host. If a volume is not mapped to a host then there can be no read or write operations. Another optional component is tags. Tagging is used for grouping purpose in order to distinguish one entity from another. After the initial preparation gets completed (as stated above) we can start the create snapshot operation by the GUI as demonstrated in Figure 1a.

Now, let us discuss how snapshot refresh operation takes place. The operation needs to be started from the XtremIO GUI interface as shown in Figure 2.

 

abc4.png

Figure 2 : Snapshot refresh GUI of XtremIO Storage


After creating snapshot to a volume or another snapshot we can select the refresh option as shown in Figure 2. Before this we need to make the volume of the snapshot creation offline just to avoid any corruption. This operation happens instantly and can occur in any of the following combinations:

  1. Production to Snapshot,
  2. Snapshot to Snapshot,
  3. Snapshot to Production.

 

abc5.png

 

Figure 3 : Select Snapshot for refresh operation

 

We can see that it has created a new snapshot as shown in Figure 4(Arrowed Volume).

 

abc6.png

Figure 4 : Creation of a new snapshot for refresh operation

 

It takes a snapshot and performs the refresh operation. Now if we bring the volume online, we will see that we get back all the contents that were there in the original state by using the Refresh Option within the GUI. Here all other options are also possible as mentioned before.

  1. Production to Snapshot,
  2. Snapshot to Snapshot,
  3. Snapshot to Production.

In summary, we get the following benefits by using the XtremIO 4.0 refresh.

  • No change in the SCSI ID (NAA) even after refresh. Hence, remapping or Rescanning on the host is not required. Less complexity in performing refreshes.
  • Resize of Volume is possible and hence better DB fitment after refresh (even after expansion).
  • The refresh time is minimal compared with the traditional oracle refresh
  • Need not to be DB or storage expert to do refreshes. All complexities are taken care internally by the GUI
  • Can perform the DB refresh in the running state. Hence, requires no downtime for DBs.
  • Saves substantial $$ for the organization as we can create space-efficient writable snapshots with practically no change in configuration like SCSI ID (NAA).

 

Follow us on Twitter:


EMCOracle.png

Tweet this document:


Want to learn how to refresh Database snapshots with XtremIO 4.0?

Click here to learn more:

store_open.png

facebook_button-30.pngtwitter_button-25.pngemail_button-30.pnglinkedin_button-30.png

 

facebook_button-30.pngtwitter_button-25.pngemail_button-30.pnglinkedin_button-30.png

Last week, I was in one of the ecommerce customer’s POC , one of the biggest ecommerce companies based in India. I was listening to the Oracle DBA team who express their daily challenges in managing databases. Here are problems expressed by the DBAs team in the meeting :

  1. Traditional database refreshes are taking too long
  2. Database backup windows and recoveries are pretty high.
  3. As the data is growing into Oracle database , performance is hitting rock bottom hence the jobs are taking long time.

The customer asked my opinion on how they could reduce the time and cost in provisioning and backing up their databases. I believe it’s important to listen to customers and learn their challenges before providing any guidance. While all-flash arrays solve many database challenges they aren’t always the best solution for the application requirements. What was most interesting in listening to the customer is how data growth was lengthening all aspects of operational management.

 

When the customer first started creating database copies they were fast as the databases were small. Same was true with the time to back-up the databases. However over time data growth started lengthening most all the operational tasks. Now the DBA team was at a critical point in which their Service Level Agreements (SLA) were going to slip because their traditional storage infrastructure couldn’t meet the demands of the larger databases. As a long time DBA, I understand the importance of creating copies of databases. Frequently, we would start the copy process in the evening with the goal of having it completed by the following morning. Array snapshots improved our copy process by reducing the initial cloning time down to minutes. Both the old school copies and array snapshots were the same in respect to capacity planning. The DBA team had to work closely with all owners (application owners and storage administrators) to define if the resources were available to support the refresh or add another copy of the production database. Strong collaboration between teams was critical to operational management and setting expectations with the business. Even so it sometimes took weeks to provision a database application.

 

This customer was looking for new transformational approach to provisioning databases. We talked about how XtremIO 4.0 is a leader in provisioning copies of databases and everything else. There are two key features of great value to DBA teams:

 

  • Inline always on compression: As data flows into XtremIO it is automatically compressed (after it’s been deduplicated). On average Oracle customers experience 2X compression which means a 10TB database compresses down to 5TB.
  • Inline always on deduplication: In terms of creating database copies this feature is huge. In XtremIO the initial database copy takes no space thanks to inline deduplication and is maintained as metadata. As you might have guessed because no data is written the copy creation is instantaneous regardless of the size of the database or number of copies the DBA team creates.

 

In a paper that is coming out shortly we show creating a copy of a production database and opening the copy only took 13 seconds with the majority of time devoted the steps required to open the database copy. The copy created initially took no additional space on the array. When unique data is written to a database copy additional storage capacity is used but in the majority of cases is a very small fraction of production. The customer was very interested in XtremIO’s copy functionality because it solved all three challenges:

  • Time to create database copies
  • Time to create a database copy for backup
  • Data growth impacting database performance

 

In this blog I’m going to talk about database provisioning but if you are interested in how all-flash solves database performance challenges please read  this blog (by using XtremIO storage with Vblock). One of the DBAs with storage experience asked a very good question, “Does XtremIO create a crash consistent copy of database if multiple LUNs are used for data, redo logs, etc.” An excellent question by the DBA! XtremIO uses consistency groups to enable the DBA team to create a copy of all the LUNs used by the database. This means creating a copy of a database using multiple LUNs is very easy (takes just a few clicks). Below are the steps used to create database copies using XtremIO. On a side note you read below two terms I use interchangeably: snapshots (storage name) and copies (non-storage name). I prefer using the term database copies as it’s more universal.

 

Here is a screen capture of the XtremIO management console:

abc1.png

Figure 1 : Conditions for the creation of initial Snapshots

 

abc2.png

Figure 1a : Starting Environment for creating XtremIO Snapshot

 

As you can see it is a simple click to drop the menu down and create a snapshot. XtremIO offers two choices for greater flexibility to the DBA: Ready-only or writable copy (snapshot) of the database. Many XtremIO customers provision directly from production using writable snapshots because there is no performance tax.  The point is the DBA has choice:

  • Create read-only snapshots (as demonstrated in Figure 2)
  • Create writeable snapshots
  • Create read-only snapshots from which to provision writeable snapshots
  • Create writeable snapshots from which to provision more writeable snapshots

 

abc3.png

Figure 2 : Process for creating Read Only Snapshot

 

Snapshots can be used for physical database restores. For example, in Figure 3 we see the option to restore from snapshot. This option to restore from snapshot applies to read-only copies.

abc4.png

Figure 3 : Restore from Read-only Snapshots

 

If you plan on using database copies as part of your protection plan then we recommend placing the database in hot-backup mode for creating a consistent database copy. Remember XtremIO snapshots are instantaneous so placing the database in hot backup mode should only last a matter of seconds. Figure 4 is a bit blurry but shows the ease of restoring a snapshot. In this particular case we are restoring from a read-only copy because we didn’t want our database inadvertently altered as it was part of our protection plan.

abc5.png

Figure 4: Selection of the Snapshot to be restored

 

You can restore over production or create another copy. Below we show creating a new copy.

 

abc6.png

Figure 5 : Snapshot created for Restore

 

Now if we bring the volume online, we will see that we will be able to see all the contents that were there in the original state by using the Restore Option within the XtremIO GUI. Here No rescanning is required as there is no change in the SCSI ID (NAA).

 

In summary, we get the following benefits by using the XtremIO 4.0 restore feature.

  • Provides immediate Recover Time Objective (RTO).
  • Very simple to operate with few clicks. Need not to be DB or storage expert to do refreshes. All complexities are taken care internally by the GUI
  • No change in the SCSI ID (NAA) even after restore. Hence, remapping or Rescanning on the host is not required. Less complexity in performing refreshes.
  • Enables recovery of data from read-only snapshots.
  • The restore time is minimal compared with the traditional oracle restores.
  • Allow restore from snapshots that are direct decedent.
  • Can perform the DB restores in the running state. Hence, requires no downtime for DBs.
  • Saves substantial $$ for the organization as we can create space-efficient writable snapshots with practically no change in configuration like SCSI ID (NAA).

 

Follow us on Twitter:


EMCOracle.png

Tweet this document:


Want to know how to restore database snapshots with XtremIO 4.0?

Click here to learn more:

store_open.png

facebook_button-30.pngtwitter_button-25.pngemail_button-30.pnglinkedin_button-30.png

 

 

facebook_button-30.png

twitter_button-25.png

email_button-30.png

linkedin_button-30.png

 


EMC Storage Plug-in for OEM 12c - Part IV


EMC VNX Block & File Platforms




The EMC Storage Plug-in for OEM 12c consists of several components that work together to collect configuration and performance data from both database servers and EMC storage systems.  The plug-in collects metrics from EMC storage systems in different ways based on the optimum connection method.

 

For VNX Block arrays, Figure 1 shows the direct connection created by the plug-in to the VNX Block storage processor. The connection to the array's storage processor is made through Navisphere Secure Command Line Interface (NaviSecCLI) to collect array level metrics. One VNX Block storage target is used for each VNX Block array.

 

Figure 1  VNX Block metric collection architecture


 

Figure 2 shows how the VNX File storage target collects data from the VNX File storage control station. Using the Secure Shell (SSH) protocol, the plug-in connects to and collects array level metrics from the control station administrating the VNX File that is being monitored. One VNX File storage target is used for each VNX File array.

Figure 2  VNX File metric collection architecture


The EMC Storage Home target includes a Home page and a Configuration page. The EMC Home page contains a few features, as shown in Figure 3.

 

Figure 3 EMC Home page

 

  • In the Storage pane (1), use the menus above the graphs to select a metric to display in the graphs. Select a time period of Last Day, Last Week, or Last Month.
  • In the Database Storage pane, select a target row to display metrics in the graphs.
  • Multiple database storage targets can be graphed simultaneously.
            In the Graph column (2), select the checkbox to display graph details in the Storage pane.                          

            In the Database column (3), click the link to go to the Oracle database target.                          

            In the Storage column (4), click the link to go to the EMC database storage target.

  • In the Array pane, in the Storage Array column (5), click the link to go to the storage target.

 

The EMC Database Storage page displays information about the Oracle database and the storage used by the database. The page includes a few panes and features such as the hierarchy pane, the storage pane, the database pane, the incidents and problems pane, as shown in Figure 4.

 

Figure 4  EMC Database Storage page

 

  • The Hierarchy (1) pane displays the technology stack that is running the database. Click an image or link to go to the corresponding target.
  • In the Storage pane (2), use the menus above the graphs to select a metric to display in the graphs. Select a time period of Last Day, Last Week, or Last Month.
  • The Database pane (3) shows corresponding performance information obtained from the standard Oracle database plug-in. This information is used for comparison to the storage metrics in the Storage pane.
  • The Incidents and Problems (4) pane lists incidents for the Database Storage target, which are also forwarded to the corresponding Oracle Database target.

The EMC VNX Block Storage page, as shown in Figure 5, displays information about VNX Block arrays. You can view detailed information on the VNX Block array and drill down into secondary pages for information on specific components.

  • In the Storage Processors pane (1), select a time period of Last Day, Last Week, or Last Month.
  • The Storage Processors pane (2) shows detailed graphs on the performance of the storage processors associated with this VNX Block. Hover over the graphs to see detailed data points.
  • In the Storage Pools pane (3), Click a Storage Pool Name link to go to the corresponding Storage Pools page.

 

Figure 5 EMC VNX Block Storage page

 

The EMC VNX File Storage page, as shown in Figure 6, displays information about VNX File arrays. You can view detailed information on the VNX File array and drill down into secondary pages for information on specific components.

  • In the Data Movers pane (1), Click a Data Mover Name link to go to the corresponding Data Mover page.
  • In the File Systems pane (2), Click a File System link to go to the corresponding File System page.
  • In the Storage Pools pane (3), Click a Storage Pool Name link to go to the corresponding Storage Pool page.

 

 

Figure 6 EMC VMAX Storage page


Free download and installation guide

You can find the free download and the installation guide at:

EMC Storage Plug-in for Oracle Enterprise Manager 12c

EMC Storage Plug-in for Oracle Enterprise Manager 12c Product Guide

EMC Storage Plug-in for Oracle Enterprise Manager 12c Release Notes


Other contents

EMC Storage Plug-in for OEM 12c Product Presentation

Video: EMC Storage Plug-in for Oracle Enterprise Manager (OEM) 12c: Configuration

Video: EMC Storage Plug-in for Oracle Enterprise Manager (OEM) 12c: Architecture and Installation

Video: EMC Storage Plug-in for Oracle Enterprise Manager (OEM) 12c: VNX and XtremIO Support

Video: EMC Storage Plug-in for Oracle Enterprise Manager (OEM) 12c: Features and Benefits for XtremIO




Follow us on Twitter:
EMCOracle.png

Tweet this document:



Click here to learn more:

store_open.png

 

facebook_button-30.pngtwitter_button-25.pngemail_button-30.pnglinkedin_button-30.png


 

facebook_button-30.png

twitter_button-25.png

email_button-30.png

linkedin_button-30.png

 


EMC Storage Plug-in for OEM 12c - Part III


EMC VMAX High End Platform




The EMC Storage Plug-in for OEM 12c consists of several components that work together to collect configuration and performance data from both database servers and EMC storage systems.  The plug-in collects metrics from EMC storage systems in different ways based on the optimum connection method.

 

For collecting VMAX-specific metrics, this plug-in collects storage metrics from apreviously configured Unisphere for VMAX (U4V) installation, as shown in Figure 1.  Unisphere for VMAX provides a REST API that the plug-in uses to obtain performance andconfiguration metrics about the VMAX storage systems configured in U4V. The plug-in also uses EMC Solutions Enabler to issue a limited set of SYMCLI commands associated with metric collection from a VMAX array.

 

 

 

 

 

Figure 1  VMAX metric collection architecture

 

 

The EMC Storage Home target includes a Home page and a Configuration page. The EMC Home page contains a few features, as shown in Figure 2.

 

Figure 2 EMC Home page

 

  • In the Storage pane (1), use the menus above the graphs to select a metric to display in the graphs. Select a time period of Last Day, Last Week, or Last Month.
  • In the Database Storage pane, select a target row to display metrics in the graphs.
  • Multiple database storage targets can be graphed simultaneously.
            In the Graph column (2), select the checkbox to display graph details in the Storage pane.                               In the Database column (3), click the link to go to the Oracle database target.                               In the Storage column (4), click the link to go to the EMC database storage target.
  • In the Array pane, in the Storage Array column (5), click the link to go to the storage target.

The EMC Database Storage page displays information about the Oracle database and the storage used by the database. The page includes a few panes and features such as the hierarchy pane, the storage pane, the database pane, the incidents and problems pane, as shown in Figure 3.

 

Figure 3  EMC Database Storage page

 

  • The Hierarchy (1) pane displays the technology stack that is running the database. Click an image or link to go to the corresponding target.
  • In the Storage pane (2), use the menus above the graphs to select a metric to display in the graphs. Select a time period of Last Day, Last Week, or Last Month.
  • The Database pane (3) shows corresponding performance information obtained from the standard Oracle database plug-in. This information is used for comparison to the storage metrics in the Storage pane.
  • The Incidents and Problems (4) pane lists incidents for the Database Storage target, which are also forwarded to the corresponding Oracle Database target.

The EMC VMAX Storage page, as shown in Figure 4, displays information about VMAX arrays. You can view detailed information on individual VMAX arrays and drill down into secondary pages for information on specific components.

 

 

Figure 4 EMC VMAX Storage page

From the VMAX Array list box (1), select a VMAX array to display array details in the graphs in the Array pane.

  • In the Array pane, select a time period of Last Day, Last Week, or Last Month.
  • In the Front End Directors pane (2), click a Director link to go to the Front End Directors page.
  • In the Thin Pools pane (3), Click a Thin Pool link to go to the Thin Pools page.


Free download and installation guide

You can find the free download and the installation guide at:

EMC Storage Plug-in for Oracle Enterprise Manager 12c

EMC Storage Plug-in for Oracle Enterprise Manager 12c Product Guide

EMC Storage Plug-in for Oracle Enterprise Manager 12c Release Notes


Other contents

EMC Storage Plug-in for OEM 12c Product Presentation

Video: EMC Storage Plug-in for Oracle Enterprise Manager (OEM) 12c: Configuration

Video: EMC Storage Plug-in for Oracle Enterprise Manager (OEM) 12c: Architecture and Installation

Video: EMC Storage Plug-in for Oracle Enterprise Manager (OEM) 12c: VNX and XtremIO Support

Video: EMC Storage Plug-in for Oracle Enterprise Manager (OEM) 12c: Features and Benefits for XtremIO




Follow us on Twitter:
EMCOracle.png

Tweet this document:



Click here to learn more:

store_open.png

 

facebook_button-30.pngtwitter_button-25.pngemail_button-30.pnglinkedin_button-30.png


Indranil

MongoDB on XtremIO

Posted by Indranil Sep 18, 2015

facebook_button-30.pngtwitter_button-25.pngemail_button-30.pnglinkedin_button-30.png

In present environment, broadly, there are five types of database that are being used more frequently. They are traditional, NoSQL, In-memory, Hadoop and columnar databases. There are others as well like Virtualized or federated Database, streaming databases etc. From EMC’s perspective, the good news is that we have solutions to the 5 top variants as mentioned before. In this blog, I am going to discuss about the NoSQL databases which act ,sometimes, as a complimentary entity for traditional databases like Oracle. NoSQL Databases can manage the exponential increase in the volume of data, objects, and products and also the frequencies at which these components are accessed coupled with high performance, scalability and accessibility. NoSQL databases like MongoDB can handle the following issues with greater efficiency compared to the traditional databases.

 

  • Large volumes of structured, semi-structured, and unstructured data
  • Agile sprints, quick iteration, and frequent code pushes
  • Object-oriented programming that is easy to use and flexible
  • Efficient, scale-out architecture instead of expensive, monolithic architecture

 

Under present circumstances, we are very fortunate to learn that EMC has a solution around Mongo DB and XtremIO storage which is ranked No. 1 in All Flash Array segment. Initially, Mongo DB was running on DAS(Direct Attached Storage), but to avoid risks and costs to the organizations and to gain better performance and scalability , MongoDB has proved to be much more beneficial when used with XtremIO. By using this solution we get the following benefits:-

 

  • Consistent Performance with < ms latencies
  • On-Demand ,Scale-out performance and capacity
  • Substantial reduction in storage required for databases
  • Create database clones in minutes without disruption
  • High availability & security across database infrastructure.
  • Free Data at rest encryption
  • Cost Effective Inline Data Reduction
  • Agile Snapshot services
  • Advanced Data Protection and high Availability.

 

Let us now do a deep dive into the solution (of MongoDB with XtremIO) with the help of Figure 1, 2 & 3.

abc1.png

Figure 1 : Hardware Configuration of MongoDB with XtremIO storage

 

abc2.png

Figure 2 : Server Configuration


abc3.png

Figure 3 ; Software Configuration

 

In the solution, the above components help in accelerating the scalability factor and performance that can be taken to multiple nodes with the linear increase in IOPS bandwidth and capacity coupled with sub-millisecond latency as is demonstrated in Figure 4 below.

abc8.png

abc4.pngabc5.png

 

Figure 4: MongoDB and XtremIO IOPS and Latency

 

 

 

The above figure demonstrates that under no circumstances the performance of the MongoDB databases will degrade as the above solution is maintaining the sub-milli-second latency throughout the life of the databases. The solution has also achieved an overall capacity efficiency of 22:1(as demonstrated in Figure 5 below). Also we see in Figure 5 that out of 27.083 TB of used capacity, XtremIO has only consumed 3.98TB of physical capacity. We can also see that 7x storage capacity requirements got reduced with XtremIO features like inline deduplication & compression. It is needless to say that more we save on capacity and storage , the more we save on our company's IT expenditure and budget.

abc6.png

Figure 5: Data Reduction Ratio and other Efficiency parameters of XtremIO with MongoDB.

 

MongoDB with XtremIO helps not only the DBAs and storage administrators in terms of storage reduction and performance but also enhances the productivity and turnover of developers by utilizing XtremIO’s snapshot services, in-build advance agile processes and full-performance snapshots. Also, different MongoDB environments like test/dev/SIT and production can be consolidated under one umbrella --> XtremIO Storage. XtremIO’s snapshot services help to refresh production environments with parallel environments, thereby generating speed for copies and maintaining SLAs. Lastly, MongoDB workload snapshot consolidation with the aid of XtremIO improves TCO and accelerate MongoDB workflows. The snapshot operation is basically done via XtremIO GUI as shown in Figure 6.

abc7.png

 

 

Figure 6 : GUI of snapshot copy of Mongo DB in XtremIO Storage

 

I have to stop here and leave out some more good features of this solution in the interest of brevity of the blog. In summary, we can derive the following benefits from MongoDB on the top of XtremIO Infrastructure:-

 

  1. Scaled-out platform with enhanced performance, capacity planning and availability. Here all the attributes are achieved by MongoDB with the help of XtremIO storage.
  2. Higher Consolidation (both prod and non-prod) and faster deployment of non-prod from prod MongoDB environments and workflows.
  3. Space savings which results in cost reduction of XtremIO’s storage by its amazing features like inline deduplication, compression, snapshot services etc.
  4. Beneficial for DBAs, developers and administrators as this solution brings down infrastructure complexity with greater simplicity in their daily work activities.

 

Follow us on Twitter:


EMCOracle.png

Tweet this document:


Want to know how MongoDB runs on XtremIO ?

Click here to learn more:

store_open.png

facebook_button-30.pngtwitter_button-25.pngemail_button-30.pnglinkedin_button-30.png

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

Keynotes from Pat Gelsinger, CEO of VMware

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

VMware EUC for Windows 10

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

Bitly URL: http://bit.ly/1UrRLGp

 

Tweet this document:

Scheduling Snapshots using XtremIO 4.0

 

Follow us on Twitter:

EMCOracle.jpeg.jpg

 

 

Visit the EMC store:

store_open-218x245.png

Click here to learn more about EMC’s Solutions for Oracle

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
copied in a write consistent manner for the DBA team. To create a snapshot is
easy:

 

  • Start the XtremIO Create Snapshot Scheduler
  • Verify the time zone is correct
  • Define the parameters for scheduling a snapshot

 

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.

 

aa.png

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
array (8192). When either condition is true the scheduler will start to delete snapshots it generates according to the variables that were defined.

 

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:

 

  • Schedule the databases to be refreshed (copied) Friday at 3:00 pm
  • DBA team verifies the copies are complete by Friday at 3:00:30 pm (30 seconds later)
  • The post clone steps which have been automated start at 3:01 pm
  • All the development databases have been refreshed and are ready for business Monday morning

 

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.

 

Summary

 

In summary, we derive the following benefits from Snapshot scheduler:-

 

  • Very concise tool that helps in scheduling the snapshots in a shorter and in a much longer intervals.
    • Auto-creation of snapshots based on users choice :
      • Creates definition of Snapshot jobs with different aspects like creation, deletion, suspension, modify etc.
      • Each job can defined with respect to the time
        zones.

 

  • Snapshot scheduling is executed with the following scheduling parameters :-
    • Exact time of Occurrence.
    • Interval/Frequencie.
  • Helps in purging the snapshots automatically. Retention policy for the preservation of snapshots is based on age or number.
    • Supports: Consistent Groups, Snapshots Sets, or a Volum
  • Automates which volume to choose and take snapshots accordingly.
  • Optimized for maximum flash endurance.
  • No performance impact when snapshots are created. There is equal performance with snapshots and volumes.
  • Lastly, it can create snapshot without our intervention and thereby we get an option to restore most current copies of databases.

Over 23,000 attendees

 

 

 

Ready for Any

 

Hybrid Cloud

 

 

SDDC

 

 

vCloud Air Public Cloud Service

 

 

Simplify, Extend and Reach

 

 

EVO SDDC

 

 

 

 

 

 

 

Unified Hybrid Cloud

 

 

 

 

 

Photon Platform

 

 

 

 

 

VMware for Direct TV

Filter Blog

By date:
By tag: