Stack Exchange Network

Stack Exchange network consists of 174 Q&A communities including Stack Overflow, the largest, most trusted online community for developers to learn, share their knowledge, and build their careers.

Visit Stack Exchange

Questions tagged [mariadb]

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

0
votes
0answers
8 views

Mariadb TLS does not enable

I am trying to enable MariaDB (10.3.12) tls with certificates but it stays Disabled. I am working under centos7. I have tried this with ubuntu 18.04 and mysql and it worked, so I wonder what is wrong ...
0
votes
1answer
26 views

Why does nextcloud in a docker container not see my none docker mariadb

I have searched for this question on the internet, but found only topics the other way around. (connecting to a mariadb in a docker container). I'm in the process of installing nextcloud in ...
1
vote
0answers
16 views

mariaDB uses the wrong disk

I am using mariaDB version 10.2 - innodb, with a boot and ssd drive. the boot drive is only for root, all the data is configured to be on the ssd and mysql dir is mounted on to is. when writing I see ...
3
votes
1answer
38 views

After mariaDB 10.0 to 10.1 upgrade, mysql can no longer write tmpdir

I ordered a new server that came with mariaDB 10.0 installed. I edited /etc/my.cnf to change the tmpdir to /home/mysql_tmp_dir (owned by mysql:mysql). All worked fine. Did upgrade to mariaDB 10.1.37 ...
1
vote
1answer
58 views

MariaDB MySQL shows have_ssl disabled when certs are installled

Trying to enabled SSL on my mariadb-server. I have followed the official mariadb docs to generate a ca-key ca-cert server-key server-cert. My machine is a debian 9 kvm vps with mariadb 10.1.37 When I ...
0
votes
1answer
25 views

Webserver error 503 Troubleshooting

I have a nice VPS with 4 cores, 180ssd, 8gb of ram. My website is a custom website, that autogenerates from a database, and on the first run it is cached in memory using redis. The issue that I am ...
1
vote
0answers
14 views

MariaDB 10.2 crash on innodb table corruption

I'm running MariaDB 10.2 on Windows and had some hard drive corruption on my server that messed up some innodb tables. Unfortunately this also affected backups, so I'm trying to dump the tables and ...
0
votes
1answer
19 views

MariaDB replication and cross database queries

I need to improve backup of databases that won't load production server. I read that good solution to do that is to set database replication and do mysqldumps on slave server. But description of "...
0
votes
0answers
28 views

Azure Database for MariaDB and log_bin_trust_function_creators

I am trying to create a function on Azure Database for MariaDB like below: CREATE FUNCTION hello (s CHAR(20)) RETURNS CHAR(50) DETERMINISTIC RETURN CONCAT('Hello, ',s,'!'); but I am getting the ...
0
votes
0answers
18 views

How to restore MariaDB Databases from files

After the whole server went FUBAR I managed to retrieve website files (php,html and such) and the DBs. Now I have these files: aria_log.00000001 aria_log_control ib_buffer_pool ib_logfile0 ...
0
votes
1answer
73 views

PHP 5.6 with Debian 9 -> mysql connection

