Planet MySQL Planet MySQL: Meta Deutsch Español Français Italiano 日本語 Русский Português 中文
Showing entries 1 to 10 of 13 3 Older Entries

Displaying posts with tag: synchronization (reset)

How does the Replication Synchronization Checker Work?
+1 Vote Up -0Vote Down

We recently introduced 'mysqlrplsync' in MySQL Utilities release-1.4.2 RC. This new utility allows users to check the data consistency of an active replication system. In this blog we provide more details about how 'mysqlrplsync' works.

In an active replication topology, slaves may be slightly behind the master in processing events. Depending on the workload and capabilities of each slave, transactions may be applied at different times. Should this occur and something untoward happen to one of the slaves (such as a user making a manual change directly on the slave), a synchronization process may be required to ensure that the slaves …

  [Read more...]
New MySQL Utility: Replication Synchronization Checker
+1 Vote Up -0Vote Down

We are very happy to introduce an new MySQL utility called 'mysqlrplsync' that can check the data consistency of an active replication system. This utility is one of the new utilities included in MySQL Utilities release-1.4.2 RC. The other utility is the multi-source replication utility, mysqlrplms.

In a nutshell, the mysqlrplsync utility allows you to check the data consistency between servers in an active replication system. The utility reports missing databases and tables as well as data differences (per table) between the servers. A sophisticated synchronization algorithm that utilizes a table checksum is applied on the active replication …

  [Read more...]
Compare and Synchronize Databases with MySQL Utilities
Employee +2 Vote Up -0Vote Down

The mysqldiff and mysqldbcompare utilities were designed to produce a difference report for objects and in the case of mysqldbcompare the data. Thus, you can compare two databases and produce a report of the differences in both object definitions and data rows. 

While that may be very useful, would it not be much more useful to have the ability to produce SQL commands to transform databases? Wait no longer! The latest release of MySQL Utilities has added the ability to generate SQL transformation statements by both the mysqldiff and mysqldbcompare utilities. 

To generate SQL transformations in either …



  [Read more...]
MySQL schema maintenance
+3 Vote Up -0Vote Down



At CodeBits I had my first session about MySQL schema maintenance. I covered the basic command line possibilities before coming to the recommended tool, MySQL Workbench.
The slides are available at slideshare.


Interesting questions: ([updated] with answers from the development team









  [Read more...]
Maatkit version 1674 released
+0 Vote Up -0Vote Down

This release contains bug fixes and new features. Click through to the full article for the details. I'll also write more about the changes in a separate article.

What is new in Maatkit
+0 Vote Up -0Vote Down

My posts lately have been mostly progress reports and release notices. That's because we're in the home stretch on the book, and I don't have much spare time. However, a lot has also been changing with Maatkit, and I wanted to take some time to write about it properly.

Maatkit version 1579 released
+0 Vote Up -0Vote Down

This release contains bug fixes and new features. The biggest new feature, in my opinion, is a new sync algorithm for mk-table-sync. Now you can sync any table with an index more efficiently than previously. This is the return of the speed I promised earlier. (Though I haven't yet benchmarked it; I am very short on time these days. Your benchmarks and other contributions are welcome).

I'm finally feeling like the table sync tool is getting in good shape!

Changelog etc is in the full article.

Maatkit version 1417 released
+0 Vote Up -0Vote Down

Download Maatkit

Thanks again to all the great sponsors for my week of work on the kit!

This is the long-awaited "Baron worked on table sync" release. Hooray!

Please read the full blog post for important (very important!) information.

Progress on Maatkit bounty, part 3
+0 Vote Up -0Vote Down

This is the last day I'm taking off work to hack on mk-table-sync, and I thought it was time for (yet another) progress report. Here's what I have done so far. (Click through to the full article to read the details).

Progress on Maatkit bounty, part 2
+0 Vote Up -0Vote Down

Ironically, the Stream algorithm I wrote as the simplest possible syncing algorithm does what the much more efficient algorithm I wrote some time ago can't do: sync a table without a primary key, as long as there are no duplicate rows. In fact, it's so dumb, it will happily sync any table, even if there are no indexes.

The flash of inspiration I had on Friday has turned out to be good...

Showing entries 1 to 10 of 13 3 Older Entries

Planet MySQL © 1995, 2014, Oracle Corporation and/or its affiliates   Legal Policies | Your Privacy Rights | Terms of Use

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.