Use MySQL storage

The mysql backend stores sessions in a MySQL database. Multiple agent instances can connect to the same database for shared, distributed persistence.

When to use

Production, multi-instance, or distributed deployments;
When sessions are centrally managed by a shared MySQL.

Usage

Provide connection details via config.yaml (or the matching environment variables) — never hard-code the password.

from veadk import Agent, Runner
from veadk.memory.short_term_memory import ShortTermMemory

stm = ShortTermMemory(backend="mysql")  # connection details from config.yaml / env

agent = Agent(name="demo")
runner = Runner(agent=agent, short_term_memory=stm, app_name="memory_demo")

To forward SQLAlchemy driver args such as connection pooling, use db_kwargs:

stm = ShortTermMemory(
    backend="mysql",
    db_kwargs={"pool_size": 10, "pool_recycle": 3600},
)

You can also inject a MysqlConfig directly through backend_configs to override the environment variables (hard-coding the password is discouraged):

import os

from veadk.configs.database_configs import MysqlConfig

stm = ShortTermMemory(
    backend="mysql",
    backend_configs={
        "mysql_config": MysqlConfig(
            host="127.0.0.1",
            user="veadk",
            password=os.environ["DATABASE_MYSQL_PASSWORD"],
            database="veadk_sessions",
        )
    },
)

Parameters

ShortTermMemory constructor parameters (mysql)

Parameter	Type	Default	Effective for mysql	Description
`backend`	`str`	`"local"`	Yes	Set to `"mysql"` to select this backend.
`backend_configs`	`dict`	`{}`	Yes	MySQL-specific settings; may include `mysql_config` (a `MysqlConfig` instance) to override the configuration otherwise read from environment variables.
`db_kwargs`	`dict`	`{}`	Yes	Passed to the SQLAlchemy engine; commonly used for pool settings such as `pool_size`, `pool_recycle`, `pool_pre_ping`.
`db_url`	`str`	`""`	Yes (override)	A connection string. Once set, `backend` and `backend_configs` are ignored, and `db_url` is used with `db_kwargs`.
`local_database_path`	`str`	`/tmp/veadk_local_database.db`	No	Used only by `sqlite`.
`after_load_memory_callback`	`Callable \| None`	`None`	Yes	Callback invoked after a session is loaded; receives the loaded `Session`.

MysqlConfig fields and environment variables

The MysqlConfig config class uses the env prefix DATABASE_MYSQL_.

config.yaml

database:
  mysql:
    host:       # host or IP
    user:
    password:
    database:
    charset: utf8

Field	Env var	Type	Default	Description
`host`	`DATABASE_MYSQL_HOST`	`str`	`""`	Database host or IP.
`user`	`DATABASE_MYSQL_USER`	`str`	`""`	Username.
`password`	`DATABASE_MYSQL_PASSWORD`	`str`	`""`	Password.
`database`	`DATABASE_MYSQL_DATABASE`	`str`	`""`	Database name.
`charset`	`DATABASE_MYSQL_CHARSET`	`str`	`utf8`	Character set.
`secret_token`	`DATABASE_MYSQL_SECRET_TOKEN`	`str`	`""`	STS token for MySQL auth; not supported yet.

VeADK selects a MySQL driver compatible with the installed Google ADK version and automatically encodes special characters in usernames and passwords. You can provision MySQL on Volcengine.

MysqlConfig has no port field, so the connection uses MySQL’s default port. For a non-default port or finer connection control, use db_url to supply a full connection string instead.

Overview

Get started

Core components

Observability

Extensions

Frontend

Security

Deployment

When to use

Usage

Parameters

ShortTermMemory constructor parameters (mysql)

MysqlConfig fields and environment variables

​When to use

​Usage

​Parameters

​ShortTermMemory constructor parameters (mysql)

​MysqlConfig fields and environment variables

When to use

Usage

Parameters

ShortTermMemory constructor parameters (mysql)

MysqlConfig fields and environment variables