May 26, 2012

Post: Introducing Zend DBi as a MySQL Replacement on IBM i

… a 100% compatible drop-in replacement. Everything works on Zend DBi just as it works on MySQL, with no need to rewrite… switch to Oracle’s MySQL on another platform, it will work seamlessly. Why is Percona involved? Because providing quality server builds…

Comment: Percona Replication Manager, a solution for MySQL high availability with replication using Pacemaker

… LTS) the pacemaker mysql plugin (ocf:heartbeat:mysql) doesn’t work, because since mysql 5.5 the statement “CHANGE MASTER TO… fail. Yesterday, I fix this up very dirty and it works.

Post: Load management Techniques for MySQL

… script with multiple level of concurrency and find out doing work from 32 processes is faster than just having one process…

Comment: ext4 vs xfs on SSD

… XFS on the hardware we bought. I found that ext4 worked really well out of the box, while XFS required poorly… all our MySQL DBs with ext4, and it’s been working great for the past 7 months. I recently had an…

Comment: How to change innodb_log_file_size safely

…_file_size = 64M (without the “B” in “MB” string) This works on my site on a Debian Squeeze system where I… a dynamic innodb log file RECREATE did NOT seem to work if you are going to delete the log files later…

Post: Benchmarking single-row insert performance on Amazon EC2

I have been working for a customer benchmarking insert performance on Amazon EC2, and …

Comment: Announcement of Percona XtraDB Cluster 5.5.23

Panagiotis, it is supported on level as MyISAM supports Dave, it works like global table lock for MyISAM table. As MyISAM is not transactional there is not much we can do it.

Comment: Choosing proper innodb_log_file_size

… and shared hosting are unreliable in that context – tuning might work superb today, average tomorrow, and occasionally backfire too.

Comment: SHOW INNODB STATUS walk through

Hello Peter, I have trouble getting the monitores working – i created the different tables for the innodb (Standard, Lock,…

Comment: mysql-proxy, urgh performance and scalability ?

… i tried installing with percona server and it just dosent work, or do anything.. thanks..