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…

November 1, 2019 Vignesh Sathiyanantham

Nimesa data protection for Pure Storage integrates tightly with Pure Storage’s snapshot, replication and clone capabilities. Nimesa enables admins to create fast, space-efficient, point-in-time virtual copies of applications and virtual machines that can be used as part of a backup and recovery strategy or make available production data to various secondary use cases. Nimesa vision is to enable the availability of critical data to various stakeholders with unmatchable efficiency and SLAs. To utilize the Pure Storage array APIs, admins have to register the Pure Storage with Nimesa To protect the Virtual Machines backed by the pure storage array, Register the…

October 30, 2019 Vignesh Sathiyanantham

Microsoft SQL Server is one of the most popular enterprise database, a lot of enterprises run MS SQL Server for their mission-critical applications SQL Server database management engine is fast and stable, available on both Linux and Windows platforms and can work on cloud-based servers and local servers simultaneously. It’s owned by Microsoft and is ideal for companies that work with a range of Microsoft products as it works well with many of them. It’s market share increased fast because Microsoft pushed SQL Server with their Windows Servers and also included AI over Azure. SQL Server also has some great…

September 19, 2019 Vignesh Sathiyanantham

Backup rotation/retention scheme is the how long the backup is retained on the media, many techniques have evolved over time to balance the data retention and the restoration costs. Grandfather-father-son is a very common scheme used in the backup retention strategy. In which there are three or more backup cycles such as daily, weekly and monthly. the daily backups are rotated on daily basis using FIFO mechanism, the weekly backups are rotated on a weekly basis and the monthly on a monthly or quarterly basis. Common example The hourly backup (son) are rotated on hourly with one promoted to father…

September 18, 2019 Vignesh Sathiyanantham

Amazon EBS enables users to backup volumes ar any time using EBS snapshots, Snapshots retain the data from all completed I/O operations, allowing you to restore the volume to its exact state at the moment before backup (referred to as crash-consistency). Previously when we take the snapshots of all the disks of an EC2 instance, we need to call create snapshot API for all disks recently Amazon introduced the Create snapshot of the Instance ( creates the snapshot of all the volumes attached to the instance) This is something similar to the on-premise storage array feature of Consistency group for…

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

In my previous post, we discussed the creation of IAM user and the privilege required to protect your AWS EC2 instances. In this post, we will discuss to register the AWS account with Nimesa. Open the Nimesa web console ( refer this post for the Installation of Nimesa in your AWS account ), and log in with the credential. Then Go to “Configuration settings” > “manage platforms” In the manage platform, click on Add platform Enter the unique friendly account nameAccess Key of the IAM userSecret key Nimesa will validate the credentials, and save it in MySQL database after encrypting…