Database Preparation - documentation update (#933)

Database Preparation - documentation update (#933)

Closed

	wojciech.kapcia@tigase.net opened 6 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 6 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.net commented 6 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 6 years ago Added pubsub sql files and re-checked for any missing files. Now closing ticket.

Type	Task
Priority	Normal
Assignee	Daniel Wisnewski
RedmineID	6889
Version	tigase-server-8.0.0
Spent time	27h 30m

Issue Votes (0)

Watchers (0)

Reference

tigase/_server/server-core#933

Please wait...

Page is in error, reload to recover