Subscription

Explore Products

Best Sellers

New Releases

Books

Videos

Audiobooks

Learning Hub

Conferences

Free Learning

You're reading from MySQL 8 Administrator???s Guide Effective guide to administering high-performance MySQL 8 solutions

Product type Paperback

Published in Feb 2018

Publisher Packt

ISBN-13 9781788395199

Length 510 pages

Edition 1st Edition

Languages

SQL

Tools

MySQL

Concepts

Database Administration

Authors (3):

Chintan Mehta

Hetal Oza

Subhash Shah

View More author details

Table of Contents (17) Chapters

Preface

1. An Introduction to MYSQL 8 FREE CHAPTER

2. Installing and 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 and High Availability

11. MySQL 8 – Security

12. Optimizing MySQL 8

13. Extending MySQL 8

14. MySQL 8 Best Practices and Benchmarking

15. Troubleshooting MySQL 8

16. Other Books You May Enjoy

Leave a review - let other readers know what you think

Summary

To choose the proper software with its version for development is an important phase, right? In this chapter, we understood how to select the proper version of MySQL 8 by understanding its version pattern. We also learned the execution steps of MySQL 8 installation using the installer and command line in Microsoft Windows. For the Linux platform, we installed MySQL 8 using the Yum repository, RPM package, and Debian package. Post-installation describes the basic configuration to start with MySQL 8. Finally, we explained how to upgrade and downgrade from MySQL 8 with execution steps.

In the next chapter, we will learn about various programs and utilities available for MySQL 8. It mainly focuses on how to use these programs for MySQL 8 along with command-line executions.

The rest of the chapter is locked

A free Packt account unlocks extra newsletters, articles, discounted offers, and much more. Start advancing your knowledge today.

Unlock this book and the full library FREE for 7 days

Get unlimited access to 7000+ expert-authored eBooks and videos courses covering every tech area you can think of

Start free trial

Renews at $19.99/month. Cancel anytime

Authors (3)

Mehta

Chintan Mehta is a co-founder of KNOWARTH Technologies and heads the cloud/RIMS/DevOps team. He has rich, progressive experience in server administration of Linux, AWS Cloud, DevOps, RIMS, and on open source technologies. He is also an AWS Certified Solutions Architect. Chintan has authored MySQL 8 for Big Data, Mastering Apache Solr 7.x, MySQL 8 Administrator's Guide, and Hadoop Backup and Recovery Solutions. Also, he has reviewed Liferay Portal Performance Best Practices and Building Serverless Web Applications.

See other products by Mehta

Oza

Hetal Oza an MCA from a reputable institute of India, is working as a lead consultant at KNOWARTH Technologies. She has rich experience in Java-based systems with various databases. Her 10 years of experience covers all stages of software development. She has worked on development of web-based software solutions on various platforms. She has good exposure to integration projects with web-service-based and thread-based architecture. Her knowledge is not bound to any single field because she has worked on wide range of technologies and tools.

See other products by Oza

Subhash Shah

Subhash Shah is an experienced solution architect. With 14 years of experience in software development, he works as an independent technical consultant now. He is an advocate of open source development and its utilization in solving critical business problems. His interests include Microservices architecture, Enterprise solutions, Machine Learning, Integrations and Databases. He is an admirer of quality code and test-driven development (TDD). His technical skills include translating business requirements into scalable architecture and designing sustainable solutions. He is a co-author of Hands-On High Performance with Spring 5, Hands-On AI for Banking and MySQL 8 Administrator's Guide. He has also been a technical reviewer for other books.

See other products by Subhash Shah