Blog Profile / The Data Charmer
| URL : | http://datacharmer.blogspot.com | |
|---|---|---|
| Filed Under: | Programming / Database Development | |
| Posts on Regator: | 304 | |
| Posts / Week: | 1.2 | |
| Archived Since: | June 30, 2008 | |
Blog Post Archive
Announcing the Open Database Camp - Sardinia, May 2011
I have been traveling to many conferences in the last 10 years, and many times I have been asked to organize an event in my native land, Sardinia. After delaying the inevitable for long time, here I can announce it. The Open Database...Show More Summary
Looking for a hack - Passing comment-like info through the binary log
I am facing an interesting problem. I need to mark somehow a statement in such a way that the comment is preserved through the binary log.
I don't have control on how the statement is generated or using which client software. For the...Show More Summary
Some hidden goods in MySQL 5.5
The announcement of MySQL 5.5 released as GA has outlined the improvements in this version, which indeed has enough good new features to excite most any user. There are two additions, though, that were lost in the noise of the bigger features, and I would like to spend a few words for each of them. Show More Summary
Speaking at the O'Reilly MySQL Conference - April 2011
I will present two talks at the MySQL Conference next April. One is a three hours tutorial on Advanced MySQL Replication Techniques, and the other is a normal session on The art of sandboxing. Reducing Complex Systems to Manageable Boxes. The first topic is not a first to me. Show More Summary
Excluding databases from mysqldump
A question that came up during the MySQL track at the UKOUG conference in Birmingham was "Can I exclude only a few databases from mysqldump? Let's say that I have 50 databases, and I want to dump all of them, except a few." As many know, mysqldump has an option to ignore specific tables. Show More Summary
My picks for PGDay-EU 2010
On Sunday I will be in Stuttgart with the double purpose of attending the annual European PostrgreSQL conference and the technical meeting of my company that will be held after the normal proceedings of PGDay-EU. For the first time in several years I am attending a conference where I am not a speaker. Show More Summary
Who's afraid of MySQL forks?
There is much talk about MySQL forks and how they are going to replace MySQL, or take over MySQL user base, or become more powerful/profitable/popular/you-name-it than MySQL itself. Let's clear some air on this topic. There is more about...Show More Summary
Dispelling some unintentional MySQL FUD
There are three types of FUD: the first and more genuine is (#1) the intentional spreading of falsehood, mostly to gain some marketing advantage over a competing product. While I despise this practice, I understand it. Then there isShow More Summary
A world of ebooks
I am a bibliophile, or, to say it in plain English, a book lover. I have been collecting books since I was in first grade. I read books at high speed, which is both a blessing and a curse. A blessing, because I can squeeze useful information out of a book very quickly, and that's useful for my job, and for some of my hobbies. Show More Summary
How MySQL Workbench breaks itself
Once upon a time, there was a policy in MySQL not to add new features after the beta stage. To my surprise, MySQL Workbench 5.2.30 introduces a new feature, the query formatter. I gave it a try. The results are not extremely encouraging. Show More Summary
How to create a private cloud in your laptop
Everybody is moving to cloud architectures, although not all agree on what cloud computing is. In my limited understanding, and for the purpose of my work, cloud computing is a quick and versatile availability of virtual machines.
Now, if my purpose was deploying these machines, a private cloud in one host (namely, my laptop) would not make sense. Show More Summary
Filtering binary logs with MySQL Sandbox and replication
A few days ago, a friend of mine asked me if I knew of a way of filtering a bunch of binary logs, to extract only statements related to a single table. The task was about filtering a few hundred binary log files. It's a tricky problem. Show More Summary
Speaking at the UK Oracle User Group conference - Birmingham
Back to the conference circuit after some rest. On December 1st I will be speaking under my new affiliation at Continuent in the MySQL track at the UKOUG conference. My topic is MySQL - Features for the enterprise and it will basically...Show More Summary
Testing MySQL 5.5 semi-synchronous replication
A few days ago I saw an article about Semi-Synchronous Replication in MySQL 5.5. It asks questions, and doesn't give answers beyond gut feeling. So I thought that I would do some practical testing of this new feature.
Before we go that way, though, let's revisit the theory.
How semi-synchronous replication works
Figure 1. Show More Summary
QA at Continuent. A serendipitous job.
A few days ago, I left the MySQL team at Oracle, after more than 4 years of work dedicated mostly to the MySQL community. Someone will probably remember that, when I joined MySQL in 2006, I started my work in the QA team. It was no coincidence. Show More Summary
Book review: MySQL 5.1 plugin development
MySQL 5.1 Plugin Development, by Sergei Golubchik and Andrew Hutchings. Packt Publishing, 2010. Executive summary: Highly recommended. If you want to develop MySQL extensions, buy this book. It's a must, written by two expert professionals who probably know more than anyone else on this matter. Show More Summary
My wish list for OpenSQLCamp, Boston 2010
On Friday, October 15 th, the third OpenSQLCamp in North America will start at 6pm with a social event and then continue with more technical stuff over the week end. Compared to the overcrowded Oracle Open World with its 45,000 attendees, this event may look like a desert. Show More Summary
A funny recipe.
According to a recent book about MySQL, this is the recipe to convert an IP address into an integer, with the purpose of using it as server-ID. Take for example 10.0.159.22 Using a calculator (!!!), convert each of the four numbers to...Show More Summary
Book review : SQL Antipatterns
SQL Antipatterns, by Bill Karwin I remember that when I finished reading The Lord Of The Rings, I felt a pang of disappointment. "What? Already finished? What am I going to read now? What can give me the same pleasure and sense of accomplishment...Show More Summary
OpenSQLCamp EU 2010 - Vote your favorite sessions
The deadline for the OpenSQLCamp CfP is over. Now it's time to submit your votes. As we did last year, the procedure is public and transparent. After seeing the list of submitted sessions, you can then vote via mailing list, or via Twitter. But, please, hurry! We need to finalize the schedule at the end of this week. Thanks!