Jump to content
ripper2600

Processwire on read-only/mysql slave

Recommended Posts

Hi,

Does anyone running processwire over mySql slave server. I'm going to expand my site and load-balance incoming traffic. I know that i can move sql server into single server and connect other host to that server, but i don't want this.

I'm not using sessions and i do not have registered users except editors. Generally i want pw to render page without updating database. Maybe i can use custom configuration and init/ready.php files on slave hosts to bypass updates.

Any idea how to achieve this?

Share this post


Link to post
Share on other sites

Maybe a bit OT, but if you do not use sessions, your visits do not alter the database, it looks like you are only serving static html and assets to your regular visitors.
So are you already using ProCache? You know, with it you completely bypass the DB-server and the PHP engine. (?)

  • Like 2

Share this post


Link to post
Share on other sites

Hi Horst,

I already using ProCache with nginx, but only for static pages like blog posts and articles. I think PW altar database even if you are not log in. For example if page is not found.

The site is sport related with live stats. Initial data is loaded when the page is loaded. Then all changes on events are served via websocket in real time.

Thank you for your answer! I'm going to reorganize the site before it is too late.

  • Like 1

Share this post


Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now

  • Recently Browsing   0 members

    No registered users viewing this page.

×
×
  • Create New...