MySQL Master-Slave Replication on different AWS instances. In this article i want show how to configure master-slave replication in two different machines. What is Replication ? Replication is the continuous copying of data changes from one database (MASTER) to another database (SLAVE ). The two… Read More
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
DIFFERENCE BETWEEN ORACLE AND MySQL -07 Please refer my previous articles. Oracle vs MySQL DBA Checklist/Tasks(Article -06) Differences between Oracle and MySQL SNO ORACLE MySQL 1 In Oracle we have different ways of backup like Logical Backup and Physical backups In MySQL also we have… Read More
HOW TO CHECK INDEX FRAGMENTATION. When a database is frequently updated via UPDATE, or DELETE statements we can expect it to become fragmented over the time. If database indexes are fragmented, the SQL query optimizer may chose a non-optimal execution plan when using an index to… 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).
Startup & Shutdown process in Oracle Apps in R12. STARTUP PROCESS 1.Start Database Tier Services –Start Database Listener $ORACLE_HOME/appsutil/scripts/$CONTEXT_NAME/addlnctl.sh start <listener_name> –Start Database $ORACLE_HOME/appsutil/scripts/$CONTEXT_NAME/addbctl.sh start or alternatively you can use lsnrctl start/stop <listener_name > sqlplus “/as sysdba” SQL> startup Then 2.Start Application/Middle Tier Services… Read More
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 | +——————–+… 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
Oracle vs MySQL DBA Checklist/Tasks Note : Proper Documentation which is very important in order to save time and act on issue immediately. DB health check list for Day to Day Activities. ORACLE MYSQL –> Check Alert log –> Check Error Logs –> Tablespaces… Read More