Recently we’ve got a letter from a customer asking how to alter all float datatype to double datatype in one “Find and Replace all” shot. Good news! dbForge Studio can do this.  Let’s see how Find and Replace functionality,  Schema Compare tool,  and a database project of dbForge Studio will do their best to change the required properties at a heat.

1. Create a database project based on the existing database, i.g., the one where float data type should be changed to double. Do the following:

a. Select File ->New ->Project in the top menu. In the New Database Project Wizard check “Import schema objects from the existing database”.

b. Select a required connection and a schema to import objects from.

c. Check “Import all objects into a single file” and click the Create button.

2. …

These are now available for download from

• Binaries: http://master.ourdelta.org/bin/
  32 and 64-bit Linux tarballs
  32 and 64-bit OSX tarballs and DMGs
  
• Source tarball: http://master.ourdelta.org/src/

For the GRAPH Engine documentation, see http://openquery.com/graph/doc. It’s not another general purpose engine, it’s a computation engine. Different beast altogether, but darn useful!

Since it’s new code, it’s only in the -Sail patchset (bleeding edge).

At this point we have a 32-bit and a 64-bit Linux binary tarball, should work on most Ubuntu and CentOS and the like (I tested a few). Possibly OSX coming. Not sure on Windows right now.

For further details and download links, see yesterday’s release post.

SmugMug’s Craig Meakin downs a 7×7 for Windows 7 by Chris MacAskill

First, let me preface this by saying this is a great way to kill yourself, and that I rarely eat meat or cheese, let alone 7 patties and 7 slices.  Please go read this book and this one if you’d like to know how I stay skinny, healthy, cancer- and heart-disease free.  Except when Windows 7 isn’t driving our company mentally insane.

So our Windows 7 copies arrived today, and some moron (my brother) decided that SmugMug needed to have a Windows 7 launch party like everyone else in the world.  Except unlike …

One of my all-time favorite services, Animoto, has teamed up with SmugMug to make truly epic professional quality videos from both your stills and your video clips.  I’ve wanted this partnership since 2007, but Animoto’s had their hands full dealing with explosive growth, so it took us a little longer to sit in that tree together than we thought.

We had my good friend, Robert Scoble, over last night to demo for him, and you can see the video below (or click here to view it on blip.tv):

The really great thing about this is that it’s totally full-circle and tightly integrated.  Find your favorite photos on SmugMug, send them over to Animoto right from SmugMug’s interface (look in the ‘Buy’ …

My hack of the day for Tuesday was to add the my.cnf option innodb_mmap_buffer_pool that specifies the name of a directory in which a file is created. The file provides the buffer pool memory allocation when opened with mmap. Now if only I had a lot of NOR flash to provide the backing store for that file. The code seems to work. Eventually I will repurpose the Windows AWE code in InnoDB to run on Linux.

Today's hack is to implement innodb_file_per_database.

I originally posted this on the Maatkit discussion list:

A little while ago a user asked in http://groups.google.com/group/maatkit-discuss/browse_thread/thread/256b6c780bdb066d if it was possible to use mk-query-digest to analyze queries per hour. I responded with a skeleton script for use with –filter, but I didn’t actually test this. Today, I filled out the script and tested it and found that it works. The script is available from trunk at:

http://maatkit.googlecode.com/svn/trunk/mk-query-digest/t/samples/filter-add-ymdh-attribs.txt

The test file I’m using is available at:

…

I have complied a list of a good tips for DBAs to consider when implementing security policies in MySQL.

-- The List
1. Make sure that ALL root accounts (ALL PRIVILEGED accounts) have strong passwords and apply them using hashes not plain text. If you leave the password blank anyone can connect as root without a password and be granted all privileges.

2. For ALL other accounts use passwords and apply them using hashes not plain text.
A good practice is to use the following:

mysql> grant SELECT, INSERT……. ON `database`.* to ‘user’@’10.%’ IDENTIFIED BY ‘*9B9C8E678DB2D62877E829D633535CBEB2B7E6E0’;

NOTE: make sure you are using HASHS and not plain text!
If you run something like below…

mysql> update user set password = password(‘somepassword’) where user = ‘someuser’;
Make sure …

Overview

This is an insert performance test implemented by running just inserts with mysqlslap against 1-3 node MySQL/Galera clusters. The results show how multi-master cluster can process more inserts than single native MySQL 5.1.38 server.

Test Platform

read more

I am going to take the words of my colleague Tim Bray to explain my own position regarding the acquisition of Sun by Oracle:

[Disclosure: I have no non-public information on any of the MySQL-related 
aspects of the Sun/Oracle transaction, nor on the current anti-trust review, 
and I am not speaking for anyone but myself.]

Just to further add to this, I am one of the main contributors to the largest community driven and contributed fork of the MySQL server, Drizzle.

From Richard Stallman:

MySQL is made available to the public in two parallel ways. Most users 
obtain it as free/libre software under the GNU General Public License 
(GPL) version 2; the code is released in this way gratis. 
MySQL is also available under a different, …