Maintenance

Overview

When upgrading QueryPie, the Log DB can be large and difficult to back up, and key features should not stop recording even during the upgrade. To control the service level appropriately, enable maintenance mode and perform migration.

If QueryPie servers are deployed in an active-active pair, follow the steps below:

Preparation: Download the latest package and review configuration files.
Enable maintenance mode: Announce the work and limit service access levels.
Prepare the database: Create schemas for the new version and replicate existing data.
Upgrade server B: Remove server B from the load balancer (LB), migrate, and install the new version.
Test server B: Connect directly to server B and verify the upgrade.
Upgrade server A: Reconnect server B to the LB, detach server A, then install the new version on server A.
Final switch: Reconnect server A to the LB and complete the overall upgrade.

Maintenance mode is added in version 11.3.0.

Configure maintenance mode (Operation Mode)

Since this affects the entire service, decide carefully and proceed with caution.

Available modes:

Mode	Description
Read Only	Users can log in, but all features other than read-only operations are disabled. (The first command after switching to Read Only is executed and logged in Audit Log, but subsequent commands are not executed nor logged.)
Active Session	Existing sessions can execute commands, but new sessions can only read. (Not applicable to DAC / SAC / WAC)
Allow Connection	Existing and new sessions can execute commands, but actions like submitting workflows or editing settings are not allowed. (Not applicable to KAC / WAC)
Full Access	Normal operating mode.