Upcoming Free IOUG Webinar: Securing MySQL

Next week I will give a free IOUG webinar on Securing MySQL on Wednesday, August 10, 2011 from 11:00 AM – 12:00 PM CDT (17:00 GMT): Securing MySQL is extremely important, but often is not done properly. I will explain the different ways to secure MySQL. In addition to securing users and privileges, file permissions and encrypted…

How to Run a Streaming Backup with innobackupex

On many of our clients, we have a need to run XtraBackup as a regular OS user. Aside from running into the issue where tar4ibd was not provided with Percona’s xtrabackup-1.6.2.tar.gz package, our main issues have been with permissions when attempting a streaming backup. Here is the innobackupex command that works for us.

mydumper & myloader : fast backup and restore

At PalominoDB we do not normally use mysqldump for regular backups, but only in some circumstances (for example MySQL upgrade). Lately we gave a try to mydumper as an alternative to mysqldump, and results are quite promising. We found that mydumper performs very fast exporting both small and large datasets!! We also found that the…

More Videos from Open DB Camp

I have gotten to uploading more of the videos from Open DB camp in Sardinia, Italy back in May: Henrik Ingo speaks about Xtrabackup Manager – video Linas Virbalas speaks about “Flexible Replication: MySQL -> PostgreSQL, PostgreSQL to MySQL, PostgreSQL to PostgreSQL” – video – slideshare slides MySQL to MongoDB replication (hackfest results) – video Robert Hodges…

Log Buffer #231, A Carnival of the Vanities for DBAs

Log Writer is busily and efficiently pumping out innumerable bytes from log buffer to online redo logs, while more and more exciting features are being added to the MySQL and the SQL Server community is getting more vibrant with each passing day, and in all this beautiful frenzy, we manage to catch some elegant blog posts from across all these Log Buffer editions and present you this Log Buffer #231.

Liveblogging at OSCON Data: Drizzle, Virtualizing and Scaling MySQL for the Future

Brian Aker presents “Drizzle, Virtualizing and Scaling MySQL for the Future” at OSCon Data 2011 #drizzle @brianaker 2005 MySQL 5.0 released – web developers wanted tons of features that were not in the release (making replication better for instance) 2008 Sun buys MySQL 2008 MySQL 6.0 is forked to become Drizzle 2009…

Log Buffer #230, A Carnival of the Vanities for DBAs

Once again this week, you are holding the new edition of Log Buffer in your hands. From across the database planet, fresh and sizzling blog posts of Oracle, SQL Server and MySQL are presented just for you in Log Buffer #230. Enjoy and give your feedback in the comments.

Video: High Performance Search with BlackRay Data Engine

I realized yesterday that I never did finish putting up the videos from this year’s Open Database Camp back in May, so I’m working on finishing that in the next few weeks. Today I put up High Performance Search with BlackRay Data Engine – Felix Schupp.  The slides are on the web at, and the video…

Page 26 of 85« First Page...10...2425262728...40...Last Page »