Multi-master database systems that span sites are an increasingly common requirement in business applications.  Yet the way such applications work in practice is not quite what you would think from accounts of NoSQL systems like Cassandra or SQL-based systems like Oracle RAC.  In this article I would like to introduce a versatile design pattern for multi-master SQL applications in which individual schemas are updated in a single location only but may have many copies elsewhere both locally as well as on other sites.  This pattern is known as a system of record architecture.  You can build it with off-the-shelf MySQL and master/slave replication.

Let's …

Percona Live MySQL Conference and Expo event page, and Baron's announcement of the conference.

Dates to keep in mind:
September 1st - call for speakers opens
November 1st - call for speakers closes
Tuesday April 10th - Thursday April 12th

This week we interview Doron Levari, CEO and co-founder of ScaleBase. ScaleBase transparently scales your database, so you can have many shards without having to code sharding in your application. The sharding is completely transparent to the application. This can be combined with regular replication to have automatic use of a standby if a shard's primary database fails.

…

[...] when checked out of connection pool (use query which starts with /* ping */ *exactly* to execute lightweight ping instead of full [...]

Well like all good things, summer is also ending and its closing days are rapidly approaching. For most of the database techies, there is nothing to get remorseful, because they are thrilled to be back in full flow managing and loving their databases. They are gearing up, refreshing up, re-evaluating and reassessing themselves and also [...]

Exact !

Hi Cedric, Thanks for comment. I guess we don’t need to set it as default value is 0 and we can’t set it 1 if we used –log-slave-updates.
http://dev.mysql.com/doc/refman/5.0/en/replication-options-slave.html#option_mysqld_replicate-same-server-id

Hello, don’t forget to set “replicate-same-server-id” variable for circular replication.
Cédric

We are pleased to announce the release of MySQL Proxy 0.8.2.

Downloads are available from dev.mysql.com:

http://dev.mysql.com/downloads/mysql-proxy/

0.8.2 is a maintenance release and focuses on:

• Adding the protocol changes of MySQL 5.5 and later
• Removing the "admin" plugin from the list of default plugins as it requires configuration since 0.8.1

Note to windows users:

The Microsoft Visual C++ runtime libraries are now a requirement for running MySQL Proxy.

Users that do not have these libraries must download and install the Microsoft Visual C++ 2008 Service Pack 1 Redistributable Package MFC Security Update.

For the current Proxy version, use the following link to obtain the package:

…

We are pleased to announce the release of MySQL Proxy 0.8.2.

Downloads are available from dev.mysql.com:

http://dev.mysql.com/downloads/mysql-proxy/

0.8.2 is a maintenance release and focuses on:

• Adding the protocol changes of MySQL 5.5 and later
• Removing the "admin" plugin from the list of default plugins as it requires configuration since 0.8.1

Note to windows users:

The Microsoft Visual C++ runtime libraries are now a requirement for running MySQL Proxy.

Users that do not have these libraries must download and install the Microsoft Visual C++ 2008 Service Pack 1 Redistributable Package MFC Security Update.

For the current Proxy version, use the following link to obtain the package:

…

Last week Percona announced plans to sponsor the Percona MySQL Conference in Santa Clara in April 2012.  It is meant to replace the O'Reilly conferences of previous years.  The announcement led to some reasonable questions, for example from Giuseppe Maxia.  These and other online posts initiated a thoughtful exchange of views about the pros and cons of Percona's conference announcement by various members of the MySQL community.

Not everyone …