Tag: Binary Log

Feed: Planet MySQL; Author: Dave Stokes;     MySQL has had replication for decades but the various options can be confusing.  One social media post I read recently could be summarized with the statement 'there are too many good options but how do I know which is right for me?'Cluster    Of all the words used in the computer related world, 'cluster' is the one that I wish we could have found a replacement for as the confusion over the word has created it's own cluster. Since MySQL has InnoDB Cluster and NDB cluster with other vendors using the word we end ... Read More

Feed: Planet MySQL; Author: MySQL Server Dev Team; This is part 3 of the blog post series about MySQL Shell Dump & Load: Introduced in MySQL Shell 8.0.21, the new MySQL Shell Dump and Load utilities has as its main goal to minimize the time needed to create and restore logical dumps of large data sets. Through heavy parallelization and other techniques, we were able to reduce the time needed for these tasks by an order of magnitude compared to previous dump utilities. In fact, we’ve observed dump speeds close to 3 GB/s and loads at over 200MB/s in benchmarks using ... Read More

Feed: Planet MySQL; Author: Oracle MySQL Group; As with any new releases, MySQL 8.0.21 introduces many new improvements and updates, many of which deserve their own blog post for a deep dive into the new features. Among the notable changes are: Account Management Notes, JSON Notes, Authentication Notes and changes related to InnoDB, Optimizer, Group Replication, and more. Here are the MySQL 8.0.21 top blog posts: Server: - The MySQL 8.0.21 Maintenance Release is Generally Available - MySQL 8.0 – Who stopped mysqld and how long did it take? - MySQL: who’s filling my error log? Shell: - MySQL Shell ... Read More

Feed: Planet MySQL; Author: Vlad Mihalcea; Introduction In this article, we are going to see how we can implement an audit logging mechanism using MySQL database triggers to store the old and new row states in JSON column types. Database tables Let’s assume we have a library application that has the following two tables: The book table stores all the books that are found in our library, and the book_audit_log table stores the CDC (Change Data Capture) events that happened to a given book record via an INSERT, UPDATE, or DELETE DML statement. The book_audit_log table is created like this: ... Read More

Feed: Planet MySQL; Author: MyDBOPS; In my previous Blog i have explained how we can integrate MySQL tools ( Percona Tool kit ) with systemd service, At Mydbops works with multiple clients ,we get various requirements from customers a few may be a complex ones ,one of the requirement was to setup a binlog server and copy the Production binlogs instantly . To satisfy customer request i have made a simple shell script and integrated in systemd service which does a similar job as of Maxscale Binlog Server ( Pervious blog ) In this blog i will explain how to ... Read More

Feed: Planet MySQL; Author: MySQL Server Dev Team; The MySQL Development Team is happy to announce a new 8.0 Maintenance Release of MySQL Shell AdminAPI – 8.0.21! As always, we have listened to the growing community of users and introduced a very useful feature for any production deployment of MySQL InnoDB cluster or ReplicaSet. Also, since we’re talking about a patch release, quality has been improved with several bugs fixed! MySQL Shell AdminAPI This release focused on introducing a tagging framework for the AdminAPI, which ultimately allowed us to introduce a very demanded feature: As usual, we would like to ... Read More

Feed: Planet MySQL; Author: Nuno Carvalho; Group Replication enables you to create fault-tolerant systems with redundancy by replicating the system state to a set of servers. Even if some of the servers subsequently fail, as long it is not all or a majority, the system is still available.This blog post will focus on the fact that after 8.0.21 you can use Group Replication with binary log event checksums turned on. Therefore, you do not have to explicitly set binlog-checksum=NONE before starting Group Replication. The fact that Group Replication supports binary log checksums makes archiving/backing up the binary logs more resilient ... Read More

Feed: Planet MySQL; Author: MySQL High Availability; There is a new MySQL 8.0 release and it has some interesting replication features. The change log is available at the usual place, MySQL 8.0.21, but let me give you a brief summary. Binary Log Checksums Support for Group Replication (WL#9038). This work done by Nuno Carvalho implements support for binary log checksums in Group Replication. Therefore the user can now utilize Group Replication with binary log checksums turned on.Specify Through Which Endpoints Recovery Traffic Flows in Group Replication (WL#13767). This feature implemented by Anibal Pinto allows the user to specify which endpoints ... Read More

Feed: Planet MySQL; Author: InsideMySQL.com; Dear MySQL users, MySQL Shell 8.0.21 is a maintenance release of MySQL Shell 8.0 Series (a component of the MySQL Server). The MySQL Shell is provided under Oracle’s dual-license. MySQL Shell 8.0 is highly recommended for use with MySQL Server 8.0 and 5.7. Please upgrade to MySQL Shell 8.0.21. MySQL Shell is an interactive JavaScript, Python and SQL console interface, supporting development and administration for the MySQL Server. It provides APIs implemented in JavaScript and Python that enable you to work with MySQL InnoDB cluster and use MySQL as a document store. The AdminAPI enables ... Read More

Feed: Planet MySQL; Author: Geir Hoydalsvik; The MySQL Development team is very happy to announce that MySQL 8.0.21 is now available for download at dev.mysql.com. In addition to bug fixes there are a few new features added in this release.  Please download 8.0.21 from dev.mysql.com or from the MySQL  Yum,  APT, or SUSE repositories. The source code is available at GitHub. You can find the full list of changes and bug fixes in the 8.0.21 Release Notes. Here are the highlights. Enjoy! InnoDB Add config option to disable redo log globally (WL#13795) This work by Debarun Banerjee adds support for ... Read More