MySQL has the well earned reputation for ease-of-use and “15-minutes-to-success”, since we continually focus making the server easy to use. MySQL Workbench provides the visual tools for database design, development, and administration. However, many DBAs prefer using the command-line, and there are many tasks that require the creation scripts for doing the job.

To make it easier to work with the server, the latest release of the MySQL Workbench—version 5.2.31—contain a set of Python scripts intended to make the life easier for DBAs by providing easy-to-use utilities for common tasks, which were introduced in the blog MySQL Workbench: Utilities. The set currently consists of just a few utilities, but will expand over time.

The utilities available in the Workbench are:

…

Yay! My talk on new metadata locking in 5.5 was accepted to the
O'Reilly MySQL Conference

I'm happy to be given a chance to come and visit this place again (7th time!), especially since I know that it reinvents itself every year.

This year it's going to be different: as far as I can see, there is close to no participation in the conference on the Oracle side, and the content is being provided almost fully by the rest of the community.
Nothing to worry about if one looks for best talks -- last year's most popular sessions were delivered by Percona and Monty Program speakers anyway -- but very likely this year's participation will be, as in good old days, fewer suites and more engineers.

MariaDB 5.1 was released in February 2010. MariaDB 5.2 was released in November 2010. In terms of download numbers of MariaDB binaries from mariadb.org, we’ve seen 4x growth, and this is always good news (yes, we had our best download month in November 2010).

I run MariaDB on about six production servers of mine. All the Monty Program infrastructure that uses a database runs MariaDB (varying from 5.1 and 5.2). Monty Program have customers that are using MariaDB in production, and for that, watch out for some case studies.

Now I’d like to know: are you running MariaDB in a production environment?

Does it power your blog? Does it power a huge number of your servers? Have you migrated from another database? I’d like to know. Please shoot colin[AT]montyprogram[dot]com an email so I get a better feeling of how much MariaDB is being used in production environments. Who knows, it might even make a good …

One data point which is very helpful but surprisingly few people have is the history of the table sizes. Projection of data growth is very important component for capacity planning and simply watching the growth of space used on partition is not very helpful.

Now as MySQL 5.0+ has information schema collecting and keeping this data is very easy:

PLAIN TEXT SQL:

1. CREATE DATABASE stats;
2. USE stats;
3. CREATE TABLE `tables` (
4. `DAY` date NOT NULL,
5. `TABLE_SCHEMA` varchar(64) NOT NULL DEFAULT '',
6. `TABLE_NAME` varchar(64) NOT NULL DEFAULT '',
7. `ENGINE` varchar(64) DEFAULT NULL,
8. `TABLE_ROWS` bigint(21) UNSIGNED DEFAULT NULL,
9. `DATA_LENGTH` bigint(21) UNSIGNED DEFAULT NULL,
10. `INDEX_LENGTH` bigint(21) UNSIGNED DEFAULT NULL,
11. `DATA_FREE` bigint(21) …

JavaOne Latin America 2010 (Day 1 and 0) started in an exciting way where I found a nice multi-instance cluster installation of GlassFish. More on that later but enjoyed meeting colleagues from different groups within Oracle.

I gave a presentation on "Whats New in Enterprise Java Beans 3.1" and the slides are available:

S314168 - What's New in Enterprise Java Bean Technology @ JavaOne Brazil 2010
The attendees seem to like simplified packaging (EJB-in-a-WAR and deployment descriptor-free), no-interface bean, cron-like syntax, and other features were well appreciated by the users. All other …

MySQL Workbench is an extensible tool for database design, development, and administration – with support for python scripting and plugins, that can automate basic tasks.

Starting with MySQL Workbench 5.2.31, and with MySQL designers, developers, and administrators in mind, we’ve added a new plugin called MySQL Utilities. The MySQL Utilities is a set of python scripts that automate basic tasks. And as MySQL Workbench is about helping design, develop and administer databases, we’ve put the MySQL Utilities at your fingertips so you can quickly get to them and get your job done. Users will benefit from proven scripts, leverage the testing and ideas of the community and the experts at MySQL, and avoid having to reinvent common scripts…

Lets go on a quick tour…

The MySQL Utilities Plugin starts a shell that contains a set of python scripts that perform tasks such as copying, exporting, and importing databases, finding …

We’re proud to announce the next release of MySQL Workbench, version 5.2.31. This is a maintenance release focusing on general product improvement and usability.

We managed to close 97 bugs for this release.

MySQL Workbench:  Remote Administration on Windows – Support for Windows “Remote” Management within the New Server Instance Wizard and Manage Server Instance Form. This works for servers on the same domain (or trusted) – ie typical Windows LAN environments.  We expect Windows users to prefer this “native” way to do remote admin on Windows.  SSH remote admin has been available for some time on Windows, Mac OS, and Linux.

MySQL Workbench:  Utilities Plugin – Starts a shell that contains a set of python scripts that perform basic tasks such as copying, exporting, and importing databases, finding database objects or processes, cloning servers and cloning users.

MySQL Workbench: …

One more DRBD tutorial, this time I will describe howto setup MySQL with DRBD (Distributed Replicated Block Device). Purpose This document describes how to to setup a failover system with MySQL and DRBD (Distributed Replicated Block Device). Introduction In this tutorial we will setup two Debian Linux nodes with a DRBD volume. MySQL will be [...]

JavaOne Latin America 2010 (Day 1 and 0) started in an exciting way where I found a nice multi-instance cluster installation of GlassFish. More on that later but enjoyed meeting colleagues from different groups within Oracle.

I gave a presentation on "Whats New in Enterprise Java Beans 3.1" and the slides are available:

S314168 - What's New in Enterprise Java Bean Technology @ JavaOne Brazil 2010
The attendees seem to like simplified packaging (EJB-in-a-WAR and deployment descriptor-free), no-interface bean, cron-like syntax, and other features were well appreciated by the users. All other …

JavaOne Latin America 2010 (Day 1 and 0) started in an exciting way where I found a nice multi-instance cluster installation of GlassFish. More on that later but enjoyed meeting colleagues from different groups within Oracle.

I gave a presentation on "Whats New in Enterprise Java Beans 3.1" and the slides are available:

S314168 - What's New in Enterprise Java Bean Technology @ JavaOne Brazil 2010
The attendees seem to like simplified packaging (EJB-in-a-WAR and deployment descriptor-free), no-interface bean, cron-like syntax, and other features were well appreciated by the users. All other …