…script that outputs the network throughput on an interface every second. I’m running a sysbench test on…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…
Post: How to fix your PRM cluster when upgrading to RHEL/CentOS 6.4
May 29, 2013 By 2 Comments
…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: MySQL Query Patterns, Optimized - Webinar questions followup
June 3, 2013 By 2 Comments
On Friday I gave a presentation on “MySQL Query Patterns, Optimized” for Percona MySQL Webinars. If you missed it, you can still register to… Europe. Join Percona and the MySQL community at our events. The next one is in London on November 11-12, 2013. We also look forward to the Percona Live MySQL Conference and Expo in…
Comment: Percona Server 5.1.69-14.7 now available: A drop in replacement for MySQL
June 10, 2013 By 3 Comments
… have to export databases from mysql and import them in Percona server or can I use mysql data directory? 2. What’s the advantage of using Percona server over MySQL? 3. I am using CentOS…
Comment: ZFS on Linux and MySQL
May 31, 2013 By 17 Comments
…. Would be interested if someone wanted to contribute on the MySQL side. Interesting that on Wikipedia Data Virtualization is talked about as data… aggregating Oracle, SQL Server and MySQL into one source that the user or application sees. On the other hand following the VMware…
Comment: Upgrading MySQL
May 27, 2013 By 24 Comments
… mysql-5.5.11-linux2.6-i686.tar.gz /usr/local/ cd /usr/local/ tar -xf mysql-5.5.11-linux2.6-i686.tar.gz mv mysql-5.5.11-linux2.6-i686 mysql cd mysql chmod root:mysql data/ chown root:mysql data cd /var/lib/mysql/ rm -rf ibdata1…
Comment: ZFS on Linux and MySQL
May 24, 2013 By 17 Comments
Wow, I pulled all the 300GB drives out of my MySQL servers years ago. I don’t need the space of… are as big, and much faster than the 300GB HDDs, on MySQL type loads.
Post: ZFS on Linux and MySQL
May 24, 2013 By 17 Comments
…on servers for backup purpose, boxes with 64 300GB SAS drives, 3…5.6.11 and xfs. Then, since ZFS on…”zfs snapshot script” you’ll many scripts ready for the… Even the fairly slow gzip-1 mode works …on Linux is a very interesting solution for MySQL backup servers. All backup solutions have an impact on…
Post: Experiences with the McAfee MySQL Audit Plugin
May 23, 2013 By 4 Comments
…user activity in MySQL has traditionally been challenging. Most data can be obtained from the slow or … has been discussed on a previous post in our blog. Starting with 5.1, the new…script to listen on this socket and process the audit records as you wish. Performance-wise, I did basic tests on…
Post: Percona XtraBackup 2.1.3 for MySQL available for download
May 22, 2013 By 3 Comments
… glad to announce the release of Percona XtraBackup 2.1.3 for MySQL on May 22, 2013. Downloads are available from our download… 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…
