2022.2

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
PlanetPress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32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:PlanetPressConnectusesa lotofdatabaseconnections.This
numberensuresthateveninhighvolumeenvironments,enoughconnectionswillbeavail-
able.
l
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PlanetPressConnectwill
beabletobestoredwithinthedatabase.
Page 16