$ mkdir ~/mysql-tutorial/ && cd ~/mysql-tutorial/
 $ openssl genrsa 2048 > ca-key.pem
 $ openssl req -new -x509 -nodes -days 1000 \
   -key ca-key.pem -out ca-cert.pem 

 $ openssl req -newkey rsa:2048 -days 1000 \
   -nodes -keyout server-key.pem -out server-req.pem
 $ openssl rsa -in server-key.pem -out server-key.pem
 $ openssl x509 -req -in server-req.pem -days 1000 \
   -CA ca-cert.pem -CAkey ca-key.pem -set_serial 01 -out server-cert.pem 

 $ openssl req -newkey rsa:2048 -days 1000 \
   -nodes -keyout client-key.pem -out client-req.pem
 $ openssl rsa -in client-key.pem -out client-key.pem
 $ openssl x509 -req -in client-req.pem -days 1000 \
   -CA ca-cert.pem -CAkey ca-key.pem -set_serial 01 -out client-cert.pem 

$ sudo cp *.pem /etc/mysql/

# Instead of skip-networking the default is now to listen only on
 # localhost which is more compatible and is not less secure.
 #bind-address            = 127.0.0.1

# The following can be used as easy to replay backup logs or for replication.
 # note: if you are setting up a replication slave, see README.Debian about
 #       other settings you may need to change.
 server-id	 = 1
 log_bin	 = /var/log/mysql/mysql-bin.log
 expire_logs_days	= 10
 max_binlog_size	= 100M
 binlog_do_db	= exampledb

# For generating SSL certificates I recommend the OpenSSL GUI "tinyca".
 ssl-ca=/etc/mysql/ca-cert.pem
 ssl-cert=/etc/mysql/server-cert.pem
 ssl-key=/etc/mysql/server-key.pem

$ sudo service mysql restart

$ mysql -h localhost -u root -p

GRANT REPLICATION SLAVE ON *.*
 TO 'slave_user'@'slave.webdevelopersdiary.com'
 IDENTIFIED BY 'slave_password'
 REQUIRE SSL;
 FLUSH PRIVILEGES;
 USE exampledb;
 FLUSH TABLES WITH READ LOCK;
 SHOW MASTER STATUS;

+------------------+----------+-----------------+------------------+
 | File             | Position | Binlog_Do_DB    | Binlog_Ignore_DB |
 +------------------+----------+-----------------+------------------+
 | mysql-bin.000002 |     1337 | exampledb       |                  |
 +------------------+----------+-----------------+------------------+
 1 row in set (0.00 sec)

$ mysqldump -h localhost -u root -p --opt exampledb > ~/mysql-tutorial/exampledb.sql
 $ fg

UNLOCK TABLES;
 quit;

server-id=2
 replicate-do-db=exampledb

$ sudo service mysql restart
 $ mysql -h localhost -u root -p

STOP SLAVE;
 CREATE DATABASE IF NOT EXISTS exampledb;
 USE exampledb;
 SOURCE /path/to/exampledb.sql;
 
 CHANGE MASTER TO
 MASTER_HOST='master.webdevelopersdiary.com',
 MASTER_USER='slave_user',
 MASTER_PASSWORD='slave_password',
 MASTER_CONNECT_RETRY=60,
 MASTER_LOG_FILE='mysql-bin.000002',
 MASTER_LOG_POS=1337,
 MASTER_SSL=1,
 MASTER_SSL_CA='/etc/mysql/ca-cert.pem',
 MASTER_SSL_CERT='/etc/mysql/client-cert.pem',
 MASTER_SSL_KEY='/etc/mysql/client-key.pem';
 START SLAVE;
 SHOW SLAVE STATUS \G;

 svn co svn://svn.caucho.com/home/svn/svnroot/resin/trunk resin
 cd resin
 ant quercus.war
 mvn install:install-file -Dfile=dist/quercus-4_0-snap.war -DgroupId=com.caucho -DartifactId=quercus -Dversion=4.0-SNAPSHOT -Dpackaging=war 

 git clone https://github.com/mdaniel/svn-caucho-com-resin.git
 cd svn-caucho-com-resin
 ant quercus.war
 mvn install:install-file -Dfile=dist/quercus-4_0-snap.war -DgroupId=com.caucho -DartifactId=quercus -Dversion=4.0-SNAPSHOT -Dpackaging=war 

<project>
 	...
 	<dependencies>
 		...
 		<dependency>
 			<groupId>com.caucho</groupId>
 			<artifactId>quercus</artifactId>
 			<version>4.0-SNAPSHOT</version>
 			<type>war</type>
 		</dependency>
 		...
 	</dependencies>
 	...
 </project>

ant -p

 svn checkout http://h2database.googlecode.com/svn/trunk/ h2database-read-only
 cd h2database-read-only/h2
 ./build.sh mavenInstallLocal
 

<project>
 	...
 	<dependencies>
 		...
 		<dependency>
 			<groupId>com.h2database</groupId>
 			<artifactId>h2</artifactId>
 			<version>1.0-SNAPSHOT</version>
 		</dependency>
 		...
 	</dependencies>
 	...
 </project>

