Network Time Protocol – System Administration We are going to show you a simple and handy way to setup NTP over single/multiple servers connected to a network for time synchronization. What is NTP? Network Time Protocol (NTP) is a networking protocol for Clock synchronization between computer systems over packet-switched data networks. Basically, a client requests the current time from a server and uses it to set its own clock. Learn...
s3cmd is a command line tool for saving, retrieving, uploading and managing data from Amazon s3. Its capacity to store huge amount of data on nominal charges, Amazon s3 is becoming one of the most suitable choices for storing data remotely. Pre-Requests Install amazon s3 cli on ec2. Create IAM role with s3 Access Configure s3cmd on ec2. Create Amazon s3 bucket for the backup process. Basic Bash Script, can be modified...
Install Let’s Encrypt Free SSL | Linux Administration Install free let’s encrypt SSL certificate to enhance the security of your website. It is a free certificate authority which to enable HTTPS on your website. Download lets encrypt library. git clone https://github.com/letsencrypt/letsencrypt /opt/letsencrypt Jump to /opt/letsencrypt directory. cd /opt/letsencrypt/ Turn off the auto updates. —– OPTIONAL ./letsencrypt-auto –no-self-upgrade renew Enter the document root path (example: /var/www/html/) and domain name (example.com) in below...
Show all upgradeable packages $ apt-get -s dist-upgrade | grep “^Inst” Show security updates only : $ apt-get -s dist-upgrade |grep “^Inst” |grep -i securi or $ sudo unattended-upgrade –dry-run -d or $ /usr/lib/update-notifier/apt-check -p Install required packages:- $ apt-get install unattended-upgrades 1. The below command will run silently on your system and apply security updates. $ sudo unattended-upgrades 2. Or you can use optin -d with command to show...
MySQL Database Backup | Bash Scripting #!/bin/bash TIMESTAMP=$(date +”%F”) BACKUP_DIR=”/backup/databases/$TIMESTAMP” MYSQL_USER=”username” MYSQL_PASSWORD=”userpass” MYSQL=”$(which mysql)” MYSQLDUMP=”$(which mysqldump)” mkdir -p $BACKUP_DIR find “$BACKUP_DIR” -mtime +3 -type d -exec rm -rf {} \; databases=`$MYSQL -u$MYSQL_USER -p$MYSQL_PASSWORD -e “show databases”| grep -Ev “(database|Database|information_schema|performance_schema|phpmyadmin|mysql)”` for db in $databases; do $MYSQLDUMP -u $MYSQL_USER -p$MYSQL_PASSWORD –databases $db > $BACKUP_DIR/$db.sql done Making the sqlbak.sh file executable. chmod 755 sqlbak.sh Quick explanation of MySQL database backup shell script Shell...
Recent Comments