MyEnv is an environment to run comfortably multiple MySQL instance on one server. You can run even multiple instances with the same binaries.

The concept behind this is to separate binaries from databases itself.

MyEnv bases on OFA which was adapted and improved by my former employer Trivadis. Their product is called TVD-BasEnv. MyEnv is not so comfortable yet but it is free and open.

Requirements

• Perl must be installed.
• A user where mysql runs on must exist.

How to install myenv

 root > su - mysql
 mysql> mkdir -p myenv data etc log product source tmp
 mysql> wget http://www.shinguz.ch/MySQL/myenv.tgz …

In one of my previous posts: MySQL backups, I talked about using a script for automating backups. I show that we can use gzip to compress backup file to compress and save. Since then, our backup file has been growing meg or two a day which is causing our backup files to get [...]

CyberTech, developer and supplier of voice recording solutions, has integrated the MySQL relational database in its MynaVoice software for the storage and analysis of telephone calls. Because the MySQL Server is based on open source and open standards, CyberTech found that it integrated simply, quickly and at very low cost with their own technology.

Waiter: "We have our vegetarian Pad Thai on the menu."

Me: "Can you ask the chef if he puts fish sauce in it?"

Waiter goes off and comes back.

Waiter: "Yes there is fish sauce in the Pad Thai."

Me: "Do you have anything which is vegetarian?"

Waiter: "Well I know people who say they are vegetarian who eat fish..."

Me: "Dude, your friends are not vegetarians."

The argument can go down hill from here. Its simple, if you eat meat, even only sometimes, you aren't a vegetarian.

Its popular in some circles to call yourself a vegetarian. Some people just want to cut down on their meat and find that its an easy way to not eat meat for a night. Some people believe it creates an aura around them.

They aren't vegetarians though.

Open Source software is similar. Weeks ago I saw …

MySQL Toolkit's Show Grants tool can now separate grants into individual statements, convert them into REVOKE statements, and help you remove users from a server, even if your server doesn't support DROP USER.

I've already wrote we do not generally do a lot of on-site onsite consulting, but as I'm anyway going to be speaking at MySQL Users Conference anyway it may be good time for some onsite jobs. In fact I have already scheduled visits on Friday, Monday and Tuesday following the conference but I can do couple of more till the end of that week. Just let me know soon before I bought plane tickets.

I also know I virtually know a lot of guys from Sillicon Valley and SF whom I'd love to meet in person. Drop me a note if you're interested I'll have number of evenings and post conference weekend available.

See here.

After a great reception to my MySQL talks at PHP Quebec, I've decided to go ahead and start a user group in Montreal.

I'm still searching for a venue, so let me know if you can help out!

I've heard a lot about Ruby on Rails, and finally had occasion to try to use it. This tutorial was very well laid out, and entirely true - maybe a half dozen commands and a couple dozen lines of code later, there was a nice set of "scaffolds" for browsing & editing my data model.

It didn't "guess" my data model, but I prefer to tell a framework how to handle relationships. Telling rails was as simple as adding a handfull of commands like "has_one :parent", "belongs_to :category". And then you get drop-downs for foreign key values and column sorting virtually free.

read more

It's time for another Meetup of the Hamburg MySQL User Group! As for previous events, we'll meet on Monday, 2nd of April at 19:00 in the Chinese restaurant Ni Hao in Hamburg-Wandsbek.

This time there will be a presentation about "Xing/OpenBC growing pains", held by Erick Dennis und Michael Otto from epublica, the company behind Xing.com.

The talk will be held in english and is a rehearsal for their presentation at our upcoming MySQL Conference and Expo, which will take place from April 23rd-26th in Santa Clara, California. Please subscribe to our …