Last day of Collaborate 2012 and Scott Spendolini, Sumneva, gave a great presentation on APEX. Only caught the beginning Jan Visser’s Perl presentation because of the distance to the Luxor from the Mandalay South Conference Center and anticipated queuing time for checkout.

We can now look forward to Collaborate 2013 in Denver, Colorado.

Back to observing and working with code, here’s a nice article from MacWorld on how you set up a WebDAV on the Mac. While I’m mentioning Mac OS X and development, there’s still no firm upgrade window for the missing text editing tool – TextMate, and WWDC 2012 tickets sold …

MySQL Connect will be held this September before Oracle Open World and time is running out for you to submit your presentation. There are tracks on Application Development, Architecture and Design, Cloud Computing, Database Administration, High Availability, and Performance & Scaling.

You’ll need between 15-40 slides for an hour presentation (sixty minute session, leave ten or so minutes for Q&A). The submission software lets you stop and save before submission, just in case you need to do some research while create your submission. And once you submit, you can go back and edit so that you can include the latest and greatest information. But May 6th is the last day submissions will be accepted.

…

This has been an interesting week. I have been told over the past year that the Collaborate conference was more Oracle focused and little interest in MySQL. While the conference is Oracle focused, MySQL and open source technologies do have people's interest. I was informed that the MySQL sessions all had larger attendees than last year overall. I did meet some great people here and a big thank you to the IOUG, OAUG, QUEST for this event.

Some typical comments I heard from attendees about MySQL while at Collaborate:
“SQL Server just does not have the throughput, I know MySQL can do it.”
“Depending on what your application is, MySQL is just better and faster.”

The biggest hurdle for MySQL this week was how to pronounce it: “MySQL” …

Following a brief list of what I have found more interesting during the last two weeks. Up to now, April has being a great month for MySQL. MySQL Conference  – Percona conference 2012 The Percona MySQL 2012 conference, has seen the MySQL community, interact as it was doing many years ago, re-creating the dynamic and creative [...]

Whatever Google intended to do with the latest update, I personally think there was some collateral damage done to sites like mysqljoin.com . Since this is only a site I created to show people how joins can be used within MySQL (for free), I never spent money to a SEO agency or something. All I did was installing a SEO Plugin for WordPress. Am I guilty of “over optimizing” now?

The site is approx. 1,5 years old and it grew slowly. The first few month nothing really happened, then people somehow started to link to us , people on stackoverflow.com started to reference us and things like that. To me, this looks really organic. However, the traffic dropped overnight from approx. 1500 unique visitors per day to approx. 300 unique visitors.

If this update works to fight again spammy sites in the organic results, I’m fine with it. Even though I have no idea why Google …

Being a data recovery specialist and having recovered countless GBs of corrupted, and/or stranded, InnoDB data in my days, I am very happy to hear about the new InnoDB Transportable Tablespaces coming in MySQL 5.6!

Back in the day, if you had a stranded .ibd file (the individual InnoDB data file with –innodb-file-per-table option), you basically had nothing (even though that file contained all of the data). This was because unless you had the original instance that that particular .ibd file (table) originated from, there was no way to load it, import, or dump from it. So it was not of much use, though all the data was *right* there.

Thus I created the method of Recovering an InnoDB table from only an .ibd file (I should note that this was before the …

Read the original article at Bulletproofing MySQL replication with checksums

Your MySQL replications running well? You might not even know if they aren’t. One of the scariest things about MySQL replication is that it can drift out of sync with the master “silently”. No errors, no warnings.

1. What and Why?

MySQL’s replication solution evolved as a statement based technology. Instead of sending actual block changes, MySQL just has to log committed transactions, and reapply those on the slave side. This affords a wonderful array of topologies and different uses, but has it’s drawbacks. The biggest occur when data does not get updated or changed in the …

Just as one does, I was finding stuff to delete and I stumbled across this old directory which had dozens of BitKeeper work directories. Of course, I don't have a valid license for BitKeeper anymore and these directories haven't been touched in years!

I guess I shall sit on them for a while.

Virtualization is important and Dave Welch from the House of Brick gave a great presentation of experiences with VMWare and Tier 1 databases. It was a comprehensive presentation, but the white paper was easier to follow. The slides were complete but the volume of information was a lot for an hour presentation. Well worth the time though.

Utah Oracle User Group (UTOUG) announced a call for Fall Symposium papers today. The Fall Symposium will be in Salt Lake City on 9/6/2012. If you’re interested in presenting on Oracle or MySQL, the call for presentations will be open until 6/15/2012.

The conference party was tonight, and it provided some nice orderves and pizza. The theme was a return to 1980s music, and …

While preparing for the yesterday's MySQL/MariaDB 5.5 talk at the Mail.Ru technical forum, I downloaded the source code of three 5.5 forks - Oracle, Percona and MariaDB. And was happy that my g'old way of sandboxing an instance without installing it still works.

I don't know whether MySQL sandbox is using this approach under the hood, here it goes:

1. Make sure /etc/mysql/my.cnf is not present or commented out.
2. Create a ~/.my.cnf with few important lines:

[client]
port        = 3307
host        = 127.0.0.1
socket      = /opt/local/var/mysql/mysql.sock

[mysqld]
gdb # this one is necessary just to sandbox
max_allowed_packet=16M
port=3307
socket=/opt/local/var/mysql/mysql.sock
language=/home/kostja/work/mariadb/5.5/sql/share/english
character-sets-dir=/home/kostja/work/mariadb/5.5/share/charsets …