Questions tagged [mariadb]

MariaDB is a drop-in replacement for Oracle(R) MySQL(TM).

Filter by
Sorted by
Tagged with
0
votes
1answer
25 views

Can't change the data-directory for MariaDB Centos7.6

I have a fresh install of Centos 7.6 which includes standard partition scheme for Centos 7.6 install. Which includes a "/" directory partition of 50GB. I would like to move the default nysql (mariadb)...
1
vote
1answer
10 views

How to access mysql console on Docker container using secrets

I've been able to access Mysql console on a Mariadb Docker container. From my local machine I can run this command to access the console (I have mariadb installed locally): mysql -h localhost -P ...
0
votes
0answers
9 views

Can't run new Galera Cluster

I'm trying to run a new Galera Cluster on my local machine. I'm using CentOS 7 on Parallels Desktop. I followed all the instruction to bootstrap a new cluster but I keep getting this: MariaDB [(none)]...
0
votes
0answers
19 views

mysqldump generating inconsistent dumps

I cannot get mysqldump to generate a dump that will properly restore. The dump is being generated to setup a new slave, but whenever the slave starts up, it gets foreign key constraint failures. I'm ...
0
votes
0answers
10 views

ha_tokudb.so not found … but TokuDB is not installed

I found following message in /var/log/mysql.err and I would like to find out how to remove it (as it disturbs me a bit): 2019-12-01 8:13:40 140640051248512 [ERROR] Can't open shared library '/usr/...
1
vote
0answers
19 views

Create MariaDB cluster across 2 seperated OpenShift clusters

Good day, I am looking to create a MariaDB cluster in OpenShift/Kubernetes. The caveat, is that my cluster need to be ''spanned'' across 2 seperated OpenShift/Kubernetes clusters. I am trying to ...
0
votes
0answers
10 views

How to get default config file for MariaDB on Debian Stretch

Previously, mysql-common installed a lovely default MySQL config file in /etc/mysql/my.cnf, that you could just make minor tweaks to. Now, it points to a conf.d/ and mariadb.conf.d/ folder which ...
0
votes
2answers
89 views

Fastest possible configuration for a local MySQL database, no security needed?

We have a local Optiplex PC setup to run our shared MySQL MariaDB database with no way to access it from the outside world. It doesn't have any critical data that needs to be protected. Basically, no ...
0
votes
1answer
53 views

MariaDB in docker - setting up grants to limit access by container hostname

