Log Buffer Editions are marching along, and this Log Buffer #268 is once again all about Oracle, MySQL, and SQLServer plus some peeks at some of other glittering database technologies like PostgreSQL and DB2. Sit back and enjoy. Oracle: Martin has produced another scenario based blog post about Shrinking Tables to Aid Full Scans. What [...]

Ronald Bradford and Giuseppe Maxia (hey guys!) wrote about different ways to ignore a database when using mysqldump –all-databases over the past couple of days.

Whilst the solutions are interesting, I wondered why not attack it from the proper approach, and add the option to mysqldump itself? Honestly, the patch is trivial, and doing anything against INFORMATION_SCHEMA with lots of databases and tables … well let’s just say … group_concat_max_len is the least of your worries..

15 minutes later I had a working solution:

To my surprise, I also found Bug#3228, created a little over 8 years ago.. I’ve posted the patch …

Register for this webinar "Replication, Read-Consistent Slaves & Redundancy" where we'll discuss various replication solutions and explain why SchoonerSQL offers the best synchronous replication solution. The webinar will also cover performance benchmarks and how read-consistent slaves (redundant database nodes) can help your application stay online 24x7, providing 99.999% availability. 

Replication, Read-Consistent Slaves & Redundancy Thursday, April 26, 2012, 10 a.m. PT / 1 p.m. ET
Webinar link
http://info.schoonerinfotech.com/ReadConsistentSlavesWebinar


There is also another webinar on how you can "Free your Data and Budget".  This is a business discussion aimed at helping IT decision makers make better choices to protect …

I wanted to evaluate MariaDB's virtual column and see if it could store business rules next to table data. With virtual columns this could be done and if you specify as 'virtual', would not even take up space on disk.

The imaginary use case is that there is a sales team in a company and you would like to evaluate if a particular salesperson is eligible for a bonus. In order to get a bonus, you need to sell above the average for the day and be in the top 5 amongst the salespeople.

So here is what I did:

MariaDB [test]> create table salespeople (id int unsigned not null auto_increment primary key, salesperson_id int unsigned not null , `date` datetime not null default 0, sold decimal(15,2) not null default 0, day_avg decimal(15,2) not null default 0,  above_avg char(1) as …

Percona’s version of MySQL Conference this year was awesome, and there were some great keynotes there, I’ll high-light two of them.

One was called “Future Perfect: The Road Ahead for MySQL” and had a vendor panel of “Industry leaders from HP, Amazon Web Services, McAfee, Clustrix, and Akiban discuss the future of MySQL”.

It went like this:

BaronTheModerator: “so, what is the future for MySQL?”
HP Cloud: “Clouds!”
Amazon Web Services: “Clouds and DynamoDB/RDS!”
McAffee: “More Security!”
Clustrix: “More Scaling!”
Akiban: “More document stores!”

BaronTheModerator, “what do your customers ask for?”
HP Cloud: “Clouds!”
Amazon Web Services: “Clouds and DynamoDB/RDS!”
…

After an hour of that I already …

Using mysqldump is a quick way to do backups, although usually limited to only smaller databases – perhaps up to a few gigabytes large. It is still a fairly popular solution as majority of databases aren’t even that big. Also phpMyAdmin provides a variant of mysqldump format through its Export function. Everything works well for plain dump and restore, but in certain situations it is necessary to restore only a single table. With all data being in a single text file, it may not be a trivial task. Here is how I deal with the problem.

Rather than editing out parts of the file that I don’t need, I wrote simple one-liners that do that for me. These are not perfect as for example they can’t deal with multiple tables by the same name existing in several different schemas, but that so far never turned out to be a problem. I encourage you to suggest improved ways of doing this, just let me know in the …

Collaborate is in Las Vegas next and the MySQL Community Team will be there promoting MySQL. Keith Larson and I are presenting two sessions on MySQL for Oracle DBAs or How to Speak MySQL for Beginners. More and more Oracle DBAs are discovering MySQL among their corporate infrastructure and need a little guidance to walk them through some of the differences between Oracle 11g and MySQL. Several years ago, the IOUG said 70% of their members use MySQL and it should be much higher by now. Please drop by the demo between sessions!

…

Installing MySQL-Frontend Chive (A phpMyAdmin Alternative)

This guide explains how to install the phpMyAdmin alternative Chive. Chive is a free, open source, web-based database management tool with easy administration, super fast UI and state of the art web technologies. It takes advantage of the capabilities of modern browsers. Features include an SQL editor with syntax highlighting and built-in profiling of SQL queries.

The slides and accompanying document of the High availability deep dive tutorial have all been uploaded and can be downloaded from the link below:

http://box.com/perconalive2012

For the slides, you’ll find a PDF and a pptx version, the gdocs animations works somewhat OK with pptx. Also, the VMs will stay available from a at least few months from here:

Virtualbox: http://ubuntuone.com/01mJtfGDc2QbxB9eaOqcWc
Xen and VMWare: http://ubuntuone.com/3nikxumH483slq8rfP73iZ

It has been a pleasure to be part of the tutorial, if you have any question, feel free to contact either Florian or myself.

Regards,

Yves

I’d had some difficulty manually creating my own windows service for MariaDB (worked fine from the installer), but it was due to the way I was creating it, so I wanted to share the proper approach:

Old Way:

sc create "maria55" binpath= "\"C:/Program Files/MySQL/MariaDB 5.5/bin/mysqld\"
\"--defaults-file=C:/Program Files/MySQL/MariaDB 5.5/data/my.ini\""
DisplayName= "Maria55" start= "auto"

New Way:

sc create "maria55" binpath= "\"C:/Program Files/MySQL/MariaDB 5.5/bin/mysqld\"
\"--defaults-file=C:/Program Files/MySQL/MariaDB 5.5/data/my.ini\" maria55"
DisplayName= "Maria55" start= "auto"

The key is adding the name, maria55, after the –defaults-file=.. option, but still within the “” that belong to “binpath”.

This extra parameter exists so that mysqld knows whether or not it was started as a service or not.

Without it, the server does not know, and …