Fixing a ghost database migration failure31 August 2023·1234 words·6 minsI woke up one morning to find my Ghost blog unresponsive. It required an unexpected fix. 🔧
Survive the Google Reader exodus with Tiny Tiny RSS17 March 2013·301 words·2 minsIt’s no secret that Google Reader is a popular way to keep up with your RSS feeds, but it’s getting shelved later this year.
mysql-json-bridge: a simple JSON API for MySQL29 March 2012·450 words·3 minsMy quest to get better at Python led me to create a new project on GitHub.
Monitor MySQL restore progress with pv24 November 2010·250 words·2 minsThe pv command is one that I really enjoy using but it’s also one that I often forget about.
Private network interfaces: the forgotten security hole2 March 2010·561 words·3 minsRegardless of the type of hosting you’re using - dedicated or cloud - it’s important to take network interface security seriously.
MySQL: The total number of locks exceeds the lock table size16 February 2010·181 words·1 minIf you’re running an operation on a large number of rows within a table that uses the InnoDB storage engine, you might see this error:
MySQL: The total number of locks exceeds the lock table size29 January 2010·335 words·2 minsThis problem has cropped up for me a few times, but I’ve always forgotten to make a post about it.
Importing Excel files into MySQL with PHP7 November 2008·235 words·2 minsIf you have Excel files that need to be imported into MySQL, you can import them easily with PHP.
MySQL: ERROR 1040: Too many connections24 June 2008·651 words·4 minsIf you run a fairly busy and/or badly configured MySQL server, you may receive something like this when attempting to connect:
Remove backticks from MySQL dumps18 June 2008·104 words·1 minI found myself in a peculiar situation last week.
MySQL: Can’t drop one or more of the requested users11 June 2008·219 words·2 minsMySQL has quite a few cryptic error messages, and this one is one of the best:
Backing up MySQL to Amazon’s S36 June 2008·123 words·1 minI received an e-mail from Tim Linden about a post he made in his blog about backing up MySQL data to Amazon’s S3.
Importing MySQL dumps made on 64-bit servers21 March 2008·128 words·1 minIt’s tough to find examples of dumps that can’t be properly reimported on other servers.
Plesk and MySQL 530 January 2008·110 words·1 minOne of the questions I receive the most is: “What version of Plesk works with MySQL 5?
MySQL Replication: Wrap-up15 January 2008·71 words·1 minAfter a couple of weeks, my MySQL replication series has come to a close.
MySQL Replication: Slave Performance14 January 2008·124 words·1 minThere’s a few final configuration options that may help the performance of your slave MySQL servers.
MySQL Replication: Upgrading the MySQL server11 January 2008·197 words·1 minIf you want to make a DBA nervous, just let them know that they need to upgrade MySQL servers that are replicating in a production environment.
MySQL Replication: Across an external network10 January 2008·198 words·1 minWhile many people might find replicating over an external network to be an odd concept, it does have some uses.
MySQL Replication: Breakdown9 January 2008·313 words·2 minsOn some occasions, MySQL replication can break down if an statement comes from the master that makes no sense to the slave.
MySQL Replication: Delayed Slaves9 January 2008·385 words·2 minsIn a perfect world, slaves will contain the same data as the master at all times.
MySQL Replication: Horizontal Data Partitioning7 January 2008·110 words·1 minIf you have a master with multiple slaves, you can get some performance and save money on hardware by splitting data horizontally among your servers.
MySQL Replication: Backups & Data Integrity4 January 2008·180 words·1 minAn often overlooked benefit of MySQL replication is the ability to make reliable backups without affecting the integrity of the MySQL data.
MySQL Replication: Redundancy4 January 2008·311 words·2 minsAlthough performance is a much larger benefit of replication, it provides some redundancy for your application as well.
MySQL Replication: Performance2 January 2008·269 words·2 minsMySQL replication can increase performance by allowing developers to spread queries over two servers.
Seven Step MySQL Replication31 December 2007·133 words·1 minMySQL replication may sound complicated, but it can be done easily.
Table ‘mysql.proc’ doesn’t exist29 November 2007·104 words·1 minAfter I was asked to create a stored procedure on a MySQL 5.
mysqldump: Got packet bigger than ‘max_allowed_packet’ bytes12 October 2007·81 words·1 minWhen you dump table data from MySQL, you may end up pulling a large chunk of data and it may exceed the MySQL client’s max_allowed_packet variable.