Yunus Shaikh MySQL, Linux, Monitoring
No reviews yet

I am an experienced MySQL database administrator with loads of experience in system administration as well as Automation.
I have knowledge of various open source technologies and cloud database as well.
You can learn the MySQL databases and also go for certification and I can help you achieve that.
I also have experience in monitoring of databases with effective tools.
I like to teach online and offline both to my students and like to share my knowledge to grow further.
We can discuss at start of the course what is needed and can work on it together if any specific topics are needed to learn.
Below are the topics,
1. Basics of MySQL Architecture
MySQL Server components and architecture.
Storage engines: InnoDB, MyISAM, and others.
Buffer pool and memory management.
2. Installation and Configuration
Installing MySQL on different platforms (Linux, Windows).
MySQL configuration file (my.cnf or my.ini) basics.
Tuning MySQL parameters for performance.
Managing and upgrading MySQL versions.
3. User and Security Management
Creating and managing users and roles.
Granting and revoking permissions.
Understanding authentication methods.
Securing MySQL with SSL/TLS.
4. Backup and Recovery
Logical backups: mysqldump, MySQL Shell.
Physical backups: Percona XtraBackup, MySQL Enterprise Backup.
Point-in-time recovery.
Testing backups for integrity and restoration.
5. Monitoring and Performance Tuning
Using tools like PMM (Percona Monitoring and Management), MySQL Workbench.
Query performance tuning using EXPLAIN and optimizer.
Index optimization and index types.
Monitoring and tuning InnoDB buffer pool and query cache.
6. High Availability and Replication
Configuring MySQL replication (asynchronous, semi-synchronous).
Understanding GTIDs (Global Transaction Identifiers).
Setting up MySQL Group Replication.
Implementing clustering solutions: MySQL Cluster, Galera Cluster.
7. Storage Engines and Data Types
Deep dive into InnoDB.
Understanding table and index structures.
Choosing the right storage engine for different use cases.
8. Logging and Auditing
Configuring general, slow query, and error logs.
Analyzing log files for troubleshooting.
Using MySQL Enterprise Audit or third-party tools for auditing.
9. Managing Large Databases
Partitioning tables and data.
Archiving old data efficiently.
Handling schema changes with minimal downtime.
10. Troubleshooting
Diagnosing and resolving replication lag/issues.
Recovering from crashed tables or servers.
Handling locking issues and deadlocks.
11. Automation and Scripting
Using mysql CLI and MySQL Shell for routine tasks.
Writing administrative scripts in Bash, Python, or Perl.
Automating backups and monitoring alerts.
12. Advanced Topics
Query optimization with hints.
Managing MySQL in containerized environments (Docker, Kubernetes).
Working with ProxySQL for connection pooling and query routing.
Migrating MySQL databases using tools like mysqlpump or MySQL Shell.

Subjects

  • Ansible Beginner-Expert

  • Nagios Administration Beginner-Expert

  • MySQL Administrator Beginner-Expert

Experience

  • Senior Database administrator (Nov, 2018–Present) at Percona
    Managing database for high availability.
    Automating administration tasks using Ansible.
    Managing backups and restores.
    Disaster recovery.
    Monitoring databases.
    Managing databases in cloud

Education

  • BCA (Jan, 2010–Jan, 2013) from SIKKIM UNIVERSITY–scored 83

Fee details

    ₹500/hour (US$5.90/hour)

Reviews

No reviews yet. Be the first one to review this tutor.