Database Considerations
This page describes the different considerations and pre-requisites
for the database back-end used by PrintShop Mail Connect,
whether using the MySQL instance provided by the installer, or pre-existing instance.
Using the MySQL Instance from the Installer
The MySQL Instance provided in the Installation
Wizard is already pre-configured with options to provide the most stable back-end setup.
These are the specific options that have been changed in our version
of "my.ini":
- max_connections = 200 :
PrintShop Mail Connect uses
a lot of database connections.
This number ensures that even in high volume environments, enough
connections will be available.
- max_allowed_packet = 500M
: In some implementations, especially when using Capture OnTheGo, large
packet sizes are required to allow transferring binary files. This substantial packet
size maximum setting ensures that the data received by PrintShop Mail Connect
will be able to be stored within the database.
- character-set-server = utf8 ,
collation-server = utf8_unicode_ci , default-character-set=utf8
: These indicate database support for UTF-8/Unicode.
Using a pre-existing MySQL Instance
If MySQL server is already installed and you wish to use it, the
following should be taken into consideration:
- The MySQL account must have access to all permissions using the
GRANT Command, including creating databases.
- The database configuration must include the options detailed in
the Using the MySQL Instance from the Installer above.
- The SQL instance must be open to access from other computers. This
means the bind-address option should not be set to 127.0.0.1 or localhost.
|
|