Skip to content

MariaDB

Since v0.24.0

Introduction

The Testcontainers module for MariaDB.

Adding this module to your project dependencies

Please run the following command to add the MariaDB module to your Go dependencies:

go get github.com/testcontainers/testcontainers-go/modules/mariadb

Usage example

ctx := context.Background()

mariadbContainer, err := mariadb.Run(ctx,
    "mariadb:11.0.3",
    mariadb.WithConfigFile(filepath.Join("testdata", "my.cnf")),
    mariadb.WithScripts(filepath.Join("testdata", "schema.sql")),
    mariadb.WithDatabase("foo"),
    mariadb.WithUsername("root"),
    mariadb.WithPassword(""),
)
defer func() {
    if err := testcontainers.TerminateContainer(mariadbContainer); err != nil {
        log.Printf("failed to terminate container: %s", err)
    }
}()
if err != nil {
    log.Printf("failed to start container: %s", err)
    return
}

Module Reference

Run function

Info

The RunContainer(ctx, opts...) function is deprecated and will be removed in the next major release of Testcontainers for Go.

The MariaDB module exposes one entrypoint function to create the MariaDB container, and this function receives three parameters:

func Run(ctx context.Context, img string, opts ...testcontainers.ContainerCustomizer) (*MariaDBContainer, error)
  • context.Context, the Go context.
  • string, the Docker image to use.
  • testcontainers.ContainerCustomizer, a variadic argument for passing options.

Image

Use the second argument in the Run function to set a valid Docker image. In example: Run(context.Background(), "mariadb:11.0.3").

Info

From MariaDB docs:

From tag 10.2.38, 10.3.29, 10.4.19, 10.5.10 onwards, and all 10.6 and later tags, the MARIADB_* equivalent variables are provided. MARIADB_* variants will always be used in preference to MYSQL_* variants.

The MariaDB module will take all the environment variables that start with MARIADB_ and duplicate them with the MYSQL_ prefix.

Container Options

When starting the MariaDB container, you can pass options in a variadic way to configure it.

Tip

You can find all the available configuration and environment variables for the MariaDB Docker image on Docker Hub.

Set username, password and database name

If you need to set a different database, and its credentials, you can use WithUsername, WithPassword, WithDatabase options.

Info

The default values for the username is root, for password is test and for the default database name is test.

WithScripts

  • Since v0.24.0 If you would like to perform DDL or DML operations in the MariaDB container, add one or more *.sql, *.sql.gz, or *.sh scripts to the container request, using the WithScripts(scriptPaths ...string). Those files will be copied under /docker-entrypoint-initdb.d.
CREATE TABLE IF NOT EXISTS profile (
    id MEDIUMINT NOT NULL AUTO_INCREMENT,
    name VARCHAR(30) NOT NULL,
    PRIMARY KEY (id)
);

INSERT INTO profile (name) values ('profile 1');

WithConfigFile

If you need to set a custom configuration, you can use WithConfigFile option to pass the path to a custom configuration file.

The following options are exposed by the testcontainers package.

Basic Options

Lifecycle Options

Files & Mounts Options

Build Options

Logging Options

Image Options

Networking Options

Advanced Options

Experimental Options

Container Methods

The MariaDB container exposes the following methods:

ConnectionString

This method returns the connection string to connect to the MariaDB container, using the default 3306 port. It's possible to pass extra parameters to the connection string, e.g. tls=false, in a variadic way.

Info

By default, MariaDB transmits data between the server and clients without encrypting it.

// By default, MariaDB transmits data between the server and clients without encrypting it.
connectionString, err := ctr.ConnectionString(ctx, "tls=false")

MustConnectionString

Same as ConnectionString, but panics if an error occurs while getting the connection string.