Have you ever wondered what was in those .frm files littered
throughout your data directory? Better still, have you
encountered a situation where your data is either missing (was
deleted) or damaged and all you have is the .frm files but don't
know the structure of the table? Well, wonder no more!
The MySQL Utilities Team is pleased to announce the newest
utility - the .frm reader (mysqlfrm). This utility is designed to
read .frm files and produce a facsimile of the CREATE statement
for the table or view.
That's Impossible! How Can That Work?
It works by making a copy of the .frm file(s) and launching a
new, read-only instance of your existing server. The server need
not be running but you are required to provide an open port for
the new instance with the --port option.
The utility will launch the cloned server without reading your
configuration file (--no-defaults). The utility also makes some …
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 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]MySQL 5.6 through the eyes of a custom storage engine MySQL plugin
MySQL is famous for its pluggable storage engine architecture which allows a DBA or an application developer to choose the right engine for the task. An application uses MySQL API and is isolated from all of the low-level implementation details at the storage level. As an example, the Cloud Storage Engine (ClouSE) enables existing MySQL applications to use cloud storage such as Amazon S3 or Google Cloud Storage to store its data. The application doesn’t need to be changed or even redeployed: with ClouSE, remote cloud storage will look like a better (ultra-scalable, durable, always-on) alternative to the local storage.
As you may already know, ClouSE now supports MySQL 5.6 release …
[Read more]Check out who’s talking, and about what, at our annual event on all things MySQL, MariaDB and Cloud - straight after Percona Live!
As we mentioned earlier this week, we’re gearing up for Percona Live: MySQL Conference and Expo in a few weeks.
But of course, we’re getting particularly excited as we prep for the 2nd annual SkySQL and MariaDB MySQL & Cloud Database Solutions Day, which takes place on the day (Friday, April 26) right after Percona Live: MySQL Conference and Expo.
Check out who’s talking, and about what, at our annual event on all things MySQL, MariaDB and Cloud - straight after Percona Live!
As we mentioned earlier this week, we’re gearing up for Percona Live: MySQL Conference and Expo in a few weeks.
But of course, we’re getting particularly excited as we prep for the 2nd annual SkySQL and MariaDB MySQL & Cloud Database Solutions Day, which takes place on the day (Friday, April 26) right after Percona Live: MySQL Conference and Expo.
Join the SkySQL and MariaDB Crews in Santa Clara and Save on Registration
Percona Live: MySQL Conference and Expo 2013 starts in just 3 weeks, and it’s the premiere event for MySQL users, open-source enthusiasts, and the technology movers ‘n shakers that make up the rich and diverse MySQL ecosystem.
">
Join the SkySQL and MariaDB Crews in Santa Clara and Save on Registration
Percona Live: MySQL Conference and Expo 2013 starts in just 3 weeks, and it’s the premiere event for MySQL users, open-source enthusiasts, and the technology movers ‘n shakers that make up the rich and diverse MySQL ecosystem.
">
MySQL for Database Administrators is the foundation of the authentic MySQL Curriculum. By taking this live 5-day instructor-led course, you find out how MySQL enhancements increase performance, scalability, reliability and manageability of your Web, Cloud and embedded application requirements.
You will learn to:
- Setup the server and databases
- Maintain and secure data
- Configure for performance and high availability
- Explore real-world problems and discover best practices
You can take this course as a:
- Live Virtual Event: Take this course from your own desk choosing from 15 events already on the schedule, delivered in English or Germany. …
Hi everyone!
Here’s a video of this week’s #DBHangOps:
March 27th at 12:00pm PDT (19:00 GMT) is when the next #DBHangOps is gonna go down. Check out the twitter search and hop on the google hangout to contribute some discussion! This week’s topics are:
- MySQL and puppet
- Sheeri Cabral shared a pastebin of a puppet manifest used at Mozilla: http://scabral.pastebin.mozilla.org/2251358
- MySQL “Gotchas” (round 2)
- A shoutout for NWCNA 2013 from Sheeri. Submit …