Jump to:

4938 Posts in 16244 Topics by 1490 members

Installing SilverStripe

SilverStripe Forums » Installing SilverStripe » Read only database

Getting SilverStripe up and running on your computer and on your web server.

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

Page: 1
Go to End
Author Topic: 1260 Views
  • tvachon
    Avatar
    Community Member
    3 Posts

    Read only database Link to this post

    Hi folks

    We'd like to be able to cut over to a read-only clone of our silverstripe database in case of master database failure, but when we try this we get:

    #

    Couldn't run query: INSERT INTO `PageView` SET Created = NOW() | The MySQL server is running with the --read-only option so it cannot execute this statement

    is there a configuration variable we can set to avoid this problem? Has anyone else had experience with this configuration?

    Thanks!

  • Fuzz10
    Avatar
    Community Member
    787 Posts

    Re: Read only database Link to this post

    Well... you could try switching off the statistics...

    Comment out in sapphire/core/control/ContentController.php
    //Statistics::collect();

    1260 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.