Tag: replication

Feed: MariaDB Knowledge Base Article Feed. Author: . MariaDB replication can be used to replication between MariaDB Galera Cluster and MariaDB Server. This article will discuss how to do that. Configuring the Cluster Before we set up replication, we need to ensure that the cluster is configured properly. This involves the following steps: Configuring Wsrep GTID Mode If you want to use GTID replication, then you also need to configure some things to enable wsrep GTID mode. For example: wsrep_gtid_domain_id needs to be set to the same value on all nodes in the cluster, so that each cluster node uses ... Read More

Feed: Planet MySQL; Author: João Gramacho; Starting in version 8.0.14, MySQL server can encrypt all new binary and relay log files on disk. In order to do so, you just need to enable the new binlog_encryption option (and also ensure that you have a keyring). Once enabling the option in a client session, the server will rotate both binary and relay logs to start using a new encrypted binary log file format. Only the data at rest is encrypted. The replication stream sent to replicas (and to mysqlbinlog client program) wasn’t changed. First of all, you need to have keyring ... Read More

Feed: Planet PostgreSQL. I’ve come across this scenario maybe twice in the past eight years of using Streaming Replication in Postgres: replication on a standby refuses to proceed because a WAL file has already been removed from the primary server, so it executes Plan B by attempting to fetch the relevant WAL file using restore_command (assuming that archiving is set up and working properly), but upon replay of that fetched file, we hear another croak: “No such file or directory.” Huh? The file is there? ls shows that it is in the archive. On and on it goes, never actually ... Read More

Feed: Planet MySQL; Author: MySQL Server Dev Team; As listed in the release announcement of the latest MySQL InnoDB Cluster release, 8.0.14 brings exciting new features! This blog post is the first of a series detailing every single new feature added, starting by: “Changing cluster topology modes ‘live‘”. Cluster topology modes The AdminAPI provides the means to create an InnoDB cluster to run on single-primary mode or multi-primary mode. By default, a cluster setup runs in single-primary mode, i.e. the cluster has a single-primary server that accepts read and write queries (R/W), meanwhile all the remaining members accept only read ... Read More

Feed: Planet MySQL; Author: MySQL High Availability; MySQL 8.0.14 is out and it contains some new and very interesting replication enhancements. As always, we are very pleased to share with you the details about the exciting new features in this release. This blog post will provide you a summary of the features and subsequent blog posts will dive into the mechanics and details of each one. Without further ado, here is the list: Binary Log Encryption at Rest. The binary and relay logs can now be encrypted when stored on disk. Encryption is opt-in and can be enabled through the ... Read More

Feed: Planet MySQL; Author: MySQL Server Dev Team; The MySQL Development team is proud to announce a new version of the MySQL Shell which includes the following features: Support for importing BSON data. Ability to show column type information when executing SQL. Addition of command line options to lower the verbosity when the shell starts. Improved InnoDB Cluster support by enhancing the Admin API to support new features provided by Group Replication. For additional details look at MySQL InnoDB Cluster – What’s new in the 8.0.14 (GA) release. Improved the Upgrade Checker utility to: Support upgrades to MySQL 8.0.14. Provide instructions ... Read More

Feed: Planet MySQL; Author: InsideMySQL.com; Dear MySQL users, MySQL Shell 8.0.14 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.14. 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 you ... Read More

Feed: Planet MySQL; Author: Geir Hoydalsvik; The MySQL Development team is very happy to announce that MySQL 8.0.14 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.14 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.14 Release Notes. Here are the highlights. Enjoy! SQL Lateral derived tables  (WL#8652)  This work by Guilhem Bichot adds support for SQL:99 feature T491 “lateral derived ... Read More

Feed: Planet MySQL; Author: MySQL Server Dev Team; The MySQL Development Team is very happy to announce a new 8.0 Maintenance Release of InnoDB Cluster – 8.0.14! In addition to bug fixes, 8.0.14 brings exciting new features! MySQL Shell For this release, we have focused on extending the AdminAPI with several highly desired features. But also, as always, we have extended it to support every new Group Replication feature. On top of that, quality has been greatly improved with many bug fixes addressed. Here are the highlights of this release: Changing cluster topology modes “live” Checking current cluster configuration options ... Read More

Feed: Planet MySQL; Author: Valeriy Kravchuk; Slides for my talk about MySQL bugs at FOSDEM 2019 MySQL, MariaDB and Friends Devroon are ready, support customers decided not to break anything badly on weekend, so I have some free time for blogging.  As usual, when I do not have any better idea or useful recent real life experience to share I write about MySQL bugs.Today I'd like to continue my review of interesting MySQL bug reports added by Community members in December, 2018. I'll review them starting from the oldest:Bug #93701 - "Assertion `maybe_null' failed |Item_func_concat::val_str(String*)". It's debug assertion, not a big ... Read More