MEM Upgrade

Assumptions

  • x86 64 bit Linux

  • Bundled MySQL Server

  • You have a graphical login (e.g. VNC)

MySQL-Matrix

Preparation

DLP: MySQL Enterprise EditionMySQL Enterprise Monitor

This needs to happen on the targets with Agents installed...

mv /opt/mysql/enterprise/agent/share/mysql-monitor-agent/items-mysql-monitor.xml \

/opt/mysql/enterprise/agent/share/mysql-monitor-agent/items-mysql-monitor.xml.bak

This needs to happen on the "Service Manager" server...

mv /opt/mysql/enterprise/monitor/mysql/my.cnf /opt/mysql/enterprise/monitor/mysql/my.cnfO

Upgrade


Copy the Service Manager zip file to a suitable location (e.g. /u01/img/MEM/8.0.28) and unzip...

cd /u01/img/MEM/8.0.28

unzip V1018520-01.zip

chmod u+x *.bin

./mysqlmonitor-8.0.28.1358-linux-x86_64-update-installer.bin

Choose a backup location with enough room to hold the backup. Create a new location on another filesystem if necessary.
During testing I received a warning stating "A backup directory from a previous update has been detected on /u01/mysql/backup" "Do you want to remove any existing backup data?". In my case, this was a freshly created directory! I clicked ''Yes'.
18080 and 18443 are the default values. Check in:/opt/mysql/enterprise/monitor/configuration_report.txt
Nothing to enter here. The installer should retrieve all values from the existing configuration.
Getting to this point took approximately 10 minutes during testing.
Uncheck "launch browser" if you prefer to run the browser on your client rather than the server.

Next Steps

Upgrade MEM Agent

Backout

*** Untested ***

Shutdown MEM Service Manager and MySQL Database

cp -R /u01/mysql/backup/* /opt/mysql/enterprise/monitor

Restart MySQL database and MEM Service Manager

Bibliography


https://dev.mysql.com/doc/mysql-monitor/8.0/en/mem-upgrading.htmlhttps://dev.mysql.com/doc/mysql-monitor/8.0/en/mem-upgrading-general.htmlhttps://docs.oracle.com/cd/E17952_01/mysql-monitor-8.0-en/mem-upgrading-general.html
https://support.oracle.comHow to Download MySQL Enterprise Monitor, Dashboard, Query Analyzer, Analyser, MEM (Doc ID 1322149.1)How to Upgrade MySQL Enterprise Monitor (MEM)? (Doc ID 1365286.1)Oracle Log4j2 Update (CVE-2021-44228) in MySQL Products (Doc ID 2827698.1)