November 6, 2019 Vignesh Sathiyanantham

All websites available on the internet are vulnerable to hacking attempts, DDOS attack, Data loss, This could happen to WordPress websites as well. WordPress has core files, the wp-content folder where the theme, plugin and the user uploaded post media are available, Configuration files which has your database configuration etc and the database contain every post, every comment and every link you have on your blog. If any of the core files, the configuration is corrupted or lost we can rebuild it, but if your wp-content and your database get erased or corrupted, you stand to lose everything on your…

November 3, 2019 Vignesh Sathiyanantham

AWS offers two main options for deploying SQL Server in the cloud – Elastic Compute Cloud and Relational Database Service. I lately read a few blogs and did some searches with both the types of deployment of SQL Server and learnt a few things, in this blog, I am sharing my findings Relational Database Service AWS RDS offered a Database as a Service (DaaS). It removed the complete complexity of installing, configuring the database. All instance options exposed by AWS are configured on the RDS dashboard. Options such as license model, port number, domain membership, authentication mode, backup settings etc….

November 3, 2019 Vignesh Sathiyanantham

After the availability of SQL Server 2019 and Windows Server 2019, I decided to play around with that in my lab. Microsoft, owing to the new demands and other technological advancements in the software industry, has released the upgraded version of SQL Server 2017, which is the SQL server 2019. This was announced and introduced in the Ignite 2018 event, on September 24th. However, this was just a preview edition. A more technically advanced and detail picture of SQL Server 2019, was submitted only in the PASS Summit, which happened later in November, in the same year. The newer version…

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…