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 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

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…

May 2, 2019 Vignesh Sathiyanantham

Creating a full backup in the SQL server using SSMS is very simple, but if you have 10’s of databases you find bit difficult to backup all databases in one go. So i write a small Powershell script which gets the list of databases and takes the backup except the system databases https://gist.github.com/asvignesh/9c2f275c9418b038022ceffa94ba2152 Run the script with Server name and the backup directory as parameters .\BackupAllDatabases.ps1 -serverName NW\CLUST -backupDirectory c:\backupdir

December 25, 2018 Vignesh Sathiyanantham

Storage capacity consumed by multiple unnecessary data copies costs businesses as much as $44 billion annually, according to IDC. It estimates that redundant copies of the same data ( copy data) account for more than 60% of enterprise disk storage capacity. The redundant copies are compounded by rational practices intended to protect the business with multiple separate copies of production data like full backups, disaster recovery copy, test and dev, data analytics All the extra storage comes at a cost, data storage isn’t cheap, businesses have to waste more money on unnecessary storage expenses. There are many Copy Data management…

December 14, 2018 Vignesh Sathiyanantham

Like every computer needs harddisk VM or Cloud Instances are no exception. In Amazon, EBS is the virtual hard disk for your EC2 instances, it stores data as blocks and it is like a traditional file system you can format it with any file system and use EBS is not a stand-alone storage, you cannot use EBS volumes like S3 and unlike VMware Virtual Disks you cannot share the EBS between instances at the same time. Until 2012 Amazon had a single type EBS volumes The magnetic standard volume then they had another two more types ( General Purpose SSD and…

July 31, 2018 Vignesh Sathiyanantham

If you’re looking into data protection solutions you’re probably have heard the phrase “3-2-1 backup”. You’ll hear it from most IT consultants, professionals as well as many backup vendors and admins. Every admin should have backups. This 3-2-1 principle works for any virtual environment regardless of the hypervisors you are running (VMware, Hyper-V or whatever). and it can effectively address any failure scenario Keep at least 3 copies of your data That includes the original copy and at least two backups. Keep the backed-up data on 2 different storage types The chances of having two failures of the same storage type…

July 7, 2018 Vignesh Sathiyanantham

Cloud Server/network outages are wrecking balls, and it can happen with a dominant market player like the Amazon Web Services (AWS), The latest is an extensive outage brought on by a human error at an AWS data center in Virginia. Many consider it to be the worst hit in four years. And in June 2016: The storms that battered Sydney also shook AWS services. An extensive power outage led to the failure of a number of Elastic Compute Cloud (EC2) instances and Elastic Block Store (EBS) volumes, many of which hosted critical workloads for big brands. The result was that…