|Showing entries 1 to 10 of 33180||10 Older Entries|
More MySQL releases than ever before. Check out the following that we just released:
- MySQL Connector Java 5.1.33 GA
- MySQL Fabric & MySQL Utilities 1.5.2 GA
- MySQL Connector Python 2.0.1 GA
- MySQL Fabric and Utilities 1.6.0 Alpha
- MySQL Connector C (Labs)
- MySQL Connector Python (Labs)
- MySQL Group Replication (Labs)
- MySQL HTTP Plugin (Labs)
Percona is pleased to announce the availability of Percona Toolkit 2.2.11. Released on Sept. 25, Percona Toolkit is a collection of advanced command-line tools to perform a variety of MySQL server and system tasks that are too difficult or complex for DBAs to perform manually. Percona Toolkit, like all Percona software, is free and open source.
This release contains bug fixes for pt-query-digest, pt-mysql-summary, pt-stalk, as well as other tools and is the current GA (Generally Available) stable release in the 2.2 series. Downloads are available[Read more...]
The multi master plugin for MySQL is here “MySQL Group Replication“. It is a virtual synchronous solution for MySQL with conflict detection. It also supports automatic group membership management, failure detection and automatic distributed recovery.
With the introduction of this new feature there was a need to perform some good amount of testing as it involves complex functionalities like :
So a great deal[Read more...]
Multi-master update everywhere solution 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.
Starting with MySQL 5.7.2 there has been a constant effort from the replication team to provide more fields to monitor the replication performance in the performance schema tables. This post gives a brief overview of the Performance Schema tables that have been introduced for MySQL Group Replication.TABLES INTRODUCED
There are two new tables introduced as a part of the MySQL Group Replication monitoring.
Lets go through each table in detail :[Read more...]
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.
One of the interesting functionality with GTID in use is the function to sync a slave with its
master server using the WAIT_UNTIL_SQL_THREAD_AFTER_GTIDS. This is used to do a timed or an indefinite wait till the servers in contention are in sync with respect to the GTID executed set.
This function is used to address specific use cases in which transactions are applied using SQL/worker thread. In order to give more flexibility to the user a new function of syncing the servers with GTID has been introduced in mysql-5.7.5 called WAIT_FOR_EXECUTED_GTID_SET.Limitations of WAIT_UNTIL_SQL_THREAD_AFTER_GITDS
The already existing[Read more...]
On MySQL-5.7.2, we released a new type of multi-threaded slave (MTS). It is called logical clock based MTS. Because it can parallel apply transactions in the same schema, it has the potential to improve slave throughput on almost any application, regardless of the schema layout. After it was released, we continued to work on the framework to improve it further. Therefore, 5.7.5 includes a few enhancements, in addition to those released as part of previous DMRs. This blog post introduces one of the new features in the latest DMR.
It is a system global variable and can be set dynamically.
Enabling this variable ensures that the order which transactions were committed on the master is preserved on the slave. The replication threads must be stopped[Read more...]
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.
Multi-threaded slave and single-threaded slave share the system variable slave_transaction_retries and they have similar transaction retry logic. So this blog just brings you a little new knowledge and then refresh you with the transaction retry logic.
For multi-threaded slave, Transaction retry is done in worker threads when they are applying their transactions. When a worker thread encounters a temporary error, it needs to read the transaction’s events from relay log by itself and then apply them again.
The only new thing is that worker threads need to read events[Read more...]
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 server group.
How do you start? Just sit back, download MySQL Group Replication from http://labs.mysql.com/ and then let us begin this journey into the world of multi master MySQL.
Under its hood, the multi master plugin is powered by a group communication toolkit. This is what decides which nodes belong to the server group, performs failure detection and orders server messages. This last being the magic thing that allows the data to be consistent across all nodes.
As of now we rely on the[Read more...]
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.
In term of support, we develop MySQL Group Replication based on Corosync version 1.4.6, so this tutorial is based on this version. Regardless of this, no known problems are know to exists when using newer versions, but no extensive testing has been done on those.
Along with Corosync we also encourage the use of NSS to better secure your data that is transmitted in the group.
To install Corosync, you can rely on your packet manager for most distributions or compile it from source.
==> From the package manager
|Showing entries 1 to 10 of 33180||10 Older Entries|