… Master/Slave Set: ms_MySQL [p_mysql] Masters: [ percona2 ] Slaves: [ percona3 percona1 ] [root@percona1 ~]# cat /etc/redhat-release CentOS release 6.3 (Final…_MySQL [p_mysql] (unmanaged) p_mysql:0 (ocf::percona:mysql): Master percona1 (unmanaged) p_mysql:1 (ocf::percona:mysql): Slave percona2 (unmanaged) p_mysql:2 (ocf::percona:mysql…-mode=false You can also check your cluster using cman_tool or clustat (if you have installed rgmanager) [root@percona3 ~]# cman…
Post: Virident vCache vs. FlashCache: Part 2
May 17, 2013 By 3 Comments
… as the cache storage device. EXT4 is the filesystem, and CentOS 6.4 the operating system, although the pre-release modules… on both systems. The benchmark tool used was sysbench 0.5 and the version of MySQL used was Percona Server 5.5…-time=7200 –max-requests=0 –percentile=95 \ –mysql-user=root –mysql-socket=/tmp/mysql.sock –mysql-table-engine=innodb \ –oltp-read-only=off run…
Post: Which Linux distribution for a MySQL database server? A specific point of view.
December 8, 2011 By 38 Comments
… the other end there are Debian and Ubuntu. Both use tool called dpkg for package management. There isn’t a month… CentOS are the only platforms getting packages from all MySQL and MySQL-fork vendors – Oracle, MariaDB and Percona. By my observations RedHat and CentOS are also much more frequently used with MySQL…
Post: CentOS 5.8 users: your UTF-8 data is in peril with Perl MySQL
February 22, 2013 By 3 Comments
…. First, DBD::mysql v3.0007 was released in September 2006, but this very old problem still exists today because CentOS 5 is…::mysql have handled UTF-8 correctly for nearly the last decade. Second, just a reminder: all Percona Toolkit tools that connect to MySQL… Run CentOS 5 Have UTF-8 data in MySQL Use Perl to access that data Have not upgraded DBD::mysql (perl-DBD-MySQL) then…
Post: Connecting orphaned .ibd files
May 13, 2011 By 19 Comments
… in InnoDB dictionary. MySQL must be stopped at this point. There is a tool ibdconnect in Percona InnoDB Recovery Tool. Make sure you… the dictionary in ibdata1. # ./ibdconnect -o /var/lib/mysql/ibdata1 -f /var/lib/mysql/sakila/actor.ibd -d sakila -t actor actor… tool ibdconnect was tested on MySQL 5.1 on CentOS 5.6 x86_64. However it expected to work on all versions of MySQL…
Post: MySQL - to use or not to use
May 28, 2007 By 10 Comments
… use CentOS, Fedora or Debian,Ubuntu. Most articles speaking about MySQL for Enterprises speaking about MySQL with full pack of services from MySQL AB… from MySQL. They indeed may be more efficient for you than having your own tool set and DBAs which can resolve all MySQL issues with help of Google rather than MySQL Support Team. You…
Post: Binaries of MySQL 5.0.33 Community release for AMD64 / EM64T
January 12, 2007 By 37 Comments
… build for MySQL 5.0.33 Community release. This build was done using “Generic Linux RPM” spec file on CentOS 4.4 (RHEL compatible) x86_64 (Links removed) We added one more RPM to stantard MySQL RPMs – MySQL-microslow-5….mysqlperformanceblog.com/2006/09/06/slow-query-log-analyzes-tools/ http://bugs.mysql.com/bug.php?id=25412 Also we propose Linux…
Post: Testing Percona Replication Manager (prm) with Vagrant
April 17, 2012 By 2 Comments
… Replication Manager (PRM), a new high availability tool for MySQL. Percona Live DC 2012 Percona Live MySQL Conference & Expo 2012 PRM is an OCF Resource Agent for Corosync / Pacemaker that take cares of MySQL and manages the replication. Corosync allows any number of servers… https://github.com/lefred/percona-prm. You can use the CentOS 6 base box I used in the previous post (Testing…
Comment: Which Linux distribution for a MySQL database server? A specific point of view.
December 10, 2011 By 38 Comments
… MySQL Python module is only available if you bought a support contract). On CentOS/RHEL/OEL: The system MySQL is easy to install. CentOS 5 ships with MySQL 5.0.77 which is… solve it). And the MySQL package is indeed too smart. Good things are that many other tools like maatkit are available and…
Post: SystemTap - DTrace for Linux ?
September 14, 2009 By 17 Comments
…DTrace functionality. Why I am interested in this tool, because there is no simple way under …iotop, but iotop is not available in RedHat / CentOS) with output like this Mon Sep 14 …simple script that I tried to hack around MySQL ® probe process(“/usr/libexec/mysqld”).function(“*innobase*”). { printf…
