Schema definitions on replication slaves sometimes differ. Ability to rename schemas, tables and columns and still setup replication with comfort is useful for MySQL to MySQL replication, while for heterogeneous topologies like these, it's a must. In this article I'll present a component which I recently developed to enable an easy way of renaming database objects during both (a) initial slave load (provisioning) and (b) real-time replication.

It is called RenameFilter and is part of the latest Tungsten Replicator build. RenameFilter works with all DBMS types that Replicator supports.

Specifying What to Rename
First, let's look at how rename definitions file looks like. It is a CSV file which first three columns specify what to rename, while …

Annnd all set! Check out the recording for the topics below:

Hello everyone!

We missed out on the last meeting time for #DBHangOps due to some conflicts, but we’re looking to come back strong this Wednesday, June 12th 2013 at 12:00pm pacific (19:00 GMT). Come join the discussion and contribute your experience on:

• Upgrading to MySQL 5.6
  • Any issues or gotchas?
• MySQL Python Utilities
  • How do you use them?
• MySQL patches
  • Patches you use
  • Patches you want
• Interesting or valuable Linux kernel settings

Be sure to check out the #DBHangops twitter search, the DBHangops Twitter …

Seems interesting. Where do we apply for beta testing ?

Also, when we can expect Linux version ?

Annnd all set! Check out the recording for the topics below:

Hello everyone!

We missed out on the last meeting time for #DBHangOps due to some conflicts, but we're looking to come back strong this Wednesday, June 12th 2013 at 12:00pm pacific (19:00 GMT). Come join the discussion and contribute your experience on:

• Upgrading to MySQL 5.6
  • Any issues or gotchas?
• MySQL Python Utilities
  • How do you use them?
• MySQL patches
  • Patches you use
  • Patches you want
• Interesting or valuable Linux kernel settings

Be sure to check out the #DBHangops twitter search, the DBHangops Twitter Feed, …

We are excited to announce that we just released a new beta of XAMPP. It is a little rough around the edges, but we wanted to release it early to give you a chance to let us know what you think and help make XAMPP a better software bundle.

http://www.apachefriends.org/xampp-beta.html

This is the first version we have released since we announced earlier this year that the BitNami team would be joining the XAMPP project. Thanks to their work, this version of XAMPP includes the following improvements:

• Updated main components PHP to 5.4.15, MySQL to 5.5.30, Apache to 2.4.4
• Updated Linux and Mac OS X versions of XAMPP, which had not been updated for a while. Moving forward, we aim to keep them up to date and perform releases at the same time as the Windows version.
• New manager tools for Linux and OS X that allows starting / …

Percona Server for MySQL version 5.1.69-14.7

Percona is glad to announce the release of Percona Server 5.1.69-14.7 on June 10, 2013. A drop in replacement for MySQL, downloads are available  here and from the Percona Software Repositories. Based on MySQL 5.1.69, this release will include all the bug fixes in it. All of Percona’s software is open-source and free, all the details of the release can be found in the …

Recently, I was working with a client that asked about using Percona Xtrabackup to take a snapshot of a particular MySQL schema and then reload it with a different schema name on the same server.  It caught me off guard because I’d never really thought about it – typically, I’ve used Xtrabackup simply to clone a server (for replication or migration) or migrate an existing schema to a new server.  However, given the import/export functionality of Xtrabackup combined with Percona Server (Exporting and Importing Tables), it did seem …

First, I have to tell you, that the “fragmentation” is not the best word what I should use, but that was the closest to that what I wanted to say. The base of the fragmentation checker script is Peter Zaitchev’s 2008 article about Information_schema, I used that query to get that results what I needed.

Some background: a few weeks ago we got some free space related problems (well, they weren’t a real problem, but they could lead onto one, and we had to act fast.) The innodb is working on a bit strange way, it is not like to free up space what is deleted before, and because of this, the datafiles will grow to the end of the world. The first thing what we could do to reclaim free space is to use

innodb_file_per_table

configuration option, what will split up the database to a lot of …

Use tungsten replicator to replicate between mysql and mongodb.

Mysql tables are equivalent to collections in mongodb. The replication works by replicating inserts and updates. But all DDL statements on mysql are ignored...

Replication in detail

MySQL continues to improve in terms of performance. To get the best out of MySQL, you must learn to analyze your system and use tools to monitor, evaluate and tune the MySQL Server.

The MySQL Performance Tuning training is a 4-day instructor-led course which teaches you to configure the database for performance, tune application and SQL code, tune the server, examine storage engines and assess the application architecture.

You can take this course through the following event types:

• Training-on-Demand: Start training within 24 hours of registration. Follow this course at your own pace through streaming video of instructor delivery and scheduling time to do lab exercises at a time that suits you.
• Live-Virtual: Attend …