Embedded Files
Assumptions
Assumptions
x86 64 bit Linux
Bundled MySQL Server
You have a graphical login (e.g. VNC)
Preparation
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
Upgrade
- V1018520-01.zip MEM SM 8.0.28
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'.
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
Next Steps
Upgrade MEM Agent
Backout
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
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)
Page updated
Google Sites
Report abuse