Chapter 9. Database Management

Table of Contents

Recommended database versions
Database Watchdog
Using modified database schema
Schema files maintenance
Assumptions
Checks
Schema files layout
Handling of changes in the schema
Making a change in old-stable (and stable)
Making a change in master
Implementation details
Database Preparation
Schema Utility
Prepare the MySQL Database for the Tigase Server
Prepare the Derby Database for the Tigase Server
Prepare the MS SQL Server Database for the Tigase Server
Prepare the PostgreSQL Database for the Tigase Server
Preparing Tigase for MongoDB
Hashed User Passwords in Database
Shortcut
Full Route
Tigase Server and Multiple Databases
Importing User Data
Importing Existing Data
Connecting the Tigase Server to MySQL Database
Integrating Tigase Server with Drupal
PostgreSQL Database Use
Schema Updates
Changes to Schema in v8.0.0
Tigase Server Schema v7.2 Updates

Tigase is coded to perform with multiple database types and numbers. Owing to it’s versatile nature, there are some tools and procedures that may be of use to certain administrators.

Recommended database versions

As of v8.0.0 here are the minimum and recommended versions of databases for use with Tigase:

DatabaseRecommended VersionMinimum VersionAdditional Information

DerbyDB

10.12.1.1

10.12.1.1

Included with Tigase XMPP Server

MySQL

5.7

5.6.4

Required to properly support timestamp storage with millisecond precision

SQLServer

2014

2012

2012 needed so we can count use fetch-offset pagination feature.

PostgreSQL

9.5

9.4

New UA schema requires at least 9.4

MongoDB

3.2

3.0

 

MariaDB

?

10.0.12

Basic features works with 10.0.12-MariaDB Homebrew, but is not fully tested.

Although Tigase may support other versions of databases, these are the ones we are most familiar with in offering support and advice. Use of databases outside these guidelines may result in unforeseen errors.