Metawerx - Developer Hosting

database information

All metawerx hosting plans include HyperSQL support, a free low-performance, file based database.
The Developer Plan or MyFire Pack adds MySQL (including INNODB), PostGreSQL or a FireBird database.
The Database Plan or Database Pack adds a Microsoft SQL/Server 2005 database, or a 2nd MySQL database.
The Commercial Plan, Pro Plan and Pro II Plans, provide all of the above databases. On these plans multiple databases are provided.
The Pro Plan and Pro II Plans include the options of dedicated PostGreSQL or MySQL server instances, with no limit on the number of databases or users you create, up to the disk space provided on your plan.
See the Plan Comparison page for details.
The operating system of your JVM is independant of your database. Therefore, you can select SQL/2005 with a Linux dedicated VM and PostGreSQL 8.1 with a Windows-based VM.

To install and maintain your database, we provide the following options:

Execute SQL scripts (SQL dump files) quickly online using our SQL/Administrator tools
Build the database online by adding tables and fields using our online administration tools (phpMyAdmin, phpPgAdmin)
Use SQL Enterprise Manager, PG Explorer, MySQL/Admin or similar GUI or command line tools to remotely administer your database over a secure connection (using SSH), directly from your office or home

Your data is important and we fully understand that. Accidents happen, and malicious users can also cause problems. For this reason, we provide a historical range of backups to allow restoration of your database(s) in case of emergency. All database servers also use RAID drives, so in the case of a single drive failure, your database will not skip a beat.
With MySQL, we provide MyISAM and INNODB engine options for MySQL. MyISAM is backed up daily as SQL using a full dump, and individual customer database dumps, to a second server (14 days kept).
With SQL/Server, we provide hourly transaction log backups (24 hours kept), daily full backups (7 days kept), and weekly backups (2 weeks kept) to a second server.
With PostGreSQL, we provide daily full backups of the entire cluster as well as individual databases, to a second server (30 days kept).
Recovery services are available on request (hourly fee applies).

Our online DB Administrator tools allows you to perform the following operations online:

Execute raw SQL scripts (SQL dump files) - to restore/install database
Export an object or your database as an SQL script - to backup database
Export your data as CSV (comma separated values) - for use with spreadsheets, word processors
View your tables and table structure
Add and remove tables and fields

To use JDBC with MS SQL typically requires the use of a commercial JDBC driver. The jTDS driver is available free for connections to SQL/Server. MySQL Connector/J is available for MySQL.
You are also able to install any JDBC driver of your choice in your WEB-INF/lib folder, since our java hosting provides a full webapps folder.
We recomment the free jTDS driver for SQL/Server, and the drivers for MySQL/PostGres available for download from their websites.
We also provide the ability to set up JNDI DBCP Connection Pools, with full examples available on the metawerx wiki