Using MySQL as a backend
By default Sockso uses the Java database engine HSQLDB. This provides a nice fast easy way to get a database up and running in an application and works excellently for most uses of Sockso.
If you have a very large collection though you may run into some performance problems and possibly "out of memory" errors when accessing some of the pages. In these cases you have the option of changing the database engine Sockso uses, and for this MySQL support is available.
NB: Sockso requires MySQL 5+
1) Download Sockso's Optional Components
You will need to install the optional components first to use MySQL.
2) Create the database
The first thing you will need to do is create a MySQL database for Sockso to use. It doesn't need to have any tables in it, Sockso will take care of creating these when it starts up, but the database does need to exist.
3) Start Sockso with MySQL
When you have created the database just start Sockso with the following command line switches (changing the values to match your set up obviously) which tell it to use MySQL, and the connection information for the database.
$> java -jar sockso.jar --dbtype=mysql \
--dbhost=localhost \
--dbuser=myuser \
--dbpass=secret \
--dbname=socksodb
Sockso will now be running with MySQL.
NB: This will be a completely blank database.
