Mastering MySQL Administration

Y V Ravi Kumar is an Extraordinary Ability (EB1-A) Einstein Visa recipient from the United States of America, an Oracle Certified Master, a co-author, a mentor, a technical blogger, a frequent speaker in international conferences, and a technical reviewer. He is TOGAF-certified, has published 100+ technical articles, and is an Oracle Open/cloud speaker (x4). He is an IEEE Senior Member with 26+ years of multinational leadership experience in the USA, Seychelles, and India in banking, financial services, and Insurance (BFSI) verticals. Ravi Kumar has co-authored four books: Oracle Database Upgrade and Migration Methods, Oracle High Availability, Disaster Recovery, and Cloud Services, Oracle GoldenGate with MicroServices, and Oracle Global Data Services for Mission-Critical Systems. And he served as technical reviewer on five books: Oracle 19c AutoUpgrade Best Practices, Oracle Autonomous Database in Enterprise Architecture, End-to-End Observability with Grafana, Maximum Availability Architecture (MAA) with Oracle GoldenGate MicroServices in HUB Architecture, and The Cloud Computing Journey: Design and Deploy Resilient and Secure Multi-cloud Systems with Practical Guidance. Ravi Kumar is an Oracle Certified Professional (OCP) in Oracle 8i, 9i, 10g, 11g, 12c, and 19c, and he is also an Oracle Certified Expert (OCE) in Oracle GoldenGate, RAC, Performance Tuning, Oracle Cloud Infrastructure, Terraform, and Oracle Engineered Systems (Exadata, ZDLRA, and ODA), as well as certified in Oracle Security and Maximum Availability Architecture (MAA). He is also certified in PostgreSQL, MySQL, and MySQL Heatwave platforms. And he is certified in multi-cloud architect (OCI, AWS and GCP). Ravi Kumar has published over 100+ Oracle technology articles, including on Oracle Technology Network (OTN), in ORAWORLD Magazine, on UKOUG, in OTech Magazine, and on Redgate. He hasspoken four times at Oracle Cloud/Open World (OOW) in Las Vegas/San Francisco, USA. And over the last decade, he has delivered technical sessions at Oracle user groups: IOUG, OCW, NYOUG, AUSOUG, AIOUG, UTOUG, SOUG, DOUG, and Quest Oracle Community. Ravi Kumar has designed data centers and implemented mission-critical databases for core banking solutions for two major central banks in the world. He has also received the honor of being named “TOP Data Architecture voice” from LinkedIn. And Oracle Corporation has published his profile on their OCM list and in their Spotlight on Success stories. Naresh Kumar Miryala is a highly experienced engineering leader with 20 years of industry experience and a strong background in cloud, platform engineering, and artificial intelligence. He has been leading high-performing cloud data platforms teams in his current role at Meta Platforms, Inc. He has a proven track record of cloud transformations, infrastructure implementation,database management, ERP solutions, and DevOps deployments. His expertise spans multiple domains such as database systems, large-scale backend infrastructure, security, multi-cloud deployments, cloud infrastructure, DevOps, and artificial intelligence. Naresh has contributed to esteemed organizations such as Oracle Corp and Computer Sciences Corporations, where he played a pivotal role in migrating or implementing Oracle technologies for Fortune 500 companies across the globe. His impact spans various industries, including pharmaceuticals, retail, banking, and gold mining companies worldwide. Naresh's experience in cloud migrations, particularly involving relational, open-source, and NoSQL databases, middleware, and applications, has granted him a comprehensive understanding of multi-faceted technical and business challenges in the modern world and developing innovative solutions across the industry to solve large-scale data transformation and security problems using artificial intelligence. He is also an active member of IEEE, IOUG, OATUG, and AIM leadership council, and holds certifications as a professional in cloud, database, and artificial intelligence platforms. Arun Kumar Samayam is an experienced technology architect and a seasoned database professional with a profound passion for innovation. Arun is a Principal Cloud Solutions Architect in Cloud and Engineering platform team at a global airline company. Arun is part of the Cloud Center of Excellence (CCoE) team, where he drives the organization's cloud transformation journey through cloud governance practices. Before this role, Arun worked as a Product Technical leader for the Enterprise Database services team, where he had the opportunity to develop and hone his technical proficiency through engineering, managing and supporting multiple database platforms like Oracle, MySQL, PostgreSQL, SQL server, and MongoDB. In addition, Arun is a multi-cloud certified professional, and his industry knowledge and experience have made him a speaker at prestigious events like Oracle OpenWorld, where he shared his insights and expertise on database products.

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.