Sign In Start Free Trial

MySQL 8 Administrator???s Guide

By : Mehta, Oza, Subhash Shah

2.7 (10)

MySQL 8 Administrator???s Guide

2.7 (10)

By: Mehta, Oza, Subhash Shah

Overview of this book

MySQL is one of the most popular and widely used relational databases in the world today. The recently released version 8.0 brings along some major advancements in the way your MySQL solution can be administered. This handbook will be your companion to understand the newly introduced features in MySQL and show you how you can leverage them to design a high-performance MySQL solution for your organization. This book starts with a brief introduction to the new features in MySQL 8, and then quickly jumping onto the crucial administration topics that you will find useful in your day-to-day work. Topics such as migrating to MySQL 8, MySQL benchmarking, achieving high performance by implementing the indexing techniques, and optimizing your queries are covered in this book. You will also learn how to perform replication, scale your MySQL solution and implement effective security techniques. There is also a special section on the common and not so common troubleshooting techniques for effective MySQL administration is also covered in this book. By the end of this highly practical book, you will have all the knowledge you need to tackle any problem you might encounter while administering your MySQL solution.

Preface

Preface

Who this book is for

What this book covers

To get the most out of this book

Get in touch

Free Chapter

An Introduction to MYSQL 8

An Introduction to MYSQL 8

Overview of MySQL

Core features in MySQL

Improved features in MySQL 8

Benefits of using MySQL 8

Limitations of MySQL 8

Use cases of MySQL

Summary

Installing and Upgrading MySQL 8

Installing and Upgrading MySQL 8

The MySQL 8 installation process

Post-installation setup for MySQL 8

Upgrading MySQL 8

MySQL 8 downgrading

Summary

MySQL 8 – Using Programs and Utilities

MySQL 8 – Using Programs and Utilities

Overview of MySQL 8 programs

MySQL 8 command-line programs

MySQL 8 client programs

MySQL 8 administrative programs

MySQL 8 environment variables

MySQL GUI tools

Summary

MySQL 8 Data Types

MySQL 8 Data Types

Overview of MySQL 8 data types

Numeric data types

Date and time data types

String data types

JSON data type

Storage requirements for data types

Choosing the right data type for column

Summary

MySQL 8 Database Management

MySQL 8 Database Management

MySQL 8 server administration

Data directory

The system database

Running multiple instances on a single machine

Components and plugin management

Roles and permissions

Caching techniques

Globalization

MySQL 8 server logs

Summary

MySQL 8 Storage Engines

MySQL 8 Storage Engines

Overview of storage engines

Several types of storage engines

The InnoDB storage engine

Creating a custom storage engine

Summary

Indexing in MySQL 8

Indexing in MySQL 8

An overview on indexing

Column-level indexing

B-Tree index

Hash index

Index extension

Using an optimizer for indexes

Invisible and descending indexes

Summary

Replication in MySQL 8

Replication in MySQL 8

Overview of replication

Configuring replication

Implementing replication

Group replication

Replication solutions

Summary

Partitioning in MySQL 8

Partitioning in MySQL 8

Overview of partitioning

Types of partitioning

Partition management

Partition selection and pruning

Restrictions and limitations in partitioning

Summary

MySQL 8 – Scalability and High Availability

MySQL 8 – Scalability and High Availability

Overview of scalability and high availability in MySQL 8

Scaling MySQL 8

Challenges in scaling MySQL 8

Achieving high availability

Summary

MySQL 8 – Security

MySQL 8 – Security

Overview of security for MySQL 8

Common security issues

Access control in MySQL 8

Account management in MySQL 8

Encryption in MySQL 8

Security plugins

Summary

Optimizing MySQL 8

Optimizing MySQL 8

Overview of MySQL 8 optimization

Optimizing MySQL 8 servers and clients

Optimizing database structure

Optimizing queries

Optimizing tables

Leveraging buffering and caching

Summary

Extending MySQL 8

Extending MySQL 8

An overview of extending MySQL 8

Extending plugins and using services to call them

Adding new functions

Debugging and porting

Summary

MySQL 8 Best Practices and Benchmarking

MySQL 8 Best Practices and Benchmarking

MySQL benchmarking and tools

Best practices for memcached

Best practices for replication

Best practices for data partitioning

Best practices for queries and indexing

Summary

Troubleshooting MySQL 8

Troubleshooting MySQL 8

MySQL 8 common problems

MySQL 8 server errors

MySQL 8 client errors

MySQL 8 troubleshooting approach

Real-world scenario

Summary

Other Books You May Enjoy

Other Books You May Enjoy

Leave a review - let other readers know what you think

Customer Reviews

2.7 (10)

5 star

40%

4 star

0

3 star

0

2 star

10%

1 star

50%

An Introduction to MYSQL 8

MySQL is a well-known open source structured database because of its performance, easiness to use, and reliability. This is the most common choice of web applications for a relational database. In the current market, thousands of web-based applications rely on MySQL including giant industries such as Facebook, Twitter, and Wikipedia. It has also proven to be the database choice for Software as a Service (SaaS) based applications such as Twitter, YouTube, SugarCRM, Supply Dynamics, Workday, RightNow, Omniture, Zimbra, and many more. We will discuss this in detail in the use cases of MySQL section later in the chapter. MySQL was developed by MySQL AB, a Swedish company, and now it is distributed and supported by Oracle Corporation. MySQL carries a valuable history with it.

MySQL has continued to improve in order to become an enterprise-level database management system. MySQL 8 is expected to be a game-changer as today we are in the age of digitization. MySQL 8 is all tuned to serve many new use cases that in prior versions were difficult to achieve. Some of the use cases an enormous amount of data is produced are social networking, e-commerce, bank/credit card transactions, emails, data stored on the cloud, and so on. Analysis of all such structured, unstructured, or semi-structured ubiquitous data helps to discover hidden patterns, market trends, correlations, personal preferences.

"There is so much for each of us"
- James Truslow Adams

Let's take an in-depth look at MySQL 8 new features, benefits, use cases along with a few limitations of MySQL 8 after we have an overview of MySQL. This is going to be exciting, let's get prepared.

Search

Your notes and bookmarks