The MySQL Utilities Team is pleased to announce a major
advancement of MySQL Utilities. It is now available as a separate
download!
That's right. If you want to use MySQL Utilities without
installing MySQL Workbench, you can do that now.
The Utilities release-1.3.0 has been built for Windows Installer,
RPM archive, and .tar/.zip. We have also made downloads for
source only if you want to use Utilities to develop your own
utilities or install the product in custom location. We plan to
add other repositories in the future.
Is that it? Well, not quite. We have also included a new utility
- the .frm Reader. See the blog, "New Utility: .frm Reader" for
more information.
If you'd like to try out the new download, visit the MySQL
Workbench download page:
http://dev.mysql.com/downloads/tools/utilities/ …
The latest from the MySQL community
Ideas, releases, practical guides, and perspectives from the people building with MySQL.
The MySQL Utilities Team is pleased to announce our latest
release, version 1.2.1. This release contains many quality
improvements and enhancements to the HA and Replication
utilities. The following lists some of the most significant
improvements.
- Improved transaction gathering algorithm for failover
- Skips slaves that are already caught up
- Ensures all transactions in the relay logs on the slaves are executed first
- External scripts in mysqlfailover and mysqlrpladmin now receive the old and new master information
- Improved demote master handling for switchover
- Improved connection error handling
- Quoting of tables and database names has been improved
- Login-path feature now reads port and socket
The utilities team continues to focus on improving usability, making features easier to use, and …
[Read more]The MySQL developer tools team announces the availability of version 5.2.46 of the MySQL Workbench GUI tool. This version contains 30 resolved bugs and support for the new MySQL 5.6 server.
Additionally, MySQL Utilities 1.2.0 have been included on the distribution.
For a full list of issues fixed in this release, see the release notes.
Please get your copy from our Downloads site. In Windows, you can also use the MySQL Windows Installer to update Workbench and other MySQL products.
Sources and binary packages are available for several platforms, including Windows, Mac OS X and Linux.
http://dev.mysql.com/downloads/workbench/
Workbench Documentation can be found …
[Read more]I recently had a need to import a bunch of data into MySQL, and for reasons I won’t get into here, LOAD DATA INFILE wasn’t working for me. I was in a hurry to get the data into MySQL so that I could filter it, and didn’t have time to work through my LOAD DATA INFILE issues. Looking around for another way to quickly get my tab-delimited data into MySQL quickly, I decided to use the MySQL for Excel plugin. If you haven’t seen this yet, and you have Excel, it might be worth your while.
In my case, I was able to quickly copy and paste the tab-delimited text file into an Excel spreadsheet, connect MySQL for Excel to the MySQL database and append the data to the existing table. You’ll need to have Excel, MySQL and the MySQL for Excel plugin. The latter two can be installed from a single download using the …
[Read more]
New in MySQL Workbench 5.2.44 is the latest release of MySQL
Utilities 1.1.0. This release contains a new utility called the
MySQL Utilities Users' Console (mysqluc).
The MySQL Utilities Users' Console is designed to make using the
utilities easier. While it is not a new utility in the sense it
doesn't provide any new functionlity for managing MySQL servers
or data, it does provide a unique shell environment with command
completion, help for each utility, user defined variables, and
type completion for options.
That's right, you no longer have to type out the entire name of
the utility. For example, you can type mysqldbe and press the TAB
key and it will complete the command as mysqldbexport. Don't
remember the name of a database utility you want to use? That's
no problem either - just type mysqldb and press TAB twice. The
console will list all of the utilities that start with
mysqldb.
The same is true …
Momentum for MySQL Utilities continues to build. I hosted a webinar recently about MySQL Utilities (available on-demand from the link below), which generated a lot of interest and some good questions.
With so many questions and ideas coming in I decided to create a blog of FAQs. I plan to add these to the MySQL documentation as well. Keep your ideas and questions coming!
I hope you find these questions enlightening. I have grouped them for easier reading. You can find the MySQL Utilities documentation using the link below.
…
[Read more]
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 utility, simply use the
--sql option to tell the utility to produce the statements.
Object Transformations with mysqldiff
If you would like to compare the schema of two databases (the
objects and their definitions), mysqldiff can do that for you and
produce a difference report …
The new MySQL 5.6 Development Milestone Release (DMR) includes
many new enhancements. One of the most impressive is the use of
Global Transaction Identifiers (GTIDs) for replication. With
GTIDs enabled, administrators no longer need to keep track of
binary log files and positions. In a nutshell, GTIDs simplify the
setup and maintenance of replication.
MySQL Utilities has taken this a step further by providing two
new utilities that automate two of the most complex replication
administration tasks - switchover and failover. Switchover is
changing the role of an active, healthy master to one of its
slaves whereas failover is the act of promoting a candidate slave
to become the new master. Clearly, switchover is an elective
operation and failover is performed when there are issues with
the master.
The GTID utilities are included in release-1.0.5 of MySQL
Utilities. They are included as a plugin for MySQL Workbench or
via …
The MySQL Developer Tools team is announcing the next maintenance
release of its flagship product, MySQL Workbench, version 5.2.39.
This version contains MySQL Utilities 1.0.5, a set of command
line Python utilities for helping to perform and script various
administration tasks for MySQL. A complete list of changes in
this release of the Utilities can be found at:
http://dev.mysql.com/doc/workbench/en/wb-utils-news-1-0-5.html
MySQL Workbench 5.2 GA
• Data Modeling
• Query (replaces the old MySQL Query Browser)
• Administration (replaces the old MySQL Administrator)
Please get your copy from our Download site.
Sources and binary packages are available for several platforms, including Windows, Mac OS X and Linux.
…
[Read more]
I see so many posts on what happened to company X, product Y and
dream Z that I couldn't resist the temptation to summarize this
great year for MySQL. At the end of 2010, Oracle did an
announcement we were all waiting for: MySQL 5.5 is GA! Another year has passed
since then and it's time to reflect on what has been done.
I know this is a long post. I tried to rewrite it at least 10
times to make it shorter, but I couldn't condense the list.
Hence, I wrote a summary in the beginning for those who don't
want to read it all.
I believe that 2011 was an exceptional year for MySQL and I
really enjoy being part of this team. I wish all of us a lot of
success and fun in the years to come!
Summary:
Oracle released many …
