Yes it does:
However, it looks confusing, I would only use this to upgrade mysqsl -or- mariadb, not convert from mysql to mariadb.
No a lot more. Like also creating a better backup and taking care that mysql is stopped the correct way that DA won't start it automatically again. Also a backup of /var/lib/mysql is mentioned. I don't see that this would be only for Centos as also Debian/FreeBSD is mentioned.
Oke, but how does anybody running MySQL gets a part MariaDB? This can only appear if a conversion went wrong, and then you have a problem anyway. So I don't understand this one completely.
That section also mentions RPM so that's a bit difficult in Debian. Anyway if this is the only correct conversion procedure it should be made clear in the docs that the How to upgrade MySQL / MariaDB with CustomBuild 2.0 section isn't the correct conversion procedure as this isn't obvious at all now because they have that "Drop-in replacement and upgrade path is following:" stuff in that section as well.
It must not be in the Bug portal...
You funny man!
mysqldump: Got error: 1356: "View 'sys.host_summary' references invalid table(s) or column(s) or function(s) or definer/invoker of view lack rights to use them" when using LOCK TABLES
mysqldump: Couldn't execute 'SHOW FIELDS FROM `host_summary`': View 'sys.host_summary' references invalid table(s) or column(s) or function(s) or definer/invoker of view lack rights to use them (1356)
mysqldump: Couldn't execute 'SHOW FIELDS FROM `memory_by_host_by_current_bytes`': View 'sys.memory_by_host_by_current_bytes' references invalid table(s) or column(s) or function(s) or definer/invoker of view lack rights to use them (1356)
mysqldump: Couldn't execute 'SHOW FIELDS FROM `memory_by_thread_by_current_bytes`': View 'sys.memory_by_thread_by_current_bytes' references invalid table(s) or column(s) or function(s) or definer/invoker of view lack rights to use them (1356)
mysqldump: Couldn't execute 'SHOW FIELDS FROM `memory_by_user_by_current_bytes`': View 'sys.memory_by_user_by_current_bytes' references invalid table(s) or column(s) or function(s) or definer/invoker of view lack rights to use them (1356)
mysqldump: Couldn't execute 'SHOW FIELDS FROM `memory_global_by_current_bytes`': View 'sys.memory_global_by_current_bytes' references invalid table(s) or column(s) or function(s) or definer/invoker of view lack rights to use them (1356)
mysqldump: Couldn't execute 'SHOW FIELDS FROM `memory_global_total`': View 'sys.memory_global_total' references invalid table(s) or column(s) or function(s) or definer/invoker of view lack rights to use them (1356)
mysqldump: Couldn't execute 'SHOW FIELDS FROM `metrics`': View 'sys.metrics' references invalid table(s) or column(s) or function(s) or definer/invoker of view lack rights to use them (1356)
mysqldump: Couldn't execute 'SHOW FIELDS FROM `processlist`': View 'sys.processlist' references invalid table(s) or column(s) or function(s) or definer/invoker of view lack rights to use them (1356)
mysqldump: Couldn't execute 'SHOW FIELDS FROM `ps_check_lost_instrumentation`': View 'sys.ps_check_lost_instrumentation' references invalid table(s) or column(s) or function(s) or definer/invoker of view lack rights to use them (1356)
mysqldump: Couldn't execute 'SHOW FIELDS FROM `schema_table_lock_waits`': View 'sys.schema_table_lock_waits' references invalid table(s) or column(s) or function(s) or definer/invoker of view lack rights to use them (1356)
mysqldump: Couldn't execute 'SHOW FIELDS FROM `session`': View 'sys.session' references invalid table(s) or column(s) or function(s) or definer/invoker of view lack rights to use them (1356)
mysqldump: Couldn't execute 'SHOW FIELDS FROM `session_ssl_status`': View 'sys.session_ssl_status' references invalid table(s) or column(s) or function(s) or definer/invoker of view lack rights to use them (1356)
mysqldump: Couldn't execute 'SHOW FIELDS FROM `user_summary`': View 'sys.user_summary' references invalid table(s) or column(s) or function(s) or definer/invoker of view lack rights to use them (1356)
mysqldump: Couldn't execute 'SHOW FIELDS FROM `x$host_summary`': View 'sys.x$host_summary' references invalid table(s) or column(s) or function(s) or definer/invoker of view lack rights to use them (1356)
mysqldump: Couldn't execute 'SHOW FIELDS FROM `x$memory_by_host_by_current_bytes`': View 'sys.x$memory_by_host_by_current_bytes' references invalid table(s) or column(s) or function(s) or definer/invoker of view lack rights to use them (1356)
mysqldump: Couldn't execute 'SHOW FIELDS FROM `x$memory_by_thread_by_current_bytes`': View 'sys.x$memory_by_thread_by_current_bytes' references invalid table(s) or column(s) or function(s) or definer/invoker of view lack rights to use them (1356)
mysqldump: Couldn't execute 'SHOW FIELDS FROM `x$memory_by_user_by_current_bytes`': View 'sys.x$memory_by_user_by_current_bytes' references invalid table(s) or column(s) or function(s) or definer/invoker of view lack rights to use them (1356)
mysqldump: Couldn't execute 'SHOW FIELDS FROM `x$memory_global_by_current_bytes`': View 'sys.x$memory_global_by_current_bytes' references invalid table(s) or column(s) or function(s) or definer/invoker of view lack rights to use them (1356)
mysqldump: Couldn't execute 'SHOW FIELDS FROM `x$memory_global_total`': View 'sys.x$memory_global_total' references invalid table(s) or column(s) or function(s) or definer/invoker of view lack rights to use them (1356)
mysqldump: Couldn't execute 'SHOW FIELDS FROM `x$processlist`': View 'sys.x$processlist' references invalid table(s) or column(s) or function(s) or definer/invoker of view lack rights to use them (1356)
mysqldump: Couldn't execute 'SHOW FIELDS FROM `x$schema_table_lock_waits`': View 'sys.x$schema_table_lock_waits' references invalid table(s) or column(s) or function(s) or definer/invoker of view lack rights to use them (1356)
mysqldump: Couldn't execute 'SHOW FIELDS FROM `x$session`': View 'sys.x$session' references invalid table(s) or column(s) or function(s) or definer/invoker of view lack rights to use them (1356)
mysqldump: Couldn't execute 'SHOW FIELDS FROM `x$user_summary`': View 'sys.x$user_summary' references invalid table(s) or column(s) or function(s) or definer/invoker of view lack rights to use them (1356)
mysqldump: Couldn't execute 'SHOW CREATE PROCEDURE `diagnostics`': Failed to load routine sys.diagnostics (internal code -6). For more details, run SHOW WARNINGS (1457)
mysqldump: Got error: 1356: "View 'sys.host_summary' references invalid table(s) or column(s) or function(s) or definer/invoker of view lack rights to use them" when using LOCK TABLESWe had no issues upgrading from Mysql 5.7 to MariaDB 10.2 on the other servers. Maybe DA used already a fix in the update script? I don't know why it might have issues now.
and I read you were having issues upgrading mariadb 10.4.20 so I don't know what this 10.2 stuff has to do with your upgrade issue?
Couldn't find anything in the CB2 changelog about that but let's hope so!
Upgrade path on this machine over time was MySQL 5.7 -> MariaDB 10.2 -> MariaDB 10.3 MariaDB 10.4
Manually; open to suggestions here though, still hoping DirectAdmin will add a fix in a future version of CB.
The sys scheme is present by default on MySQL 5.7 and it's only doing a drop in replacement so the sys scheme would be present since it's not touching the actual database source files at all. This was the case on all our (Debian) machines anyway.
I don't know exactly what is ment by a drop in replacement, but the upgrade is doing a dump of all tables, then uninstall mysql and install mariadb and then restore all tables again. You mean the sys scheme table would get back in with the restore? Because as far as I know that is not backed up in the dump.
As far as I know a drop in replacement is just replacing the MySQL binaries with MariaDB keeping the raw database source files as is. CB does give you the option to backup/dump all tables but MariaDB will just use the exact same database source files MySQL were using including the incompatible sys scheme.
