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
1answer
15 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
46 views

Mariadb 1000% CPU [on hold]

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
0answers
9 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 ...
0
votes
0answers
17 views

phpMyAdmin - forbids updating field with the strings “|powershell” or “|PHP”

Running this query on my 10.1.34 MariaDB database works fine from the command line: UPDATE `allbooks` SET `longDesc` = '|PHP: Hello World\r\n|Powershell: Hello World\r\n' WHERE `bookId`.`id` = 1001; ...
0
votes
0answers
15 views

Mysqlpump on MariaDB (parallel backup)

I've recently read about the tool mysqlpump and wanted to make use of it's parallel processing feature. I'm currently running Mariadb-server 10.1 on Debian 9. But https://mariadb.com/kb/en/library/...
1
vote
0answers
28 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
12 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
20 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
29 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 / ...
1
vote
0answers
20 views

innodb_buffer_pool_size, optimize and mysqltunner [migrated]

I'm trying to understand how to properly size innodb_buffer_pool_size and when to optimize my tables. Questions are: When sizing the innodb_buffer_pool_size, should I take into account the size of ...
0
votes
2answers
263 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
64 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
67 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
31 views

Error with galera load balancer port

I have two machines VNDMARIADB01 172.22.126.21 VNDMARIADB02 172.22.126.22 I have configured a Galera cluster in the first machine and Mariadb (in port 3307), both machines have a mariadb node ...
0
votes
0answers
12 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
14 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 ...
0
votes
0answers
131 views

Access denied; you need (at least one of) the SUPER privilege(s) for this operation - Strange issue with MariaDB instance on shared server

I have local instances of MySQL 8.0.12 and MariaDB 10.1.31. Both have a database "ExampleDB" when I execute the script below there is no issue: CREATE ALGORITHM=UNDEFINED DEFINER=`root`@`localhost` ...
2
votes
1answer
51 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
42 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# ...
0
votes
0answers
107 views

Galera cluster fails to start on MariaDB 10.3 and Ubuntu 18.04

I've installed and setup several Galera clusters on our factory servers, however after upgrading to Ubuntu 18.04 and MariaDB 10.3, I'm unable to get a new cluster to bootstrap. I'm following the ...
1
vote
3answers
82 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
92 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
0answers
19 views

MariaDB table varbinary column not lined up correctly

I have a strange issue with my MariaDB table. I am using varbinary(16) to store IP addresses (IPv4 and IPv6). The row is inserted ok, but when I SELECT rows, the ip column seems to be skewed. Example: ...
0
votes
0answers
77 views

Failed to start MariaDB on centos 7

I got this error after rebooting the server mariadb-prepare-db-dir[1551]: Database MariaDB is probably initialized in /var/lib/mysql already, nothing is done. mysqld_safe[1581]: 181011 04:04:18 ...
0
votes
1answer
45 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
46 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
20 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
53 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
46 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
52 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
24 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 ...
0
votes
0answers
62 views

Why is Percona CPU load so high compared to MySQL and MariaDB?

I compared Percona CPU load (left on screenshot) to Oracle MySQL (same almost default config, same DB, load, etc.) Percona vs. MySQL CPU load Tested on all my servers running Debian and Ubuntu. ...
1
vote
1answer
106 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
18 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
46 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
58 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
51 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
59 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
202 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
404 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
22 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
0answers
30 views

xtrabackup unpacks database backup too slowly

XtraBackup unpacks database backup too slowly (I can't wait when it's done) System: Debian 9, MariaDB 10.1.23 On Debian 8 with the same MariaDB 10.1.23 it works perfect (some minutes) When it try ...
0
votes
1answer
84 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
402 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
150 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
227 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 ...
0
votes
1answer
58 views

Centos 7 / MariaDB, 1gig DigitalOcean Droplet high traffic kills MySQL [duplicate]

I have a Centos 7 / MariaDB, 1gig DigitalOcean Droplet with 2 low traffic Wordpress sites on. When the server gets approx 15 concurrent users MySQL runs out of memory and drops. Log below: 180806 14:...
0
votes
1answer
125 views

systemd trying to start MariaDB twice (mariadb@multi-user.service vs mariadb.service)

systemd on my system seems to be trying to start MariaDB twice. This first try succeeds, so my system has no real problems, but the second try creates spurious error messages since all the relevant ...
0
votes
0answers
50 views

mariadb 10.3.7 gcache page files not deleted

env: 3 node ubuntu cluster : galera cluster but it is not deleting any of those files. 2018-07-31 22:52:28 16 [Note] The slave is applying a ROW event on behalf of an UPDATE statement on table ...
0
votes
1answer
515 views

MariaDB doesn't start after upgrade from MySQL 5.7

I installed MariaDB server, my MySQL got removed automatically and I tried to get it running using sudo service mysql start, which caused the following error message: Job for mariadb.service ...