(Nuno Carvalho) The multi master plugin for MySQL is here. MySQL Group Replication provides virtually synchronous updates on any node in a group of MySQL servers, with conflict handling and automatic group membership management and failure detection.
Tag: Open Source
InnoDB Native Partitioning – Early Access
(Mattias Jonsson) The InnoDB labs release includes a snapshot of the InnoDB Native Partitioning feature.
WAIT_FOR_EXECUTED_GTID_SET for MySQL Replication
(manish) With the introduction of Global Transaction Identifiers(GTID) in MySQL from mysql-5.6 GA a whole lot of different functionality have been developed around it so that GTID could be used in a much simpler and efficient way.
Visualizing the impact of ordered vs. random index insertion in InnoDB
(Jeremy Cole) Many DBAs know that building indexes in “random” order (or really any order that greatly differs from ordered by key) can be much less efficient. However, it’s often hard to really understand why that is.
Transaction Retry Is Available On Multi-Threaded Slave
(Libing.Song) I am happy to announce that slave_transaction_retries is available on multi-threaded slave now. You will no longer see the warning that slave_transaction_retries is not supported by multi-threaded slave since MySQL-5.7.5.
Is the HTTP Plugin for MySQL secure?
(Ulf Wendel) The HTTP Plugin for MySQL offers three APIs: REST-like CRUD, REST-like JSON DOCUMENT and SQL. The SQL API lets you run any SQL you want. Including, for example, DROP mysql.users if you mess up your setup. Insecure? It depends on your viewpoint.
Getting started with MySQL Group Replication
(Pedro Gomes) The multi master plugin for MySQL is here. MySQL Group Replication ensures virtual synchronous updates on any node in a group of MySQL servers, with conflict handling and failure detection. Distributed recovery is also in the package to ease the process of adding new nodes to your serv
The Query Rewrite Plugins
(Martin Hansson) Now that the cost model project is progressing, most of you are going to notice execution plan changes. In the vast majority of the cases, the changes will be for the better, and some bugs with a long history will finally be closed.
MySQL Group Replication: A small Corosync guide
(Pedro Gomes) MySQL Group Replication is here and with it comes the need to install and configure the underlying group communication toolkit that supports it: Corosync. Corosync is a well known and reliable Group Communication System that is used in such applications as Pacemaker.
How to deal with MySQL deadlocks
(Peiran Song) A deadlock in MySQL happens when two or more transactions mutually hold and request for locks, creating a cycle of dependencies. In a transaction system, deadlocks are a fact of life and not completely avoidable. InnoDB automatically detects transaction deadlocks, rollbacks a transacti
