As most of MySQL users, I have often ignored what I'd like to call the minor storage engines. MYISAM, InnoDB and NDB (aka MySQL Cluster) are well covered in several articles; but what about engines like CSV or ARCHIVE? As part of some internal projects, we have been playing around with these 2 with some interesting results. On this article I'll concentrate on CSV.
ScenarioCurrently we have a few servers that are storing historical data that will eventually be migrated into Oracle. Two things need to happen until we can finally decommission them: 1) export the data to CSV so it can be imported in bulk into Oracle and 2) keep the data online so it can be queried as needed until the migration is finalized. I thought it would be interesting if we could solve both issues simultaneously and decided to try the CSV engine. Here's a description of the process.
Understanding CSV EngineThe CSV engine, as far as I can tell, was and example …

Dear MySQL Users,

We are proud to announce public Beta 2 of MySQL Workbench 5.2.

We want to thank all the people who tried MySQL Workbench 5.2 alphas and beta 1 and helped us out by filing bugs and providing valuable feedback.
The team has put in an all out effort to fix those reported bugs and enhance performance.

This build includes fixes for 54 bugs – 18 P1, 19 P2, 13 P3 and 2 P4 – as well as a few new features and some added fine tuning.

MySQL Workbench 5.2 Beta 2 provides:

1. Data Modeling
2. Query (upgrade from MySQL Query Browser)
3. Admin (upgrade from MySQL Administrator)

If you are a current user of MySQL Query Browser or MySQL Administrator, we look forward to your feedback on all the new capabilities we are delivering in a single unified MySQL Workbench

As always, you will find binaries for the various platforms on our download …

Banking on open source. Open source as a business model. And more.

Follow 451 CAOS Links live @caostheory on Twitter and Identi.ca
“Tracking the open source news wires, so you don’t have to.”

For the latest on Oracle’s acquisition of MySQL via Sun, see Everything you always wanted to know about MySQL but were afraid to ask

Banking on open source
# CIOL.com reported on the benefits of Standard Chartered Bank’s open source-based core banking system.

Open source as a business model
The “open source has failed as a …

I’ve been trying to dig a bit deeper into the European Commission’s investigation of Oracle’s proposed acquisition of Sun Microsystems, to look beyond the received wisdom about the EC’s concerns about the deal.

We know they revolve around the open source MySQL database, the European Commission has said that much. But the Statement of Objections weighs in at 155 pages, and even those that have read it admit to being confused by it. Meanwhile some of the most vocal parties in the public debate have vested interests in encouraging opinions for or against the deal.

Without knowing precisely what the European Commission wants to achieve it is impossible to come to any conclusions about the investigation. However, here are a few statements and observations:

…

I really like ZRM for MySQL Community Edition for backups. I find
it very simple to install and configure and it gets the job done. It's default settings suits most installations. The challenges arise once you need to adapt it to more complex organizations. Please note that all the issues described on this article refer to Linux installations.
What If DBAs Have No sudo?This was the 1st challenge that I ever faced. ZRM requires full root access at least during installation and in some cases, it requires some sudo permissions to be able to manage its files as well. Some organizations don't grant these permissions to the DBAs complicating the installation. When I looked into the scripts, I didn't see any reason why they wouldn't run in the user space, other than a few hard coded paths. I posted the question in the Zmanda forums and I got an answer with some …

A number of people have recently raised the issue of the threat that cloud computing poses to the monetization of open source by specialist vendors, including Savio Rodrigues, Matt Asay, and Mike Hogan.

I believe that cloud computing provides an opportunity for open source specialists, but agree that cloud services based on open source code could potentially eat into the business opportunities for open source specialists since the cloud providers have no …

Savio Rodrigues has published a post arguing that cloud platforms such as Amazon Web Services and Microsoft’s Azure pose a threat to the monetization of open source by specialist vendors.

Savio makes a good case based on the recent launch of AWS’s Relational Database Service, based on MySQL, and Microsoft’s support for MySQL and Tomcat on Azure:

“When Amazon decided to offer MySQL via Amazon RDS, they did so without purchasing MySQL support from Sun. I’ve confirmed that Microsoft Azure is supporting MySQL on Azure without paying Sun for a MySQL Enterprise subscription.”

Clearly there is a threat to open source vendors from cloud-based services. Meanwhile I have previous …

Google launches Chromium project, Terracotta acquires Quartz. And more.

Follow 451 CAOS Links live @caostheory on Twitter and Identi.ca
“Tracking the open source news wires, so you don’t have to.”

For the latest on Oracle’s acquisition of MySQL via Sun, see Everything you always wanted to know about MySQL but were afraid to ask

# Google launched the Chromium OS open source project, a prelude to the Chrome OS, while Canonical confirmed that it is contributing to the development of Chrome OS.

# Terracotta …

I am working with a client that is using managed hosting on dedicated servers. This has presented new challenges in obtaining the right permissions to undertake MySQL tasks but not have either ‘root’ or ‘mysql’ access and not have to involve a third party everytime.

Adding the following to the /etc/sudoers file enabled the ability to restart MySQL.

User_Alias      DBA = rbradfor, user2, etc
Host_Alias      DB_SERVERS = server1.example.com, server2.example.com, etc
Cmnd_Alias      MYSQL = /etc/init.d/mysqld, /usr/sbin/tcpdump

DBA DB_SERVERS = MYSQL

As you can see I also got tcpdump, which I find valuable to monitor via mk-query-digest.

Next, permissions for log files.

MySQL Workbench 5.2 introduces a lot of new functionality and therefore this short tutorial will help you to get started quickly.

The Home Screen

The most prominent new addition in respect to previous Workbench releases is the new Home Screen. It allows you to access the main features of Workbench in a nice and easy way and is divided into 4 parts.

The upper Workbench Central panel features a few Links and Action Buttons to quickly access common resources.

The lower Workspace panel shows the main feature sets, grouped horizontally.

• SQL Development allows editing and execution of SQL queries and scripts, create or alter database objects and edit table data.
• Data Modeling covers the EER Modeling functionality you might already be familiar with from previous MySQL Workbench releases.
• Server …