The latest release of MySQL Enterprise Backup (MEB 3.7.0) introduces a new method for performing incremental hot backups - the redo-log-only incremental backup. This new method of incremental backups allows for highly compact and fast incremental backups and MEB users now have the choice between data-file based incremental backups and the redo-log-only incremental backups.

In data-file based incremental backups (performed using the '--incremental' option) MEB scans all InnoDB datafiles but copies to the backup only modified pages. The main benefit of this is …

Linux.conf.au this year kicks off next week in Ballarat, just down the road from me.  I'll be there and even have a speaking gig, not in the main conference but in the HA and Distributed Storage mini-conf before the main event.

I'll be talking about MySQL®, the companies that now exist to support it, and the third party products that are starting to proliferate in what appears to be a community effort to address perceived shortcomings in the Oracle offerings.  Many of these offerings are in the HA space, and there have been some pretty amazing developments recently.

So if you want to find some history of Oracle's effect on MySQL's …

The collaboration is good and the information was useful!!!!!!!!!

In this post I want to show new possibilities which open with Percona XtraDB Cluster.
We will create 3 nodes Cluster with nodes on different continents (Europe, USA, Japan) and each node will accept write queries.
Well, you theoretically could create 3 node traditional MySQL ring replication, but this is not what you want to use day-to-day.

To show how it works I will use Amazon m1.xlarge instances, by one in Tokyo, Ireland and North California, running RedHat Entreprise 6.2 64bit.

In fact to create instances is most time consuming task. After that using my script you will have cluster running in 5 min or less.

There however some precautions needed if you run Amazon instances.
First, you need to open ports in the firewall. For the communication the nodes need, …

Current White Papers for the Oracle Professional Zero Downtime Migration to Oracle Exadata using Oracle GoldenGate In this paper we will review Oracle GoldenGate’s capabilities and how it can be used to achieve zero downtime migration and consolidation to Oracle … Continue reading →

A few months ago I wrote an article geared towards MySQL Windows users on using ActiveState Perl in order to run various MySQL scripts. It was kind of a pain to get set up properly for MySQL usage, hence requiring a write-up in the first place.

But now I’d just like to inform all Windows MySQL users that using Strawberry Perl for your Perl needs is much easier than Active State Perl.

Simply install it. That’s it. No need to worry about later locating and installing the Perl DBI and DBD:MySQL modules, as they’re automatically installed. How refreshing!

You can download Strawberry Perl from here:

http://strawberryperl.com

I downloaded the latest GA version: 5.12.3.0, double-clicked on the installer, installed it, and ran the MySQL scripts immediately.

It doesn’t get …

We are giving PECL/mysqlnd_qc a second chance. PECL/mysqlnd_qc is a query cache plugin for mysqlnd. It can cache any query issued by any PHP MySQL extension using storage handler for process memory, APC, Memcache and SQLlite. Its default invalidation strategy is Time to Live (TTL). Using a more sophisticated invalidation strategy is possible. Of course, its transparent to use and inherits all the other advantages of a driver based approach.

Award-winning technology: Oxid loves the query cache
View more presentations on PHP and MySQL Cloud and Cluster

Albeit quite powerful the plugin came late and is faced with stiff competition from …

 There is an updated version of the MySQL Cluster Evaluation Guide to go with the MySQL Cluster 7.2 Development Milestone Release.

The purpose of this guide is to enable you to efficiently evaluate the MySQL
Cluster database and determine if it is the right choice for your application,
whether as part of a new project or an upgrade to an existing service.
This guide presents a brief overview of the MySQL Cluster database and new
features in the latest 7.2 Development Milestone Release, and then discusses:

• Considerations before initiating an evaluation
• Evaluation best practices
• Configuration options and sanity checking
• Troubleshooting
…

 
Thanks again to Sheeri Cabral  for having me at the Boston MySQL Meetup on Monday for the talk on “Fractal Tree® Indexes – Theoretical Overview and Customer Use Cases.” The crowd was very interactive, and I appreciated that over 50 people signed up for the event and left some very positive comments and reviews.

In addition, the conversation spilled over late into the night as we made our way over to nearby Mead Hall afterwards for a few drinks, some food, and to continue the discussion.

The presentation is …

I’ll be speaking at FOSDEM 2012 conference at MySQL and Friends track (schedule is yet to appear) with two talks “How to offload MySQL server with Sphinx” and “Sphinx performance top secrets”. Additionally I’ll be co-presenting “Sphinx users stories” with SkySQL engineers and customers.

Looking forward to meet you at FOSDEM 2012!