Blog Profile / The Data Charmer

Filed Under:Programming / Database Development
Posts on Regator:147
Posts / Week:0.4
Archived Since:June 30, 2008

Blog Post Archive

A deceiving error message while setting a replication slave

I was setting up a slave manually for a quick-and-dirty experiment, when I found this one:mysql %gt; slave start;ERROR 1200 (HY000): The server is not configured as slave; fix in config file or with CHANGE MASTER TOHmm... I did the CHANGE...Show More Summary

Q&A on MySQL 5.1

Listening to Sheeri's presentation on MySQL 5.1, I saw that there are a few questions left unanswered. I am listing here some of the questions that I found interesting, plus a few from an early webinar on the same topic.Q: does Partitioning physically split data?A: No. Show More Summary

Tutorial on Partitioning at the MySQL Users Conference 2009

Another approval has arrived. I will be co-presenting a tutorial at the MySQL Users Conference 2009.Partitioning in MySQL 5.1. My co-speaker is Sarah Sproehnle, a well known MySQL trainer. The topic is one of the flagship features of...Show More Summary

Will you use row-based replication by default?

MySQL 5.1 introduces row based replication, a way of replicating data that fixes many inconsistencies of the statement based replication, the standard method used by MySQL so far.The good: row based replication solves some problems with replicating the result of non deterministic functions, such as UUID() or NOW(). Show More Summary

Decoding binlog entries with row-based replication

If you have tried using row based replication, you may have noticed two things: (1) it fixes many inconsistencies of statement-based replication, but (2) the binlog is unfit for humans. Inspecting it after a problem occurs won't provide...Show More Summary

MySQL virtual columns

Would it be cool to enhance MySQL creation table syntax to do this?CREATE TABLE t1 ( my_date DATE, my_month VIRTUAL INT AS (DATE_FORMAT(d,'%Y%m')));And later, when you insert '2008-08-23' in my_date, then automatically my_month will be set to 200808.Yes, it would be cool, and it has been done. Show More Summary

Editing a dump file from the airport

Keith Murphy asks if you have ever edited your dump files before feeding them to the database. And he recommends using sed. This reminds me of a war story, when I was consulting in Milan. The customer needed, among other things, to import a huge text file (created by a third party application) into a MySQL database. Show More Summary

Copyright © 2015 Regator, LLC