Questions tagged [mariadb]

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

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

How i can install mariadb odbc connector on Ubuntu 20.04

How i can install mariadb odbc connector from sources https://github.com/mariadb-corporation/mariadb-connector-odbc? i tryed install by using this https://blog.sleeplessbeastie.eu/2018/01/08/how-to-...
0
votes
1answer
65 views

Change password length for MariaDB

I'm currently working with mariadb and phpmyadmin on my debian 10 server. For some reason mariadb only allows passwords with a maximum length of 79 characters. If I specify a password that is longer ...
0
votes
2answers
77 views

Why the length of tinyint seems to make no difference?

I've been searching for what the length in the tinyint declaration means (e.g. tinyint(5)). And the answers seem to be that it should just be a rule for how MySQL displays the data. But in my case ...
-2
votes
0answers
10 views

web report for Mariadb

i hope everyone having a great weekend so i have a mariadb (voip system) to be accurate and i want to make a report from this database so i started to learn html, css and sql to make the front end ...
0
votes
1answer
53 views

Fixing crashed MariaDB databases on a cPanel server

I have a small cPanel server which I use for my clients' projects and my own personal projects. This is also shared among a few of my friends who chime in to keep the disks spinning. Recently I've ...
0
votes
0answers
34 views

How does one go about using master to master replication along with something like rsync to keep two identical copies of an application identical?

I have servers that do things for me at home, for instance they keep copies of my bookmarks in the way that del.icio.us used to (nextCloud) and keep copies of my code (gitea). Initially I thought that ...
0
votes
1answer
60 views

MariaDB chokes on lock file after forced docker restart

I have a docker compose setup for running Nextcloud alongside a MariaDB container and a reverse proxy etc. Recently, I had to force a manual restart of the docker daemon because some containers were ...
0
votes
0answers
20 views

Mariadb failover VIP- check the host behind

During MariaDB failover our VIP didn't reflect the host change in UI which caused issues. Is there a way/command to check if the VIP got assigned new master host properly by any command? So that we ...
0
votes
0answers
27 views

MariaDB Galera needs openssl 1.0.0 on RHEL 8

I have a RHEL 8.3 installation. It comes with openssl.x86_64 1:1.1.1g-11.el8. However the MariaDB 10.5.7 Galera needs libssl and libcrypto 1.0.0. ldd libgalera_smm.so ldd: warning: you do not have ...
2
votes
1answer
38 views

MariaDB 10.2.35 Memory Spikes

On an AWS EC2 T3.large instance I'm hosting a website built with the Cake PHP framework. It utilises the MariaDB version 10.2.35. I'm having an issue whereby the memory for the server is spiking. When ...
0
votes
0answers
61 views

Database Restore ERROR 2013 (HY000) at line 68497: Lost connection to MySQL server during query mariadb

I have a Database of 150G - 300 Mio entries and i want to restore it (gz SQL Dump) on MariaDB 10.3 but the restore failed because the sql server gone away. I tried to raise max_allowed_packet to the ...
1
vote
0answers
20 views

Does high cpu load make apache reject incoming requests?

I am deploying a laravel app on a RHEL7.x server with apache as the underlyiing web server. Part of the functionality of the application is to accept http POST requests from other servers and save ...
1
vote
1answer
95 views

MaridaDB Error and Wont Start

