Subscription

Explore Products

Best Sellers

New Releases

Books

Videos

Audiobooks

Learning Hub

Conferences

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

2. MySQL 8's New Features FREE CHAPTER

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

Limitations of group replication

The following is a list of limitations for group replication:

Group replication works on top of a GTID-based replication, and it depends on transactions. So, we need tables with the InnoDB storage engine, which has transaction support.
CREATE TABLE...SELECT statements are not allowed, because the binlog_format maybe different on the master and slave. If the format is set to STATEMENT, the binary log will have one transaction with one GTID. If the format is set to ROW, the CREATE_TABLE..SELECT statement would result as two transactions with two GTIDs.
When the binary log format is set to STATEMENT, the creation of temporary tables and dropping temporary tables cannot be used inside transactions, functions, or triggers when we use GTID-based replication with auto commit set to 1. From MySQL 8.0.13, if the binary log format is set to ROW or MIXED...

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 €18.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