Entries tagged under ' mysql '

Written September 10, 2008 in mysql

Freshbooks ran into an interesting bit about selecting a MySQL Table Cache size:

The problem was caused by our new configuration of MySQL. The usual approach to setting MySQL’s table cache size is to make it large enough that it can hold all of your tables open, but

Continue Reading »

Written July 26, 2008 in mysql

Sorry about the title. Couldn’t resist.

Brian Akers (One of the loudest voices in the MySQL world) and Michael Widenius (The original MySQL developer) have started a New MySQL fork called ‘Drizzle’. They aim to keep the development truly open source, to take a step back to simplicity, speed, …

Continue Reading »

Written May 27, 2008 in centos, howto, linux, mysql, sysadmin

What a mouthful. Like most other americans who live on a budget, I’m taking a “staycation” this weekend. What better thing to do than to get my mail server migrated to my new VPS? Well, first, I suppose, I should get the mail server all working on the new VPS…

In CentOS, the default Postfix package doesn’t have MySQL support built in. If you’ve got the priorities plugin installed, you’re either going to need to disable it or otherwise work around it so that you get the one from the centosplus repo. Other than that, it’s been made about as easy as it can be… just keep in mind as you’re reading this tutorial that I really loathe administering mail servers and consider it to be a quite onerous chore that’s been made even more onerous by spammers and hackers and script kiddies and what have you.

You’ll need to install: yum install gcc postfix clamav mysql-server mysql-devel spamassassin
dovecot php php-mbstring php-mysql rpm-build. There’s no RPM for Postfixadmin, but it’s available from the project’s site on Sourceforge.

And now the fun begins. This howto assumes that you have a decent level of knowledge and skill setting up services that run on Linux.

Continue Reading »

Written May 27, 2008 in mysql, sysadmin

Been doing a lot of work with MySQL Replication recently. We’re exploring a solution for our needs, which are mostly HA issues. Maatkit has a bunch of scripts that make replication easier to troubleshoot or fix, or make loading large datasets easier, or … well, go read the …

Continue Reading »

Written May 12, 2008 in mysql, opensuse

There aren’t any binaries for MySQL Carrier Grade Edition, which includes the NDB Cluster engine, enabling highly available MySQL services. If you’re using OpenSUSE, you can get an older edition (MySQL 5.1.24) from the Build Service … or the most recent Carrier Grade Edition, 6.2 and 6.3, from the MySQL …

Continue Reading »