E-Books →MySQL 8 Cookbook

Problems like table corruption, excessive CPU and memory usage, deadlocks, and replication lag are addressed in the troubleshooting sections. Also shown are methods for automating and monitoring database security using Linux tools, cron jobs, and MySQL's performance schema. Whether you're managing enterprise databases or developing backend applications, this book will teach you to improve your database management skills and ensure peak performance for systems that are critical to business.
Key Learnings
Ins and outs of installing, configuring, and optimizing MySQL 8 for high-performance database systems.
Implementing advanced replication setups, including master-master and multi-source.
Advantage of partitioning and indexing techniques to manage massive datasets.
Use MySQL's relational and NoSQL features in combination to manage schema-less data.
Use cron jobs and Linux-native tools to automate backups, recovery, and security audits.
Find table corruption, deadlocks, and replication lag and fix them.
Implement strong firewall settings, encryption, and user access control.