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
MySQL Sandbox supports latest MySQL releases, has more metadata and docs
MySQL Sandbox has been updated again. The latest version is 3.0.38, which was just released. There were four releases in the space of one week, and this last one is just a polished edition. Cherry-picking from the Change log: Added option...Show More Summary
A great day! MySQL Sandbox and Continuent get a MySQL Community Award
It was a busy day at Percona Live MySQL Conference and Expo 2013. After the regular sessions, there were the traditional MySQL Community Awards, and two entities close to me were among the winners. My company, Continuent won the ward...Show More Summary
Installing and administering Tungsten Replicator - Part 2 : advanced
Switching roles To get a taste of the power of Tungsten Replicator, we will show how to switch roles. This is a controlled operation (as opposed to fail-over), where we can decide when to switch and which nodes are involved. In our topology, host1 is the master, and we have three slaves. Show More Summary
Installing and Administering Tungsten Replicator - Part 1 - basics
Intro Tungsten Replicator is an open source tool that does high performance replication across database servers. It was designed to replace MySQL replication, although it also supports replication from and to Oracle and other systems. Show More Summary
Book review: Instant InnoDB
Instant Innodb, by Matt Reid This book does a good job of explaining the InnoDB internals. I have found particularly useful the section where it describe in detail all the server variables affecting InnoDB. Although these variables are also in the MySQL manual, some of them have never been explained to me as thoroughly as this book as done. Show More Summary
Multi-master data conflicts - Part 2: dealing with conflicts
In the first part of this article we examined the types of conflicts and their causes. In this part, we will analyse some of the methods available to deal with conflicts. Pessimistic locking (or: conflicts won't happen) Applicability: synchronous clusters with 2pc We've covered this topic in the previous article, but it's worth repeating. Show More Summary
Multi-master data conflicts - Part 1: understanding the problem
What is a conflict? Readers of this blog know that one of my favorite tools, Tungsten Replicator, can easily create multi-master replication topologies, such as all-masters, star, fan-in. While this is good news for system designers and ambitious DBAs, it also brings some inconvenience. Show More Summary
Sessions at Percona Live MySQL Conference 2013: fun, competition, novelties, and a free pass
The Percona Live MySQL Conference and Expo 2013 is almost 1 month away. It's time to start planning, set the expectations, and decide what to attend. This post will give a roundup of some of the sessions that I recommend attending and I look forward to. Show More Summary
Deploying remote MySQL sandboxes
Stating the problem. In my job, I do a lot of testing. And no matter how much organized we try to be, we end up with fewer machines than we would need to run all the tests that we want. For some tasks, we can run MySQL Sandbox, and get the job done. Show More Summary
North East Linux Fest and Open Database Camp - Boston, March 16-17 2013
On Thursday, I will travel to Boston, MA, to attend the Northeast LinuxFest, which includes also an edition of the Open Database Camp. The events will be at one of my favorite places on earth: The Massachusetts Institute of Technology, a.k.a. Show More Summary
Parallel replication and GTID - A tale of two implementations
MySQL 5.6 is probably the version of MySQL with the biggest bundle of new features. You may want to try it soon, since it's now released as GA, and I would like to offer some practical experience on how to use some of the advanced features. Show More Summary
Tungsten Replicator 2.0.7 is released
Tungsten Replicator 2.0.7 was released today. In addition to a large number of bug fixes, this release adds several improvements for multi-master management, and support for Amazon RDS (as a slave). While the Release Notes show a long list of improvements, I would like to focus on some of them that improve the handling of multi-master deployments. Show More Summary
Provisioning an Oracle slave using Tungsten and MySQL Sandbox
A few years ago, I used MySQL Sandbox to filter binary logs. While that one was a theoretical case, recently I came across a very practical case where we needed to provision an Oracle database, which is the designated slave of a MySQL master. Show More Summary
MySQL Sandbox as a riddle
Shlomi Noach is the next chairman of the Percona Live 2013. As such, he has opened the preview of the conference by posting some talks of interests, which includes a riddle to win a free pass. The riddle went unanswered, and Shlomi submitted it also to members of the review committee, getting only blank stares, including mine. Show More Summary
MySQL Sandbox 3.0.30 - now adapted to work with 5.5.30 and 5.6.10
The latest releases of MySQL Sandbox, in addition to deal with minor bugs, have mostly been necessary because of compatibility issues in MySQL, both 5.5 and 5.6. When I found that MySQL 5.6 has some InnoDB tables inside the 'mysql' schema,...Show More Summary
MySQL and warnings - Yet another compatibility break
The MySQL team seems to have a very peculiar idea about defaults and compatibility. Recently, I wrote about an annoying warning that cannot be removed. And previously, I noticed that MySQL 5.6 mixes warnings, info lines and errors in the same bunch of excessive chattiness. Show More Summary
Lightning talks at Percona Live MySQL Conference and Expo 2013
It happened last year at the previous Conference, and it's going to happen this year as well. There will be a session of lightning talks during the conference, for the joy of both the audience and the speakers. Lightning talks are fun and instructional micro events. Show More Summary
Easily testing MySQL 5.6 GTID in a sandbox
MySQL 5.6 seems to be ready for GA. I have no inside information about it, but from some clues collected in various places I feel that the release should not be far away. Thus, it's time for some serious testing, and for that purpose I have worked at updating MySQL Sandbox with some urgent features. Show More Summary
Fun with MySQL options
While testing MySQL 5.6, I came across some curious values for the new values used to set the crash-safe slave tables. To get safety, we need to set relay_log_info_repository and master_info_repository to 'TABLE'. That way, the replication...Show More Summary
Using a password is insecure, but no password is OK?
I have been preaching since 2003 that the default deployment of MySQL (where root can access without password) should be changed to something more sicure.Yet, MySQL 5.6 still uses the same defaults. $ mysql --no-defaults -u root --port=5000 -h 127.0.0.1Welcome to the MySQL monitor. Show More Summary