<IfModule mod_rewrite.c>
 	RewriteEngine On
 
 	RewriteCond %{REQUEST_URI} ^(system|application).*
 	RewriteRule ^(.*)$ /index.php?/$1 [L]
 
 	RewriteCond %{REQUEST_FILENAME} !-f
 	RewriteCond %{REQUEST_FILENAME} !-d
 	RewriteRule ^(.*)$ index.php?/$1 [L]
 </IfModule>
 
 <IfModule !mod_rewrite.c>
 	ErrorDocument 404 /index.php
 </IfModule>

$assign_to_config = array();

$db['default']['hostname'] = 'mysql:';
 $db['default']['dbdriver'] = 'pdo';

	/**
 	 * Number of rows in the result set
 	 *
 	 * @access	public
 	 * @return	integer
 	 */
 	function num_rows()
 	{
 		$sql = $this->result_id->queryString;
 		if(NULL === $sql) {
 			$sql = print_r($this->result_id, TRUE);
 			$quercus_preg = '/\Aresource\(PDOStatement\[(.*)\]\)\z/is';
 			$php_preg = '/\APDOStatement Object\s*\(.*=>\s*(.*)\)\s*\z/is';
 			if(preg_match($quercus_preg, $sql)) {
 				// We're running in Quercus
 				$sql = preg_replace($quercus_preg, '\1', $sql);
 			} else if(preg_match($php_preg, $sql)) {
 				// We're running in PHP
 				$sql = trim(preg_replace($php_preg, '\1', $sql));
 			} else {
 				// No clue about what is running this script!
 				$sql = NULL;
 			}
 		}
 		if (is_numeric(stripos($sql, 'SELECT')))
 		{
 			$count = count($this->result_id->fetchAll());
 			$this->result_id->execute();
 			return $count;
 		}
 		else
 		{
 			return $this->result_id->rowCount();
 		}
 	}

<?php
 
 class Test extends CI_Controller {
 	public function index() {
 		$this->load->database();
 		$sql = $this->db->query('CREATE TABLE IF NOT EXISTS test (value DATETIME)');
 		$sql = $this->db->set('value', 'NOW()', FALSE)->insert('test');
 		var_dump($this->db->get('test')->result());
 	}
 }

 mvn install:install-file -Dfile=quercus-4.0.25.war -DgroupId=com.caucho -DartifactId=quercus -Dversion=4.0.25 -Dpackaging=war 

<project>
 	...
 	<dependencies>
 		...
 		<dependency>
 			<groupId>com.caucho</groupId>
 			<artifactId>quercus</artifactId>
 			<version>4.0.25</version>
 			<type>war</type>
 		</dependency>
 		...
 	</dependencies>
 	...
 </project>

<project>
 	...
 	<build>
 		<plugins>
 			<plugin>
 				<groupId>org.mortbay.jetty</groupId>
 				<artifactId>jetty-maven-plugin</artifactId>
 			</plugin>
 		</plugins>
 		<pluginManagement>
 			<plugins>
 				<plugin>
 					<groupId>org.mortbay.jetty</groupId>
 					<artifactId>jetty-maven-plugin</artifactId>
 					<version>8.1.4.v20120524</version>
 					<configuration>
 						<scanIntervalSeconds>1</scanIntervalSeconds>
 						<stopKey>foo</stopKey>
 						<stopPort>9999</stopPort>
 					</configuration>
 				</plugin>
 			</plugins>
 		</pluginManagement>
 	</build>
 	...
 </project>

 echo '<?php phpinfo();' > src/main/webapp/phpinfo.php
 mvn jetty:run
 

<project>
 	...
 	<dependencies>
 		...
 		<dependency>
 			<groupId>com.h2database</groupId>
 			<artifactId>h2</artifactId>
 			<version>1.3.167</version>
 		</dependency>
 		<dependency>
 			<groupId>commons-dbcp</groupId>
 			<artifactId>commons-dbcp</artifactId>
 			<version>1.4</version>
 		</dependency>
 		...
 	</dependencies>
 	...
 </project>

<?php
 
 $pdo = new PDO('mysql:');
 $sth = $pdo->prepare('SELECT NOW()');
 if($sth) {
 	$sth->execute();
 	if($now = $sth->fetchColumn()) {
 		printf('Successfully executed query on H2 at %s.', $now);
 	} else {
 		echo 'Could not execute query.';
 	}
 } else {
 	echo 'Could not prepare query.';
 }

<Set name="url">jdbc:h2:mem:;MODE=MYSQL</Set>

<Set name="url">jdbc:h2:filename;MODE=MYSQL</Set>

 mysql> SELECT FROM_UNIXTIME(@ts := 1351387800) = FROM_UNIXTIME(@ts - 3600);
 +--------------------------------------------------------------+
 | FROM_UNIXTIME(@ts := 1351387800) = FROM_UNIXTIME(@ts - 3600) |
 +--------------------------------------------------------------+
 |                                                            1 |
 +--------------------------------------------------------------+
 1 row in set (0.00 sec) 

 mysql> SELECT UNIX_TIMESTAMP(), UTC_TIMESTAMP(), NOW();
 +------------------+---------------------+---------------------+
 | UNIX_TIMESTAMP() | UTC_TIMESTAMP()     | NOW()               |
 +------------------+---------------------+---------------------+
 |       1351384200 | 2012-10-28 00:30:00 | 2012-10-28 02:30:00 |
 +------------------+---------------------+---------------------+
 1 row in set (0.00 sec)