-
https://www.appfog.com/
PaaS offering for a wide range of platforms, free up to 8 servers, 2G of ram, 100M database. Supports, PHP, Node.js and more.
-
http://serverfault.com/questions/399487/cant-connect-to-mysql-using-self-signed-ssl-certificate
This one question contains much of the necessary wisdom around mysql and SSL certificates. Incredibly helpful.
-
http://www.howtoforge.com/how-to-set-up-mysql-database-replication-with-ssl-encryption-on-centos-5.4
Good introduction on setting up mysql replication with SSL encryption. Some of the options have changed in mysql 5.5 (no moremaster-connect-retry) and some settings are not applicable to Ubuntu, but the gist of it is useful.
-
http://www.maatkit.org/doc/mk-heartbeat.html
Simple script to monitor mysql replication delay. It updates a value on the master every second and checks how far behind the value is on the slave. Simple yet effective.
-
http://www.elevatedcode.com/articles/2007/12/05/replication-monitoring-with-monit/
Clever approach to monitoring mysql replication with monit. Ruby script checks replication is running and then touches a file, monit in turn monitors that file's timestamp and if it gets out of date, sends an alert. Sort of like a dead man switch. Clever.
-
http://www.nbs-system.co.uk/blog-2/magento-optimization-howto-en.html
Very useful article outlining the broad basics of optimising Magento. Includes links to more detailed information and lots of config file examples. Very useful.
-
http://www.scalebase.com/
Another cloud based scale solution for MySQL, aims to simplify deploying MySQL "in the cloud".
-
http://nimbusdb.com/how_it_works.html
Cloud based database that tries to achieve a new type of scalable, highly available, fault tolerant persistent data storage layer in "the cloud".
-
http://xeround.com/
Tool that tries to automate the scaling and replication of MySQL database in "the cloud".
-
http://programmersnotes.info/2009/03/04/handling-application-parameters-in-yii-using-the-database/
Very helpful article on how to store option or config data Yii in a database. Also includes a quick overview (the useful part for me!) of how to access data stored in a config file. Nifty. :-)
-
http://ubuntuforums.org/showthread.php?t=1615383
Post about linking vsftpd to mysql via pam-mysql. Contains detailed copies of config files, useful.
-
http://ubuntuforums.org/showthread.php?t=1149573
Topic on vsftpd / mysql via pam-mysql, contains some useful info on logging data via pam-mysql.
-
http://www.linux.com/archive/feature/125789
Article on how to link vsftpd to mysql via pam-mysql. Handy.
-
http://www.pixelpost.org/
Open source photoblog software. Funky, clean, described as extensible. PHP / MySQL based.
-
http://mysqlha.blogspot.com/
Mark Callaghan from Google on high availability MySQL.
-
http://ourdelta.org/about
OurDelta produces enhanced builds for MySQL, with OurDelta and third-party patches, for common production platforms. All the builds are freely available for download.
-
http://www.percona.com/percona-lab.html
Percona builds binaries that contain recent versions of the MySQL database server, plus additional popular patches not included in the official binaries from MySQL/Sun. Hat tip Morgan Tocker.
-
http://www.sysadmin.hep.ac.uk/wiki/DatabaseBackup
Useful article on how to backup and restore MySQL databases. Includes example commands and a basic overview of the theory.
-
http://barry.wordpress.com/2008/05/19/mod_auth_mysql-and-phpass/
A patch for mod_auth_mysql to support the new phpass format used in WordPress 2.5+. It's an apache mod.
-
http://wikkawiki.org/HomePage
Wikka is a very simple PHP/ MySQL wiki. It has very basic functionality, without the advanced features of something like MediaWiki, but it's extremely easy to use.
-
http://eventum.mysql.org/
Eventum is an issue / bug tracking system developed by MySQL AB and used internally at MySQL.
-
http://www.sitepoint.com/article/developing-facebook-platform
An article from Sitepoint.com on how to develop PHP apps for Facebook
