… errors in the log parser or bad changed page data. Bug fixed #1108613 (Laurynas Biveinis). … event that a slave was disconnected from the master, under certain conditions, upon reconnect, it would … (Alexey Bychko). Percona Server for MySQL was missing help texts in the MySQL client because the help …
Post: 5 Percona Toolkit Tools for MySQL That Could Save Your Day: April 3 Webinar
March 22, 2013 By Leave a Comment
… on the master pt-stalk, to gather data when performance problems happen randomly or are very short pt-online-schema-change, to run ALTER TABLE statements on large tables without downtime You can reserve your spot for this free MySQL webinar… on “5 Percona Toolkit Tools for MySQL That Could Save Your Day”Percona Toolkit for MySQL is a must-have set of…
Post: Percona XtraDB Cluster 5.5.30-23.7.4 for MySQL now available
April 17, 2013 By 2 Comments
…. Bug fixed #1130888 (Seppo Jaakola). If MySQL replication threads were started before running wsrep… (Seppo Jaakola). Conflicting prepared statements in multi-master use case could cause node to hang…/clustercheck script would get overwritten, and any changes (such as username and password) would be…
Post: Is Synchronous Replication right for your app?
May 14, 2013 By 18 Comments
… MySQL replication from this instance, since MySQL replication is asynchronous. What about semi-sync MySQL replication… count = $last_count where achievement = ‘killed_troll’”; } change your schema In Example 2, above, … it’s caught up with the master?). Synchronous replication with PXC and Galera …
Post: Galera Flow Control in Percona XtraDB Cluster for MySQL
May 2, 2013 By 5 Comments
… can be behind committing transactions from the cluster. gcs.fc_master_slave The fc_limit is modified dynamically if you have… feature by setting fc_master_slave=YES. Despite its name, this setting really does no more than to change if the fc… control in a master/slave cluster might be: mysql> set global wsrep_provider_options=”gcs.fc_limit=500; gcs.fc_master_slave=YES…
Post: Announcing Percona XtraBackup 2.1.1 GA
May 15, 2013 By Leave a Comment
…. innobackupex now uses Perl’s DBD::MySQL package for server communication instead of spawning the MySQL command line client. Support for InnoDB… can use XtraDB changed page tracking feature to perform the Incremental Backups now. Bugs Fixed: innobackupex is using SHOW MASTER STATUS to…
Post: Percona Server 5.5.30-30.2 rerelease fixes non-restart issue
April 24, 2013 By Leave a Comment
… errors in the log parser or bad changed page data. Bug fixed #1108613 (Laurynas Biveinis). … event that a slave was disconnected from the master, under certain conditions, upon reconnect, it would … (Alexey Bychko). Percona Server for MySQL was missing help texts in the MySQL client because the help …
Post: How to create/restore a slave using GTID replication in MySQL 5.6
February 8, 2013 By 7 Comments
… to know in which GTID is the master and set it on the slave. MySQL keeps two global variables with GTID numbers… method of GTID: slave1 > CHANGE MASTER TO MASTER_HOST=”127.0.0.1″, MASTER_USER=”msandbox”, MASTER_PASSWORD=”msandbox”, MASTER_PORT=18675, MASTER_AUTO_POSITION = 1; How… 1236 from master when reading data from binary log: ‘The slave is connecting using CHANGE MASTER TO MASTER_AUTO_POSITION = 1, but the master has…
Post: How SHOW SLAVE STATUS relates to CHANGE MASTER TO
July 7, 2008 By 21 Comments
…MASTER STATUS has Master_Log_File value and CHANGE MASTER TO accepts Master_Log_File parameter, while you actually want to use Relay_Master…
Post: Percona Replication Manager, a solution for MySQL high availability with replication using Pacemaker
November 29, 2011 By 102 Comments
…” nic=”eth0″ \ meta target-role=”Started” ms ms_MySQL p_mysql \ meta master-max=”1″ master-node-max=”1″ clone-max=”3″ clone-node… MySQL unix socket file replication_user: The user to use when setting up replication. It is also currently used for the ‘CHANGE MASTER TO’ command, something that should/will change in the future replication_passwd: The password…
