Stories
Slash Boxes
Comments
NOTE: use Perl; is on undef hiatus. You can read content, but you can't post it. More info will be forthcoming forthcomingly.

All the Perl that's Practical to Extract and Report

use Perl Log In

Log In

[ Create a new account ]

acme (189)

acme
  (email not shown publicly)
http://www.astray.com/

Leon Brocard (aka acme) is an orange-loving Perl eurohacker with many varied contributions to the Perl community, including the GraphViz module on the CPAN. YAPC::Europe was all his fault. He is still looking for a Perl Monger group he can start which begins with the letter 'D'.

Journal of acme (189)

Wednesday August 03, 2005
01:14 PM

OSCON Day 3: MySQL Snapshots and Replication from Oracle

[ #26067 ]
After the lightning keynotes and banjo music, I stroll into my first session of the day: MySQL Snapshots and Replication from Oracle by Theo Schlossnagle. As you might imagine, it's about high query counts, lots of data and a limited budget. Starting off with an Oracle cluster, how can we use master-slave replication to handle many distributed queries? He's doing it in the application, selecting individual tables to replicate. It's all quite cute. using triggers to insert changes (inserts, deletes, updates) into a "log table" which is then replayed onto the slaves after a while. For more scaling, he advocated MySQL master-slave replication and LVM snapshots for initial slave startup. Turns out he's explaining what approach works fine for UltraDNS. Jeremy Zawody is sitting behind me and heckling^Wsharing some more information. Unfortunately, Theo often has 30 lines of SQL on the screen, which is quite hard to follow. Best quote: "There are two solutions. One is good, and the other is correct".
The Fine Print: The following comments are owned by whoever posted them. We are not responsible for them in any way.
 Full
 Abbreviated
 Hidden
More | Login | Reply
Loading... please wait.