Top 50 MySQL DBA interview questions answers

MySQL/MariaDB DBA Interview Questions and Answers - Part 1

Q1. What is the MySQL default port number?

answer: 3306

Q2. How MySQL replication works?

answer:

Replication is the process of creating and maintaining multiple copies of a MySQL database. It allows you to synchronize data across multiple database servers, providing high availability, scalability, and redundancy.

Q3. How will you fix MySQL slave replication issues?

answer:

Q4. What is GTID based replication?

answer:

Q5. Please explain the main differences between RDS MySQL and Amazon Aurora MySQL cluster?

answer:

Q6. Define ACID properties?

answer:

Q7. How many types of backups are available in MySQL? How do you take a backup of a MySQL database?

answer:

MySQL provides multiple methods for backup, such as using the mysqldump utility, using the MySQL Enterprise Backup tool, or performing raw data backups using file system-level tools.

Q8. How do you take incremental backup in MySQL?

answer: 

Q9. Give the different types of logs available in MySQL?

answer:

Q10. What is the command to retrieve the current date in MySQL?

answer:

Q11. Which is the default database engine utilized in MySQL?

answer:

Q12. Provide the various database engines present in MySQL?

answer:

Q13. How can a user get the current MySQL version?

answer:

Q14. What is Sharding in MySQL?

answer:

Q15. Is there any way to optimize MySQL tables? What is optimize table command do?

answer:

Q16. What are the Transaction Isolation Levels in MySQL database?

answer:

Q17. What is the default Transaction Isolation Level in MySQL?

answer:

Q18. How to change Transaction Isolation Level in MySQL?

answer:

Q19. What is MVCC in MySQL database?

answer:

Q20. How to improve the performance of a MySQL query?

answer:

    
Related MySQL Articles: 50 Best MySQL DBA interview questions answers Part 2   MySQL Database Administrator Online Quiz