Blog Profile / The Data Charmer

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

Blog Post Archive

Multi dimensional cubes in MySQL through Gearman

I gave two presentations about Gearman at the As part of the preparation for these talks, I created several sample applications. One of them, about remote replication administration, I will cover in a separate post. The...Show More Summary

Holiday gift - A deep look at MySQL 5.5 partitioning enhancements

Half a day into my vacation, I managed to finish an article on a topic that has been intriguing me for a while. Since several colleagues were baffled by the semantics of the new enhancements of MySQL 5.5 partitions, after talking atShow More Summary

MySQL Conference 2010 - The call for participation is open

The MySQL Conference 2010, co-sponsored by Sun and O'Reilly, has opened its Call for participation.There is already an impressive lineup of tutorials, and I don't say that only because I am on that list. You will find the usual suspects...Show More Summary

MySQL schema maintenance

At CodeBits I had my first session about MySQL schema maintenance. I covered the basic command line possibilities before coming to the recommended tool, MySQL Workbench.The slides are available at slideshare.Interesting questions:Are...Show More Summary

Poor man's schema comparison

Comparing database schemas is one of those DBA tasks that occurs all the time.If you can afford the luxury of having a GUI, then MySQL Workbench is the tool for you. It will help you compare structures and eventually synchronizing the...Show More Summary

Snow Leopard blues

On Friday afternoon, I went to give a presentation about MySQL advanced features at the Sardegna Ricerche technology park. The presentation included a quick introduction to MySQL Sandbox, something that I have been doing for years, and I thought I could do blindfold, if required. Show More Summary

MySQL Sandbox and Spider at FrOSCon and OpenSQLCamp

FrOSCon and the OpenSQLCamp are about to start. I am packing for Sankt Augustin, where I will attend the fourth edition of FrOSCon and the second OpenSQLCamp. I will have two sessions, Sharding for the masses, about the Spider storage engine and MySQL Sandbox 3, about one of my favorite tools.The program is very rich. Show More Summary

Testing the InnoDB plugin with MySQL snapshots

The cat is out of the bag.MySQL 5.1 will include the InnoDB plugin, and thanks to you can try the new version right away.Here is a step-by-step guide to testing the InnoDB plugin with MySQL snapshot 5.1.39 and MySQL Sandbox.1. Show More Summary

Remote replication setup with Gearman and MySQL Sandbox

A few months ago, Brian Aker invited me to have a look at Gearman, saying that I could find interesting combinations with MySQL Proxy. I did not forget, and I kept thinking about interesting ways of using it. The first idea that I managed to apply is not related to Proxy, but to a practical problem that I have been keeping in reserve for years, i.e. Show More Summary

Test driving the Spider storage engine - sharding for the masses

At the MySQL Conference 2009 I attended a session about the Spider storage engine, an engine with built-in sharding features.The talk was notable for the speaker wearing a spiderman costume, and for some language barrier that made the talk less enjoyable than it should be. Show More Summary

Query Analyzer features integrated in MySQL Sandbox

Community strikes.It was about time that someone provided a match for MySQL Query Analyzer, the flagship feature of MySQL Enterprise.Now MySQL Sandbox includes a --query_analyzer option, which will convert your sandboxed server into an analysis machine. Show More Summary

Something to know about the event scheduler and replication

MySQL 5.1 has been GA for 4 months now, and I am sure that many people have been using the event scheduler.There is something that you must know if you are using the event scheduler in a replicated environment.The important thing to know is that, when you use the events in replication, by default the event is active on the master only. Show More Summary

sbtool - an new advanced entry in the MySQL Sandbox toolkit

MySQL Sandbox 2.0.17 introduces a new item in the toolkit. sbtool is a multi-purpose tool for advanced tasks with MySQL sandboxes.Most notables: assigned and used port detection, port range detection, replication tree, copying and moving...Show More Summary

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