DevOps Stack Exchange
DevOps Stack Exchange

Questions tagged [mysql]

For questions about MySQL, which is an open source Relational Database Management System (RDBMS).

37 questions
8
votes
3 answers

How to create staging servers for multiple git branches?

I have to create a new staging process for our development and testing. At any given time, there are only around 4 git branches actively being developed and tested. Within each git branch, there may be database evolution scripts (straight SQL) that…
max1221
  • 81
  • 1
  • 2
5
votes
1 answer

Terraform: Delay the MySQL Provider

I have a Terraform project which uses the MySQL provider. Because of the way Terraform works, the MySQL provider will fail to load correctly because the AWS_RDS instance doesn't exist. Is there a way for me to delay or split my project so that the…
Black Dynamite
  • 151
  • 5
3
votes
1 answer

Mysql with Kubernetes

I am converting a webapp from monolithic to kubernetes based architecture. But how can mysql be persistent with data when we have 2 mysql pods in each of 2 differnet nodes? I think we can mount a volume but still if my server with the mounted volume…
ankk98
  • 131
  • 4
2
votes
2 answers

How to handle AWS Offsite or cross-account RDS (mysql) backups?

AWS Provides a great solution to provide point-in-time recovery backups within RDS. However, while we take every measure to protect the root account, I'm paranoid that if someone were to gain access they can wipe the entire AWS account including all…
Brad
  • 179
  • 1
  • 3
2
votes
1 answer

Persistent data in MySQL with Docker

If I startup MySQL server during docker build (derived from official MySQL Dokcer Image) in two different statements, would be database files be pertained? I would say yes, but it seems to be wrong. Why? Logfile: 180228 08:54:50 mysqld_safe Logging…
Ta Mu
  • 6,792
  • 5
  • 43
  • 83
2
votes
0 answers

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, and in part because Jaws DB is very limiting and I…
gcr
  • 121
  • 3
2
votes
3 answers

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 xtrabackup. We are using xtrabackup version 2.4.21…
Hiren Namera
  • 123
  • 1
  • 4
2
votes
0 answers

Connecting to MySQL Remotely on Azure VM

I am having trouble connecting remotely to my MySql install that runs on an Azure VM. Here is what I did: Ubuntu VM with MySql 5.7 installed Bind Address set to 0.0.0.0 User granted rights with wildcard domain Opened 3306 on Azure networking page…
Nick
  • 121
  • 1
1
vote
1 answer

docker mysql container not running suddenly

docker mysql container was working perfectl.But after restarting of the server and using the start command to run the conatiner it is not working.My other containers are all up and running as normal.But mysql shows status exited.If I do docker start…
Rajesh k
  • 41
  • 2
1
vote
1 answer

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 version running. This is my docker compose config,…
Bas Visscher
  • 21
  • 1
  • 3
1
vote
2 answers

Can't connect to my dockerized MySQL

I'm trying to implement this pre-cooked package of NGINX, PHP-FPM, MySQL, E-L-K. Everything is working fine but the connection with the database. It throws a ConnectionException. I'm not really sure if the program should try to access 172.18.0.4…
CarlosAS
  • 435
  • 1
  • 5
  • 9
1
vote
1 answer

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 community.mysql.mysql_query: login_user:…
Ravi Kumar CH
  • 113
  • 5
1
vote
2 answers

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 containers, and I'd rather use ports published by…
Gerald Schneider
  • 121
  • 7
1
vote
1 answer

Managed MySQL cluster - similar solution for a private cloud

Is it possible to build a similar solution to managed MySQL cluster on a private cloud (VMware vSphere / Hyper V). Even with Kubernetes. A solution which supports auto-scaling, auto-upgrade, multi-master and similar to the largest public clouds…
jwalker
  • 27
  • 3
1
vote
1 answer

mariadb docker on raspberry

I've tried countless docker images, but all of them have the same behaviour. When I open up a console and try to import my database structure via the mysql/mariadb command. But I always get the same error: ERROR 1045 (28000): Access denied for user…
Cowboy_Patrick
  • 79
  • 2
  • 6
1
2 3