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

Member
Jul 18, 2017
7
0
1
Israel
cPanel Access Level
Website Owner
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

Product Owner
Staff member
Nov 14, 2017
13,296
1,252
313
Houston
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: