Fixing a ghost database migration failure
··1234 words·6 mins
I woke up one morning to find my Ghost blog unresponsive. It required an unexpected fix. 🔧
Mysql
2023
2013
Survive the Google Reader exodus with Tiny Tiny RSS
··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.
2012
mysql-json-bridge: a simple JSON API for MySQL
··450 words·3 mins
My quest to get better at Python led me to create a new project on GitHub.
2010
Monitor MySQL restore progress with pv
··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
··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
··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
··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.
2009
2008
Importing Excel files into MySQL with PHP
··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
··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
··104 words·1 min
I found myself in a peculiar situation last week.
MySQL: Can’t drop one or more of the requested users
··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
··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
··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
··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
··71 words·1 min
After a couple of weeks, my MySQL replication series has come to a close.
MySQL Replication: Slave Performance
··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
··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
··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
··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
··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
··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
··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
··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
··269 words·2 mins
MySQL replication can increase performance by allowing developers to spread queries over two servers.
2007
Seven Step MySQL Replication
··133 words·1 min
MySQL replication may sound complicated, but it can be done easily.
Table ‘mysql.proc’ doesn’t exist
··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
··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.