Mysql – Install galera cluster without remove existing mariadb

galeramariadbmulti-masterMySQLreplication

I have to setup Galera cluster in one of my production servers.

OS: Ubuntu 14.04
Existing mysql: maridb 10.1

While installing this cluster, its asking to remove the existing mariadb-server-10.1

How can I install this without remove anything?

Best Answer

If you installed MariaDB 10.1, you don't need to remove anything because MariaDB Server and MariaDB Galera Server packages have been combined and Galera packages and their dependencies get installed automatically when installing MariaDB 10.1.

So you must only configure galera without remove anything.

Reference

Related Solutions

Mysql – MariaDB Galera Cluster – nodes fail to start

I think you should switch back to Maria DB 5.5 for Galera support.

MariaDB Galera Cluster vs. MariaDB – SELECT Performance Issues

I managed to solve this -for the most part- by changing a few parameters. apparently it looks like the database needs to warm up by opening the tables at least once. This is behavior I am familiar with since mysql 5 with plenty of tables and databases.

The query still runs slow when it's the first time it runs (TABLE CACHE IS OFF). By changing the parameters below, this only happens on the first run of the query. Any additional attempts to run it after that does not exhibit this slow down anymore. The following parameters helped

[mysqld_safe]
open-files-limit = 65535

And

[mysqld]
innodb_open_files       = 16384

table_cache = 800
table_open_cache = 40000
table_definition_cache = 3000
thread_cache_size = 50

I believe the reason is that the information_scheme is the bottleneck here. Afaik, a known problem when having plenty of tables around.

Best Answer

Related Solutions

Mysql – MariaDB Galera Cluster – nodes fail to start

MariaDB Galera Cluster vs. MariaDB – SELECT Performance Issues

Related Question