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…

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 31, 2019 Vignesh Sathiyanantham

The default user for Amazon Linux 2 is ec2-user, first, we need to create a password for the ec2-user [ec2-user@ip-164 ]$ sudo passwd ec2-user Changing password for user ec2-user. New password: Retype new password: passwd: all authentication tokens updated successfully. Then enable the password authentication for the Login in the SSHD config file sudo nano /etc/ssh/sshd_config Find the PasswordAuthentication no and set it to yes Restart the SSHD Service sudo systemctl restart sshd

August 31, 2019 Vignesh Sathiyanantham

In this post, we will see how to install MySQL server on AWS EC2 Amazon Linux 2 and configure the security group to access from your desktop The Amazon Linux AMI is a supported and maintained Linux image provided by Amazon Web Services for use on Amazon Elastic Compute Cloud (Amazon EC2). It is designed to provide a stable, secure, and high-performance execution environment for applications running on Amazon EC2. It supports the latest EC2 instance type features and includes packages that enable easy integration with AWS. Amazon Web Services provides ongoing security and maintenance updates to all instances running…

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

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

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 18, 2019 Vignesh Sathiyanantham

If you have a large datacenter having too many VMs, you may find it difficult to filter the VMs, using the super powerful tool vSphere PowerCLI you can get the VM with filters To get the VM where the tool is not installed, run the below script after connecting with VI-Server Get-VM -name windows-* | ?{$_.extensiondata.guest.toolsstatus -eq ‘toolsNotInstalled’}

June 5, 2019 Vignesh Sathiyanantham

Ansible is the glue for VMware and DevOps, Many DevOps engineers use vRealize Automation to automate the Provisioning of VMs but there are a lot of chances that VMware isn’t the only infrastructure tool your company uses. Ansible helps you to do provisioning on multiple clouds, in this blog I try to explain the creation of Virtual Machine from a template on VMware vCenter Ansible provides various modules to manage the VMware Infrastructure, which included datacenter, cluster, host system and virtual machine. As a pre-requisite we need to install pyVmomi, the VMware modules are written over the top of VMware…