Administration Guide

This guide contains information on how to manage the various components of the EleanorAI Framework.

RDBMS

This section contains administrative information related to the MariaDB RDBMS.

Backup

To take a backup of the RDBMS, bin/backup_mariadb.sh may be run. Backups must be executed from the host machine with kubectl installed and configured to access the cluster. Backups will be stored in backup/mariadb in the project root directory. Note that this script will capture a backup of all configured environments:

bin/backup_mariadb.sh backup

Force Drop All Tables

Sometimes it may be necessary to drop all tables in the database. This can be done by running the following SQL script:

-- Delete all data in database, useful for testing and development. Note 
-- that the alembic_version table should never be truncated.

USE eleanor;
SET FOREIGN_KEY_CHECKS = 0;

TRUNCATE TABLE activity_session;
TRUNCATE TABLE activity_session_participant;
TRUNCATE TABLE activity_session_setting;
TRUNCATE TABLE agent;
TRUNCATE TABLE agent_memory_collection;
TRUNCATE TABLE agent_setting;
TRUNCATE TABLE chain_invoke_log;
TRUNCATE TABLE memory;
TRUNCATE TABLE memory_collection;
TRUNCATE TABLE memory_graph;
TRUNCATE TABLE namespace;
TRUNCATE TABLE namespace_setting;
TRUNCATE TABLE participant;
TRUNCATE TABLE `user`;
TRUNCATE TABLE user_setting;

SET FOREIGN_KEY_CHECKS = 1;