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…

August 15, 2019 Vignesh Sathiyanantham

In this post, we will see how to install ZFS on Ubuntu and present a ZVOL through iSCSI protocol to a Windows Machine for SQL Database First I created a Linux Ubuntu x64 Virtual Machine and installed the Ubuntu 18.04 Server using the server iso file available in the Ubuntu website After installing the Ubuntu, configured the static IP and installed openssh-server sudo apt-get install openssh-server Then I proceed to install the ZFS File system in my mint ubuntu Install Software properties common sudo apt-get install software-properties-common First, you have to make sure that main, restricted, universe and multiverse software…

July 12, 2019 Vignesh Sathiyanantham

Recently we faced an issue in our product Nimesa Cloud Data protection, our QA Director raised a bug that Nimesa is listing two networks during Virtual Machine clone but while editing the VM in vSphere web client he was getting only one network. When I checked in the vSphere web client I can see one network as Uplink port group but in the manage object browser two networks are listed and there is no difference between them to identify that as an uplink port group and ignore while listing in the clone after scratching my head and wondered “ But…

April 19, 2019 Vignesh Sathiyanantham

  While testing our product Nimesa with Microsoft SQL Server 2016 on Microsoft Windows 2019 i hit with some scenarios my nodes in SQL cluster has some shadows, i wanted to check in all the machine and delete the shadows. What i did is, i wrote a small powershell script which connects to all the nodes in my test bed and run diskshadow command  delete shadows all  For that, First i need to enable the PowerShell Remoting on all the nodes ( My nodes are connected to active directory and all are part of Windows Failover clustering ) Enable-PSRemoting -Force…

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/

January 18, 2019 Vignesh Sathiyanantham

One of our Nimesa customers get this error on Event Logs, CheckTokenMembership. hr = 0x80070005, Access is denied when he takes a consistent backup using Nimesa. We found out this error is from VSS Requestor, This happens when UAC(user account control) is active. Which blocks even the administrators group users from performing operation in admin mode. Right-click at the bottom of the Windows Server Start screen, select All apps and click Run.Enter regedit and click OK. The Registry Editor window opens.Expand HKEY_LOCAL_MACHINE > SOFTWARE > Microsoft > Windows > CurrentVersion > policies > system.Right-click EnableLUA, and then select Modify.In Value data, enter 0 and then click OK.  The following message displays:You must restart your computer to turn off User Account Control Click to restart this computer

January 18, 2019 Vignesh Sathiyanantham

When we are deploying our Nimesa Appliance and running on client environment, we noticed that there are no disk serial number for virtual disks on Windows server 2016, later we came to know that deployment of Windows Server 2016 happened using deprecated vSphere thick client As per the VMware KB article, If the VM is not created with vSphere WebClient, the advanced parameter “disk.EnableUUID” is not set. and we have noticed this issue happening only with Microsoft Windows Server 2016 not in Windows 2k12 and 2K12 R2 In this scenario, we have to set the enable the disk UUID for…

January 8, 2019 Vignesh Sathiyanantham

Nimesa Software based Data protection and copy data management solution supports Microsoft SQL Server full backup and log backup, recently we got a customer request why Nimesa is skipping the Simple recovery model database during log backup Simple recovery model doesnt support log backups. Simple recovery model database automatically reclaims the log space to keep space requirements small, essentially eliminating the need to manage the transaction log space The following features are not supported by SQL Server if your database is in Simple recovery model Log shippingAlways On or Database mirroringMedia recovery without data lossPoint-in-time restores Under the simple recovery…

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…

November 19, 2018 Vignesh Sathiyanantham

Backup applications for the Virtualized environment back up the Virtual Machine at the image level and are not aware of what is going on inside the installed guest operating system. So before you back up your Virtual Machines you should ensure they are quiesced so they are in a consistent state to be backed up. Quiesce is to pause or alter a device or application to achieve a consistent state, usually in preparation for a backup. The quiesce operation is handled inside the guest OS, and for Windows VMs, the Volume Shadow Copy Service (VSS) handles this. If you don’t…

November 16, 2018 Vignesh Sathiyanantham

VMware Virtual Machine snapshots should not be used as a primary backup, Virtual Machine snapshots are good for the shorter period. you can create VM snapshot before applying hotfix and delete after successful patching. When VM snapshots are created the state of the virtual disk at the time the snapshot is taken will be preserved and all writes to the VMDK are redirected to a new delta disk file (The delta disk represents the difference between the current state of the virtual disk and the state that existed at the time the previous snapshot was taken), and the original VMDK…

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…

January 28, 2018 Vignesh Sathiyanantham 29Comment

