Difference between revisions of "Retain Database"
| Line 12: | Line 12: | ||
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) | 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=== | ||
[http://training.gwava.com/index.php5/MySQLInstallGuide MySQL Quick Installation notes 5.5 (mostly information from the Docs)] | [http://training.gwava.com/index.php5/MySQLInstallGuide MySQL Quick Installation notes 5.5 (mostly information from the Docs)] | ||
[http://training.gwava.com/index.php5/Install_MySQL_Without_Using_The_Install_Script_Included_in_Retain Installing MySQL manually (I.E. sans the Retain install script) for 5.5 and 5.6] | [http://training.gwava.com/index.php5/Install_MySQL_Without_Using_The_Install_Script_Included_in_Retain Installing MySQL manually (I.E. sans the Retain install script) for 5.5 and 5.6] | ||
| + | ===Backup=== | ||
| + | [http://training.gwava.com/index.php5/Backup_MySQL Framework for getting your database backed up so that you can sleep at night.] | ||
| + | ===Trouble Shooting basics=== | ||
| + | [http://training.gwava.com/index.php5/Troubleshooting_MySQL_Issues Some basic troubleshooting tips and tricks when MySQL explodes.] | ||
==MS SQL== | ==MS SQL== | ||
Revision as of 19:11, 30 December 2014
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.
Contents |
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.
Trouble Shooting basics
Some basic troubleshooting tips and tricks when MySQL explodes.
