2022.2

Database 1
Dependingonthecomponentsinstalled,adatabaseinstanceiscreatedinafoldercalled"con-
nect.database"undertheWindowssystemtempfolder.Thisfolderisaccessibleviathestandardized
systemvariable%TMP%.Usually,foldersholdingsuchtemporaryfilesandfoldersshouldbeexcluded
fromavirusprotection,becausethisinfluencestheoverallperformanceofthewholesystematall.
Howevertheresponsiblepersonforthecomputerprotectionhastodecideaboutthemonitoringofsuch
temporaryfoldersfollowingthecompanyguidelines.
Database 2
AnotherdatabaseinstanceforConnectwillbeholdandusedunderthefolder,whichisintendedtohold
data,accessiblebyandforallusers.Thepathtothisfolderisstoredinthestandardizedsystemvari-
able%PROGRAMDATA%.TheConnectdatabaseinstanceislocatedinthesubfolder"Objectif Lune\OL
Connect\MariaDB".
Asthisdatabasewillbeinextremelystrongusage,virusprotectiononthisfolderanditssub-folders
mayhaveaseriousimpactontheperformanceofConnect.

Database Considerations
Thispagedescribesthedifferentconsiderationsandpre-requisitesforthedatabaseback-endusedby
PrintShopMailConnect,whetherusingtheMariaDBinstanceprovidedbytheinstaller,orpre-existing
(external)instance.
UsingtheMariaDBInstancefromtheInstaller
TheMariaDBInstanceprovidedinthe"InstallationWizard"onpage27isalreadypre-configuredwith
optionstoprovidethemoststableback-endsetup.
InstallingConnectusinganexistingMySQLinstance
IfMySQLServerisalreadypresentandyouwishtouseit,thefollowingshouldbetakenintocon-
sideration:
l
TheminimumsupportedMySQLversionisMySQL5.6.
l
TheMySQLaccountmusthaveaccesstoallpermissionsusingtheGRANTCommand,including
creatingdatabases.
l
Thedatabaseconfigurationmustincludethefollowingoptions:
l
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
Page 13