Percona configuration examples¶
About Percona¶
More enterprises rely on MySQL® performance, resilience and security to power the applications and websites that make achieving their business goals possible.
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.
More information about Percona¶
How to add Percona to Qlico?¶
How to add Percona 8 to Qlico?¶
Add the following YAML to the services
section of your docker-compose.yaml
file.
qlico-core/docker-compose.yaml
percona8:
image: percona:8.0.42-33-centos
container_name: qlico-core_percona8
logging:
driver: none
ports:
- 3308:3306
environment:
MYSQL_USER: ${MYSQL_USERNAME:-root}
MYSQL_ROOT_PASSWORD: ${MYSQL_ROOT_PASSWORD:-qlico}
volumes:
- percona8-data:/var/lib/mysql
networks:
- qlico-core
Add the following YAML to the volumes
section of your docker-compose.yaml
file.
qlico-core/docker-compose.yaml
percona8-data:
name: qlico-core_percona8-data
driver: local
Example in a full docker-compose file¶
This is a large example, so you know where to place the Percona service(s) and volume(s).
qlico-core/docker-compose.yaml
---
# Author: Qlico <hello@qlico.dev>
services:
traefik:
image: traefik:v3.4.0
container_name: qlico-core_traefik
command: ["--providers.docker", "--api.insecure"]
networks:
- qlico-core
ports:
- 80:80
volumes:
- /var/run/docker.sock:/var/run/docker.sock
labels:
- "traefik.http.routers.traefik.rule=Host(`traefik.qlico`)"
- "traefik.http.services.traefik.loadbalancer.server.port=8080"
percona8:
image: percona:8.0.42-33-centos
container_name: qlico-core_percona8
logging:
driver: none
ports:
- 3308:3306
environment:
MYSQL_USER: ${MYSQL_USERNAME:-root}
MYSQL_ROOT_PASSWORD: ${MYSQL_ROOT_PASSWORD:-qlico}
volumes:
- percona8-data:/var/lib/mysql
networks:
- qlico-core
volumes:
percona8-data:
name: qlico-core_percona8-data
driver: local
networks:
qlico-core:
driver: bridge
name: qlico-core