Database Setup
What database/schema setup is required for MagooClient/MagooServer? Do I need any SQL knowledge/tools?
The data persistence mechanism for Version 4 and above differs from previous MagooClient versions in that an RDBMS rather than the filesystem is used to store all message and configuration data. This revised architecture was introduced primarily to allow the message store size to scale more effectively.
MagooServer requires a properly configured MySQL instance - please see the MagooServer Guide for details. MagooClient uses either a MySQL or embedded HSQL database depending on the client settings - again see the MagooClient Guide for details on appropriate MySQL configuration. If HSQL is selected then no database installation or configuration is required.
Note: MagooClient can be fully evaluated using its own embedded HSQL database thereby avoiding the need for a separate database installation.
Regardless of the database engine, MagooClient and MagooServer will automatically set-up all the required database schema (tables etc) and so neither RDBMS/SQL knowledge nor additional tools are required. Also any necessary schema updates to cater for new MagooClient/MagooServer features will be automatically detected and applied on installation of new versions.