Question : I have to be missing something here. It just hit me as added a new node to my […]
Category: MariaDB
prevent a galera node from bootstrapping
Question : I have bootstrapped a node as the first node in a new galera cluster. then when I joined […]
Think I have the right indexes and query, but MySQL Query is still slow
Question : table_1 id | column_1 | import_date Indexes: Mutli-column key (multi_column) of import_date and column_1 in addition to an […]
Issues using pt-kill to kill log queries
Question : I’m trying to get pt-kill to work to kill queries running longer than n. The command as I’m […]
Upgrading MariaDB Galera cluster from 5.5 to 10.0 – rolling upgrade possible?
Question : I’ve had a good search around and cannot find much on the topic. We want to upgrade our […]
MariaDB optimizing geo IP lookup with Maxmind GeoLite2 database
Question : I have the following two tables that I ingest with data from Maxmind’s GeoLite2 Country database: CREATE TABLE […]
kill ‘ gives ERROR 1095 (HY000): You are not owner of thread … even though I am
Question : I did an ALTER TABLE on a huge table on a MariaDB Galera Cluster 10.2, but after a […]
Does executing mysql dump files trigger replication?
Question : I have two servers A and B that have a source/replica replication set up. I need to bring […]
Can I use a mariadb/mysql dump from older version in newer version?
Question : I’m a mariadb/mysql newbie. I want to take a complete backup. Apparently this is the way (please correct […]
Unable to create an user using mysql_embedded
Question : I am creating a docker mariadb image and wanted to create a database and user name before bootstrapping […]