MP1-4341 Add possibility to Deploy Tool to upgrade MySQL dB (1 Viewer)

[Sebastiii]

Will update installer on first post
It should be able to switch from MyISAM to InnoDB on upgrade (but only happening on MySQL 5.6 installed by deploytool (i.e 5.6.10)).
Stay tuned

 

[Sebastiii]

Installer updated in first post
So for best testing :
Install MP 1.5.0 (MySQL 5.1) -> scan some channel -> Install this installer (first page) -> it should install MySQL 5.6 + Migration from MyISAM to InnoDB

 

[elliottmc]

If you want this in 1.7.0, we NEED testing today!!!!!

Even then, we can't promise, but the merge window should be closed.

 

[elliottmc]

Oh, and we will need your logs once TV service starts up.

 

[elliottmc]

@Sebastiii will correct me if I am wrong, but I think this will still work fine if you update from 1.6.0 or if you have already updated to MySQL 5.6, so your testing is still useful.

 

[breese]

Because my server is running a few web sites and already have MySQL 5.6 installed, I have decided to test this installer as a upgrade / reinstall.


Because this is an upgrade, should the installer be asking me to also install Lav and Titan?
They are already installed. Or should I chose a different option?


I have aborted the install until I hear something
Also, is a switch I can add to the installer to create a detailed log?

 

[elliottmc]

Because my server is running a few web sites and already have MySQL 5.6 installed, I have decided to test this installer as a upgrade / reinstall.

View attachment 145154 View attachment 145155
Because this is an upgrade, should the installer be asking me to also install Lav and Titan?
They are already installed. Or should I chose a different option?
View attachment 145156 View attachment 145157

I have aborted the install until I hear something
Also, is a switch I can add to the installer to create a detailed log?

There is probably a newer version of LAVF and TitanExtended available than the one you have installed.

If you are not sure, update with MPEI first, then install.

In order for you to test the latest changes, you need to get this installed, then when you restart the TV service, it should update your database. Need logs from this and make sure everything works well afterwards.

 

[breese]

I will move forward... current Lav is 59.1 Not sure about the Titan...

 

[breese]

All seems to have gone ok but on the first startup of the client it took a long time to get beyond the initialization screen...
The client log is filled with
[2014-02-08 09:28:00,327] [Log ] [MPMain ] [DEBUG] - D3D FullRender: MP focus

Sorry for the zip files but someone / somehow I can only upload a single file at a time again.
btw: the 5.6 DB looks good from what I see

 

[Sebastiii]

@Sebastiii will correct me if I am wrong, but I think this will still work fine if you update from 1.6.0 or if you have already updated to MySQL 5.6, so your testing is still useful.

I suppose