Oracle vs MySQL DBA Checklist/Tasks(Article -06)

Share via:

Post Views: 0

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 log	–> Check Error Logs
2	–> Tablespaces	–> Check Storage Utilization (at OS files / df -h command)
3	–> Archive log cleanup script	–> Setup Expire_log_days (cleanup binary logs) We have cleanup for binary logs but not for transaction logs.
4	–> Check OS Watchers scripts are running or not.	–> In MySQL, we need to write our custom scripts and we maintain SAR report.
5	–> Setup cron job for sending email alert for blocking sessions	–> In MySQL also we do same .
6	–> Email alert for Alert log/Listener log monitoring.	–>We have only Error log monitoring.
7	–> ASM Disk space	–> We monitor OS file system.
8	–> Check Data-files auto extend off or on.	–> By default auto extend will be ON.
9	–> Restore points information (Drop Restore points if not needed)	–> We don’t have restore points.
10	–> Make sure No Application User connections to Prod database.(Any SQL tools)	–> We can’t control the SQL tools but we can control using IP Rules.
11	–> Table statistics (Missing or stale) & Dictionary Statistics	–> Stats collection done implicit in MySQL.
12	–> Fix Invalid objects if needed drop them after checking with application team.	–> We don’t have Concept of Invalid Objects.
13	–> Fix unusable indexes.	–> We don’t have Concept of Unusable Indexes
14	–> Make sure No Non SYS Objects in SYSTEM and SYSAUX tablespaces	–>Make sure NO objects in MYSQL database/schema.
15	–> Try to have Primary key on tables.	–> Try to have Primary key on tables.
16	–> Ensure that all indexes use an index tablespace.	–> It is not applicable in MySQL.
17	–> Look for objects that break rules (Naming convention/Storage parameters). Table names are not case sensitive.	–> Tables are case sensitive make sure the lower_case_table_name =1
18	–> Keep checking User Account Status (Lock or Expired or Expiring).	–> Keep checking User Account Status (Lock or Expired or Expiring).
19	–> Check with application team whether Disabled constraint required or not.	–> We can’t disable cosntraints in MySQL.
20	–> Make sure standby DB’s are in sync with Primary.	–> Make sure slave DB’s are in sync with Primary/Master.
21	–> Keep monitoring Redo Log generation/Archive log generation (Always maintain 3-4 Days archives on source)	–>In MySQL we do maintain same Instead of archive logs we maintain Binary Logs
22	–> Always keep checking Top Tables and if needed implement partitioning.	–> In MySQL also we do same .
23	–> Keep checking Indexes size and if needed rebuild the indexes.	–> In MySQL ,Table Rebuild will fix Indexes as well as table fragmentation
24	–> Check how many indexes are created on same column?	–> In MySQL , will do same.
25	–> Make sure RMAN Backups completed successfully.	–> For open source use xtrabackupex and its logfile.
26	–> Always keep track of TOP SQL’s(Top Physical Read/Logical Reads/Gets/Elapsed Time)	–>Use Explain plan to get details –> PMM (percona monitering and management ).
27	–>Always keep access to meta-link.	–> For Enterprise only we need access to metalink.
28	–>Archive the alert logs (if possible) to reference the similar kind of error in future.	–> Same as ORACLE
29	–>Do proper sizing for OS mount points (for Oracle Home/Grid Home)	–> Same as ORACLE(Here in MySQL /var/lib/mysql)
30	–> Monitor crontab changes and if needed keep alert for changes.	–> In MySQL also same.