… VARCHAR or one of the TEXT types, CONVERT TO CHARACTER SET will change the data type as necessary to ensure that…
Comment: Migrating between MySQL schemas with Percona Xtrabackup
June 11, 2013 By 2 Comments
adding set FOREIGN_KEY_CHECKS=0; to the beginning seems to work
Post: How people are using MySQL... from 1 user to 100 million (upcoming conference talk)
June 11, 2013 By Leave a Comment
… caveats, but you can also gain a lot from write set replication. If the application gets really popular, sooner or later…
Post: Choosing a MySQL HA Solution - Post-Webinar Q&A
June 7, 2013 By Leave a Comment
… other side, things start to degrade. If you’re just setting up a test environment to get familiar with the technology… configure the slave to only replicate a specific database, a set of databases, or specific tables; you can also configure the slave to replicate everything EXCEPT a specified set of databases and tables. With this method, every event is…
Post: How to fix your PRM cluster when upgrading to RHEL/CentOS 6.4
May 29, 2013 By 2 Comments
… percona1 writer_vip (ocf::heartbeat:IPaddr2): Started percona1 Master/Slave Set: ms_MySQL [p_mysql] Masters: [ percona2 ] Slaves: [ percona3 percona1 ] [root... percona2 writer_vip (ocf::heartbeat:IPaddr2): Started percona3 Master/Slave Set: ms_MySQL [p_mysql] Masters: [ percona2 ] Slaves: [ percona3 ] Stopped: [ p…
Post: MySQL and the SSB - Part 2 - MyISAM vs InnoDB low concurrency
May 22, 2013 By Leave a Comment
….5.30 to MySQL 5.6.10, both with default settings using only the InnoDB storage engine. In my testing I… the database optimizer. The SSB benchmark consists of four sets of queries. Each set is known as a “flight”. I have labeled… another blog post in this series. Regardless, when the working set fits in memory, InnoDB almost always performs better, at least…
Post: Multicast replication in Percona XtraDB Cluster (PXC) and Galera
June 5, 2013 By
… and synchronous clusters I’ve seen a lot of people setting up clusters with 3-6+ nodes on 1 Gbps networks….192.0.11″ If you already have wsrep_provider_options set, add it to the semicolon separated list instead of a… regular IP of the node. Typically I just set the wsrep_node_address setting on each node if this IP is not…
Post: Percona Server 5.1.69-14.7 now available: A drop in replacement for MySQL
June 10, 2013 By 3 Comments
… page tracking was enabled and variable innodb_flush_method was set to ALL_O_DIRECT. Bug fixed #1131949. Fixed the RPM… be 64-bit unsigned integers now. Bug fixed #714925. mysql_set_permission was failing on Debian due to missing libdbd-mysql…_PAGES query started returning data to indicate an incomplete result set. Bug fixed #1185040. Fixed the upstream bug #69379 which caused…
Post: The small improvements of MySQL 5.6: Duplicate Index Detection
May 31, 2013 By Leave a Comment
…_2` (`col2`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1 1 row in set (0.00 sec) In previous versions of MySQL, you can… will be disallowed in a future release. 1 row in set (0.00 sec) As the message points correctly, this is…, of course, cannot risk to block directly all cases. A set of MySQL utilities were introduced by Oracle recently, which includes…
Post: Implementing SchemaSpy in your MySQL environment
June 4, 2013 By 2 Comments
Lately I have been working with a set of customers on a longer term basis which has given … html after each run, so I find it convenient to set it up on crontab so that schema changes are automatically…
