Questions tagged [mysql]
MySQL is an open-source database owned by Oracle. ServerFault topics include how to run the server. For more MySQL specific questions like backup/restore/recovery/configuration, dba.stackexchange.com is probably a better home.
8,664
questions
0
votes
1
answer
31
views
Synchronizing load balanced Linux servers
I want to load-balance two dedicated linux servers, I'm planning to do that using round robin DNS, but I can't find a way to synchronize the servers to be identical.
The servers are running a perl ...
0
votes
1
answer
18
views
Multiple MySQL versions using Homebrew on macOS giving Error - Can't connect to local MySQL server through socket
I am trying to set up multiple MySQL versions using Homebrew. I have already been using MySQL 8.*, which is running fine. However, due to some old project requirements today, I have installed another ...
- 101
0
votes
0
answers
16
views
Which cache solution is suitable for Storing Cache data? [closed]
We are running many websites in Yii2 application. Currently we are using File Cache for Data Caching. Now we want to use load balancer and put our caching on dedicated server.
We will have to store ...
- 135
0
votes
1
answer
68
views
Frequent server downtime and suspicious server hits to access random Pdf files
Our Server hosting PHP web application is facing frequent downtime
Server Information [Nginx, FreeBSD] Web application [PHP 5.6, MYsql 5.7]
I have gone through the Nginx logs and below are my findings
...
- 101
-1
votes
1
answer
47
views
Mysql server eating all RAM (100GB) when load is running
I am using Mysql - Server version: 8.0.29 MySQL Community Server - GPL
My server has 100GB RAM.
Of it I allocated innodb_buffer_pool_size as 90 GB
SET GLOBAL innodb_buffer_pool_size = 96636764160;
I ...
- 101
-1
votes
1
answer
32
views
MariaDB - Emulate MySQL 5.7 version number?
I have been running MariaDB 5.5 on a linux server for several years.
Yesterday, I upgraded to MariaDB 10.11.3.
Now, my backup software has stopped backing up the databases, reporting an error that &...
- 943
0
votes
1
answer
22
views
Exporting Wordpress Database from GCP
I am trying to create a local replica of wordpress database by exporting it on gcloud console (after logged in via gcloud compute ssh) but facing this problem. Is there a way out to resolve this or ...
google-compute-engine
1
vote
0
answers
52
views
Issues with AWS Aurora MySQL engine version "5.7.mysql_aurora.2.10.3"
Is anyone else experiencing problems after recent automated AWS Aurora MySQL database engine updates? (specifically "5.7.mysql_aurora.2.10.3")
Over the weekend our web servers started ...
-1
votes
2
answers
75
views
How can I stop my MySQL server from going down?
I have a website based on a MySQL server on an Ubuntu machine. Every several weeks, one of my users complains that the site does not work, and I find out (using service mysql status) that it is ...
2
votes
0
answers
23
views
Can I recover MySQL data if the .MYD file is missing? [migrated]
One of my databases got corrupted. All of the tables are stored using MyISAM engine. I managed to grab what's left in the server's mysql\data folder. All the ib* files are intact.
As for the tables, ...
- 21
0
votes
0
answers
15
views
Failover configuration using two machines for Angular/Django/MySQL
Using only two physical machines, how can one establish a failover configuration using nginx for a web app that is built on angular, django and mysql.
If any of the software components such front-end, ...
- 1
0
votes
1
answer
42
views
PuTTY Reverse Tunnel to MySQL
I have:
A local Windows 10 PC running MySQL Server 8.0.33 on port 33060.
A remote Ubuntu 20.04.6 LTS VPS running MySQL Server 8.0.33 on port 3306.
I want to create a reverse tunnel using PuTTY on my ...
- 101
0
votes
1
answer
75
views
Connecting to MySQL on GCP CE instance (WordPress)
I installed WordPress from the Google Cloud Marketplace into a Compute Engine instance, and am trying to connect to the MySQL instance on that machine using DataGrip on my local machine (macOS).
I can ...
0
votes
0
answers
11
views
Optimzing Docker Builds with docker-compose.yml when using PostGres DB's, performance, etc
I just have a general about how best to build and manage DB servers when using Docker builds with docker-compose.yml. Historically, I've sometimes bound the Postgres DB's to a bound folder on the ...
- 141
0
votes
1
answer
56
views
which memory limit applies when php performs a MySQL query
If I run php as FPM, I can set my memory limit in php.ini or .user.ini. PHP can perform a MySQL query, and I can set memory limits in /etc/my.cnf for for instance the innodb buffer pool. If PHP runs ...
- 95
1
vote
1
answer
67
views
Maximum possible memory usage
recently my MYsql CPU usage is 120% and this is the mysqltuner
can you please suggest for me a solution ?
[root@server1 ~]# mysqltuner
>> MySQLTuner 1.8.3 - Major Hayden <major@mhtx.net&...
- 13
0
votes
0
answers
87
views
Why does MySQL 5.7 inside a docker container always crash?
I have a MySQL 5.7 docker container that was provisioned via a docker-compose file, the file looks like this:
version: '3'
# Run command: docker compose --env-file .env.local up
services:
# ...
- 131
0
votes
0
answers
21
views
Creating a non-public DNS alias for a database in Google Cloud Platform (GCP)
I am currently working on setting up a database in Google Cloud Platform (GCP), and I would like to create a non-public DNS alias for it. The purpose of this alias is to provide a more user-friendly ...
0
votes
2
answers
57
views
Starting MySQL standalone works but as windows service it fails
I have an xampp-portable directory that contains mysql/mariadb. The xampp directory is located directly on d:, so path is d:\xampp and mysql is d:\xampp\mysql I want to run mysql as windows service so ...
- 103
0
votes
1
answer
26
views
How to add a new database on replication?
I have a mysql replication with two servers.
There are actually 3 databases on it.
On master :
server-id = 1
log_bin = /var/log/mysql/mysql-bin.log
expire_logs_days ...
1
vote
0
answers
88
views
After upgrade Ubuntu 18.04 to 20.04, MySQL server is not starting
I upgraded Ubuntu 18.04 to 20.04
The process upgraded MySQL 5.7 to 8.0
It instantly started to throw errors in error logs
[ERROR] [MY-013379] [Server] Server upgrade started with version 80033, but ...
- 11
1
vote
1
answer
459
views
Mysql stopped working on Ubuntu 22.04. Failed to upgrade server. Error
I have a basic DigitalOcean droplet (1gb ram and 1 cpu) that has a few websites on it. There are a couple nodejs sites and a couple of Wordpress sites. All are pretty low traffic. It normally works ...
- 125
0
votes
1
answer
37
views
There is no replication in a HA Cluster
I had the problem of unrelated data aborting in a HA cluster and my Mysql resource was in standalone on both nodes, I managed to solve the problem and both nodes are synchronized, the problem now is ...
- 81
0
votes
1
answer
65
views
Setting mysql using ansible in ubuntu remote machine
I have written one ansible playbook for installing MySQL server in ubuntu remote machine but is not working here is the yaml code
---
- name: setting mysql in ubuntu
hosts: web01
become: yes
...
0
votes
0
answers
27
views
Temporary internal error / Dovecot: Initialization failed status=deferred (host domainname.com
Postfix working properly on port 25.
Getting error while sending mail from outlook 2016. Tried to use Port 110 & 993 & 995.
Mail Log:-
Error:-
status=deferred (host domainname.com[private/...
0
votes
0
answers
35
views
vsftpd with MySQL 8 - login not working
I try to set up vsftpd using MySQL database for login users via pam.d
I have this config in /etc/pam.d/vsftpd:
# Standard behaviour for ftpd(8).
auth required pam_listfile.so item=user sense=...
- 121
-2
votes
0
answers
27
views
How to install Postfix admin & Poastfix on CentOS 7 with Nginx and MySQL 5.5
Anyone could you please help me to install Postfix Admin & Poastfix on CentOS 7 with Nginx and
MySQL 5.5 and multiple domains?
Senario:- I want to send & receive mail from multiple domains.
0
votes
2
answers
69
views
CPU Usage 98% /usr/sbin/mysqld and server down
How to solve this issue. php codeigniter framwork
Everyday our server goes down because of these issue.
CPU usage 98 % Ram used 21 083 MB /usr/sbin/mysqld
0
votes
0
answers
41
views
How to set individual mysqld parameters using the bitnami/mysql Helm chart?
We're using the bitnami/mysql Helm chart.
We'd like to upgrade max_allowed_packet from the default 16M value to 64M.
From what I can read in the README, it looks like the only way to pass custom [...
- 4,447
6
votes
3
answers
119
views
DRBD Cluster nodes not configured (StandAlone)
I have a HA cluster with two nodes, node one is the primary and node 2 is its mirror. I have a problem in the mysql resource since my nodes are not synchronized
drbd-overview
Node Principal:
0:home ...
- 81
0
votes
1
answer
49
views
why mysql bin logs are not expiring even though expiry was set
I am using 5.7.37-log MySQL Community Server.
my mysqld.cnf looks below:
server_id = 11
log_bin = bin.log
log-bin-index = bin-log.index
binlog_format = row
max_binlog_size = 100M
socket = mysql.sock
...
- 101
0
votes
1
answer
121
views
Diagnosing mySQL Random CPU Spikes
Our organization has a fairly advanced (as in many moving pieces) web application that's been working great up until recently, yet no noticeable changes have been made.
There is the Apache Web Server, ...
1
vote
0
answers
49
views
MySql Service Not Starting in cluster with DRBD
I have a high availability cluster with two nodes configured, after a maintenance carried out by an external company when restarting the system my mysql resource stopped working.
when executing the ...
- 81
0
votes
0
answers
45
views
Slow MySQL 5.7 on Windows Server 2019
MySQL 5.7 standard install with standard my.cnf (server) one table 20mb size
Dell R210II Windows Server 2019 Xeon 1230 v2 16gb ram
1 queries executed, 1 success, 0 errors, 0 warnings
Query: CALL ...
- 1
0
votes
0
answers
34
views
My website running on an ubuntu server went down after reboot
I was going to add something to my php.ini file so I added it and rebooted the server. My site went down after the reboot citing that it could not connect to the database so I reversed the changes ...
0
votes
0
answers
39
views
Replicate mysql database when target server is MariaDB 10.5 (where mysql.user is a view)
I have a sync script that does a mysqldump on the mysql database on a source server, then imports that dump on the target server, followed by privelege flush. Systems are CentOS 7.
In MariaDB 10.5, ...
- 229
2
votes
1
answer
118
views
Extremely slow MySQL writes in Ubuntu (ext4) guest on Promox 7.3-3 (ZFS) host
I'm trying out Proxmox 7.3-3 as a hypervisor and managed to install it using ZFS on my NVMe (Samsung_SSD_970_EVO_Plus_2TB_S6S2NS0T505403V)
I also installed a Ubuntu 22.04 VM and its filesystem is ext4
...
- 155
1
vote
1
answer
65
views
PHP-FPM static max_children amount doesn't seem to matter much during stress tests
I've been stress testing PHP-FPM set up as static using wrk, with NGINX running on Ubuntu Server 22.04 for the past few days, writing down results for every scenario. When I look at them, it seems to ...
2
votes
2
answers
66
views
How should I automate replication of a production MySQL db onto a read/write dev server for testing while also scrubbing the data first?
I know there are lots of variables here, and they're highly dependent upon the applications in the environment as well as the needs of the org. I read this post first, as the question was similar.
[...
- 23
0
votes
1
answer
89
views
Mariadb creates a subprocess after crash
We recently had a crash on our Mariadb server (10.6.5) on a Debian 9 VM. The process was restarted without error but now there's a second mariadb process like so :
mysql 26718 5.1 42.4 15062644 ...
- 321
-2
votes
1
answer
66
views
How to fix MySQL installation in Ubuntu:20.04 Docker container
invoke-rc.d: could not determine current runlevel
invoke-rc.d: policy-rc.d denied execution of start.
...
Cannot stat file /proc/3352/fd/0: Permission denied
Cannot stat file /proc/3352/fd/1: ...
1
vote
1
answer
57
views
Hardening the security of a backup shell script of a web-server with mysql database
In the case of a simple web-server with a MySQL database, the script has to dump the database, copy the web-server files and tar everything together. Then a NAS server Rsync the tar file via a "...
- 11
1
vote
0
answers
36
views
mysql NDB backup fail
I'm trying to abort a backup on a NDB cluster like this:
ndb_mgm> abort backup 2304081512
Abort of backup 2304081512 ordered
But there is no change, the backup seems to be stalled :
ndb_mgm> ...
- 133
0
votes
0
answers
61
views
Errors importing JSON file to MySQL using mysqlsh Util.import_json
I am having errors in attempting to import a file into MySQL (8.0.32-0ubuntu0.22.04.2) using:
mysqlsh mysqluser@localhost/jsondb --import /path/to/file.json
If the file is in, say, my home directory, ...
0
votes
1
answer
49
views
Is it possible that MariaDB caches the host depending on user and password?
I have a weird issue with my MariaDB in my application.
I use Prisma NodeJS library to connect to MariaDB.
The problem looks like this:
I have localhost and a remote server with the same username/...
- 230
-1
votes
1
answer
31
views
Anybody familiar with the Shoretel database?
I have a copy of the local db from our old shoretel voip system... which is no longer in service.
I've been tasked with trying to locate information pertaining to calls to and from specific numbers ...
- 212
0
votes
0
answers
46
views
How to parse MariaDB version banner?
I encountered this form of MariaDB DB version via banner:
5.5.5-10.3.38-MariaDB-log
What is the version of the MariaDB?
Is it 5.5.5 or 10.3.38?
If one of them, what is the meaning of the other? (I ...
- 101
0
votes
2
answers
54
views
EC2 instance randomly crash
My EC2 instance kept crashing, here is the syslog, can server admin expert share some insight?
https://pastebin.com/jfP8qhZX
- 217
0
votes
0
answers
65
views
Not able to start mysql after upgrade from 5,7 to 8 (ubuntu upgrade)
After upgrading ubuntu to 22.04 from 18.04 (was planning on upgrading to 20.04 but somehow I ended up with 22.04) I'm not able to start mysql server. The error is as follows:
[ERROR] [MY-000077] [...
1
vote
1
answer
69
views
Azure App Service to Azure MySQL Flexible Server Latency
I have an old ASP.NET MVC website I've moved to Azure that runs super slow on there.
I've set up:
App Service (Standard S1 plan)
Azure Database for MySQL flexible server (Burstable, Standard B1ms - ...
- 155