… production you should put the cluster in maintenance mode before the update, see bellow how to perform this action [root@percona1 percona.../cman And create the cluster, perform the following command on one server only: [root@percona1 ~]# ccs -f /etc/cluster/cluster.conf –createcluster lefred_prm…
Post: Choosing a MySQL HA Solution - Post-Webinar Q&A
June 7, 2013 By Leave a Comment
… actual physical volume. So, in effect, you’re adding performance hit to performance hit. The other reason is because virtual machines tend… that I question its readiness. There have been some unfortunate performance regressions compared to 5.5, such as bug #69258, and… on top of a clustered filesystem with an external lock manager. You might say that MySQL/NDB Cluster is also somewhat similar…
Post: The small improvements of MySQL 5.6: Duplicate Index Detection
May 31, 2013 By Leave a Comment
… InnoDB Fulltext, Memcached integration, a more complete performance schema, online DDL and several other ….test # ######################################################################## # Key redundant ends with a prefix of the clustered index # Key definitions: # KEY `redundant` (`col2`,`id`) #…
Post: Percona XtraBackup 2.1.3 for MySQL available for download
May 22, 2013 By 3 Comments
… if you’re using the Percona XtraBackup with Percona XtraDB Cluster. This release is the latest stable release in the 2…. Bug Fixed: Percona XtraBackup 2.1.2 would hang when performing State Snapshot Transfer. Bug fixed #1182698. Release notes with all… all versions of Percona Server, MySQL, MariaDB, and Drizzle. It performs streaming, compressed, and incremental MySQL backups. Percona’s enterprise-grade…
Post: Percona MySQL University @Portland next Monday!
June 12, 2013 By Leave a Comment
…-Founder and CTO, will talk about Percona XtraDB Cluster, Percona Xtrabackup and Performance and Improvements and new Features in MySQL 5.6…
Post: Replication in MySQL 5.6: GTIDs benefits and limitations - Part 2
May 30, 2013 By 6 Comments
… to s2. This scenario can happen when you want to perform a planned failover. With GTIDs, all the operations are straightforward… the ideas of GTIDs: having for each event across the cluster a monotonically incremental identifier for each event. Notice that this…
Post: Percona Server for MySQL 5.5.31-30.3 now available
May 24, 2013 By Leave a Comment
… #1174426. Fixed the Percona-Server-shared-55 and Percona-XtraDB-Cluster-shared RPM package dependences. Bug fixed #1050654. Fixed the upstream…-2012-5627 vulnerability, where an unprivileged MySQL account owner could perform brute-force password guessing attack on other accounts efficiently. This…
Post: Follow these basics when migrating to Percona XtraDB Cluster for MySQL
May 1, 2013 By 10 Comments
… similar to Percona XtraDB Cluster in that if you want an async event replicated to the whole cluster you have to have… Not Even Work! MyISAM tables are supported within Percona XtraDB Cluster, however, MyISAM has only basic support, primarily because the storage…, and because cluster performance is somewhat dependent on the slowest node – this overhead can easily become visible on the whole cluster and your…
Post: Galera Flow Control in Percona XtraDB Cluster for MySQL
May 2, 2013 By 5 Comments
… based on the number of nodes in the cluster. The more nodes in the cluster, the larger the calculated fc_limit becomes… other magic that helps single node writing in PXC to perform better. gcs.fc_factor If fc_limit controls when flow… limits the amount of delay any node in the cluster might have applying cluster transactions. Therefore, it keeps reads more up to…
Post: Percona XtraDB Cluster 5.5.30-23.7.4 for MySQL now available
April 17, 2013 By 2 Comments
… area or from our software repositories. New Features: Percona XtraDB Cluster has implemented initial implementation of weighted quorum. Weight for node… of memory allocators on MySQL performance can be found in this blogpost. This release of Percona XtraDB Cluster has fixed number of… and #1132934 (Raghavendra D Prabhu). When upgrading the Percona-XtraDB-Cluster-server package, /usr/bin/clustercheck script would get overwritten, and…
