Pages

▼
Thursday, March 31, 2011

MySQL replication for demanding users

›
I have been working with MySQL replication for quite a while. I have dealt with simple replication setups and I have experimented with compl...
3 comments:
Thursday, March 17, 2011

How fast is parallel replication? See it live today

›
I talked about parallel replication last month. Since then, there has been a considerable interest for this feature. As far as I know, Tung...
3 comments:
Tuesday, March 15, 2011

Quick benchmarking trick

›
I have been doing quite a lot of benchmarking recently. I needed to find a safe way of measuring the time spend by the database doing a lon...
1 comment:
Sunday, March 13, 2011

A cool terminal tip for Mac users

›
If you use a Mac, and you are dealing with many similar tasks at once, like examining many database servers in different terminals, you may ...
5 comments:

Replication and sandbox talks on the road - San Francisco, Santa Clara, Orlando

›
In a few weeks, I will be on the road, for an intense set of presentations in the USA. San Francisco, April 7th I will start the tour at t...
Tuesday, March 08, 2011

The MySQL Council addresses the public bug database issue

›
When I announced the MySQL Council , I said that among its roles there is that of being a bridge between the MySQL community and Oracle. It...
3 comments:
Monday, March 07, 2011

implementing table quotas in MySQL

›
I have just seen Limiting table disk quota in MySQL by Shlomi Noach, and I could not resist. You can actually implement a disk quota using...
Sunday, March 06, 2011

Advanced replication for the masses - Part III - Replication topologies

›
After part I: the basics , and part II: parallel apply , we deal now with some more mundane topic, or how to deploy replication services in ...
1 comment:
Saturday, March 05, 2011

A hidden options file trick

›
I was listening today to the OurSQL Episode 36: It's Not Our (De)fault! Part 1 . As usual, Sheeri and Sarah are very informational and e...
4 comments:
Wednesday, March 02, 2011

beware of the log

›
The MySQL general log is one of my favorite features for a quick debug. I especially like the ability of starting and stopping it on demand...
4 comments:
Friday, February 25, 2011

Advanced replication for the masses - Part II - Parallel replication

›
I hope you liked the first part of this series of lessons. And I really hope that you have followed the instructions and got your little ...
2 comments:
Tuesday, February 22, 2011

Advanced replication for the masses - Part I - Getting started with Tungsten Replicator

›
MySQL DBAs and developers: oil your fingers and get ready to experience a new dimension of data replication. I am pleased to announce that...
10 comments:
Monday, February 14, 2011

How to detect if a MySQL server is an active replication slave

›
Sometimes you know for sure. And sometimes you wonder: Is this server part of a replication system? And, most specifically, is it an active ...
Tuesday, February 08, 2011

Webinar: Percona and Continuent on backup and replication with huge data

›
On Thursday, February 10, at 10am PST, there is a free webinar about Managing Big Data with Percona Server, XtraBackup and Tungsten . Quotin...
Monday, February 07, 2011

Evolution of MySQL metadata

›
I was looking at the latest MySQL versions, and I happened to notice that there has been a great increment in the number of metadata tables,...
3 comments:
Thursday, February 03, 2011

Open Database Camp - Accommodation and Sponsoring

›
The Open Database Camp 2011 is shaping up nicely. The logistics is being defined and local and international volunteers are showing up ...
Sunday, January 30, 2011

A first look at delayed replication in MySQL 5.6

›
If you like fresh features, you should not miss this one. MySQL 5.6.2 includes, among other improvements, the implementation of Time delay...
6 comments:
Friday, January 28, 2011

The MySQL Council is up and running. We want to hear from you!

›
The I ndependent O racle U ser G roup (IOUG) has formed the MySQL Council , with the purpose of addressing the interests and needs of MySQL ...
2 comments:
Tuesday, January 25, 2011

Joining the Oracle ACE program

›
A few days ago I received an invitation to join the Oracle ACE program , which is a group of strong community enthusiasts and advocate of ...
5 comments:
Saturday, January 22, 2011

Pitfalls of monitoring MySQL table activity with stored routines

›
A friend of mine needed a quick method to monitor a table that was frequently updated. There were several procedures writing to the table ...
5 comments: