Questions tagged [mariadb]
MariaDB is an open source database server that offers drop-in replacement functionality for MySQL.
21
questions
1
vote
1answer
47 views
Magento 2: What is causing slow reindexing of catalogsearch_fulltext with large catalog?
We have 400k line items, so I expect things to take a little while, but reindexing has started taking days, and often errors out in the middle. Checking in the database processlist, it looks to be ...
0
votes
2answers
40 views
elasticsearch and mariadb services stop sometimes. They get up automatically in a few minutes or I do it manually but I need a permanent solution
I don't know if it's a problem with my magento(magento 2.4.1) or with my server
I found this errors in log file:
1-main.CRITICAL: Lo sentimos, algo salió mal. Encontrarás más información en el ...
0
votes
0answers
52 views
MariaDB crashing every few days
I'm using Magento2 with MariaDB 10.3.27 on Debian 10.8 and i'm experiencing MariaDB crash every few days. I have no idea what can cause those unexpected crashes. I'm sending my config and crash logs. ...
0
votes
0answers
33 views
How to use Magento 2 with MariaDB Data-at-Rest Encryption for HIPAA compliance
As one of the requirements for HIPAA compliance is to store all Protected Health Information (PHI) encrypted at rest, and since customers, quotes, orders will be considered as PHI, I thought that ...
0
votes
0answers
11 views
Magento 2.4.1: how to a separate and reuse a large database for products and categories from M2.4 shop db
any idea of how can I have products and categories in M 2.4.1 community in a separate database from the actual shop and reuse products and categories in for a new M 2.4? The database I need to share ...
0
votes
0answers
73 views
Connecting Maria db 10.2 to magento 2.3.5
I have website to connected database
I am using RDS MARIAB 10.2
while running upgrade command faced :
SQLSTATE[HY000]: General error: 1419 You do not have the SUPER privilege and binary logging is ...
0
votes
0answers
44 views
RDS parameter group for Magento
I am running Magento 1.9.3.8 on EC2, database running MariaDB 10.1.34 on separate AWS - RDS instance which is db.r5.xlarge
vCPU: 4
RAM: 32 GB
I have defined various MYSQL variables under custom RDS ...
0
votes
1answer
270 views
MariaDB or MySQL Magento 2.4 “magento community edition open source”
We are in the process of planning for an eCommerce project with Magento 2.4 "magento community edition open source" for building up the e-commerce project.
But we are really confused with ...
1
vote
1answer
594 views
Magento 2.4.0 Issues using docker with MariaDB
Has anyone else encountered this error?
I am using docker-compose.yml file with mariadb:10 image.
Schema creation/updates:
Current version of RDBMS is not supported. Used Version: 10.5.5-MariaDB-1:10....
4
votes
3answers
3k views
Compatible MariDB version for Magento 2.4
We are upgrading from magento 2.3 to 2.4. Would like to know the compatible MariaDB version to be used for the upgraded magento version. As per official magento site, it mentions MySQL8.0 for on ...
1
vote
3answers
185 views
Magento 2.3.x Admin Panel keeps loading
I have installed Magento 2.3.5-p1 and also tried 2.3.4-p2 on Centos 7, with Nginx & PHP-FPM, maria DB with following commands.
1. /var/www/magento < owner by MAGENTO:NGINX user (I have created ...
1
vote
3answers
119 views
Installation Problem Magento 2.3.5p1 on Centos 7
I have been trying to install Magento on Centos 7 with Nginx and Maria Db for the past 2-3 days now but each time I got errors. I have tried several ways and changed Nginx configuration file and tried ...
0
votes
1answer
35 views
What is the most popular database choice for Magento 2?
this question sounds more like a poll because I'm just curious as to what database is the most commonly used for Magento2. I currently use MariaDB 10 from following an installation tutorial online, ...
0
votes
1answer
29 views
Error when adding a user
When I try to create a user, I get this error:
"Rolled back transaction has not been completed correctly."
In system log I get:
main.INFO: Broken reference: the 'notification.messages' tries to ...
1
vote
1answer
268 views
how to switch between mariadb and mysql
my magento2 is reading mariadb server and database is connected to that, I am trying o use mysql instead but I had no luck, it does not recognize the database at all although I have added the ...
1
vote
0answers
556 views
my.cnf MySQL optimize for 2G RAM Magento 1.9
I'm find my.cnf optimized for 2G RAM. It's good configuration for 2G RAM and magento 1.9 and 5.5.56-MariaDB? Server VPS CentOS 7.5 on SSD.
In this case i have about 30 domains in 1 multidomain ...
1
vote
0answers
60 views
Are high AUTO_INCREMENT values in cron_schedule values are problem?
I am debugging a checkout problem, where the shipping address is not saved. This can be reproduced only some times and on production, under unclear circumstances.
Checking the logs I found
...
1
vote
0answers
37 views
import csv in mariadb
We import csv files in mariadb, 1 csv takes about 30 minutes. For daily sync of csv files thats about 3-4 hours and judge that as too much.
Magento 2.3, Update on save is activated + Mysql tuner ...
1
vote
0answers
167 views
Magento upgrade from 2.2.3 to 2.3.0 just blew Cheeze balls .. help
just finshed updating composer update,
bin/magento setup:upgrade
Cache cleared successfully
File system cleanup:
/home/pricesplitters/public_html/generated/code/Composer
/home/pricesplitters/...
2
votes
0answers
120 views
NGINX 404 error despite Magento Installation complete on CentOS 7 terminal
I am trying to load the /admin part of my development build of the website. I am unsure what could be the cause of this.
Using this command: (Some of these details are intentionally not in line with ...
1
vote
1answer
633 views
<magento_instance>/graphql not working on windows but works on linux machine
Officially Magento2.3 supports only these operating systems
Linux distributions, such as RedHat Enterprise Linux (RHEL), CentOS,
Ubuntu, Debian, and similar.
This is my configuration
Installed ...
