Advanced MySQL 8: Discover the full potential of MySQL and ensure high performance of your database

What do you get with Print?

Instant access to your digital eBook copy whilst your Print order is Shipped

Paperback book shipped to your preferred address

Download this book in EPUB and PDF formats

Access this title in our online reader with advanced features

DRM FREE - Read whenever, wherever and however you want

AI Assistant (beta) to help accelerate your learning

Introduction

MySQL is the most popular open- source database system on the market and has been around since 1995. Oracle has owned MySQL since 2010, and MySQL is distributed in two versions: The Community Edition (open source), and the Enterprise Edition, which you must pay for and of course it comes with a series of enhanced features not available in the free version.

It should be mentioned that the Community Edition version (open source) is more popular than the Enterprise version, and can be downloaded from the MySQL website (https://www.mysql.com/). This edition has all the features you need for safe web applications that are reliable and secure. Websites such as Google, Wikipedia, Facebook, YouTube, and so on, are some of the biggest users of MySQL.

I'm curious whether you know what MySQL means.

MySQL is a combination of My (the name of the daughter of co-founder Michael Widenius) and SQL stands for Structured Query Language.

This book is an excellent choice if you want to learn advanced concepts at the performance level. Also, you will learn how to analyze and optimize complex queries with different techniques. You will learn to configure and optimize MySQL servers and then I will teach you how to secure your database, using back-up strategies.

We will also go through all the new features of MySQL 8.0 including the Group Replication and InnoDB cluster. Together, we will look at the best surveillance tools that exist on the market today. Throughout this book, I will share my experiences and techniques to help you better manage MySQL in its everyday management and to have a better understanding of its complex and broad architectures. Finally, I will share some techniques with you, which will allow you to make more efficient MySQL 8.0 databases and which I use with Fortune 500 customers.

In this chapter, we will cover the following topics:

Why Oracle decided to go with MySQL 8.0
Why MySQL 8.0 is the next generation
Why it is so important to have a good architecture design
A review of the chapter

Why it is so important to have a good MySQL architecture design

It must be said that MySQL is easy to use and its operation is very fast. MySQL requires at first a general knowledge of SQL to work effectively with it. MySQL does not require much more knowledge, but a little knowledge of common relational database management system (RDBMS) is helpful.

However, despite the fact that MySQL comes with a minimal configuration to help your database launch and perform well, MySQL needs more attention to maintain optimal performance, and in general a good understanding of MySQL's configuration becomes more important.

The fact is that the more your database grows with time and demands more hardware resources such as memory, processors, and disk speed, the slower response times will be; this is a sign that your data model need to be revised and adjusted to meet growing and critical demands. The better your data model is at the beginning, the easier it will be to re-adjust your configuration along the way.

The more your business or website grows the more you need a good solid MySQL architecture. During this growth phase, you will notice that you will be asking yourself questions such as the following ones:

Do I need to completely rethink my MySQL architecture?
Should I start thinking about having a large MySQL infrastructure?
Do I need to review my queries?
Do I need to create indexes?

Imagine the questions and doubts when we are in the phase where MySQL is likely to under-perform. That's when you desperately start looking at your options on Google and YouTube to see how you can improve your architecture.

This is what I call the critical or gray-zone phase. You will try to make all kinds of changes with the hope of solving your performance problems when the solution was simply to have a good architecture and a logical structure of your data right from the start.

Fortunately, MySQL 8.0 will provide a detailed understanding of high availability with InnoDB Cluster, Global Replication, and all the other features that have been added or improved. I must mention that I have been so far pleasantly surprised by the new performance of MySQL 8.0.

Key benefits

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

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.

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

What do you get with Print?

Instant access to your digital eBook copy whilst your Print order is Shipped

Paperback book shipped to your preferred address

Download this book in EPUB and PDF formats

Access this title in our online reader with advanced features

DRM FREE - Read whenever, wherever and however you want

AI Assistant (beta) to help accelerate your learning

Frequently bought together

€32.99

€41.99

€32.99

Total € 107.97

DjjZ Sep 18, 2019

One reviewer said this book was not very advanced and had a whole section on indexing, and who needs that? Well, I do. That is what convinced me to buy it. I have years of experience with a large application my company developed, and it still uses FoxPro, where I have tons of experience with indexing. But we are migrating to MySQL, and the chapter on indexing is exactly what I need. It will help me make the leap. I need to see how indexing in MySQL is different from FoxPro.

Amazon Verified review

Amazon Customer Jun 27, 2019

Excellent book. Book explaining the advanced concepts in a very easy way, best thing in this book is you can cover the whole book within 1 week and every page will give you a fresh knowledge.There are exercises in each chapter to make sure you are learning the topics. This review can be helpful for others to take this book.Highly recommended.

Knowledge Sponge Jul 21, 2019

I was looking for a book that would get me up to speed on the new capabilities of MySQL 8. This isn't it. It barely describes the new features, and doesn't even mention some major ones such as windowing. It is primarily about how to organise a database - indexes, replication, performance and so on. And it isn't very "advanced" - it has a section about why you should create indexes. If someone doesn't know that, they don't need an "advanced" book. I guess it's "advanced" as in "not for the person who only started using MySQL yesterday". It's probably an OK book at that level (though I didn't like the style, which I found patronising), just not what it claims to be from the title.

Fran G. Mar 18, 2021

Focus is placed on differences from last version.

martin yuk Dec 30, 2020

information of mysql is very basic

Advanced MySQL 8: Discover the full potential of MySQL and ensure high performance of your database

What do you get with Print?

Advanced MySQL 8

Introduction

Why MySQL 8?

Why is MySQL 8.0 the next generation?

Why it is so important to have a good MySQL architecture design

Summary

Page 1 of 5

Key benefits

Description

Who is this book for?

What you will learn

Product Details

What do you get with Print?

Product Details

Frequently bought together

Table of Contents

Recommendations for you

Customer reviews

People who bought this also bought

About the 3 authors

FAQs

Advanced MySQL 8: Discover the full potential of MySQL and ensure high performance of your database

What do you get with Print?

Contact Details

Shipping Address

Billing Address

Key benefits

Description

Who is this book for?

What you will learn

Product Details

What do you get with Print?

Contact Details

Shipping Address

Billing Address

Product Details

Packt Subscriptions

Frequently bought together

Table of Contents

Recommendations for you

Customer reviews

People who bought this also bought

About the 3 authors

FAQs