Tools for Administering the MySQL Database

Dear Readers,

In this article, we will discuss Tools for Administering the MySQL Database

Please Fill below Google Form (If we missed any Products, Tools, and Utilities that you use in achieving your goals as a Cassandra Administrator.)
👇🏻👇🏻👇🏻👇🏻👇🏻
https://forms.gle/mysql

1. MySQL Flavours

   Oracle Mysql
   MariaDB
   Percona Mysql
   RocksDB
   Azure mysql(For Azure cloud)
   Aurora(Mysql in AWS)

2. Monitoring Tools

   Mysql Enterprise Monitoring (Enterprise Versions only)
   Percona management and Monitoring (Enterprise and Community vewrsions)
   Custom Scripts
   OEM (Enterprise versions)

3. Replication Tools

   Mysql replication (Both enterprise and Community)
   Oracle Group replication
   Tungsten replication (Both enterprise and Community)

4. Clustering Tools (High Availability)

   Galera cluster
   Tungsten Cluster
   Innodb cluster

5. Text Compare Tools

   www.text-compare.com

6. My SQL day to day Tasks

   TOAD
   Mysql workbench
   SQLYog
   MySQL Client
   phpmyadmin

7. Remote Access Tools

   Putty
   Secure CRT
   MobaXterm

8. File Transfer Tools

   WinSCP
   FileZilla

9. SQL Text Compare Tools

   Redgate

10. SQL Formatter Tools

    http://www.dpriver.com/pp/sqlformat.htm

11. Performance Tunining Tools

    mysqlslap
    PMM
    Workbench
    Mysql client
    MySQL Enterprise Monitoring
    OEM
    pt-query-digest

12. Best Text Editors

    Notepad++
    Textpad
    MySQL Workbench
    SQLYog

13. Automation Tools

    ShellScripting
    Python
    Windows schedulars.
    MySQL Schedulars.

14. Upgrade Tools

    mysqldump
    datamigration using workbench
    CSV imports.
    MySQL upgrade

15. Backups

    percona xtrabackup(enterprise and community)
    Mysqlbackup(Enterprise only)
    MySQLdump (Logical backup)

Thank you for giving your valuable time to read the above information.
Follow us on 
Website :  www.ktexperts.com
Facebook Page : KTExperts Facebook
Linkedin Page : KT EXPERTS Linkedin