Advanced MySQL 8
Discover the full potential of MySQL and ensure high performance of your database
Published on 31. October 2018
Book
Paperback/Softback
286 pages
978-1-78883-444-5 (ISBN)
Description
Design cost-efficient database solutions, scale enterprise operations and reduce overhead business costs with MySQL
Key Features
Explore the new and advanced features of MySQL 8.0
Use advanced techniques to optimize MySQL performance
Create MySQL-based applications for your enterprise with the help of practical examples
Book DescriptionAdvanced MySQL 8 teaches you to enhance your existing database infrastructure and build various tools to improve your enterprise applications and overall website performance. The book starts with the new and exciting MySQL 8.0 features and how to utilize them for maximum efficiency. As you make your way through the chapters, you will learn to optimize MySQL performance using indexes and advanced data query techniques for large queries. You will also discover MySQL Server 8.0 settings and work with the MySQL data dictionary to boost the performance of your database. In the concluding chapters, you will cover MySQL 8.0 Group Replication, which will enable you to create elastic, highly available, and fault-tolerant replication topologies. You will also explore backup and recovery techniques for your databases and understand important tips and tricks to help your critical data reach its full potential.
By the end of this book, you'll have learned about new MySQL 8.0 security features that allow a database administrator (DBA) to simplify user management and increase the security of their multi-user environments.
What you will learn
Explore new and exciting features of MySQL 8.0
Analyze and optimize large MySQL queries
Understand MySQL Server 8.0 settings
Master the deployment of Group Replication and use it in an InnoDB cluster
Monitor large distributed databases
Discover different types of backups and recovery methods for your databases
Explore tips to help your critical data reach its full potential
Who this book is forAdvanced MySQL 8 is for database administrators, data architects, and database developers who want to dive deeper into building advanced database applications in the MySQL environment.
Key Features
Explore the new and advanced features of MySQL 8.0
Use advanced techniques to optimize MySQL performance
Create MySQL-based applications for your enterprise with the help of practical examples
Book DescriptionAdvanced MySQL 8 teaches you to enhance your existing database infrastructure and build various tools to improve your enterprise applications and overall website performance. The book starts with the new and exciting MySQL 8.0 features and how to utilize them for maximum efficiency. As you make your way through the chapters, you will learn to optimize MySQL performance using indexes and advanced data query techniques for large queries. You will also discover MySQL Server 8.0 settings and work with the MySQL data dictionary to boost the performance of your database. In the concluding chapters, you will cover MySQL 8.0 Group Replication, which will enable you to create elastic, highly available, and fault-tolerant replication topologies. You will also explore backup and recovery techniques for your databases and understand important tips and tricks to help your critical data reach its full potential.
By the end of this book, you'll have learned about new MySQL 8.0 security features that allow a database administrator (DBA) to simplify user management and increase the security of their multi-user environments.
What you will learn
Explore new and exciting features of MySQL 8.0
Analyze and optimize large MySQL queries
Understand MySQL Server 8.0 settings
Master the deployment of Group Replication and use it in an InnoDB cluster
Monitor large distributed databases
Discover different types of backups and recovery methods for your databases
Explore tips to help your critical data reach its full potential
Who this book is forAdvanced MySQL 8 is for database administrators, data architects, and database developers who want to dive deeper into building advanced database applications in the MySQL environment.
More details
Language
English
Place of publication
Birmingham
United Kingdom
Target group
Professional and scholarly
US School Grade: College Graduate Student
Dimensions
Height: 235 mm
Width: 191 mm
Thickness: 16 mm
Weight
539 gr
ISBN-13
978-1-78883-444-5 (9781788834445)
Copyright in bibliographic data and cover images is held by Nielsen Book Services Limited or by the publishers or by their respective licensors: all rights reserved.
Schweitzer Classification
Other editions
Additional editions
Eric Vanier | Birju Shah | Tejaswi Malepati
Advanced MySQL 8
Discover the full potential of MySQL and ensure high performance of your database
E-Book
09/2024
Packt Publishing
from
€46.39
Available for download
Persons
Eric Vanier is one of the few DBAs worldwide specializing in MySQL performance, and is an expert with large architectures such as those for Air Miles, Cogeco, McGill University, Bombardier Aerospace, and many more. As a senior DBA and instructor for 18 years, he has a track record in performance and troubleshooting on dozens of high-profile MySQL systems, including complex cluster environments. Birju Shah is the principal architect for Endurance International Group. He has a bachelor's degree in computer engineering from Gujarat University. He has the experience and expertise to build scalable products for hosting domains. He is passionate about the latest architectural patterns, tools, and technologies, and he helps organizations to follow best practices. He is also passionate about technical training and sessions. Tejaswi Malepati is the Cassandra Tech Lead for Target. He has been instrumental in designing and building custom Cassandra integrations, including a web-based SQL interface and data validation frameworks between Oracle and Cassandra. Tejaswi earned a master's degree in computer science from the University of New Mexico, and a bachelor's degree in electronics and communication from Jawaharlal Nehru Technological University in India. He is passionate about identifying and analyzing data patterns in datasets using R, Python, Spark, Cassandra, and MySQL.
Content
Table of Contents
Introduction and Topics
MySQL 8 - New Features
Indexing Your Data For High Performance
Advanced Data Techniques For Large Queries
MySQL data dictionary in MySQL 8.0
MySQL Server Settings
Group Replication in MySQL 8.0
InnoDB Cluster in MySQL 8.0
Monitoring Your Large Distributed Databases
Authentication and Security Management with MySQL 8.0
Advanced MySQL 8.0 Performance Tips & Techniques
Introduction and Topics
MySQL 8 - New Features
Indexing Your Data For High Performance
Advanced Data Techniques For Large Queries
MySQL data dictionary in MySQL 8.0
MySQL Server Settings
Group Replication in MySQL 8.0
InnoDB Cluster in MySQL 8.0
Monitoring Your Large Distributed Databases
Authentication and Security Management with MySQL 8.0
Advanced MySQL 8.0 Performance Tips & Techniques