Duplicate binlog-do-db entry — Solution

At the November MySQL User Group, Patrick Galbraith ran into a problem where binlog-do-db was duplicated. It manifests itself like this:
(copied from http://lists.mysql.com/replication/607)

master my.cnf:
binlog-do-db=db1

slave my.cnf:
replicate-do-db=db1;

Relevant show slave status output

Replicate_Do_DB: db1;,db1;

When db1 is modified on master, Read_Master_Log_Pos and Relay_Log_Pos do
changes, also I can open and see the changes in rh3-relay-bin.000002, but
they do not appear in […]

At the November MySQL User Group, Patrick Galbraith ran into a problem where binlog-do-db was duplicated. It manifests itself like this:
(copied from http://lists.mysql.com/replication/607)

master my.cnf:
binlog-do-db=db1

slave my.cnf:
replicate-do-db=db1;

Relevant show slave status output

Replicate_Do_DB: db1;,db1;

When db1 is modified on master, Read_Master_Log_Pos and Relay_Log_Pos do
changes, also I can open and see the changes in rh3-relay-bin.000002, but
they do not appear in […]

Handler_read_first MySQL Haiku

I was writing up some notes about a client’s status variables, and I’d had to remind myself of Handler_read_first. Handler_read_first is a counter that increments when the first entry in the index is read, which may indicate that a full index scan is being used.
With this particular client, I ran a SHOW […]

I was writing up some notes about a client’s status variables, and I’d had to remind myself of Handler_read_first. Handler_read_first is a counter that increments when the first entry in the index is read, which may indicate that a full index scan is being used.
With this particular client, I ran a SHOW […]

SHOW VARIABLES Shows Variables MySQL Does Not Know About

The listing of Dynamic System Variables on the MySQL Reference Manual’s page is supposed to show those variables you can change on-the-fly.
innodb_data_home_dir is listed there as a dynamic variable, but it is not one, and trying to change it on-the-fly doesn’t work:

mysql> set global innodb_data_home_dir=”/data/mysql/data”;
ERROR 1193 (HY000): Unknown system variable ‘innodb_data_home_dir’

mysql> set session innodb_data_home_dir=”/data/mysql/data”;
ERROR […]

The listing of Dynamic System Variables on the MySQL Reference Manual’s page is supposed to show those variables you can change on-the-fly.
innodb_data_home_dir is listed there as a dynamic variable, but it is not one, and trying to change it on-the-fly doesn’t work:

mysql> set global innodb_data_home_dir=”/data/mysql/data”;
ERROR 1193 (HY000): Unknown system variable ‘innodb_data_home_dir’

mysql> set session innodb_data_home_dir=”/data/mysql/data”;
ERROR […]

Replication Presentation at the November 2007 Boston MySQL User Group

Patrick Galbraith, former MySQL employee who helped write replication, came to the November 2007 Boston MySQL User Group and did a fantastic presentation on replication, including showing how to set up replication and walking us through the steps in real-time, setting up an example server.

References mentioned in the video:
Brian Aker’s DBIx::Password

Giuseppe Maxia’s article about federated tables — I think that’s the right one, feel free to comment if it’s not.

MySQL Toolkit — renamed Ma’atkit — lives at http://sourceforge.net/projects/maatkit

sample my.cnf files for 2 different dual-master replication scenarios

Patrick Galbraith, former MySQL employee who helped write replication, came to the November 2007 Boston MySQL User Group and did a fantastic presentation on replication, including showing how to set up replication and walking us through the steps in real-time, setting up an example server.

References mentioned in the video:
Brian Aker’s DBIx::Password

Giuseppe Maxia’s article about federated tables — I think that’s the right one, feel free to comment if it’s not.

MySQL Toolkit — renamed Ma’atkit — lives at http://sourceforge.net/projects/maatkit

sample my.cnf files for 2 different dual-master replication scenarios

Technocation Grants a Free Shmoocon Membership!

ShmooCon is an annual East coast hacker convention hell-bent on offering three days of an interesting atmosphere for demonstrating technology exploitation, inventive software & hardware solutions, and open discussions of critical infosec issues. Technocation has started the year off right by granting a FREE Shmoocon membership to a lucky high school student.

Garrett is a Junior at Maumee Valley Country Day School in Toledo, Ohio. His avid fascination with technology began at an early age, starting with an amateur radio license at 12 which was followed by a self-built computer shortly after. He has also always been interested in electronics and the like, and has the soldering iron burns to prove it. Garrett’s enthrallment with computer security started in late 2005 when he became interested with wireless security practices, which spawned an unhealthy love for Linux.

read more

ShmooCon is an annual East coast hacker convention hell-bent on offering three days of an interesting atmosphere for demonstrating technology exploitation, inventive software & hardware solutions, and open discussions of critical infosec issues. Technocation has started the year off right by granting a FREE Shmoocon membership to a lucky high school student.

Garrett is a Junior at Maumee Valley Country Day School in Toledo, Ohio. His avid fascination with technology began at an early age, starting with an amateur radio license at 12 which was followed by a self-built computer shortly after. He has also always been interested in electronics and the like, and has the soldering iron burns to prove it. Garrett’s enthrallment with computer security started in late 2005 when he became interested with wireless security practices, which spawned an unhealthy love for Linux.

read more

Log Buffer #77: a Carnival of the Vanities for DBAs

Welcome to the 77th edition of Log Buffer, the weekly review of database blogs.
This is the last Log Buffer of 2007. . . a time for looking back at the year, looking ahead to the next, and generally focusing on time.
It may not be the Oscars, but Firebird News is thrilled that Firebird is Sourceforge’s […]

Welcome to the 77th edition of Log Buffer, the weekly review of database blogs.
This is the last Log Buffer of 2007. . . a time for looking back at the year, looking ahead to the next, and generally focusing on time.
It may not be the Oscars, but Firebird News is thrilled that Firebird is Sourceforge’s […]

InnoDB’s Adaptive Hash

MySQL’s manual page for InnoDB’s adaptive hash states:
If a table fits almost entirely in main memory, the fastest way to perform queries on it is to use hash indexes. InnoDB has a mechanism that monitors index searches made to the indexes defined for a table. If InnoDB notices that queries could benefit building a […]

MySQL’s manual page for InnoDB’s adaptive hash states:
If a table fits almost entirely in main memory, the fastest way to perform queries on it is to use hash indexes. InnoDB has a mechanism that monitors index searches made to the indexes defined for a table. If InnoDB notices that queries could benefit building a […]

Query Profiling Tools — part 1, mysqlsla

The “sla” in mysqlsla stands for “statement log analyzer”. This does a much better job than mysqldumpslow of analyzing your slow query log. In fact, you can sort by many different parameters — by sheer number of times the query shows up in the slow query log, by the total or average query […]

The “sla” in mysqlsla stands for “statement log analyzer”. This does a much better job than mysqldumpslow of analyzing your slow query log. In fact, you can sort by many different parameters — by sheer number of times the query shows up in the slow query log, by the total or average query […]

MySQL: “SOUNDS LIKE” vs. Full-Text search

A friend of mine asked me:
I’m hoping you can help me out with something — I’m trying to optimize a search feature. Since it uses a MySQL database, the search already uses the LIKE statement to get matches for a search query, we might be needing something more flexible. I found mention on MySQL’s website […]

A friend of mine asked me:
I’m hoping you can help me out with something — I’m trying to optimize a search feature. Since it uses a MySQL database, the search already uses the LIKE statement to get matches for a search query, we might be needing something more flexible. I found mention on MySQL’s website […]

Sheeri’s First Week at Pythian

The Pythian family got a new song last Monday — “Sheeri” means “my song” in Hebrew. This post on my own blog explains how I got the job.
High winds delayed my flight last Monday, and we’ve had two snow storms since I arrived. Luckily, my real-life context switch has not been too difficult. […]

The Pythian family got a new song last Monday — “Sheeri” means “my song” in Hebrew. This post on my own blog explains how I got the job.
High winds delayed my flight last Monday, and we’ve had two snow storms since I arrived. Luckily, my real-life context switch has not been too difficult. […]