Hi All
I was able to upgrade MySQL community to enterprise edition with help of MySQL team
We had two approach either migrated to oracle(because we already had the licenses for oracle ) or to MySQL enterprise edition (since we were currently running MySQL version)
We successfully tested both just that oracle migration needed reinstallation so we chose MySQL upgrade.
it has been three weeks and no issue has occurred so we are moving towards upgrade of UIM to 9.02 then to 20.1
thanks for the support
regards
Nijin
------------------------------
Tools admin
DXC TECHNOLOGY
------------------------------
Original Message:
Sent: 09-08-2020 08:13 AM
From: Gene HOWARD
Subject: mysql community version to enterprise edition
I would not suggest that you have anything connecting to your database while doing any type of upgrade.
I would suggest you disable the primary hub and ump robots while the upgrade is being done and start them afterwards.
------------------------------
Gene Howard
Principal Support Engineer
Broadcom
Original Message:
Sent: 09-07-2020 11:29 AM
From: Nijin K
Subject: mysql community version to enterprise edition
Actually gene this is just a copy of prod we used for testing so we still can test but i want to know if after enterprise upgrade is there any special steps we need to take from UIM before trying to connect to db .
do we need to stop UIM services while this upgrade is being done or can we just let db team do the upgrade on the live environment?
regards
NIjin
------------------------------
Tools admin
DXC TECHNOLOGY
Original Message:
Sent: 09-07-2020 11:07 AM
From: Gene HOWARD
Subject: mysql community version to enterprise edition
Hi
Sorry you are having an issue.
First it is not tested and so not supported doing an in place upgrade from community to enterprise addition.
It looks like your database became corrupt.
The data_engine could not find the following table: tbnVersion.
Then when it went to create it, the process failed.
You should have your dba look into this and see what happened.
I would suggest starting over with a clean database.
There are kb articles out there about doing that.
Sincerely,
Gene Howard
Principal Support Engineer,
Original Message:
Sent: 9/7/2020 8:19:00 AM
From: Nijin K
Subject: mysql community version to enterprise edition
HI all
We are trying to upgrade our mysql community version db to enterprise dition since UIM version 9.02 does not work with mysql community version
hence we upgraded our test db to enterprise edition after that data engine probe is not connecting has failed to connect to upgraded db
i have attached the data engine log please check the error and suggest where could be possible issue.
Also are there steps for this kind of migration
Regards
Nijin
------------------------------
Tools admin
DXC TECHNOLOGY
------------------------------