Separate DB for offline messages or ability to add read slaves (#326)

Sean Drummond opened 1 decade ago

Hey guys I was just wondering if there was anything in the works to have the ability to specify a separate DB cluster for offline messages OR the ability to add read slaves for the current DB cluster.

Activities

Artur Hefczyc commented 1 decade ago

Separate database for offline messages (AMP component) and for chat history is available out of the box. Each Tigase component can have a separate database out of the box. Andrzej will provide you with a configuration example for this.
Andrzej Wójcik (Tigase) commented 1 decade ago
To use other than default database for Message Archiving component, you need to add following line to your etc/init.properties file:

message-archive/archive-repo-uri=jdbc:mysql://localhost/new_database_to_use?user=username&password=password

where:

message-archive is name under which you configured Message Archiving component

jdbc:mysql://localhost/new_database_to_use?user=username&password=password is JDBC URI required to connect to database

To change database used by AMP component (default store for offline messages) you need to add following lines to etc/init.properties file:

--amp-repo-uri=jdbc:mysql://localhost/new_database_to_use?user=username&password=password

where:

jdbc:mysql://localhost/new_database_to_use?user=username&password=password is JDBC URI required to connect to database
Login to comment

Type	New Feature
Priority	Normal
Assignee	Sean Drummond
RedmineID	1981

Issue Votes (0)

Watchers (0)

Reference

tigase/_server/server-core#326