Home | Amazing | Today | Tags | Publishers | Years | Account | Search 
MySQL 8 Administrator's Guide: Effective guide to administering high-performance MySQL 8 solutions


Step by step guide to monitor, manage, and secure your database engine

Key Features

  • Your companion to master all the administration-related tasks in MySQL 8
  • Ensure high performance and high availability of your MySQL solution using effective replication and backup techniques
  • A comprehensive guide to performing query optimization, security and a whole host of other administrative tasks in MySQL 8

Book Description

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 how you can leverage them to design a high-performance MySQL solution for your organization.

This book starts with a brief introduction to the newly introduced features in MySQL 8, followed by 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. 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.

What you will learn

  • Understanding different MySQL 8 data types based on type of contents and storage requirements
  • Best practices for optimal use of features in MySQL 8
  • Explore globalization configuration and caching techniques to improve performance
  • Create custom storage engine as per system requirements
  • Learn various ways of index implementation for flash memory storages
  • Configure and implement replication along with approaches to use replication as solution
  • Understand how to make your MySQL 8 solution highly available
  • Troubleshoot common issues and identify error codes while using MySQL 8

Who This Book Is For

This book is intended for MySQL administrators who are looking for a handy guide covering all the MySQL administration-related tasks. If you are a DBA looking to get started with MySQL administration, this book will also help you. Knowledge of the basic database concepts is required to get started with this book.

Table of Contents

  1. Introduction to MySQL 8
  2. Installing & Upgrading MySQL 8
  3. MySQL 8 – Using Programs and utilities
  4. MySQL 8 Data Types
  5. MySQL 8 Database Management
  6. MySQL 8 Storage Engines
  7. Indexing in MySQL 8
  8. Replication in MySQL 8
  9. Partitioning in MySQL 8
  10. MySQL 8 – Scalability & High Availability
  11. MySQL 8 – Security
  12. Optimizing MySQL 8
  13. Extending MySQL 8
  14. MySQL 8 Best Practices & Benchmarking
  15. Troubleshooting MySQL 8
(HTML tags aren't allowed.)

Lectures on Quantum Mechanics
Lectures on Quantum Mechanics
This book is the “verbatim” transcription of the introductory lectures on quantum mechanics that I delivered for more than 25 years at the ´Ecole Polytechnique. It is not a textbook. I was dragged into writing it by friends, among whom are many former students of mine. For sure, this text is obviously less complete than a...
Eureka!: Physics of Particles, Matter and the Universe
Eureka!: Physics of Particles, Matter and the Universe
"... a concise, authoritative, well written review of physics, in all of its branches from Newton to Hawking ... has a truly excellent glossary ..." -- Australian & New Zealand Physicist

"... sets out the basic ideas of physics in a readable style which will commend itself to the general reader, high-school
Complete Idiot's Guide to Biblical Mysteries
Complete Idiot's Guide to Biblical Mysteries
The Bible is without a doubt one of the most significant and influential written works the world has ever seen. Despite thousands of years of study, the Bible's holy texts continue to instruct, inspire, challenge, and mystify. Tens of thousands of books have been written about the Bible in an attempt to make sense of its...

Dermatology Skills for Primary Care: An Illustrated Guide (Current Clinical Practice)
Dermatology Skills for Primary Care: An Illustrated Guide (Current Clinical Practice)

The diagnosis and treatment of common dermatologic problems is a critical area of skill and knowledge for primary care physicians. According to the US Department of 1 Health and Human Services, patients present to their physicians a skin rash as their chief concern for nearly 12 million office visits each year. In 73% of these office visits,...

Probability (Graduate Studies in Mathematics)
Probability (Graduate Studies in Mathematics)

This is a textbook for a one-semester graduate course in measure-theoretic probability theory, but with ample material to cover an ordinary year-long course at a more leisurely pace. Khoshnevisan's approach is to develop the ideas that are absolutely central to modern probability theory, and to showcase them by presenting their various...

Windows Server 2019 Automation with PowerShell Cookbook: Powerful ways to automate and manage Windows administrative tasks, 3rd Edition
Windows Server 2019 Automation with PowerShell Cookbook: Powerful ways to automate and manage Windows administrative tasks, 3rd Edition

A practical guide to Windows Server 2019 and PowerShell

Key Features

  • Use PowerShell to effectively configure and administer Windows Server 2019
  • Improve the performance of new features such as DevOps and containers using PowerShell
  • Enhance PowerShell's...
©2019 LearnIT (support@pdfchm.net) - Privacy Policy