ZartsAlgo

Admin runtime

Admin Runtime Backup Guide

Admin Runtime Backup Guide for moving ZartsAlgo admin, portal, connector, traffic, and reporting data toward prepared MySQL runtime at larger client volume.

Request database audit Back to library

Runtime contract

What this part of the migration controls.

Use this page as a practical build note before connecting real customer records, provider data, or high-volume event streams.

Boundary

Keep the runtime boundary narrow

This guide moves one admin, portal, import, or reporting behavior at a time so the public site stays stable.

Owner

Assign a runtime owner

Data engineering owns setup, verification, rollback notes, and the first client-facing explanation.

Risk

Name the failure mode

The main risk is mixing raw provider data, client-visible summaries, and high-volume event records into one unbounded runtime path.

First action

Start with the smallest proof

Create one small read or import path, verify row counts, confirm no public page depends on it, and document rollback before expanding.

Target tables

Keep writes organized.

  • event_api_requests
  • event_lead_activity
  • event_notification_deliveries
  • event_webhook_events
  • experiment_results
  • experiment_variants
  • experiments

Verification checklist

Do this before switching runtime reads.

  • Confirm the target database user has only the privileges needed for the current phase.
  • Use prepared statements and named parameters for every runtime query.
  • Keep raw provider payloads, webhook bodies, and high-volume events out of the public page layer.
  • Add a rollback path before switching any admin or portal screen away from JSON demo data.
  • Write the client-facing summary from clean report, metric, and source records instead of exposing internal notes.
  • Check cPanel/phpMyAdmin import results and record the applied SQL file date.
  • Verify mobile rendering after the runtime content appears on a dashboard or portal screen.
  • Keep traffic rollups separate from account, client, project, and report records.

Prepared query plan

Small queries beat one giant dashboard query.

Each screen should load a bounded set of records, with source labels and date ranges included wherever the result becomes client-facing proof.

Query 1

admin priority dashboard

Prepare a short SELECT or INSERT path for this behavior, bind parameters, limit result size, and log the outcome without storing secrets.

Query 2

portal source coverage

Prepare a short SELECT or INSERT path for this behavior, bind parameters, limit result size, and log the outcome without storing secrets.

Query 3

portal metric summary

Prepare a short SELECT or INSERT path for this behavior, bind parameters, limit result size, and log the outcome without storing secrets.