September 19, 2019 Vignesh Sathiyanantham

In ubuntu 18.04 PostgreSQL is running on the default directory /usr/lib/postgresql/ and the data directory is ‘/etc/postgresql/10/main’ To get the data directory you can run sudo -u postgres psql -c “show data_directory;” To change the data directory, first, stop the PostgreSQL service sudo service postgresql stop I mounted a ZFS volume through iSCSI protocol in my home directory /home/vignesh/pdata That will be my target directory so whenever I want to create a backup I can take the ZFS snapshot After mounting the FS, I changed to the owner to postgres vignesh@vignesh:~$ sudo chown postgres pdata Then modify the data_directory configuration…

September 17, 2019 Vignesh Sathiyanantham

In today’s data center industry there is a misconception about the storage snapshot as a Backup. The main one is storage snapshots are not backup, they are just point-in-time copies. It’s unclear from where the idea came from. Backup is a collection of data stored on (usually removable) non-volatile storage media for purposes of recovery in case the original copy of data is lost or becomes inaccessible; also called a backup copy. To be useful for recovery, a backup must be made by copying the source data image when it is in a consistent state. – The SNIA ( Storage…

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

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

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…

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/

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…

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…