Projects tigase _server server-core Issues #326
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.

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
issue 1 of 1
Type
New Feature
Priority
Normal
Assignee
RedmineID
1981
Issue Votes (0)
Watchers (0)
Reference
tigase/_server/server-core#326
Please wait...
Page is in error, reload to recover