August 31, 2019 Vignesh Sathiyanantham

In recent posts, we have discussed adding your AWS account to Nimesa to do the data protection. In this post, we will discuss application-consistent backups of your MySQL on EC2 instance. To know to install MySQL Server on Amazon Linux 2 on AWS Cloud click here Read here more about consistent, app-consistent, crash-consistent backup Nimesa supports pre and post script hooks to perform the specific operation before or after a backup, example if your Instance is running Oracle and you want to enable hot backup mode before performing backup you can write the script and upload to pre-script There is…

August 27, 2019 Vignesh Sathiyanantham

In my previous post, we discussed the creation of IAM user and the privilege required to protect your AWS EC2 instances. In this post, we will discuss to register the AWS account with Nimesa. Open the Nimesa web console ( refer this post for the Installation of Nimesa in your AWS account ), and log in with the credential. Then Go to “Configuration settings” > “manage platforms” In the manage platform, click on Add platform Enter the unique friendly account nameAccess Key of the IAM userSecret key Nimesa will validate the credentials, and save it in MySQL database after encrypting…

August 21, 2019 Vignesh Sathiyanantham

In the recent posts, I shared about taking backup and restore of database and also discussed some of the issues I have seen in the customer environment and how I fixed those in Nimesa Software Nimesa uses cloud-native / storage native snapshot technology to provide the backup, backup copy to DR site, restore on primary, restore on secondary, power and cost management everything in a single Software suite for both public cloud and the private cloud. Currently, Nimesa is available as a community AMI in the Amazon marketplace. The AWS Marketplace is a curated digital catalog that makes it easy…

August 21, 2019 Vignesh Sathiyanantham

Recovery Point Objective (RPO) and Recovery Time Objective (RTO) are two of the most important parameters of the disaster recovery (DR) or data protection planning. These are the objectives/decision points for choosing the optimal backup software. Recovery Point Objective (RPO) Recovery Point Objective (RPO) describes up to what point in time could the business-critical data can be recovered in other words the last point where the data is in a usable format If you back up all or most of your data in regularly scheduled 24-hour increments, then in the worst-case scenario you will lose 24 hours’ worth of data….

August 21, 2019 Vignesh Sathiyanantham

Who uses MongoDB? Based on the online resource* there are 37,658 Companies using MongoDB, MongoDB is most often used by companies with 10-50 employees and 1M-10M dollars in revenue, and the market share is about 5.0% and also many financial services using the MongoDB Data is always critical whether its RDBMS or NoSQL or Flat files AWS EBS Volume Snapshot is block-level incremental snapshots, which is one of the best and efficient way to protect the Data in the EC2 environment, you might have read lots of posts, whitepapers about advantages of using the snapshot technology. But the Snapshots of…

August 18, 2019 Vignesh Sathiyanantham

In my previous blog, I discussed how to set up the ZFS File system in Ubuntu 18.04 and setup ZVOL for Microsoft SQL Server Databases In this post let’s discuss on how to set up the Disaster recovery plan for the Microsoft SQL Database with the ZFS replication, For that, I set up the Ubuntu 18.04 Instance in us-east-1 in availability zone us-east-1c , and ssh into the instance using the pem file Then I followed my post on ZVOL for MS SQL Database to install the ZFS on the AWS Linux Instance And then with the new volume, I…

August 18, 2019 Vignesh Sathiyanantham

When I am setting up the Disaster recovery plan for the MS SQL Databases in ZFS Volume, I faced permission issue while running ZFS send/receive command from a non-root account root@vigneshzfs:/home/vignesh# sudo zfs send sql-pool/disk1@aug18 | ssh ubuntu@10.7.8.25 zfs recv aws-pool/sql-pool-aug18 ubuntu@10.7.8.25’s password: cannot receive new filesystem stream: permission denied So my sender is vignesh and the receiver is ubuntu both are a non-root account On the sender side, I used these permissions sudo zfs allow -u vignesh send,snapshot,hold sql-pool And on the receiver side sudo zfs allow -u ubuntu compression,mountpoint,create,mount,receive aws-pool After setting up this permission I can send…

May 2, 2019 Vignesh Sathiyanantham

Failure rate depends more on the number of disk blocks modified since the last snapshot of the EBS volume than the total size of the volume. EBS has a listed failure rate of 0.1% – 0.4% annually, compared to a commodity disk’s rate of 4%. At first glance, this appears to be great, but this is somewhat misleading as any real production setup will use some sort of RAID. Using a RAID 1 with two drives failing at 4% would give a failure rate of 0.16% annually, which appears to be line with EBS. As long as the failed drive…

April 12, 2019 Vignesh Sathiyanantham

To do some testing of the on going release of Nimesa which do the application aware ( AppAware ) Backup of Microsoft SQL Server Cluster on SQL 2016 i created a small powershell scripts which create ( actually restores ) the databases from Adventure Works backup file Change the total and volume drive letter in the below code and run it. If you want to have Data files (.mdf ) and Log Files (.ldf) in the same volume, set the volume1 and volume2 with same value If you want to create data and log files on different volume, set different…

April 10, 2019 Vignesh Sathiyanantham

PS C:\WINDOWS\system32> Set-ExecutionPolicy RemoteSigned PS C:\WINDOWS\system32> Set-PowerCLIConfiguration -InvalidCertificateAction Ignore PS C:\WINDOWS\system32> Connect-VIServer -Server servername Get-VM -name vignesh-VM-1 | Get-AdvancedSetting -Name ‘disk.EnableUUID’ If that command returns no result or the value is false, you won’t see the disk serial number inside your OS. To Enable to DISK UUID, Refer this blog disk-serial-number-is-not-set-for-windows-server-2016-on-vmware-vsphere/