http://fewbar.com Technology, life, and mischief, not in that order Tue, 11 Nov 2008 18:06:09 +0000 http://backend.userland.com/rss092 en One of my favorite bloggers, Peter over at Percona/MySQL Performance Blog, has thrown down the gauntlet. Basically saying that it would be fairly trivial to write an incremental InnoDB backup tool. If you see me, and I haven't run up to you and told you that I am writing/have written an ... http://fewbar.com/2008/11/i-should-write-an-innodb-backup-tool/ There are quite a few articles out there that talk about how to give your application some context and send reads to one server, and writes to another. There are even some mentions of marking your connection "dirty" and then sending all reads to the write server. As a first try ... http://fewbar.com/2008/10/maximizing-usage-of-mysql-replication-slaves/ This week was an ugly one for my monster database servers. It should have been triumphant, but oddly enough, I think it shows how prone to mistuning InnoDB on MySQL 5.0 is with multiple cores. This server is a multi-core, high concurrency server. The application has been designed a little bit ... http://fewbar.com/2008/08/innodb-concurrency-problems-on-multi-core-boxes-possibly-a-thing-of-the-past/ Holy cow, did you read about this company "The Linkup" losing 45% of its customers' data?! How about they change their name to "The @$%! Up". First off, let me say that these guys didn't have to be retarded to lose this much data. In fact, there are (were?) probably a ... http://fewbar.com/2008/08/online-storage-provider-linkup-goes-belly-up/ So a few days ago, my big mean MySQL server started having problems that were very hard to explain. It was slowing down, taking a minute to run queries that usually take a few seconds, and Linux load averages were in the teens, despite having quiet disks (less than 0.1% ... http://fewbar.com/2008/07/mysql-query-cache-scales-like-a-286-with-turbo-off/ I don't remember exactly how I found memcachedb, however, it is one of those projects that somebody else beat me to the punch in writing. I mean, it was going to happen, as the need was there. Steve Chu, the author, did a great job of melding two open source ... http://fewbar.com/2008/06/using-memcachedb-and-memcached-make-things-scale/ Anybody who is in IT in America, has probably experienced that sinking feeling when somebody somehow introduces the latest version of Microsoft Office into their organization. It usually comes in like some corporate ninja while you're not looking. Whether its an application that your accounting department writes with the new ... http://fewbar.com/2008/06/openoffices-achilles-heel/ Just a few weeks ago, I found out that thread_concurrency's purported magical effects at correcting MySQL's concurrency limitations (especially in 4.1) were something of a myth. It was a post on mysql's lists that alerted me to this. Apparently it only works on Solaris, Linux's threading library ignores this parameter ... http://fewbar.com/2008/06/the-thread_concurrency-myth/ I've been promising for some time to create a blog about Technology, Life, and mischief in general. Fewbar.com is just my good-faith first step in getting that done. Only time will tell whether this will be the next clearing house for genius technical advice, or just another empty Wordpress blog ... http://fewbar.com/2008/06/fewbarcom-comes-alive/