LogoLogo
Release notesAPI docsDocs homeEphemeral CloudTonic.ai
  • Tonic Ephemeral guide
  • About Tonic Ephemeral
  • Getting started with the Ephemeral free trial
  • Managing your Ephemeral account
  • Managing Databases
    • Viewing the list of databases
    • Starting a database
    • Changing the database configuration
    • Database configuration settings
      • Setting the required resources for a database
      • Setting the database expiration
      • Providing a custom configuration file
    • Connecting to a database
    • Resetting a database
    • Deactivating and reactivating databases
    • Managing auto snapshots
    • Tracking database activity
    • Deleting a database
  • Managing user snapshots
    • About user snapshots
    • Viewing the user snapshot list
    • Creating a user snapshot from an Ephemeral database
    • Creating a user snapshot from imported data
    • Editing a user snapshot
    • Creating a database from a user snapshot
    • Deleting a user snapshot
  • Installing and configuring Ephemeral
    • Ephemeral architecture
    • Configuring an allowlist for Ephemeral Cloud database connections
    • Installing a self-hosted instance of Ephemeral
      • System requirements
      • Deploying Ephemeral with Helm
    • Configuring database access on a self-hosted instance
    • Configuring tolerations and node selectors
    • Managing access to Ephemeral
      • Managing Ephemeral users
      • Enabling SSO on a self-hosted instance
        • Google
        • Okta
    • Setting the registry location for data volumes
    • Managing custom images
      • Creating, editing, and deleting custom images
      • Oracle image configuration
    • Configuring automatic deletion of snapshots
  • Monitoring and data collection
    • Monitoring your Ephemeral billed usage
    • Monitoring your disk storage
    • Data that Tonic.ai collects
  • Using the Ephemeral API
    • About the Ephemeral API
    • Configuring Ephemeral
    • Getting information about Ephemeral databases
    • Starting a database
    • Managing databases
    • Managing snapshots
Powered by GitBook
On this page
  • Supported parameters
  • PostgreSQL
  • MySQL
  • Providing the file

Was this helpful?

Export as PDF
  1. Managing Databases
  2. Database configuration settings

Providing a custom configuration file

For a MySQL or PostgreSQL database, you can provide a customization file to ensure that the database is configured correctly.

Supported parameters

Ephemeral supports the following customization file parameters. For details about the parameters and how they are used, go to the database platform documentation.

PostgreSQL

For PostgreSQL, Ephemeral supports:

  • max_wal_size

  • min_wal_size

  • wal_buffers

  • max_connections

  • shared_buffers

  • checkpoint_completion_target

  • checkpoint_timeout

  • synchronous_commit

  • work_mem

  • maintenance_work_mem

MySQL

For MySQL, Ephemeral supports:

  • sql_mode

  • sql-mode

  • max_allowed_packet

Providing the file

On the Settings tab of the database details panel, to provide the customization file:

  1. Toggle Custom configuration file to the on position.

  2. In the text area, paste the contents of the customization file.

PreviousSetting the database expirationNextConnecting to a database

Last updated 1 month ago

Was this helpful?