Search icon CANCEL
Subscription
0
Cart icon
Cart
Close icon
You have no products in your basket yet
Save more on your purchases!
Savings automatically calculated. No voucher code required
Arrow left icon
All Products
Best Sellers
New Releases
Books
Videos
Audiobooks
Learning Hub
Newsletters
Free Learning
Arrow right icon
Arrow up icon
GO TO TOP
Advanced MySQL 8

You're reading from  Advanced MySQL 8

Product type Book
Published in Jan 2019
Publisher
ISBN-13 9781788834445
Pages 286 pages
Edition 1st Edition
Languages
Authors (3):
Eric Vanier Eric Vanier
Profile icon Eric Vanier
Birju Shah Birju Shah
Profile icon Birju Shah
Tejaswi Malepati Tejaswi Malepati
Profile icon Tejaswi Malepati
View More author details
Toc

Table of Contents (13) Chapters close

Preface 1. Introduction 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

Group replication

Group replication is a MySQL server plugin. It helps us create a replication topology that has the following attributes:

  • Elasticity: On-demand resource allocation/reallocation
  • Fault tolerance: Ability to withstand up to n failures
  • High availability: Systems or services will be available for a longer period of time without failures, or, in some cases, available for a longer period of time, which is more than the agreeable time without failures

It achieves this by implementing Paxos protocol (Mencius ) to support the multi-master facility, which allows applications to write on all servers of the same group at the same time while maintaining consistency through conflict detection and resolution mechanisms. It achieves this by implementing replicating databases with state machine fundamentals. It has built-in modules to support distributed recovery across all platforms...

lock icon The rest of the chapter is locked
Register for a free Packt account to unlock a world of extra content!
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
Renews at $15.99/month. Cancel anytime