 |
 |
 |
 |
I logged into the primary member of the replica set and ran rs.status() which showed me that the replica was too stale (“error RS102 too stale to catch up”): { “_id” : 4, “name” : “55.55.55.55:27017″, “health” : 1, “state” : 3, “stateStr” : “RECOVERING”, “uptime” : 502511, “optime” : { “t” : 1340841938000, “i” Read More
You can create a MySQL backup with Percona Xtrabackup by running: $ innobackupex –user=DBUSER –password=DBUSERPASS /path/to/BACKUP-DIR/ You can then restore the backup with: $ xtrabackup –prepare –datadir=/var/lib/mysql –target-dir=/path/to/BACKUP-DIR/ $ sudo service mysql stop $ sudo mv /var/lib/mysql ~/dbbackup $ sudo mv /path/to/BACKUP-DIR /var/lib/mysql $ sudo chown -R mysql:mysql /var/lib/mysql $ sudo service mysql start $ Read More
The easiest way to get started is to install Apache and PHP: $ sudo apt-get install apache2 php5 php-pear If you need to edit the Apache ports because you already have another server running on port 80 then edit /etc/apache2/ports.conf. You’ll need to install the PHP Mongo connector: sudo pecl install php_mongo Add “extension=mongo.so” to Read More
When dealing with distributed systems, Brewer’s CAP theorem is often brought up when discussing how a system will behave in certain error conditions. The CAP theorem means that you can only have two of: consistency, availability, and partition tolerance. Here’s what you’ll be giving up for each of the three that you may sacrifice: C: Read More
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
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