Last week, Baron pointed out that semi-synchronous replication is not synchronous. I learned a lot reading that post, but I was surprised it was used to pimp the Percona cluster, with no comparison to MySQL's own cluster solution -- that would be a much more fair comparison. There is one critical point Baron did not make, though....

whether it's semi-synchronous replication or regular asynchronous replication, there is no guarantee of data integrity. I saw this over and over when I was consulting. Just because replication is not failing does *not* mean that the data on the master and slave are in sync.

There is no form of replication that verifies data integrity. You can check if the data on the slave is in sync with the data on the master with …

As many of you know, the schedule had been set for FOSDEM.

Giuseppe had posted the full scehdule here:

http://datacharmer.blogspot.com/2012/01/mysql-and-friends-schedule-at-fosdem.html

However, I refreshed the FOSDEM list (provided at fosdem.org) and noticed some changes to the schedule late last week.

http://fosdem.org/2012/schedule/track/mysql_and_friends_devroom

Specifically, I noticed new talks by Oli Sennhauser ("New Features in MySQL 5.6"), Alexey Yurchenko ("Galera 2.0"), Steve Hardy ("Optimizing your innodb buffer pool usage"), Liz van Dijk ("Virtualized Databases"), and Stéphane Combaudon ("Practical indexing guidelines").

…

Sometimes you might hear people talk about full backups, and differential backups versus incremental backups. What is the difference?

A full backup is pretty self-explanatory. It makes a copy of all of your MySQL data.

A differential backup, on the other hand, simply records the differences since your last full backup. The advantage of taking a differential backup is usually the space savings. Most databases have a lot of data that does not change from one backup to the next. Not copying this data into your backups can result in significantly smaller backups. In addition, depending on the backup tool used, a differential backup can be less labor-intensive for the server. If a differential backup does not have to scan all of the data to determine what has changed, the differential backup process can be significantly more efficient.

An incremental backup is a modification of a differential backup. An incremental backup …

I recently found Todd's posts on interceptors which allow callbacks (called interceptors) to be registered with the connector so that you can intercept a statement execution, commit, or any of the many extension points supported by Connector/Java. This is a language feature that allow you to implement a number of new features without having to change the application code such as load-balancing policies, profiling queries or transactions, or debugging an application.

Since Python is a dynamic language, it is easy to add interceptors to any …

Recently, I found myself needing MariaDB 5.1.60 for Windows for some testing purposes. Therefore, I needed to build it from source. I ended up using what I’d call a “blend” of the commands listed in this “how-to” and the readme file INSTALL-WIN-SOURCE, so I thought I’d post those steps.

1. Download 5.1.60 MariaDB source from here.

2. cd C:\mariadb-5.1

3. win\configure.js

4. cmake .

5. VS: File -> Open -> Solution -> MySql.sln
6. VS: Build -> Build Solution
7. VS: Right-click “PACKAGE” -> Build (in “Solution Explorer” View)

That’s it.

Let’s fire it up:

MariaDB> select version(); …

If you’re a MySQL user, tell us about your adoption plans by taking our current survey.

Back in late 2009, at the height of the concern about Oracle’s imminent acquisition of Sun Microsystems and MySQL, 451 Research conducted a survey of open source software users to assess their database usage and attitudes towards Oracle.

The results provided an interesting snapshot of the potential implications of the acquisition and the concerns of MySQL users and even, so I am told, became part of the European Commission’s hearing into the proposed acquisition (used by both sides, apparently, which says something about both our independence and the malleability of data).

One of the most interesting aspects concerned the apparently imminent decline in the usage of …

SkySQL™ today announced the immediate availability of SkySQL™ Enterprise HA, its leading 360° degrees High Availability solution for the MySQL® & MariaDB® databases.

High Availability is the #1 requested enhancement to the MySQL & MariaDB servers, even more popular than scalability and performance.  And with SkySQL's expertise at hand, it is now easier than ever before for customers to achieve the level of High Availability that they want.

SkySQL™ Enterprise HA is SkySQL's 360° answer to providing a …

Jet Profiler for MySQL 2.0.5 is now available!

We recently announced that we now provide multi-language support for English, German and Swedish. This time, the latest version adds French language support. By meeting requests from our French speaking users we hope to help even more companies manage their MySQL database performance.

This release also contains bug fixes and adds support for explaining CREATE TABLE ... AS SELECT ... queries by just explaining the SELECT part.

See also this press release.


3 Comments

Next Tuesday, January 31st, it’s going to be all about MySQL Embedded!

We will be running an Online Forum from 9.00 am to 12.00 pm PT. Oracle’s MySQL Embedded experts will deliver 4 technical sessions addressing “what all ISVs & OEMs should know about embedding MySQL…but often don’t”.

By attending the Online Forum you will learn:

• Why MySQL is a great embedded database choice for both startups and the largest software, hardware, and appliance vendors in the world, and how its features ensure costs remain low throughout an application's life cycle
• MySQL installation options that require minimal or zero end-user effort, and how to easily build them into your application
• How to secure MySQL embedded in applications, appliances, and devices
…

Next Tuesday, January 31st, it’s going to be all about MySQL Embedded!

We will be running an Online Forum from 9.00 am to 12.00 pm PT. Oracle’s MySQL Embedded experts will deliver 4 technical sessions addressing “what all ISVs & OEMs should know about embedding MySQL…but often don’t”.

By attending the Online Forum you will learn:

• Why MySQL is a great embedded database choice for both startups and the largest software, hardware, and appliance vendors in the world, and how its features ensure costs remain low throughout an application's life cycle
• MySQL installation options that require minimal or zero end-user effort, and how to easily build them into your application
• How to secure MySQL embedded in applications, appliances, and devices
…