News, articles and feedback for MySQL database administrators and developers using MySQL on a daily basis to provide some of the best database infrastructure available.

MySQL Magazine's 2008 Annual MySQL Usage Survey
By Keith Murphy

It has been my desire to do this survey for quite some time. With the help of Mark Schoonover we developed thirty-four questions covering a range of subjects. There were over 400 responses to the survey with people chiming in from all over the world. Because of space constraints I am not going to spend any time giving analyses of the results here. In my log-bin column I manage to get in a few thoughts however.

News
This issue brings us a couple of announcements about major versions of software that can be used to support MySQL. Monday, July the 14th, saw the release of SQLyog 7.0. We have a complete review of the previous release in this very issue.

New features of this release include:
· New GRID design for easier navigation
· Multiple selection in GRIDs with SHIFT+CLICK.
· Improved Data Synchronization. Now typically 2-8 times faster than before depending on data. Option to generate a SQL sync script was added.
· Drastically improved the speed of exports.
· New more user friendly design for the Schema Synchronization (renamed from Structure Synchronization).
· Added automatic and manual update check

In addition, one of our new advertisers, dbWatch Software, is opening a sales office in the United States. Their product dbWatch (v8.1) is a heterogeneous database monitoring/reporting tool currently supports Oracle, SQL Server, and MySQL.

Download MySQL Magazine, Summer 2008

PDF format, 1.9MB, 42Pages.

INSIDE THIS ISSUE
2 SQLYog Enterprise Edition Version 6.55 Review
10 Ma'atkit Toolkit Tutorial: mk-table-checksum
13 Command Line mysql Client Options
21 MySQL Magazine’s 2008 Annual Usage Survey

Visit MySQL Magazine Website

Log-bin
The highlight of this issue, in my humble opinion, is the survey of MySQL Usage Survey. I have had the idea to do a survey like this for quite some time. Unlike many other database servers there can be a lack of information about usage patterns, what companies actually use in production, or even the salary ranges of the database administrator. As a database administrator myself I found the last item rather disconcerting.

While it certainly wasn't perfect, I think for a first edition it went pretty well. I would like to take the time to publicly thank Mark Schoonover for his extensive help with the survey. We really could not have done it without his help.

To me, the most interesting question was if a person worked remotely or "at the office". I was surprised that over 25% of the respondents actually worked remotely. I love working from my home. Being a MySQL DBA makes this a natural fit. There are plenty of questions to choose from for your own favorite! ...

Comments (0)

Name

Email

Comment

smaller | bigger

Add Comment