Jump to:

557 Posts in 3305 Topics by 244 members

Hosting Requirements

SilverStripe Forums » Hosting Requirements » Silverstripe 3.1 and MySQL table type InnoDB

What you need to consider when choosing a hosting provider and plan.

Moderators: martimiz, Sean, biapar, Willr, Ingo, swaiba, simon_w

Page: 1
Go to End
Author Topic: 234 Views
  • ramtamtam
    Avatar
    Community Member
    5 Posts

    Silverstripe 3.1 and MySQL table type InnoDB Link to this post

    Hi,

    i am running Silverstripe 3.1 on a hosted webserver that only supports table type MyISAM. Every time i run a dev/build Silverstripe tries to change the table type to InnoDB. Apparently it does not succeede, because next time i run dev/build, it tries again.
    I am wondering if this can cause any problems in the usage of Silverstripe. As far as i know transactions are supported only with InnoDB. In case the usage of MyISAM will not cause any problems, can i configure Silverstripe in a way that it does not try to change the table type?

    I know, there SHOULD be posts about this, but i could not find anything helpful.

    Thanx for your help!
    Funz3l

  • ramtamtam
    Avatar
    Community Member
    5 Posts

    Re: Silverstripe 3.1 and MySQL table type InnoDB Link to this post

    ... so i guess i just give it a try, because

    • server requirements for 3.1 do not say InnoDB is mandatory and

    • changelogs for 3.0.0 suggest that in order to use full text search one has to change default table type from innoDB to MyISAM by inserting

      DataObject::$create_table_options['MySQLDatabase'] = 'ENGINE=MyISAM';

      into _config.php. As visibility of $create_table_options apparently was changed to private later on, the only way i see is to change this setting in DataObject.php directly. Not nice, i know. But it seems to work as a dev/build now does not attempt to change table type.

    I hope i do not run into problems with mysql foreign key constraint.

    234 Views
Page: 1
Go to Top

Want to know more about the company that brought you SilverStripe? Then check out SilverStripe.com

Comments on this website? Please give feedback.