I have done API Portal installation in POC a while ago but need some clarification. Appreciate if someone can shed light,
Does API Portal 3.5 need a MySQL database to be on the same server or MySQL can exist on a different host?
Also, what is the difference between LRS Database and LRS Data Database.
Thanks in advance.
We only support off-boxing the Portal DB if you are using 'MySQL Cluster', which would provide high availability for the database. But if you are using our out of the box 'MySQL Enterprise' edition, we do not support off-boxing the DB. This should remain on-box.
*** Please note the difference between 'MySQL Cluster' and the clustering of multiple 'MySQL Enterprise' servers. 'MySQL Cluster' is a separate product line.
In regards to the lrs vs lrsdata: the lrs database contains things such as Applications, Orgs, Users, Keys, and more CMS information whereas lrsdata is all about the metrics/analysis of it.
I hope this helps!
Thanks Alec for the quick support. Appreciate it.
Hello Alec, Can you please shed more clarity on this statement 'But if you are using our out of the box 'MySQL Enterprise' edition, we do not support off-boxing the DB. This should remain on-box.'
We are using software based install , do we still get mysql enterprise edition out of box? in that case, we dont have to use our own community edition etc? I am not looking for Mysql clustering at this point.
It looks like danal03 addressed this question for you in another thread: API Portal software ships with OOB Mysql?