tigase/_server/server-core

Database Preparation - documentation update (#933)

Wojciech Kapcia (Tigase) opened 7 years ago

Following section (especially per-db chapters) http://docs.tigase.org/tigase-server/snapshot/Administration_Guide/html_chunk/databasePreperation.html is a bit outdated. We should update it:

make it very clear that the automatic way of installing schema is the recommended way and users should avoid using manual mode if it's not 100% required and they know exactly what they are doing.
we must add information, that:
- currently schema files don't reference each other across versions
- now it's required to install common schema at the beginning (in the appropriate version!)
- it's required to install all required versions manually in succession;
- correct filenames;
- link to [[Schema files maintenance]]

I.e. if it's a clean install of version 8.0.0 user must:

create database as before
load (source, import, etc.…) common-schema (version 0.0.1 and then 0.0.2)

load all server and component versions, i.e. for the server and MySQL database that will be:

mysql> source database/mysql-common-0.0.1.sql
mysql> source database/mysql-common-0.0.2.sql
mysql> source database/mysql-issue #7.0.0.sql
mysql> source database/mysql-issue #7.1.0.sql
mysql> source database/mysql-issue #8.0.0.sql

Daniel Wisnewski commented 7 years ago

I labored about where to move some documents for a while on this, but I felt that moving the manual database installations to an appendix would best relegate users who are just glancing at the documentation.

I've updated the manual installation ones, I did notice MongoDB has no schema files, I suppose they're different? All manual installation methods are updated with appropriate sql files and order.

Schema update information was included in the header of Database Preperation.

Back to you for feedback.
Wojciech Kapcia (Tigase) commented 7 years ago

Daniel Wisnewski wrote:

I labored about where to move some documents for a while on this, but I felt that moving the manual database installations to an appendix would best relegate users who are just glancing at the documentation.

Good call.

I've updated the manual installation ones, I did notice MongoDB has no schema files, I suppose they're different?

Yes, MongoDB doesn't have schema files in relation-databases sense so no files.

All manual installation methods are updated with appropriate sql files and order.

Looks good. One thing to correct (and close) - Derby guide misses PubSub versions.
Daniel Wisnewski commented 7 years ago

Added pubsub sql files and re-checked for any missing files. Now closing ticket.
Login to comment

Type	Task
Priority	Normal
Assignee	Daniel Wisnewski
RedmineID	6889
Version	tigase-server-8.0.0
Spent time	0

Issue Votes (0)

Watchers (0)

Reference

tigase/_server/server-core#933