Quantcast

Ben McCann

Co-founder at Connectifier.
ex-Googler. CMU alum.

AngelList Twitter LinkedIn Google+

MySQL

Migrating from MySQL to Percona Server

12/11/2011

Percona Server is just MySQL with a few extra options added in by Percona. It’s backwards compatible and based off the same code base. If you’re not familiar with Percona, they are the world’s leading MySQL consultants. The main reason I switched is because Ubuntu uses an old version of MySQL. Ubuntu is about a Read More

Security Lockdown for Linux

02/11/2011

Automatic updates If you’re using Ubuntu you can do this by editingĀ /etc/apt/apt.conf.d/50unattended-upgrades. Running out of date packages with security holes is a good way to get your machine pwnd. Remove unused software Every piece of software installed on your system provides one more attack point for malicious users. You should inventory your system and remove Read More

MySQL Commands Cheatsheet

01/22/2011

Install SQL Buddy sudo apt-get install apache2 libapache2-mod-php5 php5-mysql sudo /etc/init.d/apache2 restart Download SQL Buddy, unzip, and move to /var/www Allow connections from a remote server: Set the bind address in /etc/mysql/my.cnf to your ip address Open the port in the firewall by running “/sbin/iptables -A INPUT -i eth0 -p tcp –destination-port 3306 -j ACCEPT” Read More