![](http://processwire-forums.s3.us-west-2.amazonaws.com/set_resources_6/84c1e40ea0e759e3f1505eb1788ddf3c_pattern.png)
ripper2600
-
Posts
7 -
Joined
-
Last visited
Posts posted by ripper2600
-
-
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?
-
@Zeka Thanks! That's exactly what i'm looking for.
I'm updating a lots of stats via php and python. Now i can put some data into `caches` table through external scripts and fetch it from PW.
The magic date 2010-04-08 03:10:10 clearly shows 'expireNever' on https://processwire.com/api/ref/cache/ ?
I'm not sure it is ok to use
if(!$yesterday_matches) {
if return value is null.
@ZekaThanks for prompt and detailed answer!
-
Thanks for answer!
'autojoin' will not help in my case.
I should read more about cache API. I already look in `caches` table early but do not find any variables except FileCompiler__xxxx. By the way all expires rows in `caches` table have same datetime (in my case 2010-04-08 03:10:10).
-
Hi,
Is there easy way to auto load custom data from database on every page. For example Wordpress store this in wp_options and loads fields that are marked for autoload.
I have football related site and want to show how many matches are played (today,yesterday and tomorrow) but don't want to query database each time for things that will not change at least 24H.
Processwire on read-only/mysql slave
in General Support
Posted
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.