Advanced MySQL 8

Design cost-efficient database solutions, scale enterprise operations and reduce overhead business costs with MySQL
Code Files

Advanced MySQL 8

Eric Vanier, Birju Shah, Tejaswi Malepati

2 customer reviews
Design cost-efficient database solutions, scale enterprise operations and reduce overhead business costs with MySQL
Packt Subscription
FREE
$9.99/m after trial
eBook
$12.80
RRP $31.99
Save 59%
Print + eBook
$39.99
RRP $39.99
What do I get with a Packt subscription?
  • Exclusive monthly discount - no contract
  • Unlimited access to entire Packt library of 6500+ eBooks and Videos
  • 120 new titles added every month, on new and emerging tech
What do I get with an eBook?
  • Download this book in EPUB, PDF, MOBI formats
  • DRM FREE - read and interact with your content when you want, where you want, and how you want
  • Access this title in the subscription reader
What do I get with Print & eBook?
  • Get a paperback copy of the book delivered to you
  • Download this book in EPUB, PDF, MOBI formats
  • DRM FREE - read and interact with your content when you want, where you want, and how you want
  • Access this title in the subscription reader
What do I get with a Video?
  • Download this Video course in MP4 format
  • DRM FREE - read and interact with your content when you want, where you want, and how you want
  • Access this title in the subscription reader
$0.00
$12.80
$39.99
$9.99 p/m after trial
RRP $31.99
RRP $39.99
Subscription
eBook
Print + eBook
Start a FREE 10-day trial

Frequently bought together


Advanced MySQL 8 Book Cover
Advanced MySQL 8
$ 31.99
$ 12.80
Beginning Data Science with Python and Jupyter Book Cover
Beginning Data Science with Python and Jupyter
$ 11.99
$ 4.80
Buy 2 for $17.60
Save $26.38
Add to Cart

Book Details

ISBN 139781788834445
Paperback286 pages

Book Description

Advanced 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.

Table of Contents

Chapter 11: Advanced MySQL Performance Tips and Techniques

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

Authors

Table of Contents

Chapter 11: Advanced MySQL Performance Tips and Techniques

Book Details

ISBN 139781788834445
Paperback286 pages
Read More
From 2 reviews

Read More Reviews

Recommended for You

Beginning Data Science with Python and Jupyter Book Cover
Beginning Data Science with Python and Jupyter
$ 11.99
$ 4.80
Mastering Java 11 - Second Edition Book Cover
Mastering Java 11 - Second Edition
$ 35.99
$ 14.40
Mastering Python for Networking and Security Book Cover
Mastering Python for Networking and Security
$ 31.99
$ 12.80
101 UX Principles Book Cover
101 UX Principles
$ 31.99
$ 12.80
Hands-On GPU-Accelerated Computer Vision with OpenCV and CUDA Book Cover
Hands-On GPU-Accelerated Computer Vision with OpenCV and CUDA
$ 39.99
$ 16.00
Tkinter GUI Application Development Blueprints - Second Edition Book Cover
Tkinter GUI Application Development Blueprints - Second Edition
$ 39.99
$ 16.00