Open Questions
-
**Only if not connected to Internet** : Access denied for user '<user>'@'localhost' (using password: YES)
Hi - everything works fine *unless* I disconnect from Internet in which cas... -
Access denied for user 'admin'@'localhost'
Hello... I have installed MariaDB 10.3.13 in Centos 7... all worked well...... -
Adding DataFlex 3.1c .dat Files As An External Table Type With CONNECT
I'm using MariaDB's CONNECT engine to access / utilize a set of Visual FoxP... -
Async replication channel setup
Hello, We have two MariaDB clusters with 3 nodes each. Setup following asyn... -
Audit Log Plugin--Filtering & Old Values
Is it possible to use the built-in audit plugin to log only Create, Update/... -
Automatically wrapping queries with duplicate columns into CTEs or Derived Tables
The requirement is to automatically wrap existing queries with duplicate co... -
awr kind of report for MariaDB
Hi there Just wonder is there any AWR (Oracle) kind of report or script ava... -
AX 1.2 - PM cluster to protect disk / cpu failure
What is the preferred cluster for PM disk / cpu solution? -
Breaking changes per every new subversion?
Hello all, Given that MariaDB 10 -> 10.1 -> 10.2 -> 10.3 all require incre... -
breaking replication then resetting it
mariadb 5.5.60-MariaDB I have a LIVE DB in a database "bugtracker". that m... -
Can I create view on remote tables
Hi, I am migrating Oracle database to MariaDB. In Oracle views are created ... -
Can not load default MySQL library (libmysqlclient.so.18 or libmysqlclient.so)
Hi fellows I have a problem after changing from mysql to mariadb. This has ... -
Can the returned events-bitmask include only `MYSQL_WAIT_TIMEOUT` flag?
The status that is being returned by a non-blocking operation is a bitmask ... -
Can We configure replication between MariaDB 5.5.56 and MySQL 5.5.21?
Hi Team, We are having a development server with RHEL 5.11 and MySQL 5.5.21... -
cannot use collation with mysql_stmt_prepare
If I want to select with a case insensitive collation SELECT * FROM test WH... -
Character set changes depending upon privs
Not sure if this is a bug or feature but try this experiment. On a MariaDB-... -
Circular replication
I am creating a circular replication for Laravel application, for 6 islands... -
Cobol and Maria DB
Hi, Can I write a routine using C connector provided by Maria DB and call ... -
Column Store Cross-Engine join
The cross engine join documentation https://mariadb.com/kb/en/library/confi... -
Completely Unistall and then Reinstall Mariadb 10.3
Hello Members, I installed mariadb 10.3 on my Ubuntu 16.04 server, and then... -
CONNCET via ODBC: Logging connect-generated sql
Hello, I want to update an Oracle table via the connect storage engine. For... -
Connecting to MariaDB
Connection string to connect to MariaDB through .net c# application -
Connecting to MariaDB via OPC
I have a synology diskstation NAS running MariaDB. Further there is a Scada... -
Connection Timeout ignored (mariaDB java Client 1.5.3)?
Hi, The problem i'm experiencing is: {tomcat 8 connection pool , spring app... -
connector c++ connection pooling support
I saw that in connector/J of MariaDB enables directly connection pooling by... -
CP437 CharSet
I need to configure the character set of a schema as CP437. Unfortunately, ... -
Datafile storage location changing or defining in any CREATE situation
Hi, coming from ORACLE experiences i am used to define, where all the files... -
Delete partially and gradually a very large table (1 million records)
Hello, I would like to know, in your opinion what's the best way to create ... -
Derived Tables & Column Store
I have been having trouble with a stored procedure using derived tables joi... -
Disable Server Side Prepare Statements
Is it possible to disable server-side prepared statements in the ODBC conne... -
Does MySQL Enterprise Backup work with MariaDB?
We primarily support MySQL from Oracle. A business group needs an applicat... -
Enabling SSL in mariaDB running on Synology NAS
I am having problems with enabling SSL in MariaDB running on Synology NAS (... -
Encountering errors using MariaDB ODBC Driver 3.1.4 32-Bit
Hi: When I connect using the 3.1.4 driver, all datatypes come over only as ... -
ERROR 2002 (HY000): Can't Connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)
All, I am receiving the above and below error message out of nowhere and I ... -
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)
Hello, We have a MariaDB server that runs for a while and then stops with t... -
ERROR INSTALLING MARIADB 10.1.21 64/32 BIT ON WINDOW 8.1
HELLO, I JUST TRIED TO INSTALL MARIADB 10.1.21 64BITS ON WINDOWS 8.1 64bit ... -
ETL tool recommendations for MariaDB
Please suggest which tools are most suitable for extraction, transform and ... -
Excessive contexting running MariaDB CE Query
I'm working on a MariaDB vs. Oracle query performance issue. We have about... -
File Key Management encryption method
I have been using File Key Management encryption method to encrypt data at ... -
Find Queries with huge Result-Set
Hello, we are using MariaDB as DB for our CMS. Lately I noticed a massive g... -
Flush logs hangs
We have a 3-node Galera cluster running with Mariadb "Server version: 10.1.... -
FreeBSD with MariaDB
Hi! Where to find examples of mariadb(mysql) with wsrep replication. With a... -
Functional indexes
Any ways or plans to create/implement functional indexes like in MySQL 8.0?... -
Galera cluster evaluation
We want to evaluate Galera Cluster for Master/Master replication. We want t... -
Galera Cluster large differences in databases sizes on each server
I'm not sure if this is intended or not (seems unlikley but I'm still new a... -
Galera Cluster Recovery
Hi all, I faced the following problem. Give me away to resolve this problem... -
GTID Slave - Behavior
Hi, I have Master -> Slave Replication using GTID enabled. During staging ... -
ha_tokudb.cc:161
Hello guys! Im facing this errors on mysql.log when i restart my database. ... -
Hibernate
How hibernate can use Maria DB's with noSQL data(flexible columns, JSON)? -
How can I prevent record deletion in before delete trigger?
How can I prevent record deletion in before delete trigger? I tried signal ... -
How do I setup Mariadb GIS extension?
Hi I have mariadb (10.3.17) with Debian Buster working. How do I set up GIS... -
How execute an insert in a Trigger using table with Engine CONNECT?
Hello Guys I hope you are fine. I have a project, where I need to insert d... -
How to access binary log for Aria tables
The binary log contains a record of all changes to the databases. However, ... -
How to access test mariadb enterprise kubernetes maxscale endpoints externally
I re-installed the helm chart that creates a Mariadb Enterprise cluster wit... -
How to backup 250GB MariaDB database daily in Master-Slave scenario at table level
We have setup MariaDB master-slave in our production environment. We want t... -
How to build mariadb connector c for windows
The release of 2.3.1 have bug, the bug will fix on 2.3.2，so i download the ... -
how to change tmpdir in galera environment
please share procedure for changing location of tmpdir in galera environment 10.3 version -
How to configure MariaDB Configuration File
OS - Rhel 7 MariaDB version 10.3.9 High Availability - Galera Cluster No of... -
How to configure MariaDB configuration file in recommend way
Following are my environment ---------------------------------------------- OS : RHEL 7 Mar -
How to configure parameters for each database in one server machine?
We are trying to configure one my.cnf file for a different database on one ... -
How to count items for a specific ordernation
Hi everyone, This is my table: PACKAGE_ID | ITEM_ID 1 ... -
How to disable logs aria and logs binary.
I installed mariadb on a release of opensuse 13.2, I ask the most experts: ... -
How to get a spool file generated, along with the executed SQL script
We are migrating DB from Oracle to MariaDB. As part of schema objects insta... -
How to incorporate mariabackup full incrementals with binarylogs
So I'm going to be starting to use MariaDB. Was going to use mariabackup f... -
How to Install MARA DB TX 3.0
Hi I am new to MARIA DB and i want to try out MARIADB TX 3.0 for a project... -
How to install MariaDB ColumnStore as a module into existsing MariaDB row database.
In the webinar from 26 April, the narrator mentioned that MariaDB ColumnSto... -
how to install mariadb server silent and set password to root with no setup step
hello, i need to include mariadb with my project as server database to my ... -
How to install MySQL-python in Centos 7 and Python 2.7.5
Hello, I need to install a system that uses MariaDB... to be able to instal... -
How to install ODBC into Linux?
I am trying to install ODBC into my Linux. I did download the ODBC (mariadb... -
how to recover from last backup and binary log + relay log on a master master DB cluster
Hi Guys, my name is Tim, i am setting up a db cluster active active. i want... -
how to set 'schema sync only' as run option
Hi, I'm currently working on a project where we have to use columnstore due... -
I know this has been asked loads before, but...
I have a raspberry pi 3 with an external USB disk mounted at /mnt/database.... -
Incorrect definition of table mysql.event
Hello... I have installed MariaDB 10.3.13 in Centos 7. All worked well, but... -
Index with up to 24 columns
Hello there, A couple years ago (like 2012), we switched from MySQL to Mari... -
insert data quickly
Below code is taking long as it is inserting line by line. There is faste... -
install issue
Trying to install mariaDB on OpenBSD andhave it working in openbsd:s defaul... -
Is it possible to disable transaction logging for LOAD DATA INFILE into a TokuDB table?
I love TokuDB features a lot, among other for its speed, but I was wonderin... -
is Master-Master scheduled replication a possibility
I have looked at the replication options of several DB's. I have a slightly... -
Is there "pg_buffercache" / same kind of a functionality in MariaDB?
In PostgreSQL, there is pg_buffercache. Is there similar functionality ava... -
islanded master master recommendation
I have a question regarding the best way to achieve what I want. I have two... -
Issue on High Concurrency
Hello All, We are using apache storm application for message processing. Th... -
Issue with INSERT data not being available for immediate SELECT
I've got an issue where it appears that data that I insert isn't available ... -
IST replication failing on 2 node galera mariadb setup
We have a galera cluster setup with 2 nodes (master-slave setup) in a docke... -
jdbc driver version
i'm currently using the following mariadb version: Server version: 10.1.40-... -
JEMALLOC not found when building on Raspbian Wheezy
I have installed the list of Required tools shown on the Build Environment ... -
JSON document
The JSON documentation, every place, talks about a "JSON document". Where i... -
JSON Validate Error
I am getting an error while inserting JSON which has depth more than 32. I... -
JSON With MariaDB in procedure
Hi, All I have problem to create insert procedure in mariadb with COLUMN_CR... -
key-based authentication for MariaDB 10.3 on centos6
I am trying to figure out how to do key-based authentication to MariaDB 10.... -
libmariadb on Centos 6
Hi all I install MariaDB on my Centos 6.8 64 bit, following the instruction... -
Loading a Geojson file into a MariaDB table.
I am trying to load a geojson file into a MariaDB table. This is the data. ... -
Loading a Geojson file into a MariaDB table.
I am trying to load a geojson file into a MariaDB table. This is the data. ... -
log_warnings=0 does about nothing in my.ini
Hi, MariaDB 10.4.8 installed under Windows as a service "wampmariadb" In th... -
Lua Filter
Can you provide a Demo for Lua Filter? -
Maraidb 10.1.18, node Binlog is not updated for writes in other nodes of the same cluster. Is gtid not working as expected ?
ClusterA and ClusterB are with 3 nodes each. Using version Mariadb 10.1.18.... -
Maria DB and Pro*C
Hi, Is there any plugin/code convertor available to perform DB operations o... -
Maria DB Spark Connector support Structured Streaming
Hi - Does the Maria DB Spark Connector support Spark Structured Streaming h... -
Maria Installation Problem - Failed to stop mysql.service
I have been trying to remove and reinstall mariadb on my system however I k... -
MariaDB - online table archiving
We have a script that "rotates"/archive the Syslog tables in MySQL. This sc... -
MariaDB 10.3.15 : Referencing OpenSSL library to tar distribution
Hi Everyone, I used MariaDB "tar" distribution [https://downloads.mariadb.c... -
Mariadb 5.5.56 replication issue
Hi Team, We are using the mariadb replication in our environment, where is ... -
MariaDB and Python
Hello Everyone, So I'm a Python developer and I've recently installed XAMPP... -
MariaDB AX Cluster Creation and configuring external file system as Data store
Need steps to create MariaDB AX Cluster and configuring external file path ... -
MariaDB Columnstore 1.2.3-1 Cluster with replication for um1/um2 fails HA
Hello, I've been struggling to understand how to handle the HA for this typ... -
MariaDB Connector/ODBC with LibreOffice Base?
When I try to use MariaDB Connector/ODBC with LibreOffice Base, Base crashe... -
MariaDB crashes on force shutdown of server (cant open gtid_slave_pos)
Hi, we have an enterprise server where we run MariaDB 10.1.14. We are upgra... -
MariaDB database server crashes due to audit plugin
For MariaDB database server version 10.3.17 enabled the audit using the fol... -
MariaDB does not start after update Solus OS
Would You be so kind to help me? I'm on Linux solusbox 5.2.13-126.current #... -
MariaDB Federated FederatedX
https://stackoverflow.com/questions/49089641/mariadb-federated-federatedx I... -
MariaDB Galera Cluster on PowerPC
Has someone tried to use MariaDB Galera Cluster with PowerPC? If yes, does it behave well? -
MariaDB Galera Cluster Out of sync suddenly (Only sync the schema change but data not) Innodb engine
Hi We are running a 3 (A,B,C) nodes mariadb galera cluster on productio... -
MariaDB Galera Cluster vs. MySQL NDB Cluster
Has someone made a performance comparison between MariaDB Galera Cluster an... -
MariaDB Galera Cluster, joining a node
Hi, Is there any good way to see what happens when a node joins a MariaDB G... -
MariaDB Installation error
I am getting error with ibdata1 auto extending of the files when running my... -
mariadb jdbc client having issues, but mysql client working
This issue has been reported before; allegedly it is a server issue and sho... -
MariaDB master-slave replication issue
Hi Team, We are having following version of MariaDB and using master-slave ... -
MariaDB Master/Master database replication across regions on Microsoft azure Environment
We would like to implement geo redundant MariaDB Active/Active Database rep... -
MariaDB on a read-only filesystem
Is it possible to start MariaDB with datadir in a read-only mounted filesys... -
MariaDB performance issues
Server version: 10.2.27-MariaDB MariaDB Server hello - i am really not much... -
Mariadb Replication
I have installed mariadb104-server-10.4.6 galera: 25.3.26 FreeBSD 12 This i... -
MariaDB Replication: trigger not executed in slave table if master table contains any triggers
https://mariadb.com/kb/en/library/running-triggers-on-the-slave-for-row-bas... -
MariaDB restore from binary log and relay log on master master setup
Hi Guys, i have setup a mariadb master master setup and i am testing recove... -
mariadb server mysteriously seems to be crashing
hello - the last couple of days my server seems to have mysteriously stoppe... -
mariadb tries to delete the wrong file from tmp directory
Running mariadb-server.x86_64 1:5.5.60-1.el7_5 from Centos Base Repo I have... -
MariaDB Windows Service
Hello friends, After installation on windows 10, the mariadb service stop e... -
Mariadb-libs installation conflicts with existing MySQL community libs
During installation of openstack on Redhat LInux7 we were facing the below error. -
Maridb 10.1.19 breaks the postfix
How to install postfix without removing maridb yum install postfix --skip-b... -
Master down event on MMMon
Hello, I use Multi-Master Monitor for two MariaDBs and my network connectio... -
Master:Master replication
Hello there, Can anyone plesae guide me how to perform a Master:Master repl... -
Max rows can stored in a table
Hi, Would like to know what is the maximum rows that can be stored in a table. Thanks -
MaxScale, "No Master can be determined"
Hi! I am trying to use maxscale (2.2.15) with mariadb (10.2.15). maxscale i... -
Migrating from Oracle to Mariadb, getting HibernateOptimisticLockingFailureException save and update in same transaction Hibernate, Mariadb and Spring
We are migrating application from oracle to Mariadb. Using container transa... -
Migrating partitioned compressed tables
We are on MySQL 5.6 using partitioned InnoDB Barracuda tables with row_form... -
missing libmariadb.so.3 on redhat 7
I have tried just about everything. But an app that has worked before does ... -
Modelling more than one application period per entity?
I am new to MariaDB specifically because of the bitemporal cabablilities wh... -
MONyog Replication Error
In replication monitor I am getting an output of Slave_Running as NO but wh... -
Moving Binary Log Files
Hi, I am wondering if I can move binary log files without any issues, like ... -
Moving mariadb to docker installation
I'm running debian jessie and I'm currently trying to replace all my server... -
Multi master setup in Mariadb 10.0
Hi Is there a upper limit of masters in multi master replication ? I'm mig... -
multi master setup with schema sharding
Hello, I would create a master-master setup with several slaves attached.... -
MultiNode PM installation with replication, can I give "hint" to columnstore to prefer one PM over other's as a dbroot backup
Is there a way to give columnstore a hint on which server to prefer for rec... -
multiple regexp_replace
hello - i am using regexp_replace with much success. however, i am trying... -
Mysql Services stops by itself
Hi, I am running "mysql Ver 15.1 Distrib 5.5.60-MariaDB, for Linux (x86_64... -
mysqldump of mariadb columnstore take long time to restore
Hi I have 2 servers with mariadb columnstore, I need move a database from t... -
mysql_upgrade -p is failed
Hi Team, We have installed and configure Mariadb 5.5.56 and migrated dtabas... -
Near real time replication Maria database
Hello All, I just want to know the better approach of DB replication near r... -
Need help related to MariaDB performance behavior
We are working on case related to MariaDB where-in we are observing perform... -
need to load csv date data along with AM/PM values.
Dear Team , we are trying to load date column data along with AM/PM values ... -
Network time of result of select query is too much.
Hello, I'm getting data using select query with column index The number of ... -
node sequelize vs mariadb node interface
hello - is there any advantage to skipping the use of sequelize and instead... -
Node.js Connector TypeError: res.status is not a function
Hallo I am learning JS scripting and am making a RESTful API with the Mari... -
Not able to start galera cluster
Hi, I am working on a project where I need to install mariadb galera on Lin... -
ODBC Level 2 compliant
Is MariaDB ODBC 3.0.2 driver ODBC level 2 compliant? -
On what macOS releases is MariaDB 10.3 supported?
On what macOS releases is MariaDB 10.3 supported? In general, where would I... -
Oracle GoldenGate cannot Extract Mariadb 10.2.9 binlog to Oracle 12c
Dear I use OGG 12c for CDC of MySQL 5.5.6 source to Oracle target It work... -
Percona pt-table-checksum output is in infinite loop "Waiting for the --replicate table to replicate"
We have following Multi master replication scenario. We are using Mariadb 1... -
Percona XtraBackup restore
How do i restore a single database from a full backup or from a single database backup?? -
Pooledconnection with wrong user credentials timeouts without information
Windows 10 MariaDB 10.2.14 mariadb-java-client-2.3.0.jar trying this with ... -
problem to insert non-ASCII characters
Hi, I have a hard time trying to insert values with non-ascii characters. I... -
Problem with connector to get latin data and UTF8 data in one table
Our software gets data from different databases, one of them ist MySQL. Dat... -
Query in a MariaDB cluster 10.3.13 of 3 nodes get slow responses in nodes 2 and 3
Query in a MariaDB cluster 10.3.13 of 3 nodes get different EXPLAIN ( using... -
Read path and write path in MariaDB Galera Cluster
Hi Everyone, I'm struggling to understand MariaDB Galera read and write pa... -
Restarting first node in cluster
Hello, I am a relatively new user of mariadb. I have a 3 node mariadb clust... -
SELECT INTO variable does not work with WITH clause
Hello! I have a stored procedure, which worked in MariaDB 10.2 but it does ... -
service mysql start command is cleaning up all the files under /var/lib/mysql
Hello All, We have 2 node Mariadb Galera cluster. Found out that mysql serv... -
ServiceNow Error when trying to use match regex, match pattern
Cannot for the life of me get these options to work in ServiceNow. No matt... -
show databases
show databases is returning data folder directory listing instead of inform... -
Simulate SST method
How can I simulate a node being fallen behind the cluster and then enforce ... -
SLES 10.2 32 bit - latest usable stable
Salve a tutti, I have to install MariaDB on a SuSE Enterprise Linux 10 patc... -
SST failing, foreign key issue?
Hello! Last night one node in a two node cluster left for some reason. Not ... -
static linked library libmysqlclient.a is missing
Hi, The static linked library libmysqlclient.a is missing. I have an issue ... -
Stored Procedure - Using Java
Does mariadb support creating stored procedures using java instead of PL/SQL? -
Subpartitioning using two different columns
Hi All, We are looking for solution where we want to apply list partition ... -
Switch over and JDBC connection
When I use JDBC connection and master host is down, how can I switch over t... -
Timing discrepancy between connector's logging and application logging
I have enabled `slowQueryThresholdNanos` logging and am seeing a log like: ... -
Transparent Huge Pages
How do we fine tune Transparent Huge Pages? Is there a guideline that someo... -
TRUNCATE sub partition?
Hi, The following command will truncate a partition : ALTER TABLE subpartio... -
UDT Options For Development with MariaDB
I am figuring out an alternative to Oracle and am trying out MariaDB. In Or... -
Unable to migrate one Db from MySql to Maria 10
Hi I'm wanting to copy a database from a MySql 5.6 server to a MariaDb 10.0... -
Unable to use connectionpool with namedpipesocketfactory
I have an application that used to connect via the network (jdbc:mariadb:<t... -
use events in galera cluster
Hi, We are going to use the galera cluster. Moreover, I have created an eve... -
Using HeidiSQL with MariaDB AX Columnstore 10.2.10 Columnstore 1.1.2-1
Hi, I was playing around with my mariadb installation and when I imported a... -
Warning without any faults!
I get a warning like this after a SP has run: array (size = 1) 0=> array ... -
We setted innodb_file_per_table is On. When new table created, What is the Initial tablespace size?
Please Help.. We are setted innodb_file_per_table variable is 'ON'. When n... -
What is the rest api for mariadb for integration purpose?
What is the rest api for mariadb for integration purpose? -
Whenever I try to use API, I'm blocked by this error log
Hello, I'm developing ARM target board. My develop environment is composed ... -
X protocol
Is there any plans to implement the X protocol or something similar for mar... -
从库启用audit plugin，主库写入，从库没有sql记录
我在从库上启用audit plugin插件，主库写，从库读，主库写入可以同步到从库，但是从库的日志审计记录里没有主库读写的记录，除非我在从库本地写入，否则日志记录中不会出现，这个什么情况
Content reproduced on this site is the property of its respective owners,
and this content is not reviewed in advance by MariaDB. The views, information and opinions
expressed by this content do not necessarily represent those of MariaDB or any other party.
