← Back to team overview

maria-discuss team mailing list archive

Drop user not replicating in 10.2.16/17 galera cluster with NO_AUTO_CREATE_USER in mysql_mode


Hi all,

not sure if this is expected or not.
I am running a test cluster in preparation for upgrading from 10.0 to
10.2 and noticed that DROP user commands were not being propagated to
other members of the galera cluster.

The only user management changes of note I know of was the addition of
NO_AUTO_CREATE_USER to sql_mode and indeed removing that from sql_mode
appears to have resolved it.

My question is, is that expected behavior and if so whats the modern way
of removing mysql users from a mariadb galera cluster. If not is it
worthy of a bug report?