… about MySQL‘s semi-synchronous replication. I find that there are often a number of misconceptions about how … that it cannot outpace the replica’s ability to fetch updates from the master. Have you seen the … data strongly guaranteed when at least one other server must have a copy of the data before…
Post: MySQL Life Cycle. Your Feedback is needed.
November 18, 2011 By 6 Comments
… MySQL 3.22 I would start running MySQL from early beta (if not alpha) and update MySQL…How long older platforms need to be supported ? I think for example it makes sense to support RHEL4 with MySQL…alternatively could be used to do various cool stuff with Percona Server, Percona Xtrabackup and other…
Post: Intel Woodcrest vs AMD Opteron for MySQL
June 8, 2006 By 9 Comments
… MySQL as well. From these numbers performance looks great and it looks like finally Intel has something to respond to AMD Opterons on Server market. Now competition heats up and we’ll see what AMD will have to respond. As Opteron did not have serious updates… the article I was working with article authors advising them how to tune MySQL and what is the reason for negative scalability etc.
Post: NDB API examples, the trivia to make ndbapi_scan works!
November 15, 2009 By 4 Comments
…time that I had to cover the NDB API. Once, a customer asked an example on how to perform a …in the IP of the MGM server. Easy to correct… yves@yves-laptop:/opt/mysql-cluster-gpl-7.0.8/storage…8 BMW Black scan_print: Success! Going to update all Blue cars to Black cars! No error 0 Mercedes Black 5…
Post: How to use tcpdump on very busy hosts
April 18, 2011 By 17 Comments
… enough to cause confusion about which queries are really slow. Recently, I got more than 60% dropped packets on a server with… ‘$event->{time} && $event->{time} > 1′” to exclude all queries which it believes took longer than the servers long-query-time of 1… it to mk-query-digest. Here is a draft of a script to automate this; use at your own risk and update to suit…
Post: Upgrading MySQL
January 5, 2010 By 24 Comments
Upgrading MySQL Server is a very interesting task as you can approach it … path than 4.1 to 5.1 just because so much more people have followed that road. So how do people approach… made it to caught up you can use mk-table-checksum to ensure data is the same. It is possible some update statements…
Post: Emulating global transaction ID with pt-heartbeat
November 4, 2011 By 6 Comments
…a three-server replication chain. I’m using sandbox servers on my laptop to illustrate: mysql> select * from heartbeat\G…documentation to see how to do it yourself), and start an instance of pt-heartbeat per server. It… up continually. But now it’s time to update that advice: everyone should not only …
Page: Presentations
May 3, 2006 By
…MySQL/Innodb Performance: Server and Schema MySQL Users Conference 2004, Orlando, FL Presentation shows how much you can improve performance by adjusting schema and MySQL Server…
Post: High-Performance Click Analysis with MySQL
December 22, 2008 By 13 Comments
… me to my next point: Use InnoDB Assuming that you will use the stock MySQL server, InnoDB… you still have to think about how to avoid enormous tables that are hard to maintain, back up,…to update the aggregates, you’re exposed to that bad data again. Any inconsistencies in the atomic data tend to…
Post: Infinite Replication Loop
October 10, 2011 By 2 Comments
…log statements in MySQL Replication. To explain what they are, how to identify them… and how to fix them. …if you want to backup one master, you need log_slave_updates[3] to be enabled. …to the time those looping statement were first inserted. Another way to see it is by monitoring your MySQL server…
