Fixing a ghost database migration failure 31 August 2023·Updated: 14 May 2024·1234 words·6 mins I woke up one morning to find my Ghost blog unresponsive. It required an unexpected fix. 🔧
Survive the Google Reader exodus with Tiny Tiny RSS 17 March 2013·Updated: 14 May 2024·301 words·2 mins It’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 MySQL 29 March 2012·Updated: 14 May 2024·450 words·3 mins My quest to get better at Python led me to create a new project on GitHub.
Monitor MySQL restore progress with pv 24 November 2010·Updated: 14 May 2024·250 words·2 mins The 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 hole 2 March 2010·Updated: 14 May 2024·561 words·3 mins Regardless 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 size 16 February 2010·Updated: 14 May 2024·181 words·1 min If 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 size 29 January 2010·Updated: 14 May 2024·335 words·2 mins This 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 indexes 4 April 2009·Updated: 14 May 2024·141 words·1 min Users of PHPMyAdmin 3.
Importing Excel files into MySQL with PHP 7 November 2008·Updated: 14 May 2024·235 words·2 mins If you have Excel files that need to be imported into MySQL, you can import them easily with PHP.
MySQL: ERROR 1040: Too many connections 24 June 2008·Updated: 14 May 2024·651 words·4 mins If 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 dumps 18 June 2008·Updated: 14 May 2024·104 words·1 min I found myself in a peculiar situation last week.
MySQL: Can’t drop one or more of the requested users 11 June 2008·Updated: 14 May 2024·219 words·2 mins MySQL has quite a few cryptic error messages, and this one is one of the best:
Backing up MySQL to Amazon’s S3 6 June 2008·Updated: 14 May 2024·123 words·1 min I 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 servers 21 March 2008·Updated: 14 May 2024·128 words·1 min It’s tough to find examples of dumps that can’t be properly reimported on other servers.
Plesk and MySQL 5 30 January 2008·Updated: 14 May 2024·110 words·1 min One of the questions I receive the most is: “What version of Plesk works with MySQL 5?
MySQL Replication: Wrap-up 15 January 2008·Updated: 14 May 2024·71 words·1 min After a couple of weeks, my MySQL replication series has come to a close.
MySQL Replication: Slave Performance 14 January 2008·Updated: 14 May 2024·124 words·1 min There’s a few final configuration options that may help the performance of your slave MySQL servers.
MySQL Replication: Upgrading the MySQL server 11 January 2008·Updated: 14 May 2024·197 words·1 min If 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 network 10 January 2008·Updated: 14 May 2024·198 words·1 min While many people might find replicating over an external network to be an odd concept, it does have some uses.
MySQL Replication: Breakdown 9 January 2008·Updated: 14 May 2024·313 words·2 mins On some occasions, MySQL replication can break down if an statement comes from the master that makes no sense to the slave.
MySQL Replication: Delayed Slaves 9 January 2008·Updated: 14 May 2024·385 words·2 mins In a perfect world, slaves will contain the same data as the master at all times.
MySQL Replication: Horizontal Data Partitioning 7 January 2008·Updated: 14 May 2024·110 words·1 min If 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 Integrity 4 January 2008·Updated: 14 May 2024·180 words·1 min An often overlooked benefit of MySQL replication is the ability to make reliable backups without affecting the integrity of the MySQL data.
MySQL Replication: Redundancy 4 January 2008·Updated: 14 May 2024·311 words·2 mins Although performance is a much larger benefit of replication, it provides some redundancy for your application as well.
MySQL Replication: Performance 2 January 2008·Updated: 14 May 2024·269 words·2 mins MySQL replication can increase performance by allowing developers to spread queries over two servers.
Seven Step MySQL Replication 31 December 2007·Updated: 14 May 2024·133 words·1 min MySQL replication may sound complicated, but it can be done easily.
Table ‘mysql.proc’ doesn’t exist 29 November 2007·Updated: 14 May 2024·104 words·1 min After I was asked to create a stored procedure on a MySQL 5.
mysqldump: Got packet bigger than ‘max_allowed_packet’ bytes 12 October 2007·Updated: 14 May 2024·81 words·1 min When 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.