Questions tagged [mysql]
For questions about MySQL, which is an open source Relational Database Management System (RDBMS).
35 questions
0 votes
0 answers
28 views
How to deploy a highly available mysql cluster in kubernetes?
I want to deploy a highly available mysql cluster in kubernetes, but the example in kubernetes official documentation is too old to operate. Because the xtrabackup image is not supported by Docker24+. ...
0 votes
1 answer
132 views
Unable to create azurerm_mysql_flexible_server in azure with terraform due to private dns zone errors "The Private DNS Zone name provided is invalid"
I am trying to use this code: resource "azurerm_mysql_flexible_server" "shared" { name = var.mysql_server_name resource_group_name = azurerm_resource_group....
- 111
0 votes
1 answer
971 views
How to configure MySQL exporter Helm chart for multiple targets (remote & local)?
I have been trying for a few days to set up a multi-target MySQL exporter (MSE) deployed with Helm inside a k8s cluster. The chart that I am using is the https://artifacthub.io/packages/helm/...
- 199
1 vote
1 answer
5k views
Setup keycloak with mysql via docker compose
I've been trying to get keycloak running for a bit now. I had it going using the legacy tag but it seems like bad practice to get started with a legacy version. So I wanted to get the most recent ...
- 21
0 votes
2 answers
175 views
How to implement simple distributed configuration system
I have multiple servers running in data centers around the world. Each server has its own configuraiton database, and cli command needs to be executed to update in-memory cache. I want to automate ...
- 111
0 votes
1 answer
781 views
K8S + HELM. Create a persistence volume for mysql database
I am using K8S with Helm 3. I am also using MYSQL 5.7 database. How can I create MYSQL pod, that the database will persist (created on first time) after first time the pod is created, and even the pod ...
- 103
1 vote
1 answer
2k views
ansible mysql query not showing results
I have used community.mysql collection and was able to run a query against the database. --- - name: Get stats of a file hosts: localhost become: true tasks: - name: run mysql query ...
- 113
0 votes
1 answer
1k views
Where is located mysqldump log file on Linux/Ubuntu
I am neither a DB administrator, nor a DevOps but I need to migrate a very large table (~500M rows) from one MySQL schema to another. For doing so, I use mysqldumpbackup tool. Also, since the DB is an ...
- 71
0 votes
1 answer
2k views
My Python application doesn't communicate with MySQL inside docker. Can someone help me?
The connection is not succeeding in docker. Look at my settings: Dockerfile FROM python:3.8.5-alpine WORKDIR /app COPY requirements.txt . RUN python3 -m pip install --upgrade pip RUN pip install -...
2 votes
0 answers
114 views
How do I deploy and configure a MariaDB (Mysql) image for remote connection?
Specifically: I want to deploy a docker mariadb image to Heroku, that my other heroku app will connect to, in part because I want that skill, in part so I can extend the architecture in the future, ...
- 121
2 votes
3 answers
3k views
Export AWS RDS mysql Database to S3 Bucket using xtrabackup or any other method
I have an AWS RDS MySQL Database. The size of the Database is around of 1.5 GB. We are using MySQL 5.7.32. We tried with SQL dump but in dump data is missing in Dump. We found out that we can use ...
- 123
1 vote
2 answers
2k views
Bootstrapping Galera Cluster in Docker
I'm trying to bootstrap a MariaDB Galera cluster in Docker containers. The following configuration works when I set network_mode: host, but then I can't directly access the MariaDB from inside other ...
- 121
0 votes
1 answer
2k views
mysqld: [ERROR] Found option without preceding group in config file /root/.my.cnf at line 1!
I'm trying to create a .my.cnf file for my MySQL docker-container that would allow me to prefill the user and password for the MySQL client. To achieve this I created the following dockerfile: FROM ...
- 101
0 votes
1 answer
448 views
Confluence mySQL image doesn't start anymore
I am running a confluence container containing an image for the application itself and one for the mySQL db. This was running smoothly until I run the latest Docker update. Since then, the mySQL image ...
- 11
0 votes
2 answers
59 views
How can I model this schema in MySQL?
I want to create a schema that reflects the following relationships, and I'm trying to do this in MySQL Workbench. (I'm no DB expert) I have 3 environments - sandbox, staging, and production I ...
- 487