Mastering MySQL Administration Год издания: 2024 Автор: Yenugula V.R.K., Samayam A.K., Miryala N.K. Издательство: Apress ISBN: 979-8-8688-0252-2 Язык: Английский Формат: EPUB Качество: Издательский макет или текст (eBook) Интерактивное оглавление: Да Количество страниц: 757 Описание: 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. MySQL is one of the most popular open source relational database management systems developed, distributed, and supported by Oracle Corporation. So what is an open source relational database management system? To understand this better, let us focus on the keywords “open source,” “relational,” and “database management systems.” A structured collection of data is called a database. We need a system that provides computing capabilities to add, access, and process data stored in a database. That system is called a database management system. MySQL is supported on various platforms, including Oracle Linux/Red Hat/CentOS, Oracle Solaris, Canonical (Ubuntu), SUSE, Debian, Microsoft Windows server, Microsoft Windows, and Apple. 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 Tablespace Management and Partitioning Chapter 5: MySQL High Availability, Replication, and Scalability Chapter 6: MySQL InnoDB Cluster and ClusterSet 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 Manager Cloud Control 13c Chapter 14: MySQL Troubleshooting Index
You cannot post new topics in this forum You cannot reply to topics in this forum You cannot edit your posts in this forum You cannot delete your posts in this forum You cannot vote in polls in this forum You cannot attach files in this forum You can download files in this forum