Chainguard Image for percona-server

Percona Server for MySQL is a free, fully compatible, enhanced, and open source drop-in replacement for any MySQL database. It provides superior performance, scalability, and instrumentation.'

To get more information about the image, please visit the GitHub repository.

Chainguard Images are regularly-updated, minimal container images with low-to-zero CVEs.

Download this Image

This image is available on cgr.dev:

docker pull cgr.dev/ORGANIZATION/percona-server:latest

Be sure to replace the ORGANIZATION placeholder with the name used for your organization's private repository within the Chainguard registry.

Usage

To get started with Percona Server for MySQL promptly, this Quickstart guide emphasizes using Docker or installing with APT or YUM. Also you can follow along the Quickstart guide on the Percona website for more details.

Docker

Starting a Detached Container

Start a container with the --detached or -d option to run it in the background. In detached mode, the container exits when the main process used to run it exits.

Start a container named ps with the latest version of Percona Server for MySQL 8.3. This example sets the root password to root (not secure).

$ docker run -d \
  --name ps \
  -e MYSQL_ROOT_PASSWORD=root \
  cgr.dev/chainguard/percona-server:latest

By default, Docker pulls the image from Docker Hub if it is not available locally.

To view the container’s logs, use:

$ docker logs ps --follow

<details> <summary>Expected Output:</summary>

You can access the server when you see the "ready for connections" message in the log.

</details>

You can pass options with the docker run command. Example: Set UTF-8 as the default character set and collation for all databases.

$ docker run -d \
  --name ps \
  -e MYSQL_ROOT_PASSWORD=root \
  cgr.dev/chainguard/percona-server:latest \
  --character-set-server=utf8 \
  --collation-server=utf8_general_ci

Accessing the Percona Server Container

Use the docker exec command to get a shell inside the container. Example:

$ docker exec -it ps /bin/bash

For troubleshooting, the error log is located in /var/log/ or /var/log/mysql/, typically named error.log or mysqld.log.

View the error log with:

$ more /var/log/mysql/error.log

<details> <summary>Expected Output:</summary>

...
2017-08-29T04:20:22.190474Z 0 [Warning] 'NO_ZERO_DATE', 'NO_ZERO_IN_DATE' and 'ERROR_FOR_DIVISION_BY_ZERO' sql modes should be used with strict mode. They will be merged with strict mode in a future release.
2017-08-29T04:20:22.190520Z 0 [Warning] 'NO_AUTO_CREATE_USER' sql mode was not set.
...

</details>

Accessing the Database

You can access the database using docker exec or the mysql command inside the container’s shell.

$ docker exec -ti ps mysql -uroot -proot

<details> <summary>Expected Output:</summary>

mysql: [Warning] Using a password on the command line interface can be insecure.
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 9
...

</details>

You can also use the MySQL command-line client inside the container’s shell to access the database:

$ mysql -uroot -proot

<details> <summary>Expected Output:</summary>

mysql: [Warning] Using a password on the command line interface can be insecure.
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 8
Server version: 8.3.0-1 Percona Server (GPL), Release 21, Revision c59f87d2854

Copyright (c) 2009-2022 Percona LLC and/or its affiliates
Copyright (c) 2000, 2022, Oracle and/or its affiliates.

Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners.

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

</details>

Contact Support

If you have a Zendesk account (typically set up for you by your Customer Success Manager) you can reach out to Chainguard's Customer Success team through our Zendesk portal.

What are Chainguard Images?

Chainguard Images are a collection of container images designed for security and minimalism.

Many Chainguard Images are distroless; they contain only an open-source application and its runtime dependencies. These images do not even contain a shell or package manager. Chainguard Images are built with Wolfi, our Linux undistro designed to produce container images that meet the requirements of a secure software supply chain.

The main features of Chainguard Images include:

• Minimal design, with no unnecessary software bloat
• Automated nightly builds to ensure Images are completely up-to-date and contain all available security patches
• High quality build-time SBOMs (software bills of materials) attesting the provenance of all artifacts within the Image
• Verifiable signatures provided by Sigstore
• Reproducible builds with Cosign and apko (read more about reproducibility)

-dev Variants

As mentioned previously, Chainguard’s distroless Images have no shell or package manager by default. This is great for security, but sometimes you need these things, especially in builder images. For those cases, most (but not all) Chainguard Images come paired with a -dev variant which does include a shell and package manager.

Although the -dev image variants have similar security features as their distroless versions, such as complete SBOMs and signatures, they feature additional software that is typically not necessary in production environments. The general recommendation is to use the -dev variants only to build the application and then copy all application artifacts into a distroless image, which will result in a final container image that has a minimal attack surface and won’t allow package installations or logins.

That being said, it’s worth noting that -dev variants of Chainguard Images are completely fine to run in production environments. After all, the -dev variants are still more secure than many popular container images based on fully-featured operating systems such as Debian and Ubuntu since they carry less software, follow a more frequent patch cadence, and offer attestations for what they include.

Learn More

To better understand how to work with Chainguard Images, we encourage you to visit Chainguard Academy, our documentation and education platform.