mysql – Page 2 – Marcus Povey

Moving a MySQL database between servers using a single SSH command

So, the other week, I migrated all my sites over to a new server. This was accomplished with minimum fuss, using lots of rsync magic and juggling of DNS ttls. The part of the migration I imagined would be the most complicated, moving several tens of MySQL databases running on the old server to the […]

March 25, 2013 Marcus Povey

So, the other week, I migrated all my sites over to a new server. This was accomplished with minimum fuss, using lots of rsync magic and juggling of DNS ttls. The part of the migration I imagined would be the most complicated, moving several tens of MySQL databases running on the old server to the […]

Automatic Create and Modified timestamps in MySQL

It is common to use create and modified timestamps on your mysql tables, here's how to maintain them automatically.

March 11, 2013 Marcus Povey

It is common to use create and modified timestamps on your mysql tables, here’s how to maintain them automatically.

Optimising your LAMP stack for performance

By default, the standard LAMP (Linux Apache Mysql Php/Perl/Python) stack doesn’t come particularly well optimised for handling more than a trivial amount of load. For most people this isn’t a problem, either they’re running on a large enough server or their traffic is at a level that they never hit against the limits. Anyway, I’ve […]

May 8, 2012 Marcus Povey

By default, the standard LAMP (Linux Apache Mysql Php/Perl/Python) stack doesn’t come particularly well optimised for handling more than a trivial amount of load. For most people this isn’t a problem, either they’re running on a large enough server or their traffic is at a level that they never hit against the limits. Anyway, I’ve […]