MariaDB Community Server and MariaDB Enterprise Server install a configuration file at the path /etc/mysql/mariadb.conf.d/50-server.cnf on Debian and Ubuntu.

This file contains the following line:

# Instead of skip-networking the default is now to listen only on

# localhost which is more compatible and is not less secure.

bind-address            = 127.0.0.1

See here:

https://github.com/mariadb-corporation/MariaDBEnterprise/blob/10.5.4-2/debian/additions/mariadb.conf.d/50-server.cnf#L28

According to the multi-node ColumnStore installation instructions from toddstoffel, this configuration line needs to be removed for multi-node ColumnStore to work. It does not seem like a good idea to make users remove this line themselves. In my opinion, the installation process should be more user friendly.

We could work around this issue by making x-columnstore.cnf override the value by setting bind_address=0.0.0.0. x-columnstore.cnf already has a similar override for plugin_maturity.