June 19, 2013

Comment: Making the impossible: 3 nodes intercontinental replication

… -y install Percona-XtraDB-server Percona-XtraDB-client right BEFORE: yes | yum -y install Percona-XtraDB-Cluster-server Percona-XtraDB-Cluster-client and then the mysql_install_db will be installed

Comment: Percona-XtraDB version 9.1

… easily install it with MySQL-shared-compat-5.1.40-2 package. I.e. once you installed Percona-XtraDB-server and Percona-XtraDB-client, install MySQL-shared-compat-5.1.40-2. Then “yum install php-mysql” will work.

Post: Announcing Percona XtraDB Storage Engine: a Drop-in Replacement for Standard InnoDB

….com/mysql/5.1.30/source/percona-xtradb-1.0.2-1.tar.gz * as binaries, percona xtradb is compiled in into MySQL-5.1.30 RPMS * as separated shared library, to use as drop-in plugin for existing MySQL-5.1.30 installation http://www.percona.com/mysql/5.1.30/binary/percona-xtradb-1.0.2-1…

Comment: XtraDB storage engine release 1.0.6-9

Answer: Package MySQL-server-percona is obsoleted by Percona-XtraDB-server-51, trying to install Percona-XtraDB-server-51-5.1.43-9.1.rhel5.x86_64 instead Package MySQL-client-percona is obsoleted by Percona-XtraDB-client-51, trying to install Percona-XtraDB-client-51-5.1…

Comment: Percona XtraDB Cluster Events

I tried to install XtraDB-Cluster-server, it depended on xtrabackup and xtrabackup depended on mysql. So I installed MySQL-server-community rpm and xtrabackup, but when I installed XtraDB-Cluster-server, I said it’s conflict with MySQL-server-community. What should I do? Thanks

Post: XtraDB: The Top 10 enhancements

… with the top 10 enhancements that XtraDB has over the built-in InnoDB included in MySQL 5.0 and 5.1.Â…-configurable assumption that the server has only a single disk installed (100 iops).  One problem in particular that this causes….  In a simple test, XtraDB recovered ten times faster (see docs). InnoDB Plugin Features – XtraDB is derived from the InnoDB plugin…

Post: Making the impossible: 3 nodes intercontinental replication

… Well, you theoretically could create 3 node traditional MySQL ring replication, but this is not what … Now, as we have running instances, you can install Cluster packages from RPM repositories. You can …to Faster than light neutrino). Also note, that XtraDB Cluster can apply events in parallel and …

Post: Percona Monitoring Plugins 1.0.2 release: enterprise-grade MySQL monitoring and graphing capabilities

… w/o checking for the largest process and monitor Percona XtraDB Cluster node status using the following example command for Nagios…/plugins/pmp-check-mysql-status -l $USER3$ -p $USER4$ -H $HOSTADDRESS$ -x wsrep_local_state -C ‘!=’ -w 4 } To install packages from… one of the following commands: yum install percona-nagios-plugins percona-cacti-templates apt-get install percona-nagios-plugins percona-cacti-templates

Post: Using pt-table-checksum with Percona XtraDB Cluster

… v2.1.5, pt-table-checksum works correctly with Percona XtraDB Cluster, but it doesn’t work quite like a traditional… presumption is false, then read the Percona XtraDB Cluster documentation or watch the Percona XtraDB Cluster – Installation and Setup webinar.  My setup has…-05T14:02:17 0 0 0 1 0 0.025 mysql.columns_priv 10-05T14:02:17 0 0 0 1…

Post: XtraDB storage engine release 1.0.2-2 (New Year edition)

…-2 percona-xtradb-1.0.2-2 as source code in tar.gz as binaries, percona xtradb is compiled in into MySQL-5.1.30 RPM as separated shared library, to use as drop-in plugin for existing MySQL-5.1.30 installation XtraDB