maria-discuss team mailing list archive
-
maria-discuss team
-
Mailing list archive
-
Message #05209
Drop user not replicating in 10.2.16/17 galera cluster with NO_AUTO_CREATE_USER in mysql_mode
-
To:
maria-discuss@xxxxxxxxxxxxxxxxxxx
-
From:
Vincent Hoffman-Kazlauskas <vince@xxxxxxxxxxxx>
-
Date:
Wed, 15 Aug 2018 13:48:09 +0100
-
Autocrypt:
addr=vince@xxxxxxxxxxxx; prefer-encrypt=mutual; keydata= xsDiBESPz78RBADybNTkAA4eQLuwYC1Qsn7qaDLzBvq2RmA0niwngigEPy/tLh9aF2zR85fL PTvxh9MyLzFZHc5RVO0tKM93CSRXjTo5xo2P1/YTopPyzTBB3eOB7uqJRi+suBnKPfXvkeW1 g5yo3pKINsqW0ed91lDwrQ1NofbIFkOOYnhQpccdiwCg0GF13Vk9Rz683bkSawFethAcVx8E AKGPTj6KfVmnhB8a3y0UeZ46LMfoZnjLF4ZDMtrZHY639zbZBJiKJ/M1B8z3GJgmRmOEXoW4 Mdoi0XaSkinIWmtdI+vhIfb/7ufFzujM0wEbEnpJ/mvTuSas6DG7MPMiJMavz3Hf/dVOX7Dd Ma+z03JKIHuMj8HVMFccjgFJLmteBADkdDBQin+YzgGuPs/Sf8KvVPVRDT5QJkHUEU/gcmSP YbPfmwC7tl1iXR9Gu4foQyk2UJJezCRUWggNScybcrLp2jQ0XWkw18uus/QC2ZCfW/f2vXg8 uL5W7cLGbeSKh3K0CFMbACmcrcMZk7JwW9a/VlAhmqOUk1MYJ1rR2ZZIp80mVmluY2VudCBI b2ZmbWFuIDx2aG9mZm1hbkBuYW1lcy5jby51az7CYAQTEQIAIAUCRI/PvwIbAwYLCQgHAwIE FQIIAwQWAgMBAh4BAheAAAoJEMQkmEPMfxC+ik0An0EFsHC1cTRRq+MgAWoM3WRvOeQFAJ9D 2GwjK6Zaiu6s+KaxeWh4yrk0Jc7BTQREj8/REAgA5AQP4RpCo/O9U/Zd4s0mArJpGQhAnYb8 2r+u3e/MyGK5hTH+ODAOZ1TeiPb75xYQ9QGOX+ygpCSDmDjG+MJyPivdZMuuwnhisYZPNuhE Tw/CdP5mekqPzZAvIqBi5q6Bdmz0tORu4L6y/zPnQ8qrkBnibK9AOKz1XkguOlzcIlfxpsOC AgTRWoOpW8oQtQl80Ik22prSExgKllBfq3/sRix28r86L51P5hHG7mlWtbv8txaLyihBO3aw mkTXLAk5IMgrlillkDvMYUsO7lOkwk54C3oq+lYarNJ4Ul7Wfyg1ufjCc8CynXrlgFMJ+wbg Uhk4lbidSuGRkT10yqlNrwAECwf/YA3W3eSNQIn6s5eBTR+Qocmp+11zTNQMwB3xRzKQFBBd UwTbFiyhxMS7+xJzEUzuhTOy/OI/QCto595C/68y53TU0fwII0e2XLRYDIWO1FqSCGyDMviO 1ixnSHMkXeIEPbalF9n+KB2ozX0OOxl3oA7wt/DmOq8nLNzCMOKHD6mJRnBAp0En9WYpnbSl nucjh2+Ry9XAK5HCZ9k1SWxFPCEvxv4nwhZnYFdm5O4M6MHw8T/viWIBa96yt2CTGP7gOz+s YKcjUTQ7UdtYFVguGW9uehvtqbCLv69clBCmooRYAmTkiupI8R1zIfKVDjllDONWoPZfCz2d LwHnLW/ZMsJJBBgRAgAJBQJEj8/RAhsMAAoJEMQkmEPMfxC+he0An3g4+nwMH9lsde9IFgQY TDhDySz9AKCZSsEaPlGPvj7Fd7c47Eh4Nt9j9w==
-
Openpgp:
preference=signencrypt
-
User-agent:
Mozilla/5.0 (Macintosh; Intel Mac OS X 10.13; rv:52.0) Gecko/20100101 Thunderbird/52.9.1
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?
Thanks,
Vince