Tag: Group Replication

Feed: Planet MySQL; Author: Sri Sakthivel Durai Pandian; We know well the MySQL Group Replication cluster is functionally working based on the GTID . GTID is mandatory for group replication . Usually, GTID is the combination of source_id ( or server_uuid ) and transaction_id . Do you think the same approach is following in the MySQL Group Replication as well ? Well, this blog mainly going to focus on the below three topics . How the binary log GTID events are being generated in the normal MySQL instance ?How the binary log GTID events are being generated in the MySQL ... Read More

Feed: Planet MySQL; Author: Valeriy Kravchuk; With conferences cancelled or postponed and people forced to stay at home due to COVID-19 wide spreading, what can be better than to give my readers a new list of MySQL bugs to check? Useful reading should help! So today I continue my previous post with a quick review of bugs I've subscribed to in February, 2020, while things were still going as usual for most of us...Here is the list of InnoDB, replication, optimizer and some other bugs to note while working with recent MySQL 5.7.x and 8.0.19 releases:Bug #98473 - "group replication will ... Read More

Feed: Planet MySQL; Author: MyDBOPS; This blog is about one of the issues encountered by our Remote DBA Team in one of the production servers. We have a setup of MySQL 5.7 Single Primary (Writer) GR with cluster size of  3 . Due to OOM, the MySQL process in the primary node got killed, this repeated over the course of the time. We all know about the OOM (out of memory), theoretically, it is a process that the Linux kernel employs when the system is critically low on memory. In a dedicated DB server, when the OOM triggers the direct ... Read More

Feed: Planet MySQL; Author: Frederic Descamps; What a great event ! I got very positive feedback for this extended preFOSDEM MySQL Day 2020. Before my summary, I wanted to thank again all speakers and attendees. Without you this event won’t even exist. And thank you to ICAB for hosting us yet another time ! As you may know, we had 2 parallel tracks for 2 consecutive days. We had very valuable technical content from the MySQL developers and also from the external community members who talked about their favorite database. There was a large interest in MySQL NDB Cluster and ... Read More

Feed: Planet MySQL; Author: Frederic Descamps; Last week, we had two exceptional preFOSDEM MySQL Days in Brussels. A lot of MySQL Engineers presented their work but also different MySQL Users. I will publish soon an overview of the two days, but today let me share with you an interview I did with Giedrius Jaraminas, engineering manager of MySQL team in Uber. “MySQL is heart of the Uber infrastructure“, this is how Giedrius started his presentation “Group Replication in Uber“. The interview: Q1: Tell us about yourself, and your experience with  MySQL A1:  I am a database guy for 28 years, ... Read More

Feed: Planet MySQL; Author: Dave Stokes; You can now earn your MySQL 8.0 DBA Certification Exam is now available. It is Oracle Exam 1Z0-908 and I was one of the many question writers.  Some of you may remember when I was the head of MySQL Certification and I can assure you this is a very complete test of all your MySQL DBA skills. And it asks very relevant questions and not trivial facts. So anyone taking this exam and earning this certification really knows their MySQL!So what do you need to know:ArchitectureConfigure client connections to the server Understand how MySQL stores ... Read More

Feed: Planet MySQL; Author: Frazer Clement; My post-FOSDEM detox has started - despite preparing by reading some survival guides, I hadn't really fathomed the variety and quantity (and quality) of beer that would flow over four days.  On reflection however, the beer flow has been far exceeded by the flow of tech content and conversation.On Thursday and Friday I attended the pre-FOSDEM MySQL Days fringe event, where there were two tracks of talks and tutorials on MySQL including sessions on : - MySQL Server simplification - MySQL replication tooling improvements - Configuring group replication - Troubleshooting group replication - Using DNS for loadbalancing and failover - ... Read More

Feed: Planet MySQL; Author: Ivan Ma; This is the tutorial and serves as a sample ONLY.  Every environment can be different.  It is a test trial for the Upgrade MySQL InnoDB Cluster with version 5.7.25 to MySQL 8.0.19 where the MySQL InnoDB Cluster Metadata has changed from V1 to V2 in 8.0.19. 1.      Assuming the following SETUP            i.              MySQL Server 5.7.25           ii.              MySQL Shell : 8.0.15         iii.              MySQL Router : 8.0.15 2.      3 nodes are running on the same machine for this tutorial            i.              Port : 3310, 3320 and 3330           ii.              Hostname : primary   (or ... Read More

Feed: Planet MySQL; Author: Ted Wennmark; Introduction to InnoDB ClusterIf you have not heard about MySQL InnoDB Cluster MySQL, InnoDB Cluster is a built-in high-availability solution for MySQL. The key benefit over old high-availability solutions is that InnoDB Cluster is built into MySQL and supported on all platforms where MySQL is supported.The key components of MySQL InnoDB Cluster: - MySQL Group Replication - MySQL Shell - MySQL RouterMySQL Group Replication is a plugin that makes sure that; data is distributed to all nodes, conflicts are handled and also handle recovery. MySQL Shell makes is easy to configure and administer your InnoDB ... Read More

Feed: Planet MySQL; Author: Jean-François Gagné; In my previous post (Puzzled by MySQL Replication), I describe a weird, but completely documented, behavior of replication that had me scratching my head for hours because it was causing data corruption.  I did not give too many details then as I also wanted allowing you to scratch your head if you wished.  In this post, I describe this behavior in more details. But first I need to apologize to my readers: I was planning to release this post a few days after the previous one and it took me more time to finalize ... Read More