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

Testing new builds with MySQL-Sandbox 3.0.24

MySQL::Sandbox 3.0.24 released yesterday, with many new features. More than vanilla MySQL If you have missed my previous announcement, here's the gist of it. MySQL Sandbox can now deal with tarballs from either Percona Server or MariaDB.The...Show More Summary

How to submit a good database bug report

When an open source project becomes popular, bug reports start flocking in.This is both good and bad news for the project developers. The good news is that someone is using the product, and they are finding ways of breaking it that we didn't think of. Show More Summary

Call for participation for MySQL events - MySQL conference and FOSDEM

It's that time of the year where MySQL would be speakers are called to action. As usual, the main event is the MySQL spring conference, this year hosted by Percona. The call for participation to the MySQL Conference And Expo 2012 is still open until December 5th. Show More Summary

Never say "there is no way"

Reading a recent MySQL book, I saw an example of SHOW CREATE TABLE that comes with backticks (`) around the table and column names, and a comment:Unfortunately,?there?is?no?way?to?remove?this?from?generated?syntax?with?this?command.(Emphasis mine).Here's how it goes: mysql> show create table mytest\G 1. Show More Summary

Replication multiple masters stars

Working with replication, you come across many topologies, some of them sound and established, some of them less so, and some of them still in the realm of the hopeless wishes.I have been working with replication for almost 10 years now, and my wish list grew quite big during this time. Show More Summary

Tungsten Replicator and MySQL Sandbox at Percona Live London 2011

I will be a speaker at Percona Live - London 2011, and I am looking forward to the event, which is packed with great content. A whopping 40 session of MySQL content, plus 3 keynotes and 14 tutorials. It's enough to keep every MySQL enthusiast...Show More Summary

Upgrading Tungsten Replicator: as easy as ...

When I talked about the usability improvements of Tungsten Replicator, I did not mention the procedure for upgrading.I was reminded about it by a question in the TR mailing list, and since the question was very relevant, I updated the...Show More Summary

My three MySQL sessions at OOW 2011 - and much more

Oracle Open World 2011 is approaching. MySQL is very well represented.Sheeri has put together a simple table of all the MySQL sessions at OOW, which is more handy than the Oracle schedule.I will be speaking in three sessions on Sunday, October 2 nd. Show More Summary

Chaining Replication Clusters

MySQL built-in replication includes a concept called relay slave, which allows you to create hierarchical database clusters.You can do the same thing with Tungsten, and this can be done in more than one way.Let's start with two distinct clusters. Show More Summary

Quick recipes for database cluster building

One lesson learned in more than two decades working in this industry is that most of the IT professionals are impatient, want to achieve results immediately, and, most importantly, they don't read documentation. Much as the average geek...Show More Summary

Welcome, MySQL commercial extensions

I saw yesterday that MySQL has finally done the right thing, and announced new commercial extensions.What this means is that paying customers receive something more than users who get the community edition for free.Believe it or not, when I was working in the community team at MySQL, I was already an advocate of this solution. Show More Summary

The happiness of failing installations

When you set-up the same software several times (for you or for your customers), you want that software to install quickly and reliably, and you are generally happy when everything works as expected.In this context, a failing installation...Show More Summary

Tungsten Replicator 2.0.4 released: usability and power

It has been a bumpy ride, with dozens of issues opened and resolved, but we finally feel that Tungsten Replicator 2.0.4 is ready for prime time.There have been quite a lot of changes. Most notably, the replicator is much faster, especially...Show More Summary

Finding tables without primary keys

I was checking a third party server, and I needed to find if there were tables without primary keys. This is important to know, not only because the lack of primary keys affects performance and data accuracy in general, but also because...Show More Summary

Primary keys from experience

From time to time I see articles in defense of natural primary keys against surrogate keys.I don't take an immovable stand on either side, as I have seen good cases for both. In general, I like the idea of a natural primary key, when I see one that it is really natural. Show More Summary

CodeBits - An event of competitive innovation

It was my pleasure and privilege to attend Codebits in 2009. As Roland Bouman says, its talk choice method is based on public voting, and therefore everyone cha have contribute to the schedule.But that is not the main reason for attending this extraordinary event. Show More Summary

Usability improvements in Tungsten Replicator 2.0.4

If you love a software product, you should try to improve it, and not be afraid of criticizing it. This principle has guided me with MySQL (where I have submitted many usability bugs, and discussed interface with developers for years), and it proves true for Tungsten Replicator as well. Show More Summary

Call for disclosure on MySQL Conference 2012

Percona has announced Percona Live MySQL Conference and Expo 2012. Kudos for their vision and entrepreneurship. I have seen comments praising their commitment to the community and their willingness to filling a void. I have to dot a few i's and cross some t's on this matter. Show More Summary

Less known facts about MySQL user grants

Reading MySQL security: inconsistencies I remembered a few related experiments that I did several years ago when I was studying for the MySQL certification.The first fact that came to mind is about the clause "WITH GRANT OPTION" can only be given on the full set of options, not on a single grant.For example GRANT INSERT,DELETE,UPDATE on world. Show More Summary

Introducing the Tungsten-toolbox

After the public home for Tungsten Replicator, we needed another place where to host complementary tools. We discussed the pros and cons of hosting these tools in the same place where we publish Tungsten, but in the end we decided that...Show More Summary

Copyright © 2015 Regator, LLC