I created an debian 9 machine with ISPConfig - standard stuff (after this tut: https://www.howtoforge.com/tutorial/perfect-server-debian-9-stretch-apache-bind-dovecot-ispconfig-3-1/ ). Comes with PHP ...
1
vote
0answers
24 views

Maria DB slow query log not writing anything

For some reason, the Maria DB (version 10.1) slow query log is not writing anything. I've enabled slow query logging: select @@slow_query_log, @@slow_query_log_file, @@long_query_time, @@log_output; ...
0
votes
0answers
15 views

Cannot enable innodb_read_only on slave

I am trying to make a MariaDB slave instance read only. From what I understand, read_only option is not truly readonly as users with super privilege can still write to the database. super_read_only ...
0
votes
1answer
51 views

MariaDB automatically shuts down every 30 minutes

MariaDB service automatically shuts down after 30 minutes. It's a VPS, 12 vCPU, 12 GB RAM. CentOS 7, Webmin, Virtualmin, 5.5.60-MariaDB, PHP 7.2, Apache 2. No errors in log, CPU load average 10%. ...
0
votes
1answer
30 views

How to setup a PHP API to work over HTTPS?

I use a simple API with PHP to get some values in JSON format, it is working fine in web browser over HTTP. I enabled SSL in mariadb with the certificates, but when I try my API using HTTPS, it says ...
2
votes
1answer
125 views

Mariadb 1000% CPU [closed]

I have a big problem with my site (Laravel based), I have from 1000 to 1500 contemporary visitors, and I have a problem with mariadb, practically when people use filters, and other options that ...
0
votes
1answer
65 views

mariadb 10.2 is not available in rhel 7 repo

I tried to install mariadb 10.2 using default red hat 7 repository. but as it seems there only available upto mariadb 10.1. when I googled, lot of articles were there and all are saying "in order to ...
1
vote
1answer
67 views

MySQL not allowing remote connections using Python3 mysql.connector on Raspbian-Stretch

I am trying to allow connections using mysql.connector from a specific machine to a MariaDB server, within the local network. Ideally, I would like to create an account limited to a single IP and DB. ...
1
vote
0answers
44 views

mariadb-libs is needed by turnserver

I am trying to install TURN server on centOS7 for one of my webrtc application. This TURN server would be used in a video calling application. I had followed below steps: yum install -y make gcc cc ...
0
votes
0answers
27 views

MySQL/MariaDB What is Prepare On Slow Log?

I am using MariaDB 10.* on AWS RDS along with replica for read-only. I have enabled slow query and I notice there is a query that takes a lot of time. The sql_text is Prepare like the image below. ...
1
vote
0answers
106 views

Converting Mariadb Galera Cluster into Simple Master Slave Replication Cluster

Now we have this project to convert our Mariadb Galera Cluster (3 nodes) to Simple Master Slave cluster (One master and two slaves). So our goal to get rid of Galera and make our setup just async / ...
0
votes
2answers
287 views

MySQL cli does not remember history of some commands

I use linux OS with mysql database. mysql CLI doesn't log some commands in ~/.mysql_history . For example can not log create user. How can force cli to store all commands in mysql_history ? How can ...
1
vote
0answers
84 views

What is a “normal” latency/performance of inserts on mariadb or mysql?

Hadn't used MySQL family for years. Now need to move from OracleDB to either MariaDB or PostgreSQL. So on a similar "hardware" (Openstack VM: RHEL 7.3, 4HT cores of 2.5GHz Xeon E312xx, "local" SAN &...
1
vote
1answer
81 views

Why is no root pass needed to access MariaDB after upgrade to Ubuntu 16.04?

I've recently upgraded a system from Ubuntu 14.04 to 16.04 (mysql Ver 15.1 Distrib 10.0.36-MariaDB) and noticed root can get in without a password eg:mysql -u root is empty. Tried setting a new ...
0
votes
0answers
14 views

Diagnose permission error in MariaDB

I am running a MariaDB server in docker using the official 10.1 docker container. Sometimes things break down and the users that are supposed to be there can't log in. I have backed up the data ...
0
votes
0answers
22 views

Recovering MariaDB with broken permissions

I am trying to build a MariaDB Galera cluster. But sometimes when I restart a node, it does seem to start fine, but it does not accept any connections. All attempts end with ERROR 1045 (28000): Access ...
2
votes
1answer
58 views

What is the maximum number of words allowed in a MariaDB InnoDB Full Text Search query

I recieved this error when performing a search with 746 words (it wasn't intentional someone pasted text into the wrong box). HA_ERR_FTS_TOO_MANY_WORDS_IN_PHRASE: Too many words in a FTS phrase or ...
0
votes
0answers
47 views

Can Mysql read content under [mariadb] group?

I migarated from Mariadb to Mysql. As some setting are not compatible,I put those incompatible setting under [mariadb] of /etc/my.cnf. For example, [mysqld] myisam_recover_options=FORCE,BACKUP# ...
1
vote
3answers
147 views

MySQL Service Stop although Restart=Always

I've an Amazon t2.small EC2 - 1 Core and 2GB RAM it's more than the minimum requirements for CentOS and Virtualmin My System: CentOS 7.5.1804 Virtualmin MySQL 5.5.60-MariaDB Apache 2.4.6 The ...
0
votes
2answers
379 views

CentOS 7 Can't Uninstall MariaDB-Server : Error Comes Up

I am trying to uninstall mariadb-server on Centos 7 and reinstall it, something went totally wrong with it and the server wouldn't respond. This actually happened on another server recently but on ...
0
votes
1answer
50 views

MariaDB cluster fails to create root user on second node

When I try to create a two node MariaDB cluster in Docker on Windows, I get this error: ERROR 1396 (HY000) at line 8: Operation CREATE USER failed for 'root'@'%' For the first node I run this ...
1
vote
0answers
148 views

MariaDB Cluster is having timeout issue between nodes

I'm having some hard time diagnosing MariaDB Cluster issue that I would like to have some advices. We're running a 3-nodes MariaDB Cluster, each node is on a dedicated ESXi server, and connected by ...
0
votes
1answer
22 views

Temporarily operate on different MySQL/MariaDB data directory without restarting service?

I know that MySQL/MariaDB can be configured at the system level to use a custom path rather than /var/lib/mysql. This requires restarting the service. Is there any way to just run a one-off sql ...
-3
votes
1answer
61 views

Is OK to delete the MySQL database files directly on the server?

So, I need to free up some space on our database server. On investigation it looks like lots of space is being taken up by MariaDB/MySQL databases that are no longer used (snapshots and defunct ...
-1
votes
1answer
82 views

Can't start mysql after installing mariadb

I have just installed mariadb but when I do sudo mysql the I get this error: ERROR 1524 (HY000): Plugin 'auth_socket' is not loaded. i have looked online for fixes but I cannot find any that actually ...
1
vote
0answers
117 views

How to reinstall MariaDB?

I had MariaDB 10.2 installed on Ubuntu 16.04. and I was using MariaDB encryption. I had to uninstall MariaDB so I have uninstalled with following command: apt purge mariadb-server -y That ...
0
votes
0answers
27 views

Getting an error message on while installing any packages in Ubuntu 18.04

While trying to install any packages/apt in my ubuntu terminal after installing showing some error messages. for example, I'm trying to install zip sudo apt-get install zip after execution above ...
1
vote
1answer
147 views

MySQL server (mariadb) auto shutdown without overload

With old configs, my VPS (1 CPU, 1 GB RAM, 1 GB swap) works normally for almost 2 years. I didn't change anything from beginning. But I have this issue several days ago, MySQL server automatically ...
0
votes
1answer
24 views

2002 Code Error When Trying Import / Export MariaDB Databases in Bitnami's WordPress Multi-tier Stack

I'm trying to do database management via SSH for Bitnami's WordPress Multi-tier Stack/ Specifically I want to export and do an initial import (though I will probably just create a new database). When ...
0
votes
1answer
52 views

Apache queries mariadb database -> how to log queries?

I got a apache2 vhost-configuration with BasicAuth. With the AuthDBDUserPWQery directive I'm checking a mariadb in the background, if the user-pw-combination exists. For troubleshooting I want to see ...
2
votes
1answer
73 views

Where to download MariaDB 10.3 over IPv6?

CentOS 7 server with only IPv6. When I try to use, [mariadb] name = MariaDB baseurl = http://yum.mariadb.org/10.3/centos7-amd64 gpgkey=https://yum.mariadb.org/RPM-GPG-KEY-MariaDB gpgcheck=1 It ...
0
votes
2answers
66 views

Safe way to manage MySQL on production server

I have production server running on Debian 9. I would like to ask you what is safe way to manage MySQL/MariaDB server (on production server). MySQL/MariaDB server listens only on localhost, because I ...
0
votes
1answer
116 views

MariaDB - import raw InnoDB frm/ibd files?

Good afternoon. My Debian 9 server ran into an issue that rendered the OS inaccessible , I managed to extract all the raw database files (/var/lib/mysql) for my project but unfortunately the engine ...
1
vote
1answer
265 views

systemd not shutting down MariaDB properly?

We are running a LAMP stack on CentOS 7. We have SCL enabled but only PHP and Apache are using it. We were not able to get MariaDB to successfully cutover on a test machine so we never attempted a ...
1
vote
2answers
697 views

MariaDB 10.3 CPU usage, Server performance suggestions

my platform: 8 cores, CPU benchmark > 10k (Intel(R) Xeon(R) CPU E5-1620 v2 @ 3.70GHz) 32GB of RAM 2x 7200 SATA enterprise HDD, 128MB cache, each of them have physical 512b block size Actual file ...
0
votes
1answer
34 views

selinux context for multiple databases

I have a directory /media/databases under which I want to hold 3 different databases : mariadb, postgresql and neo4j. My issue is that I already have configured postgresql selinux context and the ...
0
votes
1answer
137 views

Enable file key plugin of MariaDB on CentOS 7.5

I'm trying to enable the file_key_management on MariaDB. I'm working on CentOS 7.5 and MariaDB 15.1. Here is the centos-release: CentOS Linux release 7.5.1804 (Core) And the MariaDB version: ...
0
votes
0answers
411 views

Debian 9.5 with MariaDB 10.1.26. Can't write into outfile in a directory if it's in /home/, works fine if it's in /var/. Dirs chowned for mysql:mysql

I'm running MariaDB on Debian 9.5. I've done the following in the Debian shell: mkdir /home/db_out_test chown mysql:mysql /home/db_out_test mkdir /var/db_out_test chown mysql:mysql /var/db_out_test ...
0
votes
2answers
321 views

mariadb service script doesn't create /var/run/mysqld

I have issues starting a MariaDB service on a Centos 7 server, because the directory /var/run/mysqld/ is not created by default, as well as the /var/log/mysqld.log file. Creating this directory and ...
1
vote
1answer
375 views

my.cnf MariaDB configuration - hitting the CPU ceiling even with the optimizations in place

I'm trying to get around this issue of mySQL hitting the ceiling in terms of CPU/Server load, as the server specs are as follows: List item 2 x 2.4GHz Octa-Core E5-2630 v3 Haswell Xeon 128GB RAM SSD ...