Why does the mysql client says it’s 5.1.70? Welcome to the MySQL monitor. Commands end with ; or g. Your MySQL connection id is 138 Server version: 5.1.70-rel14.7-log Percona Server (GPL), 14.7, Revision 572
Comment: Percona Server 5.1.69-14.7 now available: A drop in replacement for MySQL
June 17, 2013 By 4 Comments
Post: MySQL and the SSB - Part 2 - MyISAM vs InnoDB low concurrency
May 22, 2013 By Leave a Comment
… is part two in what is now a continuing series on the Star Schema Benchmark. In my previous blog post I compared MySQL 5.5.30 to MySQL 5.6… cache, which is another advantage of InnoDB. SSB Flight #2 Flight #2 is similar to Flight #1. MyISAM is faster than InnoDB…
Post: Replication in MySQL 5.6: GTIDs benefits and limitations - Part 2
May 30, 2013 By 6 Comments
… focused on MySQL 5.6 GTIDs. You can find part one here. Our goal will be to go from setup #1 to setup #2 on… try! # For s0,s1, s3, s4 mysql> stop slave; mysql> change master to master_port=10002; mysql> start slave; # And then check the number of records from the t table s1> select count(*) from t; +———-+ | count(*) | +———-+ | 2…
Post: Percona XtraBackup 2.1.3 for MySQL available for download
May 22, 2013 By 3 Comments
… is glad to announce the release of Percona XtraBackup 2.1.3 for MySQL on May 22, 2013. Downloads are available from our… can be reported on the launchpad bug tracker. * * * Percona XtraBackup is the world’s only open-source, free MySQL hot backup software… backups Savings on disk space and network bandwidth Automatic backup verification Higher uptime due to faster restore time XtraBackup makes MySQL hot…
Post: Choosing a MySQL HA Solution - Post-Webinar Q&A
June 7, 2013 By Leave a Comment
… throughput of a single port. [Don’t try more than 2; the additional work that the kernel has to do in… reaction was, honestly, why would you ever want to use MySQL on top of something like that? I can’t imagine the… install MySQL. It failed miserably on the mysql_install_db process. Every time I tried, I got some variant of this message: 130606 2…
Post: Multicast replication in Percona XtraDB Cluster (PXC) and Galera
June 5, 2013 By
… mysql]# service mysql stop [root@node1 mysql]# service mysql stop [root@node1 mysql]# service mysql start –wsrep_cluster_address=gcomm:// [root@node2 mysql]# service mysql start [root@node3 mysql... received on. [root@node3 mysql]# lsof -P +p 17493 | grep LISTEN mysqld 17493 mysql 11u IPv4 39669 0t0 TCP *:4567 (LISTEN) mysqld 17493 mysql… the mcast address: #wsrep_cluster_address = gcomm://192.168.70.2,192.168.70.3,192.168.70.4 wsrep_cluster…
Post: Migrating between MySQL schemas with Percona Xtrabackup
June 10, 2013 By 2 Comments
…snapshot of a particular MySQL schema and then reload it with a different schema name on the same server. … of my colleagues (thanks Bill Karwin!), the cumbersome part of this process is the DISCARD/IMPORT TABLESPACE … versions I was using on my test VM: Percona Server 5.5.30 Xtrabackup 2.0.6 Some …
Post: Summertime Percona MySQL training update
June 6, 2013 By 1 Comment
…, give thought to MySQL training for you and your team. Summer is the time to brush up on those critical skills needed… the experienced MySQL DBA in mind–so it is a fast paced 2-day course. Percona has a packed summer MySQL training schedule. In June we have: Moving to MySQL 5.6…
Post: How to fix your PRM cluster when upgrading to RHEL/CentOS 6.4
May 29, 2013 By 2 Comments
… and it’s part of the …on [root@percona2 ~]# chkconfig cman on [root@percona3 ~]# chkconfig cman on And start the services on…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…
Post: ZFS on Linux and MySQL
May 24, 2013 By 17 Comments
… server can easily handle the write load of all the MySQL instances. The original idea was to configure them with raid… last 30 days one snapshot per hour for the last 2 days one snapshot per 5min for the last… together, ZFS on Linux is a very interesting solution for MySQL backup servers. All backup solutions have an impact on performance with ZFS…