AWS Lambda lets you run code without provisioning or managing servers. You pay only for the compute time you consume – there is no charge when your code is not running. With Lambda, you can run code for virtually any type of application or backend service – all with zero administration. Just upload your code and Lambda takes care of everything required to run and scale your code with high availability. You can set up your code to automatically trigger from other AWS services or call it directly from any web or mobile app. In my last post, i wrote…

January 22, 2018 Vignesh Sathiyanantham 1Comment

Recently, An Indiana hospital paid a ransom of $55,000 to get rid of ransomware that had infected its systems and was hindering operations. when attackers breached the network of Hancock Health, a regional hospital in the city of Greenfield, Indiana. Hancock Health CEO Steve Long said the hackers are believed to be in eastern Europe and may have used a type of ransomware called SamSam, SamSam encrypted files and renamed them with the phrase “I’m sorry”, according to a local newspaper who broke the news. The hospital said that despite having backups it opted to pay the ransom demand of…

May 22, 2015 Vignesh Sathiyanantham 1Comment

VSS hardware provider can be initiate and test using DiskShadow Commands Open the Powershell and Enter Diskshadow PS C:\Users\Administrator> diskshadow Microsoft DiskShadow version 1.0 Copyright (C) 2013 Microsoft Corporation On computer: WIN-VigneshDev, 5/22/2015 12:06:35 AM DISKSHADOW> List the Hardware Providers DISKSHADOW> list providers * ProviderID: {74600e39-7dc5-4567-a03b-f091d6c7b092} Type: [2] VSS_PROV_SOFTWARE Name: Hyper-V IC Software Shadow Copy Provider Version: 1.0.0.0 CLSID: {3e02620c-e180-44f3-b154-2473646e4cb8} * ProviderID: {89300202-3cec-4981-9171-19f59559e0f2} Type: [4] VSS_PROV_FILESHARE Name: Microsoft File Share Shadow Copy provider Version: 1.0.0.1 CLSID: {fce59da7-7bac-40da-8d21-3e7311ba51cd} * ProviderID: {b57190af-4567-4dd0-ad8d51abd60b20d5 Type: [3] VSS_PROV_HARDWARE Name: Vignesh Test Provider Version: 6.2.9200.16384 * ProviderID: {b5946137-7b9f-4925-af80-51abd60b20d5} Type: [1] VSS_PROV_SYSTEM Name: Microsoft Software Shadow Copy…

January 6, 2015 Vignesh Sathiyanantham

Inconsistent Backup The oldest type of backup probably not consistent. The process of taking the backup was so simple, backup application starts at the beginning of a file structure and copies all of the data until it reaches the end, resulting in a backup (Inconsistent). The reason which can make this backup inconsistent is that if any user added/modified after a backup but before it completed that would result in an inconsistent backup; the files in the backup are not consistent. Mainly the volumes which have Random read and random writes application like databases these types of backups do not…

August 21, 2019 Vignesh Sathiyanantham

In my previous post, I have explained how to deploy Nimesa cloud data protection software in your AWS account. In this post, will discuss on the permission required to protect EC2 Instance and RDS Instance. Then how to create an IAM account and get the access key. To perform the Backup, Restore, DR operation, utilization details an IAM user with the required permission and programmatic access is required. Creating the IAM user with permission is very simple. I have published the JSON file with the permissions required in my public GIST. You can directly use it https://gist.github.com/asvignesh/9cd266549ea1f969e165423db380c31a Create a policy,…

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

I created a Ubuntu 18.04 Instance in AWS, then I connected to the instance using the pem file using ssh -i pemfile ubuntu@public-IP sudo passwd ubuntu Changing password for user ubuntu. New password: Retype new password: I set the password for the account, then enable the password authentication in the SSH config file sudo nano /etc/ssh/sshd_config Find the PasswordAuthentication no and set it to yes PasswordAuthentication yes sudo service ssh restart Reference: https://aws.amazon.com/premiumsupport/knowledge-center/ec2-password-login/

August 15, 2019 Vignesh Sathiyanantham

RAID with any filesystem / Storage array or with JBOD it comes with three main benefits. PerformanceCapacityIntegrity Performance is how fast you can access the data / write the data into the filesystem and it is measured with Input / Output per second aka IOps and usually measured in megabyte per second and millisecond of latency Capacity is how much it can hold your data, usually GBs to PBs Integrity is how many disks can fail before you lose all the data, The main problem of the RAID is you cannot get all the three benefits, to get one you…

August 15, 2019 Vignesh Sathiyanantham

I have good hands-on building REST services using Java Play Framework / Spring Boot / Spark We build multiple microservices most of them are client-server architecture and in these scenarios apart from gRPC we use REST services for the microservice communications If you ask me do we need all 70 Status provided by HTTP standards, the answer is NO, We don’t need ’em all for all Situations I Architected the REST APIs for our Cloud Data Protection software Nimesa, I didn’t use them all, we use only 10 of them and it serves our purpose 200 – OK – Everything…