Welcome to this demonstration of Dell EMC AppSync and Power Store. There are numerous ways they can integrate, and today we will showcase a few of them. AppSync is a software that enables integrated copy data management with Dell EMC primary storage systems. AppSync simplifies and automates the process of generating and consuming copies of production data. It is able to orchestrate all of the activities required from copy creation and validation through mounting at the target host and launching or recovering the application.
This video will show how AppSync integrates with Dell EMC Power Store, VMware, and Microsoft SQL. First we will go over the Power Store X configuration. Next, the production SQL Server configuration. Then we will discuss the absent configuration and we'll run a power store remote silver service plan. Lastly, we will show how the remote power store T configuration looks and how to unmount a copy. If we navigate to the Power Store X GUI, we see the dashboard by default. If we click on the storage button in volume groups, you can see that we have a SQL volume group created that has 10 gigabytes of provision storage as well as 2 volumes or members created within it.
We click into the SQL volume group and look at the members, you can see that we have two luns associated with this volume group SQL data and SQL logs. They're each 5 gigabytes, and they each have one host mapping. If we click on the host mappings, you can see that this volume is mapped to a Windows host via the ISUI protocol. If we go back to the volumes, you can click on the other volume mapping. You can see that it is also mapped to the same Windows hosts via iScuzzi. If we navigate back to volume groups and click within it. And look at the protection. Click on the replication tab.
You will notice that we have replication configured between two power store arrays. The one on the left is an X and the one on the right is a T, and currently this volume group is involved in the replication. Since this is a Power Store X, we have embedded ESXI hypervisors running within the appliance. If we click on compute and vCenter Server connection and then launch vSphere. And launch vSphere Client were directly brought into the VMware vSphere client. Here you can see that we have 2 ESXI servers running, as well as an AppSync Windows VM running and a SQL server for ASync copy management. Additionally, there are 2 Power Store VMs running the Power Store software. Running virtual machines or VMs within the power store is known as apps on functionality. If we navigate back to the Power Store XGUI and click on compute again and look at the virtual Machines tab, you can see here we also show the virtual machines running within the Power Store X. Next we will navigate to the Microsoft SQL Server host that will be used for copy management with AppSync.
Here's the Microsoft SQL Server, and you can see that there is an AppSync Power Store DB1 database created within Microsoft SQL Server, and this is comprised of the E and F drives coming from the Power Store appliance. The Erive has the database data files. And the Five has the database log files. We also have another instance of SQL running on this host called AppSync Instance where we will mount a copy taken within AppSync to this same server in a different instance. Next we will navigate to the apps GUI. Here we start out on the dashboard. If we navigate to copy management. And then select Vie service plan and select our application, which in this case is Microsoft SQL Server. We see that we have all of the service plans that come out of the box bronze, silver, and gold and we also have a couple of service plans created for power storage sequel.
So we have a bronze one and a silver one. Today we will be focusing on the silver plan, which is a remote service plan, meaning that we can take a copy from one power store appliance and replicate it over to the secondary remote power store appliance. So in this case we're going from a power store X to a power store T as we showed in the power store GUI. If we edit the service plan, You can see that we gave it a name Powerto Silver SQL Service plan. The service plan is enabled. It's set up to do remote copies since this is a remote service plan. We've also configured it to mount the copy. Once we take the SQL copy, we'll actually mount it to another instance. And we're keeping 7 copies. If we go to next, we'll also see that the SQL server backup type is set to fall. And our copy priority is set to snapshot. On the mount settings we've set AppSync to do a mount and recover.
So in this case we're going to take the copy of the SQL server database and then we're going to mount it up to the AppSync instance that I showed earlier in this video, and then we're going to recover it and we're going to append a different suffix called AppSync in front of the database name. And then if we go next. We don't have any scripts configured for this service plan, so we'll go on to the next part of the wizard, and the last step we're just going to say that we want to run the service plan on demand and not set it to be on a regular schedule. If we wanted it to run at a certain time every day, you would just select schedule and pick your frequency. So we'll just leave it on demand. Click next and finish. You can also see that we've subscribed the service plan to our AppSync Power Store database. So when we run the service plan, it's going to run against this database. So the next step is to run the service plan, so I'll click run. And then here we'll go through all of the different statuses of the service plan running. You can expand out the details and see all the different steps that we're going to go through.
So now we can see that the recovery of the copy completed successfully. We scroll down here, we see that the running database recovery on mounted application finished. So now we can close out. And if we look at the copies in ASync, go under Microsoft SQL Server. Click on our SQL instance in our specific ASync powerto DB1. We can see now that we have a copy that is mounted. So now if we go over to our SQL server, now on the instance that we mounted to. We need to refresh. If we expand the databases, we can see that AppSync automatically mounted the database copy to this other instance that happens to be on the same host. We still have our original production volumes. And if we look at A sync mounts directory, we can see that we have the the mounted copy here. If we now navigate to the remote powerto T GUI. And go into host groups. And select our SQL server. And click on mapped volumes, you will see that AppSync has taken the snap and created a thin clone from it in order to map and mount.
The luns and file systems through to the SQL server allowing us to mount to the other SQL instance as shown earlier. Now if we want to come back to ASync and unmount the copy. Simply select the copy and hit on mount. And hit OK. And we'll see the unmapped copy status. We can expand out the details. Now the unmount of the copy has completed successfully. We can minimize the window, and now if we go back to our SQL host, you can see that the mount point. Has been removed and if we refresh. Our mount instance, you can see that the database is no longer mounted, so this completes the service plan run and the mounting and unmounting automatically through ASync. Thanks very much for watching today's demonstration of Dell EMC AppSync and Power Store integration. Please visit the links below for more technical documentation and videos.
