We had an unscheduled test of our backups last night. Point-in-time recovery using a mysqldump and binary log files worked fine (thank goodness).

I’m used to thinking of (Oracle) exports being one thing, and point-in-time recovery (using hot backups) another. Maybe there’s a way to do a “PITR” in Oracle using an export, rolling forward using timestamps rather than SCNs… Don’t know. I know that with MySQL you can do it.

Last night we had some user-generated data corruption on a production server. The database was relatively small (a few Gig), so, after stopping the database and restarting it with ––skip-networking, I imported it from the latest daily mysqldump. Although I didn’t use ––master-data for the mysqldump (we had some locking issues with that in the past) I knew the time that the mysqldump had been started.

I did a little investigation into the binary log files using …

One of the marketing guys mentioned to me today that he saw Adobe CEO Bruce Chizen on CNN this morning reporting on their Q3 financial results.  The company grew by 41% year over year with record quarterly revenue of $851 million and operating income of $255 million. (Yes, those are quarterly figures!)  Chizen attributed the success to the strength of the recently released Creative Suite 3 and Acrobat.

MySQL is used by over a hundred different software ISVs and hardware OEMs for everything …

We are currently working on Cool Stack 1.1.1 which will have the following components updated, in addition to fixing known bugs :

• Apache 2.2.6 : Add mod_proxy, mod_fcgid, SMF support
  
• PHP 5.2.4      : Add dtrace extension, add new fastcgi version for use with non-Apache webservers
• APC 3.0.14
  
• Suhosin 0.9.20
  
• MySQL 5.0.45: Add SMF support
  
• Perl 5.8.8       : Add Sys:Syslog, DBI, DBD-mysql extensions
• memcached 1.2.2
• squid 2.6
• tomcat 5.5.23

I would love to get feedback on this. Is your favorite module/extension missing ? Are there bugs/issues you have run into that haven't been reported on the forum ?

26th of September, just after HighLoad conference I will have full day MySQL master class.

This time we will talk about Innodb Architecture and Performance Optimization and when will discuss some MySQL Performance Optimization and Scaling case studies from audience (or some of from my MySQL Consulting Practice if there would not be enough of them). As usually I'll try to keep it very interactive and will try to answer any other MySQL Performance, Scaling and High Availability questions you might have.

Entry posted by peter | 3 comments

Add to: …

Every so often you need to perform sort results retrieved from MySQL when your WHERE clause goes beyound col=const values which would allow MySQL to still use second portion of the index for the order by. Ranges as well as IN lists make this optimization impossible, not even speaking about index merge optimization. Lets look at this example:

PLAIN TEXT SQL:

1. CREATE TABLE `utest` (
2.   `c1` int(10) UNSIGNED NOT NULL,
3.   `c2` int(10) UNSIGNED NOT NULL,
4.   `ord` int(10) UNSIGNED NOT NULL,
5.   KEY `c1` (`c1`,`ord`),
6.   KEY `c2` (`c2`,`ord`)
7. ) ENGINE=MyISAM DEFAULT CHARSET=latin1
8.  
9. mysql> EXPLAIN SELECT * FROM utest WHERE c1=5 OR c2=5 ORDER BY ord DESC LIMIT 10 \G
10. *************************** 1. row ***************************
11.           …

(whoops - Movable Type 4 decided to mess up the permalink from the index page on this entry earlier; it should be fixed now. Darn bugs in run-periodic-tasks, grrh).

One of the NTP Pool server operators emailed recently and told that his server was unavailable for a few hours because he had changed some firewall rules remotely and managed to lock everyone out. Oops!

There's an easy way to do safe remote firewall changes.

He should have used the at daemon to automatically recover! If you don't have a console server then you absolutely must get in the habit of using it before doing anything that can lock you out of your server.

The basic concept is to setup something that in say 5 minutes will undo whatever you're about to do. So if you are messing with the …

We are currently working on Cool Stack 1.1.1 which will have the following components updated, in addition to fixing known bugs :

• Apache 2.2.6 : Add mod_proxy, mod_fcgid, SMF support
  
• PHP 5.2.4      : Add dtrace extension, add new fastcgi version for use with non-Apache webservers
• APC 3.0.14
  
• Suhosin 0.9.20
  
• MySQL 5.0.45: Add SMF support
  
• Perl 5.8.8       : Add Sys:Syslog, DBI, DBD-mysql extensions
• memcached 1.2.2
• squid 2.6
• tomcat 5.5.23

I would love to get feedback on this. Is your favorite module/extension missing ? Are there bugs/issues you have run into that haven't been reported on the forum ?

We are currently working on Cool Stack 1.1.1 which will have the following components updated, in addition to fixing known bugs :

• Apache 2.2.6 : Add mod_proxy, mod_fcgid, SMF support
  
• PHP 5.2.4      : Add dtrace extension, add new fastcgi version for use with non-Apache webservers
• APC 3.0.14
  
• Suhosin 0.9.20
  
• MySQL 5.0.45: Add SMF support
  
• Perl 5.8.8       : Add Sys:Syslog, DBI, DBD-mysql extensions
• memcached 1.2.2
• squid 2.6
• tomcat 5.5.23

I would love to get feedback on this. Is your favorite module/extension missing ? Are there bugs/issues you have run into that haven't been reported on the forum ?

Its exciting to see Zimbra being purchased for USD$350 million, by Yahoo!. Exciting because its a great product, exciting because I use it daily, and I guess Satish & team (of over 100 employees) deserve a big pat on the back. The other exciting thing to note is that its got MySQL in its core, and if they’re pushing it out farther and wider now thanks to the Yahoo! purchase, all the better.

There are a few things that are unclear, though, even from their FAQ:

• They mention commitment to Zimbra 5, but I’m still waiting for 4.5.7 :P (My Series 60 phone still …

PDO is a PHP extension providing a data-access abstraction layer that can be used with a variety of databases. This gives you the flexibility of changing the database backend without having to alter your access methods. Even if you use MySQL exclusively, PDO can provide advantages; you can use the same data-access methods regardless of the MySQL version. This does away with the need for using the standard MySQL extension with older versions of MySQL and using the MySQLi extension for later versions. An additional advantage is the ability to use object-oriented code regardless of the version of MySQL.