Planet MySQL

Using Tungsten Replicator Filters to Implement MySQL Time-Delayed Replication

posted by Robert Hodges on Tue 06 Jan 2009 07:30 UTC

Time-delayed replication is a useful feature that allows a slave to lag a fixed amount of time behind a master, thus providing a time window to recover from disasters like deleting a 10 million line table by accident. You just run over to the slave, turn off replication, and recover lost data, as the delayed updates mean it has yet to see your deadly mistake. It's a simple way to protect your administrative honor as well as your job.

Time-delayed replication has been on the MySQL to-do list since at least 2001. It's currently scheduled for release 6.0 and the fix is included in recent OurDelta builds. However, there's a very simple way to get the feature with Tungsten Replicator filters. This works for unadulterated MySQL 5.0 and 5.1 releases.

[Read more...]

Libmemcached increment and decrement issue solved

posted by Patrick Galbraith on Tue 06 Jan 2009 04:23 UTC

I spoke with Brian Aker last week about the issues I found with decrement and increment while working on my book "Developing Web Applications with Apache, MySQL, Memcached, and Perl". He suggested I make sure that I was using the latest libmemcached. I checked, and the version of libmemcached that is included with Memcached::libmemcached is 0.21 - this is the version of Memcached::libmemcached I obtained from using CPAN (perhaps CPAN needs a new bundle...). So, I obtained the most recent version of Memcached::libmemcached from the subversion repository at https://perl-libmemcached.googlecode.com/svn, and it includes the lastest libmemcached, version 0.25. To make a long story short, I re-wrote my test script to test each operation individualy and time that, as well as compare the times to Cache::Memcached. The numbers are great and are reason enough [Read more...]

Which browsers and OS do mysql.com visitors use?

posted by Markus Popp on Tue 06 Jan 2009 04:21 UTC

First of all, let me wish all of you a great year 2009! As an old year ends and a new year begins, it's a good time to do some statistics. One of the statistics that web developers are interested in is, which browsers and operating systems visitors use to access their websites. Let me share some of the interesting figures regarding the mysql.com website with you.

(click to enlarge and see more detail)

The spreadsheet contains data for December 2008 (another sheet for November 2008) in a pivot table style. In the columns you see the browsers and operating system and

[Read more...]

Some basic advice for running MySQL on Amazon AWS EC2

posted by Mark Atwood on Tue 06 Jan 2009 01:09 UTC

I've been recently asked for advice on running MySQL on EC2.

Run only a one MySQL server process on the instance.

This bears repeating. Run only the MySQL server on the instance. Not your app server, or your dev environment, or your...

Use the large or xlarge size, not the small size.
Dedicate the additional partitions to be InnoDB tablespaces.
"Pre-heat" the tablespace partition with dd. That is, dd if=/dev/urandom of=/path/to/part bs=8K before using the partition.
This is one of the times where it's worth it to run tablespace on raw devices. Don't bother to put a filesystem down on those partitions.
Tune your database server. Get someone who knows MySQL tuning to do it for you.
Backup and Replicate with rigor. When an instance gets shut down, it Goes Away,

[Read more...]

Twitter overload - help!

posted by David Van Couvering on Mon 05 Jan 2009 20:41 UTC

This keeps happening - the community I need to stay engaged with keeps jumping on new forms of communication, and if you want to stay in tune, you need to jump on too.

This first happened with blogging, and then with Facebook. These I actually don't mind. I like writing and reading blogs, and Google Reader has made it fairly easy for me to quickly digest what's going on.

Facebook is nice because I keep in touch with friends. It's not so much about work but about getting a little more connected, particularly to old friends who I don't see much any more.

But this Twitter thing - I really don't like it. Sorry. I subscribe to someone's Twitter feed because I value their thoughts, but then it's serious drinking from a firehose. Many of these Thought Leaders are

[Read more...]

Seven Things About Me You May Not Know (And Probably Won't Care About)

posted by Jay Pipes on Mon 05 Jan 2009 15:43 UTC

Due to the efforts of Brian Moon and Michelangelo van Dam, I've been sucked into a meme started by Tony Bibbs. My initial reaction to this unfortunate event was ... (envision Steven Colbert, hands raised...) "Noooooo!!!" But I got over it. Hey, it's the holiday season, I might as well be a good boy and fulfill the modern-day geek's equivalent of a chain letter.

So, without further ado, here is my list of seven things about me you probably could care less about and will skip over to see if you are on my list of tagged

[Read more...]

2008 certification results, 2009 news

posted by Dave Stokes on Mon 05 Jan 2009 15:33 UTC

2008 was a good year for MySQL Certification. 1,986 folks took exams which is a 14.6% gain over 2007. 736 candidates earned certifications and that is a 14.4% gain. The biggest gains were in Associate (up 300%) and DBA (up 35%) certifications. Oddly the Developer cert was down 40%.

So what happens in 2009?

The DBA and Developer exams are both changing format to performance based tests. Candidates will be tested on a virtual server and provided with a list of tasks that need to be accomplished. The DBA exam is actually in alpha est and about to go to beta. This testing is being done on two sets of virtual environments which provide their own qualities. The Linux environment is probably closer to what most DBA's working environment but the Windows version allows the candidate more

posted by Kris Buytaert on Mon 05 Jan 2009 13:30 UTC

When your favourite ex yahoo employee and mysql guru blogs about a "dns problem" and how he solved it using Twitter you can only smile ;) At last some useful use for Twitter .. when it's up at least ..

Commercial open source business strategies in 2009 and beyond

posted by The 451 Group on Mon 05 Jan 2009 12:59 UTC

The future of commercial open source software lies in commercial licensing strategies, but which are the strategies that are more likely to deliver the results vendors are looking for?

Much of the open source blog chatter over the Christmas period was related to open source business models/strategies, largely triggered by a post written by Dave Rosenberg in which he declared that commercial licensing, and specifically open core licensing will be all the rage in 2009:

“Typically we now see an “open core” freely available with “exclusive” or proprietary features only available when you pay. If you are trying to build a commercial business on top of an open

[Read more...]

Triggers Use Case Compilation, Part I

posted by Shlomi Noach on Mon 05 Jan 2009 10:55 UTC

I’ve run by quite a few triggers lately on production systems. In previous posts, I’ve written about problems solved with triggers. So here’s a compilation of some solutions based on triggers; and some problems which are not (yet?) solvable due to current triggers limitations.

Triggers can be used to:

Maintain integrity
Enhance security
Enhance logging
Assist with archiving
Restrict table size
Manage caching
Manage counters

Triggers are not fast. In fact, they can add quite an overhead if misused. Some of the triggers presented here are known to work on real life production systems, though, and work well. But make sure you benchmark before embarking on extensive application changes.

I’ll be using

[Read more...]

Top 30 Most Active

MySQL Links

Other Links

Planetarium