MAKING RAW MyISAM BACKUP IN MySQL (Article -19). MyISAM was the default storage engine for the MySQL relational database management system versions prior to 5.5 released in December 2009. it is based on the older ISAM code. Filesystem Each MyISAM table is stored on disk in three files (if it is not partitioned).… Read More
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
