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
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. Differences between Oracle and MySQL SNO ORACLE MySQL 1 –> Check Alert… Read More
DIFFERENCE BETWEEN ORACLE AND MySQL -05 Please refer my previous articles. DIFFERENCE BETWEEN ORACLE AND MySQL -04 In this article will see few more differences between ORACLE and MySQL. Differences between Oracle and MySQL SNO ORACLE MySQL 1 In Oracle ,we need to write Parameters to set (or)… Read More
DIFFERENCE BETWEEN ORACLE AND MySQL. Please refer previous article . DIFFERENCE BETWEEN ORACLE AND MySQL -03 In this article will see few more differences between ORACLE and MySQL. Differences between Oracle and MySQL SNO ORACLE MySQL 1 How to check metadata of table ? SYS>> desc <objectname> “;”… Read More
In this article will have a look on different database editions in ORACLE & MySQL . DATABASE EDITIONS IN ORACLE : ENTERPRISE EDITION (EE) : Most powerful with a vast array of tools and features of the largest corporation. STANDARD EDITION (SE) : Oracle SE… Read More
DIFFERENCE BETWEEN ORACLE AND MySQL. Please refer previous articles. DIFFERENCE BETWEEN ORACLE AND MySQL -01 In this article will see few more differences between ORACLE and MySQL. ORACLE … Read More
Installation of MySQL Sever in Ubuntu using Generic Binaries. To begin the Installation process first download the generic binary from mysql.com or use the below link for downloading MySQL Sever Software Link to Download Binaries: https://dev.mysql.com/downloads/mysql/ Steps to Configure MySQL Server: Create a group with… Read More
Which one to choose RDS v/s MySQL on EC2 A lot of clients for whom we manage AWS come up with a simple question of which out of “RDS vs EC2” is better for their MySQL database requirements. The answer to this simple question is… Read More
Introduction Clustering adds high availability to your database by distributing changes to different servers. In the event that one of the instances fails, others are already available to continue serving. Clusters come in two general configurations, active-passive and active-active. In active-passive clusters, all writes are… Read More
About MySQL replication MySQL replication is a process that allows you to easily maintain multiple copies of a MySQL data by having them copied automatically from a master to a slave database. Advantages of replication in MySQL include: Scale-out solutions – spreading the load among… Read More
