Home |  MySQL Buzz |  FAQ |  Feeds |  Submit your blog feed |  Feedback |  Archive |  Aggregate feed RSS 2.0 English Deutsch Español Français Italiano 日本語 Русский Português 中文
Previous 30 Newer Entries Showing entries 31 to 44

Displaying posts with tag: Sys-Admin (reset)

How to know if a MySQL slave is identical to its master
+0 Vote Up -0Vote Down

A frequently asked question about MySQL replication is "how do I know whether my slave is identical to the master?" Until recently there hasn't been a good way to know, but now you can compare all the data in your master to the data in the slaves and get a reliable yes-or-no answer. And you can do this online, efficiently, across many servers simultaneously. Read on to find out how.

Three updated tools in MySQL Toolkit
+0 Vote Up -0Vote Down

I've just released three updates to tools in MySQL Toolkit. The updated programs are MySQL Query Profiler (major new features and helper script), MySQL Table Sync (bug fixes, documentation, features), and MySQL Table Checksum (minor sanity check enhancement).

MySQL Table Sync vs. SQLyog Job Agent
+0 Vote Up -0Vote Down

When I wrote my first article on algorithms to compare and synchronize data between MySQL tables, Webyog's Rohit Nadhani left a comment on the article mentioning the SQLyog Job Agent, which has a similar function. Although I have been developing MySQL Table Sync essentially in isolation, I have been meaning to give SQLyog Job Agent a try. I recently did so, and then followed that up with an email conversation with Rohit. This article is about my experience using the SQLyog Job Agent from the command line, some thoughts on the algorithm as best I can deduce it, and benchmark results against MySQL Table Sync.

A progress report on MySQL Table Sync
+0 Vote Up -0Vote Down

I wrote an article late last week about benchmark results for the two table-synchronization algorithms I've been implementing for the MySQL Table Sync tool. I've spent some time developing a test suite for the tool, and learned some really interesting things about the general problem of synchronizing tables.

Introducing MySQL Table Maintainer
+0 Vote Up -0Vote Down

MySQL Table Maintainer is a new utility to help you run table maintenance commands (ANALYZE, CHECK, OPTIMIZE, REPAIR) on your MySQL tables. It's part of the MySQL toolkit.

MySQL Toolkit updated
+0 Vote Up -0Vote Down

I've just released updates to all the tools in the MySQL Toolkit. The biggest change I made to most packages is using DBD to read MySQL's option files, though some packages got more significant updates.

MySQL Toolkit?s Show Grants tool 0.9.1 released
+0 Vote Up -0Vote Down

MySQL Toolkit's Show Grants tool can now separate grants into individual statements, convert them into REVOKE statements, and help you remove users from a server, even if your server doesn't support DROP USER.

Introducing MySQL Table Sync
+0 Vote Up -0Vote Down

MySQL Table Sync efficiently finds and resolves data (not structural) differences between two MySQL tables, which may be on different servers. It offers two search algorithms to find the rows that differ, and several methods to bring the destination table into sync with the source.

Introducing MySQL Toolkit?s Show Grants tool
+0 Vote Up -0Vote Down

MySQL Toolkit's Show Grants tool makes it easy to extract grants from a MySQL server in canonical form. You can use it to replicate grants between servers, diff grants, and avoid spurious changesets in version control systems.

Introducing MySQL Deadlock Logger
+0 Vote Up -0Vote Down

I'm continuing to add new tools to the MySQL Toolkit. MySQL Deadlock Logger is for extracting and storing information about the latest recorded InnoDB deadlock. It's not only easy to view the information from the command line, it's dead simple to store it back into a MySQL table for analysis. I think most users will find it handy to create a cron job to record the deadlocks automatically for later analysis.

What to do when MySQL says skip-innodb is defined
+0 Vote Up -0Vote Down

Are you seeing a MySQL error that says InnoDB support isn't enabled, even though it is? This article explains why it happens and how to fix it.

MySQL Table Checksum bug fix
+0 Vote Up -0Vote Down

I somehow introduced a syntax error into MySQL Table Checksum in the 1.0.1 release and didn't notice till just now. I've replaced the file in the Sourceforge release, but it may take a few hours for it to propagate to all mirrors. My apologies.

innotop 1.4.0 released
+0 Vote Up -0Vote Down

It's finally ready -- the new stable version of the innotop MySQL and InnoDB monitor. Version 1.4.0 brings you new features and enhancements I think you'll really enjoy.

MySQL Query Profiler, Checksum, Index Checker updated to version 1.0.1
+0 Vote Up -0Vote Down

I got a lot of very nice feedback on the three tools I recently added to the MySQL Toolkit project on Sourceforge, and found and solved several issues with quoting and password prompting, index types, and so forth. Thank you all for your feedback, and welcome to Ruslan Zakirov, who plans to add some new tools!

Previous 30 Newer Entries Showing entries 31 to 44

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.