Start a database

Learn how to start a database.

In Exasol 2025.1 and later you can use Exasol Admin to start and stop databases. For other versions, you must use either ConfD or the Administration API.

Prerequisites

There are no prerequisites for this procedure.

Procedure (Exasol Admin)

Exasol Admin is available in Exasol 2025.1 and later.

  1. Log in to Exasol Admin and open the Databases page.

  2. Click on the Start database button .

    start database

    The database status will change from Stopped to Running.

Verification

When the database is running, click on the Test button to verify that the the database is connectable. A checkmark on the button indicates that the test was successful.

test connection

Procedure (command line)

This procedure uses the c4 and confd_client command-line tools in a Linux terminal. To learn more about these tools, see Exasol Deployment Tool (c4) and ConfD.

  1. Connect to the cluster operating system (COS) using c4 connect -i PLAY_ID -s cos.

    Example:
    Copy 
    ./c4 connect -i c3275f84 -s cos

    To find the play ID, you can use c4 ps.

    For more information about how to use c4 commands, see How to use c4.

  2. To find the database name when you are connected to COS, use the ConfD job db_list.

    Example:
    Copy 
    confd_client db_list
    - MY_DATABASE

  3. To start the database, use the ConfD job db_start with the following parameters:

    Parameter name Data type Description
    db_name string The name of the database.
    cluster string

    This parameter is only relevant in AWS native cloud deployments.

    The database cluster(s) that should be started. If the parameter is omitted, the database is started on all clusters.

    Accepted values are:

    • MAIN Starts the main cluster. The database name can be passed instead of MAIN.
    • <clustername> Starts a specific cluster
    • +all Starts all clusters
    Example:
    Copy 
    confd_client db_start db_name: MY_DATABASE
    Examples (AWS native deployment with multiple clusters):

    To start the main cluster and all worker clusters:

    Copy 
    confd_client db_start db_name: MY_DATABASE
    # or
    confd_client db_start db_name: MY_DATABASE cluster: +all

    To start only the main cluster:

    Copy 
    confd_client db_start db_name: MY_DATABASE cluster: MAIN
    # or
    confd_client db_start db_name: MY_DATABASE cluster: MY_DATABASE

    To start a specific worker cluster (the main cluster must be running):

    Copy 
    confd_client db_start db_name: MY_DATABASE cluster: WORKER1

Verification

To verify that the database is running, use the ConfD job db_state.

Example:
Copy 
confd_client db_state db_name: MY_DATABASE
...
Result:
'running'