Explore Products

Best Sellers

New Releases

Books

Videos

Audiobooks

Learning Hub

Free Learning

You're reading from Advanced MySQL 8 Discover the full potential of MySQL and ensure high performance of your database

Product type Paperback

Published in Jan 2019

Publisher

ISBN-13 9781788834445

Length 286 pages

Edition 1st Edition

Languages

SQL

Tools

MySQL

Concepts

Database Administration

Authors (3):

Birju Shah

Eric Vanier

Tejaswi Malepati

View More author details

Table of Contents (13) Chapters

Preface

1. Introduction FREE CHAPTER

2. MySQL 8's New Features

3. Indexing Your Data for High Performance

4. Advanced Data Techniques for Large Queries

5. MySQL Data Dictionary in MySQL 8.0

6. MySQL Server Settings

7. Group Replication in MySQL 8.0

8. InnoDB Cluster in MySQL 8.0

9. Monitoring Your Large Distributed Databases

10. Authentication and Security Management with MySQL 8.0

11. Advanced MySQL Performance Tips and Techniques

12. Other Books You May Enjoy

Leave a review - let other readers know what you think

Navicat

Initially released in 2002 by PremiumSoft CyberTech Ltd., Navicat is a series of graphical database management and development software. This tool can be used with MariaDB, SQLite, MySQL, Oracle, PostgreSQL, and Microsoft's SQL Server. Navicat supports connections across multiple databases and their monitoring.

The software has been designed so that it's able to cater for a large audience. The company wants it to be used not only by other enterprises but even by database administrators and programmers from businesses or companies of various sizes. Navicat for MySQL also offers a 14-day fully functional free trial and has pre-made packages available for Windows, macOS, and Linux. Navicat for MySQL installs with the help of installers, like any other software:

After installation, a window opens from which even an amateur can figure out what goes where. All that...

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)

Vanier

Eric Vanier is one of the few DBAs worldwide specializing in MySQL performance, and is an expert with large architectures such as those for Air Miles, Cogeco, McGill University, Bombardier Aerospace, and many more. As a senior DBA and instructor for 18 years, he has a track record in performance and troubleshooting on dozens of high-profile MySQL systems, including complex cluster environments.

See other products by Vanier

Malepati

Tejaswi Malepati is the Cassandra Tech Lead for Target. He has been instrumental in designing and building custom Cassandra integrations, including a web-based SQL interface and data validation frameworks between Oracle and Cassandra. Tejaswi earned a master's degree in computer science from the University of New Mexico, and a bachelor's degree in electronics and communication from Jawaharlal Nehru Technological University in India. He is passionate about identifying and analyzing data patterns in datasets using R, Python, Spark, Cassandra, and MySQL.

See other products by Malepati

Shah

Snehal Shah has extensive experience in implementing enterprise web applications using J2EE technologies. He is the co-founder of Techforce Infotech where he has worked on various J2EE based solutions, various open source product customizations, and worked on business expansion. He was also involved in building a team and finalizing the technology path for the organization. At his previous employer, CIGNEX Datamatics, he rolled out numerous Alfresco deployments worldwide in the areas of document management, web content management, and Share. He has also worked on application-based Liferay and Moodle products. Prior to CIGNEX, he has worked on various J2EE-based solutions using cutting edge technologies. He has worked with clients in education, legal, and marketing domains across the world. He has worked on defining architecture for various projects, which involves multiple product integrations. In his previous organizations, he was involved in deciding the technology path of the organization and was also involved in various internal technical training. He holds a Bachelors Degree in Computer Engineering from Deemed University, DDIT India. He has also worked as a Technical Reviewer for the books Alfresco 3 Cookbook and Alfresco Share.

See other products by Shah