Howdy! Thanks for coming and enjoy your stay! Take a look at the sitemap and don't forget to chirp!

Posts Tagged ‘mysql’

How to Generate Quality Data for MySQL

August 19th, 2010

We all had fun with the World Database, Sakila and the others when learning MySQL (see Example Databases), but it sometimes isn’t enough to run certain experiments, benchmarks within your own schema. Of course you could write a script that would generate junk data based on your column types and populate your database with a [...]

From MySQL GUI Tools to MySQL Workbench

January 27th, 2010

I bet that some of you still work with phpMyAdmin and there are plenty of good reasons for that. Perhaps the main reason would be its mobility. Being run by a web server, phpMyAdmin is accessible from anywhere, without installing any extra software, even on the mobiles phones. And the second reason is of course [...]

Cloud Tips: Automatic Backups to S3

October 14th, 2009

In a previous post about backing up EC2 MySQL to an Amazon S3 bucket we covered dumping MySQL datasets, compressing them and uploading to S3. After a few weeks test-driving the shell script, I came up with a new version that checks, fixes and optimizes all tables before generating the dump. This is pretty important [...]

Working With Amazon EC2: Tips & Tricks

July 16th, 2009

It’s been a while now since I’ve been hosting on Amazon Web Services and I’d just like to point out some issues I had and quick ways of solving them. We’re gonna talk about setting up a server that would serve not only you, but your clients too, cause $100/mo is quite expensive, isn’t it? [...]

Foller.me: MySQL Tweaking & Optimization

July 10th, 2009

As I mentioned in the interview with @enked on his website Chidimar.com, I had serious problems with MySQL database optimization on the Foller.me project. The current public stable version (beta-1) is using the MyISAM engine and it’s not holding much data – profiles, locations, geo points for the followers geography. In the new version (currently [...]