Difference between revisions of "Retain Database"

Revision as of 17:24, 29 May 2015

The database communication settings for Retain are set under Server Configuration | Communications. You may make changes within the Communications tab. After changing any communications options, it is strongly recommended that Tomcat be restarted immediately.

The settings for the Communications tab are set in the initial setup of Retain. These include the connection to the SQL database server, the Retain database, and the notification, SMTP information. If any changes in the system or corrections are needed, they should be configured here.

Database Concepts

Here is a slide presentation on SQL basics, including information on the Retain database: SQL Basics

Here is a Google Drawing showing the Retain message database mapping.

MySQL

This is technically not supported by GWAVA (really we can't, this information is to help GWAVA technicians and partners understand the MySQL underpinnings so that they can create working servers for Retain)

Installation

MySQL Quick Installation notes 5.5 (mostly information from the Docs)

Installing MySQL manually (I.E. sans the Retain install script) for 5.5 and 5.6

Backup

Framework for getting your database backed up so that you can sleep at night. Includes a section on how to import that database if you need to get it back into play.

Troubleshooting MySQL Issues

Some basic troubleshooting tips and tricks when MySQL explodes.

MySQL Optimization and Performance

See KB, "MySQL Maintenance for Best Performance".

Helpful MySQL links

There is a LOT of information on the MySQL sites. These should help you find what you want to know. The links are for 5.5 but there is a link on the left side of the page that will send you over to the corresponding article that you're in for 5.6 if you just click on "MySQL 5.6 Manual":

• MySQL main document page.
• my.cnf option file and information on the switches used in the file.
• innodb configuration.

Another great resource is stackoverflow which has saved my bacon on many occasions.

Helpful Queries

Put queries here that you feel are helpful. Be sure to indicate what the query is doing <grin>.

Select the minimum and maximum value in a table

select min(f_delivered), max(f_delivered) from t_message;

Retain Table Explanations

Audit Table: Action Codes

• Archived ="A"
• Deleted ="D"
• Forward ="F"
• Switchmail="M"
• Audit="I"
• Schedule/Worker/Profile/Job "J"
• Login="L"
• Read ="R"
• Search="S"
• Users="U"
• Server="E"
• Export="X"
• Publish ="P"
• Restore="T"
• Litigation Hold="H"

MS SQL

Oracle

PostgreSQL