Question : As we have “purge” enabled and one the nodes went offline, so now we have out of sync […]
Category: MariaDB
how to change “localhost” in MariaDB
Question : I wonder if there is any way to change localhost in MariaDB. For example, while creating a user […]
Problem in mysql database!
Question : how to create a view of this query in (mysql) database. SET @variable = 0; — Without Pagination […]
Replicate only some tables of MariaDB database
Question : I currently have a ready-made structure cluster with MariaDB Galera with two servers that keeps both updated database. […]
ALTER TABLE statements not replicating in all tested scenarios – MariaDB
Question : Summary Tech: mariadb 10.3 Issue: some attempts to ALTER TABLE to change engine is not replicating. Scenarios tested: […]
Upgrade from MariaDB 10.3 to MariaDB 10.4 with Galera Cluster – mysql.global_priv table
Question : I have 3-node MariaDB 10.3 Galera Cluster (Ubuntu 14.04) and I want to upgrade it to MariaDB 10.4 […]
Is it expected behavior that MIN() window function in MariaDB/MySQL can return a non-null value from a window with only null values?
Question : A minimal example for MariaDB (reproduced with with 10.2 and latest): DROP TABLE IF EXISTS t; CREATE TABLE […]
Maximum overall size of MariaDB binary logs
Question : I am looking for a way to prevent MariaDB binary logs from taking a huge size when they […]
convert_unixtime output wrong date
Question : Behind the scene: Basically I operate an app that heavily relies on time calculation. We store unixtime in […]
Performance issues on a MySQL database with 150 million rows
Question : Current setup: A managed vps server InnoDB storage for big tables 10.0.36-MariaDB 18gb ram 8 x 2.40 GHz […]