Thursday, May 31, 2012

Dumping MySQL table into CSV file

Advertisements

Sometimes we need to get the MySQL tables into an Excel sheet. How this can be done? We can dump the MySQL tables into a csv format file. Lets see how to do it.

Monday, May 21, 2012

Confiugring daily backup of amazon centos instance

Advertisements

Configuring daily backup of amazon linux centos instance to amazon s3 storage

How do you backup your amazon ec2 (Amazon elastic cloud) Linux  instance? Did you buy any costly backup sofwares to do the daily backup task? Here we will discuss how to backup your amazon ec2 Linux  instance to amazon s3 bucket storage using a bash script scheduled with cron on a daily basis.

Configuring daily backup of amazon RDS server

Advertisements

Configuring daily backup of amazon RDS server to amazon s3 storage

How do you backup your amazon RDS (Amazon Relational Database Service) MySQL server? Did you buy any costly backup managers to do the daily backup task? Here we will discuss how to backup your amazon rds  MySQL databases to amazon s3 bucket storage using a bash script scheduled with cron on a daily basis.

Friday, May 18, 2012

Amazon Elastic Load balancing with autoscaling

Advertisements

Suppose you have a website. linxhelp.in And suppose sometimes you get a traffic which your system cannot handle. What you will do? You will create multiple instances of your system and will configure a load balancer. But you have to keep both instances running even if there is not much traffic. We will discuss how to eliminate this resource wastage using amazon elastic load balancer and amazon autoscaling. For using this, your instances should be configured in amazon elastic cloud or ec2.