blog

  • enable and configuring auditing and masking in mysql

    enable auditing can be done on both community and enterprise edition and its strait forward option for best approach we will use enable auditing permanently enabling auditing navigate…

    Continue Reading

    4 min read

  • MONITOR MYSQL

    Getting MySQL Report from pt-mysql-summary This tool will generate report what is configuration for MySQL instance , how many replica MySQL has Or if the MySQL itself is…

    Continue Reading

    4 min read

  • mysql replication troublshooting

    mysql replication troublshooting

    to achieve the best result in troubleshooting it is highly recommended to install percona toolkit it contains tool that will help resolve replication error Coordinator stopped because there…

    Continue Reading

    4 min read

  • MySQL master slave repliaction

    MySQL master slave repliaction

    installing MySQL Enterprise db1 & db2 we already downloaded the MySQL enterprise iso and added it on vm we have added three spread disk on the vm that…

    Continue Reading

    4 min read

  • Using percona xtrabackup for backup

    Using percona xtrabackup for backup

    taking backup percona xtrabackup is consider a hot backup that backup the whole data directory with its redo logs and also it will take backup of the my.cnf…

    Continue Reading

    4 min read

  • MySQL to MySQL Migration Guide

    MySQL to MySQL Migration Guide

    The steps involve installing Percona Toolkit to be able to use the Percona tool pt-show-grant. The tool will print out the users with their privileges and encrypted passwords.…

    Continue Reading

    4 min read

Visited 1,554 times, 1 visit(s) today