Database administration
Database administration for Exponential: the supported databases, schema, upgrades, backups and performance.
49 pages
- Clustering: DFS and its metadata database The database side of an Exponential cluster on several web servers - the DFS file handler and its metadata table ezdfsfile, the backends for MySQL and MariaDB (in the kernel), PostgreSQL (a separate package) and Oracle…
- Monitoring the database What to monitor on the database of an Exponential site and where to read it - the Database card of Setup > System information, exp:system:info for scripts and alerts, the log files and the patterns that matter, the…
- Troubleshooting database errors A symptom-first table of the database problems an Exponential site meets on each engine - the site looks down, missing tables, read-only SQLite files, lock timeouts, charset question marks, pgcrypto, sequences, MongoDB…
- Database error codes and messages How Exponential reports database errors - the engine's own error number in errorNumber() and in eZDBException, the codes for a duplicate key and a missing table on each driver, the exception classes, standard versus…
- Reviewing extension SQL for every engine A database administrator's checklist for reviewing the SQL of an Exponential extension before it goes onto a site that does not run MySQL - backticks, table aliases, driver helpers, MySQL session statements, empty…
- Database FAQ Short answers to the questions database administrators ask most about Exponential - which engine, is SQLite really enough, which privileges, where the password is, how to back up and upgrade, replicas, clustering, SQL…
- Checklists for database administrators Printable checklists for the database of an Exponential site - before an install, go-live, daily, weekly and monthly operations, before and after an upgrade, a restore, an engine move and a security review - each item…
- Glossary for database administrators The Exponential terms a database administrator meets, explained in a sentence each with a link - from .dba, alias and cluster to siteaccess, update file, WAL and writer lock.
- A reading path for database administrators The order in which a database administrator new to Exponential reads these pages - a first hour, a first day, then the pages for your engine and the pages for operations, upgrades and incidents - with the time each step…
Documentation license
This documentation is free documentation, licensed under the GNU Free Documentation License 1.3 or later.
Exponential Copyright © 1998-2026 Exponential Foundation and 7x