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 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... -
Can't create/write to file '/d/data/myhost.err' (Errcode: 13 "Permission denied")
Hello everyone, I am installing MariaDB 10.1.21 on RHEL 6.7. I am experienc... -
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... -
CP437 CharSet
I need to configure the character set of a schema as CP437. Unfortunately, ... -
cpimport with a decimal table bug
I meet with cpimport bug when I use a decimal table. this is the details :... -
Crash when inserting or selecting large amounts of text in/from LongText field
Update: This appears to only happen on Windows/Ubuntu 16. It seems very p... -
Default time zone in MariaDB server
How I can set a value in "default time zone" in option file for permanent u... -
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 maxscale allow to route to a service based on the database user connnecting?
Many of our applications have a specific database user assigned to it. Is t... -
Does MySQL Enterprise Backup work with MariaDB?
We primarily support MySQL from Oracle. A business group needs an applicat... -
dumb question about enabling error logs
hello - i thought i understood that error logs are ALWAYS enabled. so i a... -
Enabling SSL in mariaDB running on Synology NAS
I am having problems with enabling SSL in MariaDB running on Synology NAS (... -
error : (408595) Lost connection to the master server
i find many error in the log file. ------------------------------- 2019-06-24 19:13:25 no -
ERROR 1815 (HY000): Internal error: IDB-2004: Cannot connect to ExeMgr.
hi when i loading data to mariadb columnstore and at the same time ru... -
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 ... -
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... -
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 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 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 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 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... -
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... -
INTO OUTFILE error 2
Good day, I am trying to run the following command but it does not seem to ... -
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... -
j/connector parameters
I am attempting to connect PENTAHO to a MariaDB environment. I am using th... -
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 With MariaDB in procedure
Hi, All I have problem to create insert procedure in mariadb with COLUMN_CR... -
keeping out hackers
hello - (and THIS is embarrassing) for the third time now, all my databases... -
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... -
Login Fails After Upgrading to 10.4.6
I run MariaDB in a Docker container (downloaded from Docker Hub) in MacOS 1... -
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 Driver with AWS Aurora
Hi, We use MariaDB Connector/J to connect to AWS Aurora RDS. RDS has SSL en... -
Maria DB Spark Connector support Structured Streaming
Hi - Does the Maria DB Spark Connector support Spark Structured Streaming h... -
MariaDB - online table archiving
We have a script that "rotates"/archive the Syslog tables in MySQL. This sc... -
MariaDB 10.4 Password Reset
I don't know the current password. When I try to change, it says it is not ... -
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 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 Federated FederatedX
https://stackoverflow.com/questions/49089641/mariadb-federated-federatedx I... -
MariaDB For Loop
Hi I am trying to create 100 empty rows using a for loop, the insert statem... -
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 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-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 always checked dbserv node lost ,but I do not know why ?
Sometimes, when I connect to Galera cluster through the maxscale proxy, it appears: FATAL: m -
Maxscale shows slaves as Slave of External Server, Running
We have this setup : 1 master + 3 slaves I want to configure Maxscale with... -
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 ... -
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... -
Moving to the Default Directory
Is there a web page which describes the proper steps to move the default di... -
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... -
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... -
ODBC Connector and MS ACCESS 2010 not communicating
My experience is really with MS SQL server so it has been difficult to get ... -
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... -
Oozie error after upgrading to 2.4.1
The mariadb connector was upgraded from 1.1.9 to 2.4.1 for oozie (connected... -
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... -
Oracle to MariaDB Migration
Hi , I want to migrate my oracle database to mariaDB . Please suggest any m... -
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 ... -
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... -
revoking drop privileges
hello - i am trying to get "revoke drop" working and not having any success... -
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... -
Simulate SST method
How can I simulate a node being fallen behind the cluster and then enforce ... -
spider/tocudb compatibility
Can the spider engine work with tocudb shard nodes? -
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? -
Supper slow `UPDATE WHERE IN` after moving from MySql 5.5 to MariaDB 10.1.26 (maybe waiting to lock?)
I had just moved from MySql 5.5 to MariaDB 10.1.26. And suddenly some queri... -
Support for custom endpoints on AWS Aurora
I know that MariaDB Connector/J supports cluster endpoints on AWS Aurora. I... -
Switch over and JDBC connection
When I use JDBC connection and master host is down, how can I switch over t... -
temporary tables on mariadb 10.2.8
Because since Mariadb 10.2.4 Information Schema TEMP_TABLES_INFO table was... -
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... -
Uninstall or delete MariaDB completely for re-installation
I am new to this forum so pse forgive me if I am asking a question which al... -
unknown root username
hello - when i look in the mysql.user table, i see the following entry for root: MariaDB [( -
use events in galera cluster
Hi, We are going to use the galera cluster. Moreover, I have created an eve... -
useLocalTransactionState for mariadb connector/j
The Mysql Connector/J supports the useLocalTransactionState variable (https... -
User Management - admin account to only add users with view rights
Hello, I am looking for a solution to create a user account for MariaDB tha... -
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 ... -
Windows recovery point erases database
I have a situation where the Windows has been recovered. After that the dat... -
从库启用audit plugin，主库写入，从库没有sql记录
我在从库上启用audit plugin插件，主库写，从库读，主库写入可以同步到从库，但是从库的日志审计记录里没有主库读写的记录，除非我在从库本地写入，否则日志记录中不会出现，这个什么情况
