Class MySql

misc/python/materialize/mzcompose/services/mysql.py:38–92

class MySql(Service):
    DEFAULT_ROOT_PASSWORD = "p@ssw0rd"
    DEFAULT_VERSION = "9.7.0"

    DEFAULT_ADDITIONAL_ARGS = create_mysql_server_args(server_id="1", is_master=True)

    def __init__(
        self,
        root_password: str = DEFAULT_ROOT_PASSWORD,
        name: str = "mysql",
        version: str = DEFAULT_VERSION,
        port: int = 3306,
        volumes: list[str] = ["mydata:/var/lib/mysql-files"],
        additional_args: list[str] = DEFAULT_ADDITIONAL_ARGS,
        use_seeded_image: bool = True,
    ) -> None:
        image = f"mysql:{version}"
        config: ServiceConfig = {
            "init": True,
            "ports": [port],
            "environment": [
                f"MYSQL_ROOT_PASSWORD={root_password}",
            ],
            "command": [
                "--secure-file-priv=/var/lib/mysql-files",
                *additional_args,
            ],
            "healthcheck": {
                "test": [
                    "CMD",
                    "mysqladmin",
                    "ping",
                    f"--password={root_password}",
                    "--protocol=TCP",
                ],
                "interval": "1s",
                # MySQL can be slow to start up
                "start_period": "180s",
            },
            "volumes": volumes,
        }

        if (
            use_seeded_image
            and version == self.DEFAULT_VERSION
            and root_password == self.DEFAULT_ROOT_PASSWORD
        ):
            config["mzbuild"] = "mysql"
        else:
            config["image"] = image

        super().__init__(
            name=name,
            config=config,
        )