I have a MariaDB container running on my swarm cluster that services several applications, each running in their own container and connected to the database with a dedicated network (internal and ...
0
votes
1answer
31 views

cannot access mariadb remotely

I'm a new user for Linux and I was given a remote server to play with. I'm trying to access the mariadb database remotely in this server. I got 'connection refused' error when I tried it. pramod@...
2
votes
1answer
166 views

Was I using MariaDB or MySQL?

An Ubuntu upgrade (to 19.10) messed up my database server. After the upgrade, the sql server would not start. So I installed MySQL but later realized that I may have been using MariaDB. Is there a ...
0
votes
1answer
16 views

Error updating MariaDB (to 10.1.42) in CentOS and Ubunto

Yum is failing to update MariaDB to version 10.1.42. yum check-update presents available updates for MariaDB (server, client, common, etc.) and galera. MariaDB-client.x86_64 ...
0
votes
1answer
124 views

unable to update the MariaDB upgrade to work

Have run apt update and apt upgrade and this are the errors for mariadb Ign:1 http://mariadb.mirror.liquidtelecom.com/repo/10.4/ubuntu bionic/main amd64 mysql-common all 1:10.4.9+maria~bionic Ign:2 ...
0
votes
0answers
106 views

Updated MariaDB from 5.5.64 to 10.4.9, now receiving failed to resolve error on CentOS 7

I updated my version of MariaDB last night from 5.5.64 to 10.4.9. It all worked well, my databases are back up and working but I am now receiving an error with my daily yum-cron email. The error im ...
0
votes
0answers
13 views

MySQL least privileges to get database/tables size

I'm using centreon_plugins to monitor some mysql databases. As a best practice I create a dedicated user for monitoring and I give it the least possible privileges. For simple monitoring I usually ...
0
votes
0answers
394 views

mysqlimport — stack smashing detected and segmentation fault

We are importing a large batch of records with mysqlimport tool. We have ~800 files prepared for importing all in one directory with names such as: mytable.2019-10-31_17-37-1501 mytable.2019-10-...
1
vote
1answer
37 views

Errors while restoring mariadb/mysql dump in docker

I'm running mariadb in a docker container. I want to backup and restore using a sql dump. I created the database for use with wordpress, and created just one test page. I installed phpmyadmin to the ...
0
votes
1answer
61 views

MySQL (MariaDB) is running at 100% CPU utilization after adding an index

I attempted to add an index to a date field in a table (MyISAM) having about 4,000 rows, using PHPMyAdmin. PHPMyadmin froze, finally timed out. Now, even after rebooting the server, the MySQL (...
0
votes
1answer
35 views

Can't connect to MySQL server, “Unknown error”

I'm running a series of server programs on Windows Server 2016 that are using a MySQL server (MariaDB 10.0.27). At first everything is fine, the servers connect to the database, clients can connect to ...
0
votes
0answers
26 views

Force php mysqli_connect() to use TCP

Background: I'm migrating to php-fpm with chroot. Before I used socket for connecting to mysql. However it's quite a work to deliver mysql socket to all vhosts. Either I have to mount -o bind or I ...
1
vote
0answers
19 views

What is the alternative for innodb_track_changed_pages in Debian 10/MariaDB 10.3

So we have been using Debian 9 with MariaDB 10.1. For faster backups (total DB size across three DBs is > 1TB) we have enabled innodb_track_changed_pages. However, that feature has gone away on ...
1
vote
2answers
93 views

Correct way to have a mysql/mariadb incremental backup

I've read for a few hours on this topic but don't have a complete grasp. I'm going to be using borg backup to a network share. Looking to have pretty frequent backups of the binlog....every 5 ...
0
votes
1answer
60 views

mysql connection is slow sometimes on localhost

background: it's 92G/20 CPU server with ubuntu 18.04 mysql Ver 15.1 Distrib 10.1.41-MariaDB, for debian-linux-gnu (x86_64) using readline 5.2 issue: root@z:# time mysql -uroot -pXXX -e "select now(...
0
votes
0answers
29 views

logrotate problems after resetting mysql root password

A while ago, I had to reset my forgotton root password for mysql (strictly speaking mariadb) along a suitable how-to (might have been this https://devanswers.co/how-to-reset-mysql-root-password-ubuntu/...
0
votes
1answer
126 views

MariaDB docker “Can't init tc log” when using mounted storage

I am initializing a new MariaDB database. Running docker with a volume to my home directory allows MariaDB to start up just fine: docker run -it --rm --name mymaria \ -e MYSQL_RANDOM_ROOT_PASSWORD=...
0
votes
0answers
22 views

AWS easy way to provision a new database on an existing RDS (MariaDB) instance

I have a greenfields account, with a bunch of stacks I've built a-top of it. Now, I have no existing EC2 instances, however while "in this state" I want to connect to my existing RDS MariaDB instance ...
0
votes
1answer
27 views

Is it safe to patch Galera without updating MariaDB?

I've been running MariaDB Galera Cluster for some time and only today realised that despite having identical versions of the MariaDB on all nodes, my versions of the Galera plugin are all different. ...
0
votes
1answer
29 views

Will Mariadb replication master-slave setup work for Joomla/Virtuemart?

I have a Joomla/Virtuemart installation and i want to create a master-slave replication with 1 slave The Slave will be used as a failover in case there is something wrong with the master. The ...
1
vote
0answers
30 views

Εxponentially growing Innodb_row_lock_time on “master” node of MariaDB 10.3 Galera cluster

I've been trying to investigate issues with an application failing, and I have reason to believe that the culprit lies somewhere in the database backend. To this end, I started collecting metrics from ...
0
votes
0answers
78 views

Why does Mariabackup think my compressed table is corrupted?

I've got a MariaDB database (version 10.2) that I'm attempting to back up with Mariabackup (the official fork of Percona's XtraBackup). Both the DB server and the backup tool are installed from the ...
0
votes
1answer
18 views

changing from percona to mariadb without losing data

i have a production server running with percona. but i don't really like it anymore and i'm more used to mariadb. can i change from percona to mariadb without losing any data or having compatibility ...
0
votes
1answer
128 views

MariaDB / MySQL single master multiple slave odd behavior

I am trying to setup replication from a single Master server to multiple slaves. I followed the traditional steps... On Master: Updated my.cnf file: log-bin = /var/log/mysql/master-bin log-...
1
vote
0answers
73 views

Query Failed: Lost connection to MySQL server during query (Remote connection stable issues)

i've been reading a lot about this and didin't find any solution, that's why i am creating this topic. First im going to give you my dedicated server specifications root@...
1
vote
1answer
38 views

Was this a hacking attempt? (Docker container -> MariaDB)

since i am completely new to web hosting and setting up web servers, please excuse my dumb questions ;) Yesterday i uploaded my web application on digitalocean. The application is a very simple ...
0
votes
0answers
32 views

MariaDB 10.1 suddenly slow and using near 100% user% cpu and hardly any iowait%

Hi I have a single MariaDB 10.1 node running on Debian 8. Today after months of stability, it has become 20 times slower, and top is showing that >99% is used in user% and <0.3% is used in iowait% ...
0
votes
1answer
55 views

Cannot input password when installing mariadb on centos

After following the commands below, I get this error. At this point, it doesn't allow me to input a password - no key apart from Enter works. Enter just gives me this same error. How do I set a ...
0
votes
1answer
137 views

MariaDB Galera Cluster over IPSec

I am working on the expandation of my server infrastrucutre, so I orderd Servers in a second datacenter which I want to use as failover location. For better identifiaction I will use "ffm1" for the ...
0
votes
0answers
59 views

MariaDB rescan for consistency

At the beginning of a database dump, FOREIGN_KEY_CHECKS is disabled and at the and it is enabled again. That means consistency is not guaranteed in case of altered/broken commands inside the dump file....
-1
votes
2answers
199 views

Mariadb not running after AWS Linux 2 installation

I'm running an AWS Linux 2 AMI and installed mariadb. The packages installed are: But when I try to start the service running sudo systemctl start mariadb I get Failed to start mariadb.service:...
0
votes
1answer
63 views

Setting up Shopware 6 fails with PHP XML error

Currently setting up Shopware 6 Community Edition ( https://www.shopware.com/de/download/ ) on my Ubuntu machine. I followed these steps: https://docs.shopware.com/de/shopware-6-de/erste-schritte/...
0
votes
0answers
102 views

MariaDB opens lots of files causing PHP-FPM to fail

There is a problem I'm dealing with that under a known traffic (e.g. reaching 300 concurrent users) server doesn't handle more incoming requests due to open files. This is the current limit: $ cat /...
0
votes
0answers
18 views

mariadb main thread over 100% cpu and flushing logs

I have 5.5.60-MariaDB and noticed the main thread remains on sleep mode for the last 200hrs. After checking innodb status I see the below line for this thread. Main thread process no. 119014, id ...
0
votes
0answers
30 views

Docker : linking php-fpm and mariadb

I'm trying to use Docker Compose to run a Nginx/php-fpm/mariadb stack on my dev laptop. But I can't find a way of making the php-fpm and mariadb containers networking correctly. For the moment, when I ...
0
votes
2answers
42 views

How do I modify an existing user's permissions without downtime on MySQL/MariaDB

We have an existing database user in our MariaDB 10.3 instance. We'd like to grant the user a couple of extra permissions, without any interruption to service. I understand from the helpful answer ...
1
vote
1answer
470 views

MySQL (aka MariaDB) Service Won't Start After Upgrading from MySQL 5.6 to MariaDB 10 On Centos 6

I could use some help figuring out why upgrading from MySQL 5.6 to MariaDB 10 On Centos 6 is proving so difficult. Below are the steps I am using followed by the error cat /etc/centos-release ...
0
votes
0answers
89 views

mariaDB < DATA DIRECTORY > option can't create table in directory outside tmp-folder

I'm using: MariaDB 10.4.6 Debian GNU/Linux 9 (stretch) Kernel: Linux 4.9.0-9-amd64 I just started learning about databases. One major point was to have the actual data of the tables on a separate ...
2
votes
0answers
107 views

MariaDB upgrade fails with “Specified key was too long; max key length is 1000 bytes”

I'm trying to upgrade MariaDB 10.2 to 10.4 and it goes smooth up to phase 4/7: Phase 4/7: Running 'mysql_fix_privilege_tables' ERROR 1071 (42000) at line 437: Specified key was too long; max key ...
3
votes
1answer
196 views

MariaDB on docker keeps corrupting data

I'm using the official MariaDB mariadb:10.4.6-bionic image and I have a problem: my tables corrupt themselves. This had happened at least four times this month: on two different dev machines using ...
0
votes
1answer
315 views

MariaDB won't start after fresh install. No errors, no logs

I just installed MariaDB from the debian repo and I can't start it. root@Debian9A1:~$ mysql ERROR 2002 (HY000): Can't connect to local MySQL server through socket'/var/run/mysqld/mysqld.sock' (2) I ...
0
votes
0answers
308 views

Galera throws “WSREP has not yet prepared …” error but nodes are working

Yesterday we moved from 2 node Galera to 4 node Galera with a brand new infrastructure. But after we move the database, Galera started throwing "WSREP has not yet prepared node for application use" ...