s there a way to have one DB set to Antelope and another DB set to Barracuda on the same shared hosting server?

[Ram Freedman]

Hi,
Now my MySQL (5.6) uses Antelope as the file format. for another system I need the DB to be set to Barracuda file format.

Is there a way to have one DB set to Antelope and another DB set to Barracuda on the same shared hosting server?

The same question regarding innodb_large_prefix - can I set it only to one DB in a shared hosting server without changing it to all the DB on this shared hosting server?

as I understand using the SET GLOBAL command will effect the whole shared hosting server and this is something I can't do...

Is there a way to convert only the relevant MySQL DB from Antelope to Barracuda and to set the 'innodb_large_prefix' to 'ON' only on the a specific DB without changing other DB on the same shared hosting server?

Regards,
Ram


Thanks! Ram

 

[cPanelLauren]

I believe this article answers those questions: innodb_file_format Barracuda as far as I understand it barracuda should be backwards compatible and anything using antelope should be able to be converted to barracuda

For innodb_large_prefix I think it depends a lot on the version of MySQL you're using:

MySQL :: MySQL 8.0 Reference Manual :: 15.14 InnoDB Startup Options and System Variables

dev.mysql.com

MySQL :: MySQL 5.7 Reference Manual :: 14.15 InnoDB Startup Options and System Variables

dev.mysql.com