Data comparison is a difficult and resource-intensive process.
For convenience, this process can be divided into several
steps.
First, you should compare tables from one database on one server
with the database on the other server. You should choose columns
for data comparison, and also choose a column that will be a
comparison key.
The next step is to choose all data from these tables or some
specified part of the data.
The third and the most important step is comparison of the two
tables by the selected comparison key itself. During this process
the status of each record is set to “only in source”, “only in
target”, “different”, or “equal”.
The final steps of the data comparison process are including
records to the synchronization and synchronization itself. During
these steps records needed for synchronization are chosen, update
script is created, and after that the script is executed.
You can read …
Changes (as compared to 8.22) include:
Features:
* Added an option to define a ‘color code’ for a connection. The
color will be used as background color in the Object
Browser.
* A Query Builder session can now be saved and resumed.
* In Query Builder a table alias can be defined for any table by
double-clicking the title bar of the table symbol.
* In RESULT tab results can now be retrieved page-wise. This is
ON as default with this build with a defined LIMIT of 1000 rows.
For a specific query user can change and for this specific query
the setting is persistent across sessions. Also read
‘miscellaneous’ paragraph below.
* Added a context menu to Query Builder canvas.
Bug Fixes:
* Deleting a user would leave non-global privileges orphaned in
the ‘mysql’ database. Now we use DELETE USER syntax if server
supports.
* Also using …
I’ve submitted a Birds of a Feather session for Maatkit at the upcoming MySQL conference. It’s not on the public schedule yet, but it has been accepted and scheduled for 19:00 on 13 Apr 2010. See you there!
Related posts:
- Presentation uploaded for Maatkit talk at MySQL Conference The slides
- I’ll be speaking at the O’Reilly MySQL Conference 2010 I’m
- Learn about Maatkit at the MySQL Conference …
I'm happy to announce that my talk
"Making MySQL administration a breeze - a look into
a MySQL DBA's toolchest" has been accepted for this year's
edition of the MySQL Conference & Expo in Santa Clara, which will
take place on April 12-15, 2010. The session is currently
scheduled for Wednesday 14th, 10:50 in Ballroom E.
My plan is to provide an overview over the most popular utilities and applications that a MySQL DBA should be aware of to make his life easier. The focus will be on Linux/Unix applications available under opensource licenses that ease tasks related to user administration, setting up and administering replication setups, performing backups and security audits.
Of course I will cover the usual …
[Read more]At the 2010 O’Reilly MySQL Conference and Expo there will be a Drizzle BoF!
It’s currently scheduled for 7pm on April 13th.
Come along, it will be awesome.
After a good while (I can’t search my Twitter stream) on Chrome I’m switching back to Firefox as my primary browser, and actually uninstalled Chrome. Why? I was getting the “Oh snap” failure page all the time, even on Google’s own Youtube! The only support I was pointed to was this page, and when I followed the instructions there when I restarted Chrome everything was gone. The sentence “copy the relevant files from the “Backup User Data” folder to your new “User Data” folder.” is useless when you consider the folder has 50+ files to sort through and I wasn’t sure which one was causing my previous problems. So back to Firefox, and thanks to Xmarks all of my stuff is there. …
[Read more]
My proposal has been accepted, yay!
I'll be speaking on a topic that I feel passionate about:
MySQL Server Diagnostics Beyond Monitoring.
MySQL has limitations when it comes to monitoring and diagnosing
as it has been widely documented in several blogs.
My goal is to share my experience from the last few years and,
hopefully, learn from what others have done. If you have a
pressing issue, feel free to comment on this blog and I'll do my
best to include the case in my talk and/or post a reply if the
time allows.
I will also be discussing my future plans on sarsql. I've
been silent about this utility mostly because I've been
implementing it actively at work. I'll post a road map shortly
based on my latest experience.
I'm excited about meeting many old friends (and most now fellow
MySQL alumni) …
I’ve submitted a Birds of a Feather session for Maatkit at the upcoming MySQL conference. It’s not on the public schedule yet, but it has been accepted and scheduled for 19:00 on 13 Apr 2010. See you there!
Well, more defections from Oracle, it's clear where the wind is
blowing. It's as if all the cool and interesting stuff is quickly
shedding itself from Oracle.
Jay Pipes has a good blog post about the
announcement and the history behind them ending up at
Rackspace.
Interesting quote: "Rackspace is also heavily invested in
Cassandra, and sees integration of Drizzle and
Cassandra as being a key way to add value to its platforms and
therefore for its customers".I look forward to seeing what that's
about.
I also liked this from Jay:"I don't know whether Larry
understands that cloud computing and infrastructure-as-a-service,
platform-as-a-service, and database-as-a-service will eventually
put his beloved Oracle cash cow in its place or not. …
I'll be presenting two talks this year:
Faster Than Alter - Less Downtime
"This will be a informative talk about real world problem solving
and the powerful yet sometimes overlooked LOAD DATA INFILE
command. This talk is for MySQL DBAs who want to expand
their
knowledge, improve performance and decrease customer facing
downtime"
Get Your Replication On: Advanced Techniques, Tips
and Tricks
Co-speaking with Sarah Sproehnle for this one! We have lots of
interesting uses for replication and some best practices up
our
sleeves. Warning: we won't be covering how to set up basic
replication
- that's a prerequisite for this talk!
Hope to see you there!