Posted by Singer Wang on Apr 17, 2012
Day 1 is the fist official day of the Percona Live MySQL Conference; the day began with two mini-keynotes by Peter Zaitev and Baron Schwarz of Percona talking about the history of MySQL and how he got started in the open source movement respectively. Very nostalgic and I’m sure it brought a tear to a few people’s eyes.
Following the dynamic duo was full keynotes by followed by Mårten Mickos (Eucalyptus Systems) speaking on “Making LAMP a Cloud” and Brian Aker (HP) on “The New MySQL Cloud Ecosystem”. To be honest I found the full keynotes to be quite disappointing. For me the keynotes speeches should be about a topic that is visionary or notable in some way. What I got from the keynotes were: MySQL is good, MySQL is growing, let me show you my product around MySQL, and buy/use my product. For me, they felt far more like glorified sales pitches. Remember back to the last conference I attended, SXSW Interactive, the keynotes by Ray Kurzweil and Jennifer Pahlka were about their vision of the future and the innovative work they have done respectively. Kurzweil spoke on how technology will enable us to expand our intelligence without limits and achieve digital immortality. Pahlka’s work on the non-profit Code For America, similar to the Peace Corps or Teach for America, brings technology innovators employing opens source, crowd source, and other technologies to promote openness, participation, and efficiency in municipal governments
Read the rest of this entry . . .
Posted by Singer Wang on Apr 17, 2012
Day 0 of the MySQL Conference is a day unlike any other day. It is, in fact, tutorial day. While regular days of the Percona Live MySQL Conference feature 50 minute sessions, usually split into 40 minute talk and a 5-10 minute question period, tutorials are 3 hour long sessions (with a generous 10 minute break in the middle for those that wish to go to the WC) that provide an in-depth dive into some aspect of MySQL. Due to the length of the tutorials, they are more in-depth and technical than individual sessions can provide, but at the same time we are limited to 2 tutorials slots per day instead of the 5 session slots per day.
The tutorial schedule for the conference is located
here and with so many good ones, it was hard to choose which one(s) to go to.
Posted by Singer Wang on Apr 12, 2012
In about 4 hours, at 2PM PDT, I’ll be giving my talk “Security Around MySQL” at Ballroom A at the Percona Live MySQL Conference 2012. It’s a summary and guide of practical and easy-to-implement security tips around MySQL and the application. These tips were all gleamed from my years at start-ups (some which I worked at and some which I founded) and from experience at Pythian.
The details are here: http://www.percona.com/live/mysql-conference-2012/sessions/security-around-mysql.
Posted by Singer Wang on Jun 16, 2011
The other day while trying to move a schema from one MySQL server to another, I encountered a very odd issue. The schema to be moved contained both MyISAM and InnoDB tables, so the only option I had was to dump the schema using mysqldump on the source server and import it on the destination server. The dump on the source server went fine with absolutely no issues but it failed to import into the second server, and the error message was:
Can't create/write to file ‘/disk1/activity.MYI’ (Errcode: 2)
Read the rest of this entry . . .
Posted by Singer Wang on Jan 12, 2011
I’ve seen many a good DBA make the master of starting slaves from the position in the master.info file, most recently this week, that I want to bring it to everyone’s attention. Of course I mean the underlying issue and not the names of the DBA because that would be cruel. Read the rest of this entry . . .
Posted by Singer Wang on Mar 1, 2010
I recently granted ALTER access in MySQL so a user could run the ALTER TABLE command . However after I granted the necessary privileges, the user was still not able to perform the tasks needed. Reproducing the issue using a test instance, I granted a test user the required privileges and MySQL reported no errors or warnings when the ALTER TABLE was run:
Read the rest of this entry . . .
Posted by Singer Wang on Dec 31, 2009
Having been a free software user and supporter for many years, I am disheartened by some of the comments made in the MySQL/Oracle debate regarding the GNU Public License (GPL) and other licenses. There is much throwing around of misconceptions and untruths about licenses and their differences. In this blog, I shall take on some of the bigger misconceptions.
While Linux is indeed distributed under the GPL, as is MySQL, Linux has an exception that allows anyone to run any kind of applications (including closed source applications) on top of Linux.
Monty says: Help keep the Internet free
Read the rest of this entry . . .
Posted by Singer Wang on Nov 10, 2009
Debian Linux (the underlying foundation of Ubuntu) manages the startup/shutdown of MySQL quite differently from the ways I am used to. I am a long-time user of both the MySQL binary provided by Red Hat/SuSE (along with Fedora and clones like CentOS and Oracle Enterprise Linux) and the official binary from mysql.com. After the successful restore of a cold backup, I started mysqld using the Debian provided init script. The script said that mysqld failed to start up, but in reality it did start up. Similarly, stopping mysqld fails.
The output below demonstrates the outputs and the behavior seen on a Ubuntu 8.04 LTS Server: Read the rest of this entry . . .
Posted by Singer Wang on Aug 31, 2009
Recently while we were building a slave with a newer version of MySQL 5.1 from an InnoDB Hot backup, the following error occurred when we ran mysql_upgrade:
mysql.time_zone OK
mysql.time_zone_leap_second OK
mysql.time_zone_name OK
mysql.time_zone_transition OK
mysql.time_zone_transition_type OK
mysql.user OK
Running 'mysql_fix_privilege_tables'...
ERROR 13 (HY000) at line 311: Can't get stat of './mysql/general_log.CSV' (Errcode: 2)
ERROR 13 (HY000) at line 316: Can't get stat of './mysql/slow_log.CSV' (Errcode: 2)
FATAL ERROR: Upgrade failed
The problem is that in MySQL 5.1, it is possible to log the slow query log and general log to tables in the mysql schema (source: Selecting General Query and Slow Query Log Output Destinations). These tables are created by default as CSV tables for performance reasons, and are created even if MySQL is set not to log to tables.
CSV tables, however, are not copied as part of the InnoDB Hot Backup process (by the wrapper script innobackupex.pl), thus creating this error. The fix to get the slave working Read the rest of this entry . . .
Posted by Singer Wang on Feb 24, 2009
If you are using InnoDB Hot Backup utility and the innobackup.pl wrapper script, be very careful if you are not running backups under the system mysql user. There is a bug which causes InnoDB Hot Backup to sometimes report a successful backup when it actually failed. Read the rest of this entry . . .
