What is database sharding?
Databases, by their own nature, become large beasts. This is a fact of life and whilst a lot of databases don’t encroach on “unusable” sizes, some do. There is a…
A bunch of ramblings about PHP programming, JQuery, MySQL and other 'stuff'
Databases, by their own nature, become large beasts. This is a fact of life and whilst a lot of databases don’t encroach on “unusable” sizes, some do. There is a…
We had an odd thing today, whilst performing a apply-db-changes we received the error: You have an error in your SQL syntax; check the manual that corresponds to your MySQL…
If you have forgotten your root password for MySQL, then don’t panic. Although, if you don’t have root shell access, then do panic! Anyway, to reset a password, you need…
When you installed MySQL, you would have been asked for a root password. If you were testing or something similar, you may have used an empty password. This is all…
This inbuilt part of MySQL allows you to look closely at queries run – per session. And you can use this information to find bottlenecks. To enable profiling, run this…
Using mysqldump to back up a database If you want to make a super quick backup of a MySQL database, the best tool for the job is the native mysqldump.…
When performing a simple SQL search using Zend_Db_Select, $select->where('name = ?', 'chris'); But what if you want to do a LIKE search? $select->where('name LIKE ?', 'chris%'); Simples.
Having MySQL dumping out binary logs is a very good failsafe for backup redundancy. But, how do you get any of the information out of them? If you know a…
Ever wanted to sort a resultset of data, by value, but I wanted a couple of exceptions to appear at the top? SELECT country, population, CASE country WHEN 'United Kingdom'…
MySQL Incorrect String value replication error. We use ANT for releasing versions of our PHP applications. Its very smart and takes a lot of the problems related to releases out…