I am unable to get MariaDB to start. systemctl status mariadb.service gives me this following: ● mariadb.service - MariaDB 10.3.25 database server Loaded: loaded (/lib/systemd/system/mariadb....
0
votes
1answer
24 views

Unable to change tmp_table_size and max_heap_table_size mariadb

I'm running MariaDB 10.1.47 and trying to set: tmp_table_size = 64M max_heap_table_size = 64M I've set it under both the [server] and [mysqld] sections of my.cnf I've tried setting it in bytes with: ...
0
votes
0answers
17 views

MariaDB binary logging and master-master replication

I am trying to set up MariaDB master-master replication on a Debian server. Server version: 10.3.25-MariaDB-0+deb10u1 Debian 10. I have read many tutorials and all of them says it´s necessary to edit ...
0
votes
0answers
40 views

cant create a DB with Ansible

I have installed MariaDB 10.4 on a CentOS 7 box. The box has MariaDB running and it does not have a root password on the DB. It is only allows local logins. I keep getting the error message below. ...
0
votes
0answers
14 views

MariaDB Monitor does not switch between servers because of null GTID

I am currently working on creating a database cluster with 2 servers running CentOS 8, they are running mariadb 10 with MaxScale 2.5.4 running MariaDB monitors on both servers. The servers both up and ...
0
votes
1answer
72 views

Mixing Galera and MariaDB/MySQL replication

reading about it online, it appears we can use both Galera replication and native MariaDB/MySQL replication together. Can anyone confirm that this is correct? I'm thinking of a scenario where Data ...
1
vote
0answers
21 views

What steps should I take to make sure Mariadb master is unreachable?

In case of mariadb master is unreachable, what are the checks to make sure my master is really unreachable before going for failover. We use CNAME to connect to master host. So what are the network ...
0
votes
1answer
37 views

Apt update fails with bionic release no longer has a release file (Mariadb)

Tried to update the apt cache with sudo apt update and it failed with: The repository 'http://mirror1.imageworld.fi/pub/mariadb/repo/10.4/ubuntu bionic Release' no longer has a Release file ...
0
votes
1answer
27 views

Is there “another” way of getting log information on SFTP activity?

I'm administrating a debian server since last week. It used to have another administrator. I presume it's been hacked: files might have been read via SFTP to obtain information about a site that's ...
1
vote
1answer
52 views

Mariadb High Disk Write

I recently set up an docker application stack (Mail server) containing MariaDB as a database. Furthermore I noticed high (I guess?) IO write rates to my disks: (It goes up to like 40M/s) Total DISK ...
0
votes
2answers
56 views

MySQL/MariaDB database migration to server

I want to migrate a MySQL/MariaDB database from my local box, where I use it for development, to the server that will actually use it in "production". I'm totally new, so please bear with me....
0
votes
1answer
23 views

CentOS 8 syslog entrys for xrdp & mariadb

I recently took a look into my syslog /var/log/messages and noticed two repeating entries that I don't understand: The log is full (and I mean full) of: xrdp[959]: [INFO ] Socket 12: AF_INET ...
1
vote
1answer
66 views

Mysql 8.0 vs Mariadb 10.4 for low memory VPS

I have a vps with just 2Gb of memory and plan to just run wordpress on it and was wondering which is the best choice (Mysql 8.0 or Mariadb 10.4)?
0
votes
1answer
41 views

SELinux Permissions Error on Fedora 32

I am getting this error repeatedly while trying to run Nextcloud on Fedora 32 type=AVC msg=audit(1601229230.944:718): avc: denied { connectto } for pid=584 comm="php-fpm" path="/var/...
0
votes
1answer
41 views

Unable to start mysql server on linux Debian 9

I have tried a hundred of commands to fix this but to no avail. I get this error when I try to run mysql service: root@lander:/# systemctl status mariadb.service ● mariadb.service - MariaDB 10.1.45 ...
1
vote
0answers
158 views

ERROR 1006 (HY000): Can't create database 'webdata' (errno: 2 “No such file or directory”)

On Debian 10, I'm logging into MariaDB with sudo mysql -u root -p Then trying to create a DB create database webdata; ERROR 1006 (HY000): Can't create database 'webdata' (errno: 2 "No such file ...
0
votes
0answers
62 views

Why is my mariadb server reachable from the outside?

I understand that binding mariadb to localhost makes it reachable only from/via localhost: https://mariadb.com/kb/en/configuring-mariadb-for-remote-client-access/ % sudo rgrep bind-address . ./mariadb....
2
votes
1answer
63 views

How to properly backup and restore mariadb master/slave

I've got a master/slave mariadb setup using gtid. As far as I've read I should prefer using the slave side for backups. But what's in case of a desaster? Can I restore the slave in the new master? And ...
0
votes
2answers
70 views

Best practice on where to store my.cnf configuration with MariaDB

After a small update ran by an Ansible playbook from MariaDB 10.5.4 to MariaDB 10.5.5, the custom configuration file got silently overriden by the default configuration causing the server to refuse ...
1
vote
2answers
40 views

Running MariaDB server 5.5 and sharing my.cnf on multiple diskless nodes

I'm attempting to install MariaDB Server 5.5 in a diskless image using Redhat Enterprise 7.8. The problem I am running into is having a single diskless image with a single /etc/my.cnf being deployed ...
0
votes
0answers
85 views

Mariadb On Amazon Linux 2 Benchmarking

I am migrating Mariadb to Amazon Linux 2 from Amazon Linux 2012 . I have run benchmark test (OLTP_READ_WRite lua) using Sysbench for multiple threads & unlimited TPS. What are other typical tests ...
0
votes
0answers
29 views

error during DB sync of nova in openstack

While populating database in nova installation im getting this error. pymysql.err.InternalError: (1050, "Table 'instances' already exists") We are using MariaDB 10.5.5 but still this issue ...
0
votes
0answers
23 views

migrating mysql rhel6 to mariadb rhel 8

I have 3 servers running MySQL on RHEL6. I need to replace the servers with one's running MariaDB on RHEL8. I know 2 of them are in master/slave configuration. I have been studying this but I still ...
0
votes
1answer
218 views

MariaDB won't start after upgrade to 10.2 on Centos 7

I am new to Linux. I upgraded MariaDB to version 10.2.33 today and the service refuses to start: mariadb.service - MariaDB 10.2.33 database server Loaded: loaded (/usr/lib/systemd/system/mariadb....
2
votes
0answers
29 views

MariaDB table has a metadata lock, but no blocking thread

I have a MariaDB 15.1 installed on a Debian system: $ mariadb --version mariadb Ver 15.1 Distrib 10.4.14-MariaDB, for debian-linux-gnu (x86_64) using readline 5.2 A script regularly loads data into ...
0
votes
0answers
13 views

MySQLWorkbench not connecting but Sequel is

I have the exact same connection settings in both programs but Workbench will not connect to my database. I am connecting via SSH on a custom post so I selected Standard TCP/IP over SSH and entered my ...
1
vote
0answers
27 views

MariaDB/MySQL DB tracking another database

If I want to have two servers with one active and one hot standby (and each has it's own database on them), how do I get the secondary to track the primary and be quick/easy to deploy if the main ...
5
votes
3answers
242 views

High availability MariaDB only two servers

I'm not worried about split brain since the connection between the two servers is solid (and because I don't have a third machine) I want to have some MariaDB replication with automatic failover so ...
1
vote
2answers
72 views

MariaDB and PHP-FPM high cpu load

we have a dedicated server running only 1 domain (Wordpress) with 500 users per minute and have very often timeouts. Server Specs: Intel(R) Xeon(R) CPU E5-1650 v3 @ 3.50GHz (12 core(s)) 64GB RAM 2 x ...
1
vote
1answer
35 views

MYSQL my.cnf advice needed

I have a dedicated server Linux Cenots 6 with 16GB RAM - Apache + Nginx MYSQL 5.6 please can someone let me know if my etc/my.cnf MYSQL configuration is ok or can it be improved I am getting ...
0
votes
0answers
32 views

How to actually set up MariaDB replication/high availability

I'm setting up a high availability LAMP stack - so far, I have two servers with HAProxy running on both their frontends that own a floating IP. HAProxy redirects requests to backend Apache servers ...
0
votes
1answer
246 views

(Warning) IP address 'XXX.XXX.XX.XXX' could not be resolved: Name or service not known

I Use Mariadb-10.3 at 127.0.0.1:3310. The sites are working correctly, everything is fine. But I noticed these connections in the logs: 200812 21:16:31 [Warning] IP address '195.54.167.225' could not ...
0
votes
1answer
20 views

Use case for mysql users depending on host

What is the use case for having different passwords for the same username but different hosts on mariadb/mysql? Is there a way to synchronized the password for the same username for different hosts?
0
votes
1answer
20 views

MySQL Connecting with Blank User Name & Password

I'm having serious trouble for the last few days, please have empathy with my question. After a series of server crashes and hackings, today I've found out that my mysql can be connected via a web ...
0
votes
1answer
150 views

MariaDB failed at step namespace spawning /bin/sh: read-only file system

Recently my MariaDB stopped working and when I tried to start it, it always throws an error. The error message is: MariaDB failed at step namespace spawning /bin/sh: read-only file system What does ...
0
votes
1answer
37 views

NginX and Galera Cluster are friends?

So I've found NginX's official tutorial, how to use NginX Plus as the proxy for the MariaDB Cluster. However, if I do this with my standard NginX (not the Plus edition) I constantly get the error ...
0
votes
0answers
15 views

MariaDB install failling on Debian 10 based VM

Trying to simply install MariaDB server on Azure Debian 10 VM host However it fails during the process I had tried few different ways but it seems to get stuck somewhere in the half way The last i ...
0
votes
0answers
59 views

Mariadb build error on amazon linux 2 - auth_gssapi error

While building mariadb in Amazon linux 2 from a code repo (its not sudo yum install from mariadb external source), I am getting this error as below. Looks like the authentication setup/parameter/code ...

1
2 3 4 5
14