High Availability, Security, Performance, and Efficiency Ravi Kumar, Y V. creator author. aut http://id.loc.gov/vocabulary/relators/aut Samayam, Arun Kumar. author. aut http://id.loc.gov/vocabulary/relators/aut Miryala, Naresh Kumar. author. aut http://id.loc.gov/vocabulary/relators/aut SpringerLink (Online service) text xxu 2024 1st ed. 2024. monographic eng

electronic

electronic resource

access XXV, 732 p. 161 illus. online resource. This book is your one-stop resource on MySQL database installation and server management for administrators. It covers installation, upgrades, monitoring, high availability, disaster recovery, security, and performance and troubleshooting. You will become fluent in MySQL 8.2, the latest version of the highly scalable and robust relational database system. With a hands-on approach, the book offers step-by-step guidance on installing, upgrading, and establishing robust high availability and disaster recovery capabilities for MySQL databases. It also covers high availability with InnoDB and NDB clusters, MySQL routers and enterprise MySQL tools, along with robust security design and performance techniques. Throughout, the authors punctuate concepts with examples taken from their experience with large-scale implementations at companies such as Meta and American Airlines, anchoring this practical guide to MySQL 8.2 administration in the real world. What You Will Learn Understand MySQL architecture and best practices for administration of MySQL server Configure high availability, replication, disaster recovery with InnoDB and NDB engines Back up and restore with MySQL utilities and tools, and configure the database for zero data loss Troubleshoot with steps for real-world critical errors and detailed solutions. Chapter -1: MySQL Installation and Upgrade -- Chapter-2: MySQL Utilities -- Chapter-3: MySQL Server administration -- Chapter-4: MySQL -- Chapter-5: MySQL High Availability, Replication and Scalability -- Chapter-6: MySQL InnoDB Cluster and Cluster Set -- Chapter-7: MySQL NDB Cluster -- Chapter-8: MySQL Logical Backup -- Chapter-9: MySQL Enterprise Backup and Recovery -- Chapter-10: MySQL Security -- Chapter-11: MySQL Performance Tuning -- Chapter-12: MySQL Enterprise Monitor -- Chapter-13: Monitoring MySQL using Oracle Enterprise Monitor Cloud Control 13c -- Chapter 14: MySQL Troubleshooting -- Summary. by Y V Ravi Kumar, Arun Kumar Samayam, Naresh Kumar Miryala. Database management Database Management QA76.9.D3 9798868802522 https://doi.org/10.1007/979-8-8688-0252-2 https://doi.org/10.1007/979-8-8688-0252-2 240502 20251030112026.0 979-8-8688-0252-2