MariaDB Anyone using MariaDB 10.4.8 on live and busy site?

minor version downgrades are fine to do though depends on what updates were made in 10.4.10 versus 10.4.8. MariaDB 10.4.9/10.4.10 has security and bug fixes it MariaDB 10.4.10 Release Notes including a criticial InnoDB bug which can prevent MariaDB server from starting up if it has Full Text InnoDB tables with Foreign Keys. So you'd want to be on MariaDB 10.4.10 if that situation applies to you otherwise, MariaDB MySQL server will not restart/start up.

10.4.9

---

 

That's a strange one if 10.4.8 works. Let us know how the next update goes for 10.4.11

Thanks for the confirmation I'd probably be waiting till 10.4.2x releases to revisit 10.4 myself

 

Thanks for the heads up. Seems like this will take quite a long time to iron out the issues ! Wonder if MySQL 8.0 is also having similar issues ?

 

Yeah seems to be the case still. For Centmin Mod 123.09beta01 and higher at least for optional MariaDB 10.4 update, I have made optimizer_use_condition_selectivity = 1 the default for this anyway.

 

for mariadb 10.4 the routine is different but it should of run see code at centminmod/centminmod

you can verify if it was run if there's 4 files generated

• /root/centminlogs/mariadb10.4-check-users-before.log
• /root/centminlogs/mariadb10.4-check-users-after.log
• /root/.my.cnf would have been populated with mysql root password and /root/centminlogs/set-dot-my.cnf.log would of been created

what did you run manually ? as mariadb 10.4 is different from other previous versions

because optimizer_use_condition_selectivity=1 resolved most of the issues IIRC

 

From my past tests MariaDB 10.4 doesn't create an anonymous user and is more secure and the MySQL user table has actually moved, so hence why I did MariaDB 10.4 securing differently at centminmod/centminmod. See Authentication in MariaDB 10.4 — Understanding the Changes - MariaDB.org

This is example output for mariadb10.4-check-users-after.log but can be done when you run the command on MariaDB 10.4 server

Code (Text):

mysql -e "select concat(user, '@', host, ' => ', json_detailed(priv)) from mysql.global_priv;"

Don't post your output publicly on the forums as it is your mysql root and mysql user's login details. Centmin Mod makes MariaDB 10.4 use old mysql_native_password for best compatibility (see MariaDB - Interesting look at what's new in MariaDB 10.4)

Code (Text):

mysql -e "select concat(user, '@', host, ' => ', json_detailed(priv)) from mysql.global_priv;"          
+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
| concat(user, '@', host, ' => ', json_detailed(priv))                                                                                                                                                                                                                                                                                 |
+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
| root@localhost => {
   "access": 1073741823,
   "plugin": "mysql_native_password",
   "authentication_string": "*A177D80C40E567CF2F14D9CD0F14E650BCF0091F",
   "auth_or":
   [
      
       {
       },
      
       {
           "plugin": "unix_socket"
       }
   ],
   "password_last_changed": 1568844540
} |
| mysql@localhost => {
   "access": 18446744073709551615,
   "plugin": "mysql_native_password",
   "authentication_string": "invalid",
   "auth_or":
   [
      
       {
       },
      
       {
           "plugin": "unix_socket"
       }
   ]
}                                                                 |
+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+

See there is no anonymous user by default in MariaDB 10.4 to need removing. Only root user (which Centmin Mod enables with a root password you can see via authentication string hash of the root password) and the default mysql user (which is disabled with authentication string = invalid Authentication in MariaDB 10.4 — Understanding the Changes - MariaDB.org

MariaDB 10.4 has drastic changes to way it usually handles authentication from previous versions etc so ensure you're familiar with them MariaDB - Interesting look at what's new in MariaDB 10.4. Otherwise, probably best to stick with MariaDB 10.3 if you're unsure.