Fixing a ghost database migration failure31 August 2023·Updated: 22 April 2024·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·Updated: 22 April 2024·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·Updated: 22 April 2024·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·Updated: 22 April 2024·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·Updated: 22 April 2024·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·Updated: 22 April 2024·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·Updated: 22 April 2024·335 words·2 minsThis problem has cropped up for me a few times, but I’ve always forgotten to make a post about it.
PHPMyAdmin 3.x hides the table indexes4 April 2009·Updated: 22 April 2024·141 words·1 minUsers of PHPMyAdmin 3.
Importing Excel files into MySQL with PHP7 November 2008·Updated: 22 April 2024·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·Updated: 22 April 2024·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·Updated: 22 April 2024·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·Updated: 22 April 2024·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·Updated: 22 April 2024·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·Updated: 22 April 2024·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·Updated: 22 April 2024·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·Updated: 22 April 2024·71 words·1 minAfter a couple of weeks, my MySQL replication series has come to a close.
MySQL Replication: Slave Performance14 January 2008·Updated: 22 April 2024·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·Updated: 22 April 2024·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·Updated: 22 April 2024·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·Updated: 22 April 2024·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·Updated: 22 April 2024·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·Updated: 22 April 2024·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·Updated: 22 April 2024·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·Updated: 22 April 2024·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·Updated: 22 April 2024·269 words·2 minsMySQL replication can increase performance by allowing developers to spread queries over two servers.
Seven Step MySQL Replication31 December 2007·Updated: 22 April 2024·133 words·1 minMySQL replication may sound complicated, but it can be done easily.
Table ‘mysql.proc’ doesn’t exist29 November 2007·Updated: 22 April 2024·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·Updated: 22 April 2024·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.