Migrating to AWS. Migrating to AWS sessions – Dec 8th and Dec 9th -10:15 p.m to 11:45 pm IST ( 90 mins on both the days). Migrating to AWS Session -1 Sat, Dec 8, 2018 8:45 AM – 10:45 AM PST Please join my meeting… Read More
DOCKER FUNDAMENTALS. Docker Fundamentals Session – Dec 1st and Dec 2nd -10:15 p.m to 11:45 pm IST ( 90 mins on both the days).
BACKUP AND RECOVERY IN MySQL USING MYSQLDUMP UTILITY. Please Refer the previous article. BACKUP AND RECOVERY IN MySQL (Article -17). Using mysqldump utility we can take the backup of only data(ignoring structure ) Check the databases list.
mysql> show databases;
| Database |
| information_schema |
| ctg |
| mysql |
| performance_schema |
| sys |
| trg |
| trg2 |
7 rows in set (0.00 sec)
To take the backup of only data… Read More
INTRODUCTION TO AWS SECURITY.
BACKUP AND RECOVERY IN MySQL. What is backup ? Backup is nothing copying the data into another location . Why we need backup ? If you’re storing anything in MySQL databases that you do not want to lose, it is very important to make regular backups… Read More
Unix Shell Scripting For DBA’s (PART – 04) reference of this article from : www.orskl.com BASH ENVIRONMENT In BASH ENVIRONMENT we have sub topics . They are : 1. Initialization 2. Variables and characters 3. Expansions and Aliases 4.Regular expressions 5.Grep examples 6.Pattern matching 1. Initialization … Read More
Unix Shell Scripting For DBA’s (PART – 03) reference of this article from : www.orskl.com Debugging on the entire script When things don’t go according to plan, you need to determine what exactly causes the script to fail. Bash provides extensive debugging features. The most common… Read More
BASIC ARCHITECTURE OF UNIX OPERATING SYSTEM. UNIX operating system is like a layered one we first find H/W block next the heart of an operating system i.e, KERNEL, then SHELL ,and then users hence with this architecture there is something new called shell which we… Read More
Configure Postfix to use Gmail as a Mail Relay(UBUNTU Server) If you have a Gmail account, you can configure your Material Transfer Agent (MTA) to relay outgoing mail through Gmail. This gives you the benefit of Gmail’s reliability and robust infrastructure, and provides you with… Read More
IMPLEMENTING REPLICATION CONCEPT USING MATERIALIZED VIEWS (PART -02) IMPLEMENTING REPLICATION CONCEPT USING MATERIALIZED VIEWS. MATERIALIZED VIEW WITH REFRESH FAST : Now that we know how materialized view logs track changes to base tables we can use them to perform fast materialized view refreshes, i.e. refreshes where… Read More