Tag: Binary Log

Feed: Clustrix Blog. Author: Ralf Gebhardt. We are pleased to announce the release of MariaDB Community Server 10.5.2, the second and final beta release. It is now available for download at MariaDB Downloads.The release of MariaDB Community Server 10.5.2 continues our policy of yearly releases to enable user access to new features, with following Generally Available (GA) releases that are focused on maintenance. We encourage you to add MariaDB Server into your staging environment, so you can begin reviewing and testing the new features of MariaDB Community Server 10.5. Changes to binary file paths As we detailed in 2019, MariaDB ... Read More

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: Sri Sakthivel Durai Pandian; Few months back , I came to know about the tool Binlog2sql . The tool has very cool features like . The tool can extract SQL’s from MySQL Binary log .The tool can generate the rollback SQL’s for PITR .In this blog, I am going to explain, how the above two features can be achieved using the tool binlog2sql . Installation : The tool has been developed by Mr. Cao Danfeng . Great Job Mr. Cao Dancing . The tool can be downloaded from the GitHub . https://github.com/danfengcao/binlog2sql git clone https://github.com/danfengcao/binlog2sql.gitcd binlog2sqlpip ... Read More

Feed: Planet MySQL; Author: Valeriy Kravchuk; I may get a chance to speak about proper bugs processing for open source projects later this year, so I have to keep reviewing recent MySQL bugs to be ready for that. In my previous post in this series I listed some interesting MySQL bug reports created in December, 2019. Time to move on to January, 2020! Belated Happy New Year of cool MySQL Bugs!As usual I mostly care about InnoDB, replication and optimizer bugs and explicitly mention bug reporter by name and give link to his other active reports (if any). I also ... Read More

Feed: Planet MySQL; Author: Severalnines; A master/slave replication cluster setup is a common use case in most organizations. Using MySQL Replication enables your data to be replicated across different environments and guarantees that the information gets copied. It is asynchronous and single-threaded (by default), but replication also allows you to configure it to be synchronous (or actually “semi-synchronous”) and can run slave thread to multiple threads or in parallels. This idea is very common and usually arrives with a simple setup, making its slave serving as its recovery or for backup solutions. However, this always comes to a price especially ... 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: MySQL High Availability; MySQL 8.0.19 introduces Binlogless replicas with commit ordering which means you can deploy asynchronous replicas without binary logs enabled, and commit transactions in the same order they are replicated in. Yes, you can disable binlog (skip-log-bin) and the logging of changes done by the applier (log-slave-updates=FALSE) while at the same preserve commit order (slave-preserve-commit-order=TRUE). Among other things, preserving commit order can be useful for those relying on WRITESET-based dependency tracking for aggressive transaction parallelization. So, now on your replicas that have no binary logs, you can make use of both parallel worker threads ... 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

Feed: Planet MySQL; Author: MyDBOPS; We will have a look at a new feature in MySQL 8.0 called binlog encryption. This feature is available from the MySQL version 8.0.14 or above. Our previous blogs discussed about table space encryption in MySQL and Percona servers. In Mydbops, we are giving high importance about achieving security compliances. The binary log records changes made to the databases so that it can be used to replicate the same to the slaves and also for the point in time recovery (PITR). So, it means that if someone has access to the binary logs, they can ... Read More

Feed: MariaDB Knowledge Base Article Feed. Author: . MariaDB supports the following types of replication: Asynchronous replication. Semi-synchronous replication. Galera Cluster. Asynchronous Replication The original MariaDB replication system is asynchrounous master-slave replication. A master needs to have the binary log enabled. The master logs every data change in the binary log. Every event (a binary log entry) is sent to all the slaves. The events can be written in two formats: as an SQL statement (statement-based replication, or SBR), or as a binary representation of the change (row-based replication, or RBR). The generally slower, because the statement needs to be ... Read More