…. List of changes: Fixes merged from upstream (Codership-mysql) Support for MyISAM, now changes to MyISAM tables … eliminate bugs and problems during alpha and beta testing release, but this is a software, so bugs …-Cluster/ Documentation Codership Wiki General Discussion group Launchpad project Bug …
Post: Announcement of Percona XtraDB Cluster 5.5.20 GA release
April 3, 2012 By 10 Comments
…PL MySQL Conference Galera Synchronous Multi-Master Replication for MySQL. My talk on PL MySQL Conference … and problems during alpha and beta testing release, but this is a software,…Documentation Codership Wiki General Discussion group Launchpad project Bug reports Previous posts on this topic…
Post: Upgrading MySQL
January 5, 2010 By 23 Comments
… minutes job for others it is many month projects. Why is that ? Performing MySQL upgrade two things should normally worry you. It… just for this project. Query Validation It is often hard to ensure queries work same way with different MySQL version, unless you…. Adding the slave with new version for testing is also a safe way to test things out – you can move read traffic…
Post: Percona Replication Manager, a solution for MySQL high availability with replication using Pacemaker
November 29, 2011 By 94 Comments
… stop MySQL on a slave that lags behind. This will absolutely not help its recovery. test_user and test_passwd: The credentials to test MySQL. Default is to run select count(*) on mysql.user table, so… privilege which overrides read_only. Like I mentioned above, this project is young. In the future, I’d like to integrate…
Post: More on MySQL Error Messages
April 6, 2011 By 9 Comments
… during last couple of days. mysql> drop database test; ERROR 1010 (HY000): Error dropping database (can’t rmdir ‘./test/’, errno: 17) First question… some extra files, which do not belong to MySQL in database directory. MySQL will only remove files it knows about such as… code required and I bet this could be a great project for some Intern to complete over summer. Why do I…
Post: MySQL Installation and upgrade scripts.
May 21, 2007 By 3 Comments
… MySQL is doing much better than a lot of other projects in this respect. Major version upgrades become more painful recently. In MySQL… upgrade to recent MySQL 5.0 before upgrading to MySQL 5.1 – this makes sure you will be at somewhat tested upgrade/downgrade… are obviously not part of automated mysql-test process and I’m wondering if they are tested at all. For example if you…
Post: MySQL on Amazon RDS part 1: insert performance
March 15, 2011 By 37 Comments
… Database Service (RDS) is a cloud-hosted MySQL solution. I’ve had some clients hitting performance… is long-term performance, but as a side project, I thought it would be interesting to measure…happening on the server. I will reproduce this test, capture more measurements about what was going on,…
Post: Percona testing: Quick test clusters with kewpie!
January 13, 2012 By Leave a Comment
…project_name = ‘percona-xtradb-cluster’ #project_name = ‘xtrabackup’ -project_name = None +#project_name = None defaults = get_defaults(qp_rootdir,project_name) variables = test… $ mysql -uroot –protocol=tcp –port=9317 test Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL …
Post: Shard-Query turbo charges Infobright community edition (ICE)
May 6, 2011 By 22 Comments
…for testing, as it had been tested before:Another MPB postLucid DB testing The … omitting the dimension columns from the projection, instead replacing them with the dimension… has tens of millions of flights: mysql> select count(*) from ontime_one.ontime_fact; +———–+ | count(*) | +———–+ …
Post: Finding your MySQL High-Availability solution – The questions
October 16, 2009 By 36 Comments
…in the table below. Expertise level MySQL replication Typical, average MySQL DBA + some Sysadmin skills …the technology with the hardware tested, the data imported and basic testing and documentation. A … Time will vary greatly depending on your project. For example, “setting up replication” can be…
