…to parallelize. As you know, MySQL doesn’t do intra-query parallelization, so ETL jobs written to rely on SQL tend to get… we’re doing here starts to look like a hillbilly version of Infobright, which I’ll… you still have to think about how to avoid enormous tables that are hard to maintain, back up…
Post: Debugging MySQL SSL problems
November 8, 2012 By Leave a Comment
…to ensure SSL was working properly from the command line first before trying to get replication to…MySQL version. I had already added the relevant config options in the ‘mysqld’ section of the my.cnf: [mysqld] ssl-key=/etc/mysql…
Post: MySQL - to use or not to use
May 28, 2007 By 10 Comments
…how to use MySQL not just if it should be used or not. There are many applications when MySQL…version and solve things yourself or use third party support, which indeed works as MySQL…
Post: Using Flexviews - part two, change data capture
March 25, 2011 By 26 Comments
…with Flexviews. It continues with an overview of how to install and run FlexCDC, and concludes with …be able to read the binary logs of the version of mysql it ships with (and previous versions) so … if this is a MySQL slave transaction_isolation=READ-COMMITTED You can get FlexCDC directly out of …
Post: How to debug long-running transactions in MySQL
March 8, 2011 By 6 Comments
…In MySQL 5.1 and newer with the InnoDB plugin, it’s easy to figure…-plugin InnoDB versions, you can’t reliably figure out what connection is to blame … # Make sure the disk isn’t getting too full. avail=$(df -m -P /root/tcpdumps… and I am still stumped as to how a SELECT-only transaction can possibly…
Post: Percona Replication Manager, a solution for MySQL high availability with replication using Pacemaker
November 29, 2011 By 102 Comments
…to add nodes In order to setup the solution you’ll need my version of the MySQL resource agent, it is not yet pushed to…get the resource agent from here: https://github.com/y-trudeau/resource-agents/raw/master/heartbeat/mysql…slave “ms” declaration. This is how Pacemaker defines an asymmetrical …
Post: Profiling MySQL Memory Usage With Valgrind Massif
January 9, 2013 By 3 Comments
…. for what function) it was allocated, how it got there (a backtrace, …to get the Valgrind program. Though you could use the latest version which comes with your OS (think yum or apt-get…to point mysqld to your settings file etc. After mysqld is properly started (check if you can login with your mysql…
Post: MySQL Upgrade Webinar Questions Followup
June 28, 2012 By 7 Comments
… not needed as MySQL 5.5 continues to support various character sets same as previous MySQL versions. Moreover utf8 character set continues to cause significant… is hard to get them to be same as in old version. Q: What is about running 2 instances of MySQL with different versions to test upgrade… to have upgrade testing done in the environment which is maximally close to production. Q: How safe is it to upgrade from MySQL 5.5 to…
Post: New MySQL Community Release Policies published
August 9, 2007 By 9 Comments
…. I guess community will have to cooperate on its own to build true community MySQL version for production ready version. There are great patches out… be surprised MySQL Does not get too warm welcome on OSCON any more ? Its fun to see how its develops and nice to think MySQL availability…
Post: Upgrading MySQL
January 5, 2010 By 24 Comments
… path than 4.1 to 5.1 just because so much more people have followed that road. So how do people approach… probably go to the earliest MySQL version and still get same result. The more exotic or complicated functionality is the more likely it to be… to temporary get extra boxes for time of upgrade. Swapping master. Finally as you have your slave running on new MySQL version you want to…
