Re: [mapserver-users] mapcache fastcgi

2018-10-18 Thread Sebastiano Laini
I seeded the first 4 zoom level of the sqlite cache.

Here the sqlite version
https://www.traffwebdev.uk/parking/

here the disk version
http://www.buchananmapping.co.uk/

You can compare them from 5km to 200m (the scale in the bottom right), the rest 
is not cached. Bear in mind that the disk version is accessed over 80 website 
every day so there are people there all day while the sqlite you will be the 
only one as is setup just for test at the moment.

You can see that the sqlite version is almost 4 times slower, the only 
difference is that the disk is served over http and the sqlite over https.

Server setup:

-CentOS 7

-MapServer 6

-mapCache 1.6

-sqlite3 (3.7)

the 2 servers are exactly the same and I reimage them this august.

Sebastiano Laini
Web Developer
Buchanan Computing
___
mapserver-users mailing list
mapserver-users@lists.osgeo.org
https://lists.osgeo.org/mailman/listinfo/mapserver-users

Re: [mapserver-users] mapcache fastcgi

2018-10-17 Thread Travis Kirstine
gt; nothing in it.
>
>
>
> Sebastiano Laini
>
> Web Developer
>
> Buchanan Computing
>
> *From:* Sebastiano Laini
> *Sent:* 17 October 2018 12:43
> *To:* 'mapserver-users@lists.osgeo.org' 
> *Cc:* 'Rahkonen Jukka (MML)' 
> *Subject:* RE: mapcache fastcgi
>
>
>
> Still it redirect you to that link, and btw it seems that mapcache can be
> used also as a fastCGI.
>
>
>
>
> https://mapserver.org/mapcache/install.html#cgi-fastcgi-specific-instructions
>
>
>
> Though is true that I’m reading now in the CMaker Builder section
>
>
>
> MapCache can run as a FastCGI executable. Note that the overhead of
> FastCGI is non-negligible with respect to the throughput you may obtain
> with a native Apache module. The FastCGI build is less tested, and may lag
> behind the Apache module version on some minor details. YMMV.
>
>
>
> Sebastiano Laini
>
> Web Developer
>
> Buchanan Computing
>
>
>
> *From:* Rahkonen Jukka (MML) [mailto:jukka.rahko...@maanmittauslaitos.fi
> ]
> *Sent:* 17 October 2018 12:39
> *To:* Sebastiano Laini ; '
> mapserver-users@lists.osgeo.org' 
> *Subject:* VS: mapcache fastcgi
>
>
>
> Hi,
>
>
>
> That documentation is about Mapserver, Mapcache is another software. It
> does belong to the same Mapserver but is not the same.
>
>
>
> MapCache is documented here:
> https://mapserver.org/mapcache/index.html#mapcache
>
>
>
> -Jukka Rahkonen-
>
>
>
> *Lähettäjä:* Sebastiano Laini [
> mailto:sebastiano.la...@buchanancomputing.co.uk
> ]
> *Lähetetty:* 17. lokakuuta 2018 14:33
> *Vastaanottaja:* 'mapserver-users@lists.osgeo.org' <
> mapserver-users@lists.osgeo.org>
> *Kopio:* Rahkonen Jukka (MML) 
> *Aihe:* RE: mapcache fastcgi
>
>
>
> Well, for what I can read in the documentation of mapserver:
>
> https://mapserver.org/optimization/fastcgi.html
>
> FastCGI is a protocol for keeping cgi-bin style web applications running
> as a daemon to take advantage of preserving memory caches, and amortizing
> other high startup costs (like heavy database connections) over many
> requests.
>
>
>
> It seems that using mapcache as fastCGI over apache modules it that should
> improve speed also.
>
>
>
> Sebastiano Laini
>
> Web Developer
>
> Buchanan Computing
>
>
>
> *From:* Rahkonen Jukka (MML) [mailto:jukka.rahko...@maanmittauslaitos.fi
> ]
> *Sent:* 17 October 2018 12:30
> *To:* Sebastiano Laini ; '
> mapserver-users@lists.osgeo.org' 
> *Subject:* Re: mapcache fastcgi
>
>
>
> Hi,
>
>
>
> Could you explain your plan with some more details? What I have understood
> is that you have experienced that SQLite cache is slower than disk cache in
> your environment.
>
>
>
> What I do not understand is what you are going to reach by running
> Mapcache as fastcgi instead of running it as Apache module which should be
> the faster option, and if this has some connection with the SQLite cache
> vs. disk cache comparison. Do you guess that fastcgi woud make SQLite cache
> faster?
>
>
>
> -Jukka Rahkonen-
>
>
>
>
>
> *Lähettäjä:* mapserver-users [
> mailto:mapserver-users-boun...@lists.osgeo.org
> ] *Puolesta *Sebastiano Laini
> *Lähetetty:* 17. lokakuuta 2018 12:16
> *Vastaanottaja:* 'mapserver-users@lists.osgeo.org' <
> mapserver-users@lists.osgeo.org>
> *Aihe:* [mapserver-users] mapcache fastcgi
>
>
>
> Hi all,
>
>
>
> In the end I tried MapCache with sqlite3 cache but it’s very slow compared
> with the disk cache, so I want to setup MapCache with fastCGI on CentOS 7.
>
>
>
> I don’t understand what I need to install as the fastCGI link in the
> documentation is broken and I don’t know if is up to date.
>
>
>
> I already have apache fgcid installed from default in the httpd folder and
> I use PHP in fastCGI in all the domains, so I’m sure that fastCGI it works,
> though, I still need the fastCGI library? How can I install it in CentOS 7?
>
>
>
> In my apache conf I’ve already added the lines to load the mapcache module
> and the mapcache.xml file
>
>
>
> LoadModule mapcache_modulemodules/mod_mapcache.so
>
>
>
> 
>
>
>
>   Require all granted
>
>
>
>MapCacheAlias /mapcache "/path/to/directory/mapcache.xml"
>
> 
>
>
>
>
>
> I need to leave the previous configuration and add these new lines in the
> conf files?
>
>
>
> FcgidInitialEnv "MAPCACHE_CONFIG_FILE" "/path/to/mapcache/mapcache.xml
>
>
>
> 
>
>IPCCommTimeout 120
>
>MaxProcessCount 10
>
>FcgidInitialEnv "MAPCACHE_CONFIG_FILE" "/path/to/mapcache/mapcache.xml"
>
>
>
>   Order Allow,Deny
>
>   Allow from all
>
>   SetHandler fcgid-script
>
>
>
>   ScriptAlias /map.fcgi "/path/to/mapcache/src/mapcache"
>
> 
>
>
>
>
>
> And then instead of http://myserver/mapcache I need to use
> http://myserver/fcgi-bin to access mapcache fcgi?
>
>
>
> Regards,
>
>
>
> Sebastiano Laini
>
> Web Developer
>
> Buchanan Computing
> ___
> mapserver-users mailing list
> mapserver-users@lists.osgeo.org
> https://lists.osgeo.org/mailman/listinfo/mapserver-users
___
mapserver-users mailing list
mapserver-users@lists.osgeo.org
https://lists.osgeo.org/mailman/listinfo/mapserver-users

Re: [mapserver-users] mapcache fastcgi

2018-10-17 Thread Sebastiano Laini
iano Laini [mailto:sebastiano.la...@buchanancomputing.co.uk]
Lähetetty: 17. lokakuuta 2018 14:33
Vastaanottaja: 'mapserver-users@lists.osgeo.org' 
mailto:mapserver-users@lists.osgeo.org>>
Kopio: Rahkonen Jukka (MML) 
mailto:jukka.rahko...@maanmittauslaitos.fi>>
Aihe: RE: mapcache fastcgi


Well, for what I can read in the documentation of mapserver:

https://mapserver.org/optimization/fastcgi.html

FastCGI is a protocol for keeping cgi-bin style web applications running as a 
daemon to take advantage of preserving memory caches, and amortizing other high 
startup costs (like heavy database connections) over many requests.

It seems that using mapcache as fastCGI over apache modules it that should 
improve speed also.

Sebastiano Laini
Web Developer
Buchanan Computing

From: Rahkonen Jukka (MML) [mailto:jukka.rahko...@maanmittauslaitos.fi]
Sent: 17 October 2018 12:30
To: Sebastiano Laini 
mailto:sebastiano.la...@buchanancomputing.co.uk>>;
 'mapserver-users@lists.osgeo.org' 
mailto:mapserver-users@lists.osgeo.org>>
Subject: Re: mapcache fastcgi

Hi,

Could you explain your plan with some more details? What I have understood is 
that you have experienced that SQLite cache is slower than disk cache in your 
environment.

What I do not understand is what you are going to reach by running Mapcache as 
fastcgi instead of running it as Apache module which should be the faster 
option, and if this has some connection with the SQLite cache vs. disk cache 
comparison. Do you guess that fastcgi woud make SQLite cache faster?

-Jukka Rahkonen-


Lähettäjä: mapserver-users [mailto:mapserver-users-boun...@lists.osgeo.org] 
Puolesta Sebastiano Laini
Lähetetty: 17. lokakuuta 2018 12:16
Vastaanottaja: 'mapserver-users@lists.osgeo.org' 
mailto:mapserver-users@lists.osgeo.org>>
Aihe: [mapserver-users] mapcache fastcgi

Hi all,

In the end I tried MapCache with sqlite3 cache but it's very slow compared with 
the disk cache, so I want to setup MapCache with fastCGI on CentOS 7.

I don't understand what I need to install as the fastCGI link in the 
documentation is broken and I don't know if is up to date.

I already have apache fgcid installed from default in the httpd folder and I 
use PHP in fastCGI in all the domains, so I'm sure that fastCGI it works, 
though, I still need the fastCGI library? How can I install it in CentOS 7?

In my apache conf I've already added the lines to load the mapcache module and 
the mapcache.xml file

LoadModule mapcache_modulemodules/mod_mapcache.so


   
  Require all granted
   
   MapCacheAlias /mapcache "/path/to/directory/mapcache.xml"



I need to leave the previous configuration and add these new lines in the conf 
files?

FcgidInitialEnv "MAPCACHE_CONFIG_FILE" "/path/to/mapcache/mapcache.xml


   IPCCommTimeout 120
   MaxProcessCount 10
   FcgidInitialEnv "MAPCACHE_CONFIG_FILE" "/path/to/mapcache/mapcache.xml"
   
  Order Allow,Deny
  Allow from all
  SetHandler fcgid-script
   
  ScriptAlias /map.fcgi "/path/to/mapcache/src/mapcache"



And then instead of http://myserver/mapcache I need to use 
http://myserver/fcgi-bin to access mapcache fcgi?

Regards,

Sebastiano Laini
Web Developer
Buchanan Computing
___
mapserver-users mailing list
mapserver-users@lists.osgeo.org
https://lists.osgeo.org/mailman/listinfo/mapserver-users

Re: [mapserver-users] mapcache fastcgi

2018-10-17 Thread Sebastiano Laini
nection with the SQLite cache vs. disk cache 
comparison. Do you guess that fastcgi woud make SQLite cache faster?

-Jukka Rahkonen-


Lähettäjä: mapserver-users [mailto:mapserver-users-boun...@lists.osgeo.org] 
Puolesta Sebastiano Laini
Lähetetty: 17. lokakuuta 2018 12:16
Vastaanottaja: 'mapserver-users@lists.osgeo.org' 
mailto:mapserver-users@lists.osgeo.org>>
Aihe: [mapserver-users] mapcache fastcgi

Hi all,

In the end I tried MapCache with sqlite3 cache but it's very slow compared with 
the disk cache, so I want to setup MapCache with fastCGI on CentOS 7.

I don't understand what I need to install as the fastCGI link in the 
documentation is broken and I don't know if is up to date.

I already have apache fgcid installed from default in the httpd folder and I 
use PHP in fastCGI in all the domains, so I'm sure that fastCGI it works, 
though, I still need the fastCGI library? How can I install it in CentOS 7?

In my apache conf I've already added the lines to load the mapcache module and 
the mapcache.xml file

LoadModule mapcache_modulemodules/mod_mapcache.so


   
  Require all granted
   
   MapCacheAlias /mapcache "/path/to/directory/mapcache.xml"



I need to leave the previous configuration and add these new lines in the conf 
files?

FcgidInitialEnv "MAPCACHE_CONFIG_FILE" "/path/to/mapcache/mapcache.xml


   IPCCommTimeout 120
   MaxProcessCount 10
   FcgidInitialEnv "MAPCACHE_CONFIG_FILE" "/path/to/mapcache/mapcache.xml"
   
  Order Allow,Deny
  Allow from all
  SetHandler fcgid-script
   
  ScriptAlias /map.fcgi "/path/to/mapcache/src/mapcache"



And then instead of http://myserver/mapcache I need to use 
http://myserver/fcgi-bin to access mapcache fcgi?

Regards,

Sebastiano Laini
Web Developer
Buchanan Computing
___
mapserver-users mailing list
mapserver-users@lists.osgeo.org
https://lists.osgeo.org/mailman/listinfo/mapserver-users

Re: [mapserver-users] mapcache fastcgi

2018-10-17 Thread Rahkonen Jukka (MML)
Hi,

In which way does the slowness appear? Is it when seeding or when serving from 
a pre-seeded cache? Can you give metrics about the difference in speed?

In this comparison the differences were rather small 
http://blog.sogeo.services/blog/2016/07/01/mapcache-disk-vs-sqlite.html

Also by the documentation the speed should be only "a bit slower"

The SQLite based caches are a bit slower than the disk based caches, and may 
have write-locking issues at seed time if a high number of threads all try to 
insert new tiles concurrently.

You wrote that SQLite cache is very slow for you which makes me think that 
there is something sub-optimal in your installation. First thing to check is if 
the SQLite database is on a fast disk.
If SQLite cache is slow then MBTiles cache should be slow as well but I would 
make a test to be sure.

-Jukka Rahkonen-


Lähettäjä: Sebastiano Laini [mailto:sebastiano.la...@buchanancomputing.co.uk]
Lähetetty: 17. lokakuuta 2018 15:00
Vastaanottaja: 'mapserver-users@lists.osgeo.org' 

Kopio: Rahkonen Jukka (MML) 
Aihe: RE: mapcache fastcgi

Is there a way to improve the speed and match the speed of the sqLite3 cache 
with the disk one?

We have 80 websites connected to MapCache and when I tried the sqLite3 I was 
testing it just on one website and on a complete different server with nothing 
in it.

Sebastiano Laini
Web Developer
Buchanan Computing
From: Sebastiano Laini
Sent: 17 October 2018 12:43
To: 'mapserver-users@lists.osgeo.org' 
mailto:mapserver-users@lists.osgeo.org>>
Cc: 'Rahkonen Jukka (MML)' 
mailto:jukka.rahko...@maanmittauslaitos.fi>>
Subject: RE: mapcache fastcgi

Still it redirect you to that link, and btw it seems that mapcache can be used 
also as a fastCGI.

https://mapserver.org/mapcache/install.html#cgi-fastcgi-specific-instructions

Though is true that I'm reading now in the CMaker Builder section

MapCache can run as a FastCGI executable. Note that the overhead of FastCGI is 
non-negligible with respect to the throughput you may obtain with a native 
Apache module. The FastCGI build is less tested, and may lag behind the Apache 
module version on some minor details. YMMV.

Sebastiano Laini
Web Developer
Buchanan Computing

From: Rahkonen Jukka (MML) [mailto:jukka.rahko...@maanmittauslaitos.fi]
Sent: 17 October 2018 12:39
To: Sebastiano Laini 
mailto:sebastiano.la...@buchanancomputing.co.uk>>;
 'mapserver-users@lists.osgeo.org' 
mailto:mapserver-users@lists.osgeo.org>>
Subject: VS: mapcache fastcgi

Hi,

That documentation is about Mapserver, Mapcache is another software. It does 
belong to the same Mapserver but is not the same.

MapCache is documented here:
https://mapserver.org/mapcache/index.html#mapcache

-Jukka Rahkonen-

Lähettäjä: Sebastiano Laini [mailto:sebastiano.la...@buchanancomputing.co.uk]
Lähetetty: 17. lokakuuta 2018 14:33
Vastaanottaja: 'mapserver-users@lists.osgeo.org' 
mailto:mapserver-users@lists.osgeo.org>>
Kopio: Rahkonen Jukka (MML) 
mailto:jukka.rahko...@maanmittauslaitos.fi>>
Aihe: RE: mapcache fastcgi


Well, for what I can read in the documentation of mapserver:

https://mapserver.org/optimization/fastcgi.html

FastCGI is a protocol for keeping cgi-bin style web applications running as a 
daemon to take advantage of preserving memory caches, and amortizing other high 
startup costs (like heavy database connections) over many requests.

It seems that using mapcache as fastCGI over apache modules it that should 
improve speed also.

Sebastiano Laini
Web Developer
Buchanan Computing

From: Rahkonen Jukka (MML) [mailto:jukka.rahko...@maanmittauslaitos.fi]
Sent: 17 October 2018 12:30
To: Sebastiano Laini 
mailto:sebastiano.la...@buchanancomputing.co.uk>>;
 'mapserver-users@lists.osgeo.org' 
mailto:mapserver-users@lists.osgeo.org>>
Subject: Re: mapcache fastcgi

Hi,

Could you explain your plan with some more details? What I have understood is 
that you have experienced that SQLite cache is slower than disk cache in your 
environment.

What I do not understand is what you are going to reach by running Mapcache as 
fastcgi instead of running it as Apache module which should be the faster 
option, and if this has some connection with the SQLite cache vs. disk cache 
comparison. Do you guess that fastcgi woud make SQLite cache faster?

-Jukka Rahkonen-


Lähettäjä: mapserver-users [mailto:mapserver-users-boun...@lists.osgeo.org] 
Puolesta Sebastiano Laini
Lähetetty: 17. lokakuuta 2018 12:16
Vastaanottaja: 'mapserver-users@lists.osgeo.org' 
mailto:mapserver-users@lists.osgeo.org>>
Aihe: [mapserver-users] mapcache fastcgi

Hi all,

In the end I tried MapCache with sqlite3 cache but it's very slow compared with 
the disk cache, so I want to setup MapCache with fastCGI on CentOS 7.

I don't understand what I need to install as the fastCGI link in the 
documentation is broken and I don't know if is up to date.

I already have apache fgcid installed from default in the httpd 

Re: [mapserver-users] mapcache fastcgi

2018-10-17 Thread Sebastiano Laini
Is there a way to improve the speed and match the speed of the sqLite3 cache 
with the disk one?

We have 80 websites connected to MapCache and when I tried the sqLite3 I was 
testing it just on one website and on a complete different server with nothing 
in it.

Sebastiano Laini
Web Developer
Buchanan Computing
From: Sebastiano Laini
Sent: 17 October 2018 12:43
To: 'mapserver-users@lists.osgeo.org' 
Cc: 'Rahkonen Jukka (MML)' 
Subject: RE: mapcache fastcgi

Still it redirect you to that link, and btw it seems that mapcache can be used 
also as a fastCGI.

https://mapserver.org/mapcache/install.html#cgi-fastcgi-specific-instructions

Though is true that I'm reading now in the CMaker Builder section

MapCache can run as a FastCGI executable. Note that the overhead of FastCGI is 
non-negligible with respect to the throughput you may obtain with a native 
Apache module. The FastCGI build is less tested, and may lag behind the Apache 
module version on some minor details. YMMV.

Sebastiano Laini
Web Developer
Buchanan Computing

From: Rahkonen Jukka (MML) [mailto:jukka.rahko...@maanmittauslaitos.fi]
Sent: 17 October 2018 12:39
To: Sebastiano Laini 
mailto:sebastiano.la...@buchanancomputing.co.uk>>;
 'mapserver-users@lists.osgeo.org' 
mailto:mapserver-users@lists.osgeo.org>>
Subject: VS: mapcache fastcgi

Hi,

That documentation is about Mapserver, Mapcache is another software. It does 
belong to the same Mapserver but is not the same.

MapCache is documented here:
https://mapserver.org/mapcache/index.html#mapcache

-Jukka Rahkonen-

Lähettäjä: Sebastiano Laini [mailto:sebastiano.la...@buchanancomputing.co.uk]
Lähetetty: 17. lokakuuta 2018 14:33
Vastaanottaja: 'mapserver-users@lists.osgeo.org' 
mailto:mapserver-users@lists.osgeo.org>>
Kopio: Rahkonen Jukka (MML) 
mailto:jukka.rahko...@maanmittauslaitos.fi>>
Aihe: RE: mapcache fastcgi


Well, for what I can read in the documentation of mapserver:

https://mapserver.org/optimization/fastcgi.html

FastCGI is a protocol for keeping cgi-bin style web applications running as a 
daemon to take advantage of preserving memory caches, and amortizing other high 
startup costs (like heavy database connections) over many requests.

It seems that using mapcache as fastCGI over apache modules it that should 
improve speed also.

Sebastiano Laini
Web Developer
Buchanan Computing

From: Rahkonen Jukka (MML) [mailto:jukka.rahko...@maanmittauslaitos.fi]
Sent: 17 October 2018 12:30
To: Sebastiano Laini 
mailto:sebastiano.la...@buchanancomputing.co.uk>>;
 'mapserver-users@lists.osgeo.org' 
mailto:mapserver-users@lists.osgeo.org>>
Subject: Re: mapcache fastcgi

Hi,

Could you explain your plan with some more details? What I have understood is 
that you have experienced that SQLite cache is slower than disk cache in your 
environment.

What I do not understand is what you are going to reach by running Mapcache as 
fastcgi instead of running it as Apache module which should be the faster 
option, and if this has some connection with the SQLite cache vs. disk cache 
comparison. Do you guess that fastcgi woud make SQLite cache faster?

-Jukka Rahkonen-


Lähettäjä: mapserver-users [mailto:mapserver-users-boun...@lists.osgeo.org] 
Puolesta Sebastiano Laini
Lähetetty: 17. lokakuuta 2018 12:16
Vastaanottaja: 'mapserver-users@lists.osgeo.org' 
mailto:mapserver-users@lists.osgeo.org>>
Aihe: [mapserver-users] mapcache fastcgi

Hi all,

In the end I tried MapCache with sqlite3 cache but it's very slow compared with 
the disk cache, so I want to setup MapCache with fastCGI on CentOS 7.

I don't understand what I need to install as the fastCGI link in the 
documentation is broken and I don't know if is up to date.

I already have apache fgcid installed from default in the httpd folder and I 
use PHP in fastCGI in all the domains, so I'm sure that fastCGI it works, 
though, I still need the fastCGI library? How can I install it in CentOS 7?

In my apache conf I've already added the lines to load the mapcache module and 
the mapcache.xml file

LoadModule mapcache_modulemodules/mod_mapcache.so


   
  Require all granted
   
   MapCacheAlias /mapcache "/path/to/directory/mapcache.xml"



I need to leave the previous configuration and add these new lines in the conf 
files?

FcgidInitialEnv "MAPCACHE_CONFIG_FILE" "/path/to/mapcache/mapcache.xml


   IPCCommTimeout 120
   MaxProcessCount 10
   FcgidInitialEnv "MAPCACHE_CONFIG_FILE" "/path/to/mapcache/mapcache.xml"
   
  Order Allow,Deny
  Allow from all
  SetHandler fcgid-script
   
  ScriptAlias /map.fcgi "/path/to/mapcache/src/mapcache"



And then instead of http://myserver/mapcache I need to use 
http://myserver/fcgi-bin to access mapcache fcgi?

Regards,

Sebastiano Laini
Web Developer
Buchanan Computing
___
mapserver-users mailing list
mapserver-users@lists.osgeo.org
https://lists.osgeo.org/mailman/listinfo/mapserver-users

Re: [mapserver-users] mapcache fastcgi

2018-10-17 Thread Sebastiano Laini
Still it redirect you to that link, and btw it seems that mapcache can be used 
also as a fastCGI.

https://mapserver.org/mapcache/install.html#cgi-fastcgi-specific-instructions

Though is true that I'm reading now in the CMaker Builder section

MapCache can run as a FastCGI executable. Note that the overhead of FastCGI is 
non-negligible with respect to the throughput you may obtain with a native 
Apache module. The FastCGI build is less tested, and may lag behind the Apache 
module version on some minor details. YMMV.

Sebastiano Laini
Web Developer
Buchanan Computing

From: Rahkonen Jukka (MML) [mailto:jukka.rahko...@maanmittauslaitos.fi]
Sent: 17 October 2018 12:39
To: Sebastiano Laini ; 
'mapserver-users@lists.osgeo.org' 
Subject: VS: mapcache fastcgi

Hi,

That documentation is about Mapserver, Mapcache is another software. It does 
belong to the same Mapserver but is not the same.

MapCache is documented here:
https://mapserver.org/mapcache/index.html#mapcache

-Jukka Rahkonen-

Lähettäjä: Sebastiano Laini [mailto:sebastiano.la...@buchanancomputing.co.uk]
Lähetetty: 17. lokakuuta 2018 14:33
Vastaanottaja: 'mapserver-users@lists.osgeo.org' 
mailto:mapserver-users@lists.osgeo.org>>
Kopio: Rahkonen Jukka (MML) 
mailto:jukka.rahko...@maanmittauslaitos.fi>>
Aihe: RE: mapcache fastcgi


Well, for what I can read in the documentation of mapserver:

https://mapserver.org/optimization/fastcgi.html

FastCGI is a protocol for keeping cgi-bin style web applications running as a 
daemon to take advantage of preserving memory caches, and amortizing other high 
startup costs (like heavy database connections) over many requests.

It seems that using mapcache as fastCGI over apache modules it that should 
improve speed also.

Sebastiano Laini
Web Developer
Buchanan Computing

From: Rahkonen Jukka (MML) [mailto:jukka.rahko...@maanmittauslaitos.fi]
Sent: 17 October 2018 12:30
To: Sebastiano Laini 
mailto:sebastiano.la...@buchanancomputing.co.uk>>;
 'mapserver-users@lists.osgeo.org' 
mailto:mapserver-users@lists.osgeo.org>>
Subject: Re: mapcache fastcgi

Hi,

Could you explain your plan with some more details? What I have understood is 
that you have experienced that SQLite cache is slower than disk cache in your 
environment.

What I do not understand is what you are going to reach by running Mapcache as 
fastcgi instead of running it as Apache module which should be the faster 
option, and if this has some connection with the SQLite cache vs. disk cache 
comparison. Do you guess that fastcgi woud make SQLite cache faster?

-Jukka Rahkonen-


Lähettäjä: mapserver-users [mailto:mapserver-users-boun...@lists.osgeo.org] 
Puolesta Sebastiano Laini
Lähetetty: 17. lokakuuta 2018 12:16
Vastaanottaja: 'mapserver-users@lists.osgeo.org' 
mailto:mapserver-users@lists.osgeo.org>>
Aihe: [mapserver-users] mapcache fastcgi

Hi all,

In the end I tried MapCache with sqlite3 cache but it's very slow compared with 
the disk cache, so I want to setup MapCache with fastCGI on CentOS 7.

I don't understand what I need to install as the fastCGI link in the 
documentation is broken and I don't know if is up to date.

I already have apache fgcid installed from default in the httpd folder and I 
use PHP in fastCGI in all the domains, so I'm sure that fastCGI it works, 
though, I still need the fastCGI library? How can I install it in CentOS 7?

In my apache conf I've already added the lines to load the mapcache module and 
the mapcache.xml file

LoadModule mapcache_modulemodules/mod_mapcache.so


   
  Require all granted
   
   MapCacheAlias /mapcache "/path/to/directory/mapcache.xml"



I need to leave the previous configuration and add these new lines in the conf 
files?

FcgidInitialEnv "MAPCACHE_CONFIG_FILE" "/path/to/mapcache/mapcache.xml


   IPCCommTimeout 120
   MaxProcessCount 10
   FcgidInitialEnv "MAPCACHE_CONFIG_FILE" "/path/to/mapcache/mapcache.xml"
   
  Order Allow,Deny
  Allow from all
  SetHandler fcgid-script
   
  ScriptAlias /map.fcgi "/path/to/mapcache/src/mapcache"



And then instead of http://myserver/mapcache I need to use 
http://myserver/fcgi-bin to access mapcache fcgi?

Regards,

Sebastiano Laini
Web Developer
Buchanan Computing
___
mapserver-users mailing list
mapserver-users@lists.osgeo.org
https://lists.osgeo.org/mailman/listinfo/mapserver-users

Re: [mapserver-users] mapcache fastcgi

2018-10-17 Thread Rahkonen Jukka (MML)
Sorry, MapCache documentation has link to that page as well.

Anyway, my understanding is that Apache module is the fastest alternative and 
cgi/fcgi exist mainly to be used with other http servers than Apache.  Keywords 
from presentation 
https://www.slideshare.net/tbonfort/modgeocache-mapcache-a-fast-tiling-solution-for-the-apache-web-server.
 I hope that developers can confirm if I have understood right.

Apache module•  Module = code run by the apache processes that treat requests•  
Native code•  No overhead (e.g. CGI, FastCGI)•  Does not require spawning an 
interpreter per concurrent request•  Caveats: –  Thread/process synchronization 
–  Memory management –  Security

-Jukka- Rahkonen-

Lähettäjä: mapserver-users [mailto:mapserver-users-boun...@lists.osgeo.org] 
Puolesta Rahkonen Jukka (MML)
Lähetetty: 17. lokakuuta 2018 14:39
Vastaanottaja: Sebastiano Laini ; 
'mapserver-users@lists.osgeo.org' 
Aihe: Re: [mapserver-users] mapcache fastcgi

Hi,

That documentation is about Mapserver, Mapcache is another software. It does 
belong to the same Mapserver but is not the same.

MapCache is documented here:
https://mapserver.org/mapcache/index.html#mapcache

-Jukka Rahkonen-

Lähettäjä: Sebastiano Laini [mailto:sebastiano.la...@buchanancomputing.co.uk]
Lähetetty: 17. lokakuuta 2018 14:33
Vastaanottaja: 'mapserver-users@lists.osgeo.org' 
mailto:mapserver-users@lists.osgeo.org>>
Kopio: Rahkonen Jukka (MML) 
mailto:jukka.rahko...@maanmittauslaitos.fi>>
Aihe: RE: mapcache fastcgi


Well, for what I can read in the documentation of mapserver:

https://mapserver.org/optimization/fastcgi.html

FastCGI is a protocol for keeping cgi-bin style web applications running as a 
daemon to take advantage of preserving memory caches, and amortizing other high 
startup costs (like heavy database connections) over many requests.

It seems that using mapcache as fastCGI over apache modules it that should 
improve speed also.

Sebastiano Laini
Web Developer
Buchanan Computing

From: Rahkonen Jukka (MML) [mailto:jukka.rahko...@maanmittauslaitos.fi]
Sent: 17 October 2018 12:30
To: Sebastiano Laini 
mailto:sebastiano.la...@buchanancomputing.co.uk>>;
 'mapserver-users@lists.osgeo.org' 
mailto:mapserver-users@lists.osgeo.org>>
Subject: Re: mapcache fastcgi

Hi,

Could you explain your plan with some more details? What I have understood is 
that you have experienced that SQLite cache is slower than disk cache in your 
environment.

What I do not understand is what you are going to reach by running Mapcache as 
fastcgi instead of running it as Apache module which should be the faster 
option, and if this has some connection with the SQLite cache vs. disk cache 
comparison. Do you guess that fastcgi woud make SQLite cache faster?

-Jukka Rahkonen-


Lähettäjä: mapserver-users [mailto:mapserver-users-boun...@lists.osgeo.org] 
Puolesta Sebastiano Laini
Lähetetty: 17. lokakuuta 2018 12:16
Vastaanottaja: 'mapserver-users@lists.osgeo.org' 
mailto:mapserver-users@lists.osgeo.org>>
Aihe: [mapserver-users] mapcache fastcgi

Hi all,

In the end I tried MapCache with sqlite3 cache but it’s very slow compared with 
the disk cache, so I want to setup MapCache with fastCGI on CentOS 7.

I don’t understand what I need to install as the fastCGI link in the 
documentation is broken and I don’t know if is up to date.

I already have apache fgcid installed from default in the httpd folder and I 
use PHP in fastCGI in all the domains, so I’m sure that fastCGI it works, 
though, I still need the fastCGI library? How can I install it in CentOS 7?

In my apache conf I’ve already added the lines to load the mapcache module and 
the mapcache.xml file

LoadModule mapcache_modulemodules/mod_mapcache.so


   
  Require all granted
   
   MapCacheAlias /mapcache "/path/to/directory/mapcache.xml"



I need to leave the previous configuration and add these new lines in the conf 
files?

FcgidInitialEnv "MAPCACHE_CONFIG_FILE" "/path/to/mapcache/mapcache.xml


   IPCCommTimeout 120
   MaxProcessCount 10
   FcgidInitialEnv "MAPCACHE_CONFIG_FILE" "/path/to/mapcache/mapcache.xml"
   
  Order Allow,Deny
  Allow from all
  SetHandler fcgid-script
   
  ScriptAlias /map.fcgi "/path/to/mapcache/src/mapcache"



And then instead of http://myserver/mapcache I need to use 
http://myserver/fcgi-bin to access mapcache fcgi?

Regards,

Sebastiano Laini
Web Developer
Buchanan Computing
___
mapserver-users mailing list
mapserver-users@lists.osgeo.org
https://lists.osgeo.org/mailman/listinfo/mapserver-users

Re: [mapserver-users] mapcache fastcgi

2018-10-17 Thread Rahkonen Jukka (MML)
Hi,

That documentation is about Mapserver, Mapcache is another software. It does 
belong to the same Mapserver but is not the same.

MapCache is documented here:
https://mapserver.org/mapcache/index.html#mapcache

-Jukka Rahkonen-

Lähettäjä: Sebastiano Laini [mailto:sebastiano.la...@buchanancomputing.co.uk]
Lähetetty: 17. lokakuuta 2018 14:33
Vastaanottaja: 'mapserver-users@lists.osgeo.org' 

Kopio: Rahkonen Jukka (MML) 
Aihe: RE: mapcache fastcgi


Well, for what I can read in the documentation of mapserver:

https://mapserver.org/optimization/fastcgi.html

FastCGI is a protocol for keeping cgi-bin style web applications running as a 
daemon to take advantage of preserving memory caches, and amortizing other high 
startup costs (like heavy database connections) over many requests.

It seems that using mapcache as fastCGI over apache modules it that should 
improve speed also.

Sebastiano Laini
Web Developer
Buchanan Computing

From: Rahkonen Jukka (MML) [mailto:jukka.rahko...@maanmittauslaitos.fi]
Sent: 17 October 2018 12:30
To: Sebastiano Laini 
mailto:sebastiano.la...@buchanancomputing.co.uk>>;
 'mapserver-users@lists.osgeo.org' 
mailto:mapserver-users@lists.osgeo.org>>
Subject: Re: mapcache fastcgi

Hi,

Could you explain your plan with some more details? What I have understood is 
that you have experienced that SQLite cache is slower than disk cache in your 
environment.

What I do not understand is what you are going to reach by running Mapcache as 
fastcgi instead of running it as Apache module which should be the faster 
option, and if this has some connection with the SQLite cache vs. disk cache 
comparison. Do you guess that fastcgi woud make SQLite cache faster?

-Jukka Rahkonen-


Lähettäjä: mapserver-users [mailto:mapserver-users-boun...@lists.osgeo.org] 
Puolesta Sebastiano Laini
Lähetetty: 17. lokakuuta 2018 12:16
Vastaanottaja: 'mapserver-users@lists.osgeo.org' 
mailto:mapserver-users@lists.osgeo.org>>
Aihe: [mapserver-users] mapcache fastcgi

Hi all,

In the end I tried MapCache with sqlite3 cache but it's very slow compared with 
the disk cache, so I want to setup MapCache with fastCGI on CentOS 7.

I don't understand what I need to install as the fastCGI link in the 
documentation is broken and I don't know if is up to date.

I already have apache fgcid installed from default in the httpd folder and I 
use PHP in fastCGI in all the domains, so I'm sure that fastCGI it works, 
though, I still need the fastCGI library? How can I install it in CentOS 7?

In my apache conf I've already added the lines to load the mapcache module and 
the mapcache.xml file

LoadModule mapcache_modulemodules/mod_mapcache.so


   
  Require all granted
   
   MapCacheAlias /mapcache "/path/to/directory/mapcache.xml"



I need to leave the previous configuration and add these new lines in the conf 
files?

FcgidInitialEnv "MAPCACHE_CONFIG_FILE" "/path/to/mapcache/mapcache.xml


   IPCCommTimeout 120
   MaxProcessCount 10
   FcgidInitialEnv "MAPCACHE_CONFIG_FILE" "/path/to/mapcache/mapcache.xml"
   
  Order Allow,Deny
  Allow from all
  SetHandler fcgid-script
   
  ScriptAlias /map.fcgi "/path/to/mapcache/src/mapcache"



And then instead of http://myserver/mapcache I need to use 
http://myserver/fcgi-bin to access mapcache fcgi?

Regards,

Sebastiano Laini
Web Developer
Buchanan Computing
___
mapserver-users mailing list
mapserver-users@lists.osgeo.org
https://lists.osgeo.org/mailman/listinfo/mapserver-users

Re: [mapserver-users] mapcache fastcgi

2018-10-17 Thread Sebastiano Laini
Well, for what I can read in the documentation of mapserver:

https://mapserver.org/optimization/fastcgi.html

FastCGI is a protocol for keeping cgi-bin style web applications running as a 
daemon to take advantage of preserving memory caches, and amortizing other high 
startup costs (like heavy database connections) over many requests.

It seems that using mapcache as fastCGI over apache modules it that should 
improve speed also.

Sebastiano Laini
Web Developer
Buchanan Computing

From: Rahkonen Jukka (MML) [mailto:jukka.rahko...@maanmittauslaitos.fi]
Sent: 17 October 2018 12:30
To: Sebastiano Laini ; 
'mapserver-users@lists.osgeo.org' 
Subject: Re: mapcache fastcgi

Hi,

Could you explain your plan with some more details? What I have understood is 
that you have experienced that SQLite cache is slower than disk cache in your 
environment.

What I do not understand is what you are going to reach by running Mapcache as 
fastcgi instead of running it as Apache module which should be the faster 
option, and if this has some connection with the SQLite cache vs. disk cache 
comparison. Do you guess that fastcgi woud make SQLite cache faster?

-Jukka Rahkonen-


Lähettäjä: mapserver-users [mailto:mapserver-users-boun...@lists.osgeo.org] 
Puolesta Sebastiano Laini
Lähetetty: 17. lokakuuta 2018 12:16
Vastaanottaja: 'mapserver-users@lists.osgeo.org' 
mailto:mapserver-users@lists.osgeo.org>>
Aihe: [mapserver-users] mapcache fastcgi

Hi all,

In the end I tried MapCache with sqlite3 cache but it's very slow compared with 
the disk cache, so I want to setup MapCache with fastCGI on CentOS 7.

I don't understand what I need to install as the fastCGI link in the 
documentation is broken and I don't know if is up to date.

I already have apache fgcid installed from default in the httpd folder and I 
use PHP in fastCGI in all the domains, so I'm sure that fastCGI it works, 
though, I still need the fastCGI library? How can I install it in CentOS 7?

In my apache conf I've already added the lines to load the mapcache module and 
the mapcache.xml file

LoadModule mapcache_modulemodules/mod_mapcache.so


   
  Require all granted
   
   MapCacheAlias /mapcache "/path/to/directory/mapcache.xml"



I need to leave the previous configuration and add these new lines in the conf 
files?

FcgidInitialEnv "MAPCACHE_CONFIG_FILE" "/path/to/mapcache/mapcache.xml


   IPCCommTimeout 120
   MaxProcessCount 10
   FcgidInitialEnv "MAPCACHE_CONFIG_FILE" "/path/to/mapcache/mapcache.xml"
   
  Order Allow,Deny
  Allow from all
  SetHandler fcgid-script
   
  ScriptAlias /map.fcgi "/path/to/mapcache/src/mapcache"



And then instead of http://myserver/mapcache I need to use 
http://myserver/fcgi-bin to access mapcache fcgi?

Regards,

Sebastiano Laini
Web Developer
Buchanan Computing
___
mapserver-users mailing list
mapserver-users@lists.osgeo.org
https://lists.osgeo.org/mailman/listinfo/mapserver-users

Re: [mapserver-users] mapcache fastcgi

2018-10-17 Thread Rahkonen Jukka (MML)
Hi,

Could you explain your plan with some more details? What I have understood is 
that you have experienced that SQLite cache is slower than disk cache in your 
environment.

What I do not understand is what you are going to reach by running Mapcache as 
fastcgi instead of running it as Apache module which should be the faster 
option, and if this has some connection with the SQLite cache vs. disk cache 
comparison. Do you guess that fastcgi woud make SQLite cache faster?

-Jukka Rahkonen-


Lähettäjä: mapserver-users [mailto:mapserver-users-boun...@lists.osgeo.org] 
Puolesta Sebastiano Laini
Lähetetty: 17. lokakuuta 2018 12:16
Vastaanottaja: 'mapserver-users@lists.osgeo.org' 

Aihe: [mapserver-users] mapcache fastcgi

Hi all,

In the end I tried MapCache with sqlite3 cache but it's very slow compared with 
the disk cache, so I want to setup MapCache with fastCGI on CentOS 7.

I don't understand what I need to install as the fastCGI link in the 
documentation is broken and I don't know if is up to date.

I already have apache fgcid installed from default in the httpd folder and I 
use PHP in fastCGI in all the domains, so I'm sure that fastCGI it works, 
though, I still need the fastCGI library? How can I install it in CentOS 7?

In my apache conf I've already added the lines to load the mapcache module and 
the mapcache.xml file

LoadModule mapcache_modulemodules/mod_mapcache.so


   
  Require all granted
   
   MapCacheAlias /mapcache "/path/to/directory/mapcache.xml"



I need to leave the previous configuration and add these new lines in the conf 
files?

FcgidInitialEnv "MAPCACHE_CONFIG_FILE" "/path/to/mapcache/mapcache.xml


   IPCCommTimeout 120
   MaxProcessCount 10
   FcgidInitialEnv "MAPCACHE_CONFIG_FILE" "/path/to/mapcache/mapcache.xml"
   
  Order Allow,Deny
  Allow from all
  SetHandler fcgid-script
   
  ScriptAlias /map.fcgi "/path/to/mapcache/src/mapcache"



And then instead of http://myserver/mapcache I need to use 
http://myserver/fcgi-bin to access mapcache fcgi?

Regards,

Sebastiano Laini
Web Developer
Buchanan Computing
___
mapserver-users mailing list
mapserver-users@lists.osgeo.org
https://lists.osgeo.org/mailman/listinfo/mapserver-users

[mapserver-users] mapcache fastcgi

2018-10-17 Thread Sebastiano Laini
Hi all,

In the end I tried MapCache with sqlite3 cache but it's very slow compared with 
the disk cache, so I want to setup MapCache with fastCGI on CentOS 7.

I don't understand what I need to install as the fastCGI link in the 
documentation is broken and I don't know if is up to date.

I already have apache fgcid installed from default in the httpd folder and I 
use PHP in fastCGI in all the domains, so I'm sure that fastCGI it works, 
though, I still need the fastCGI library? How can I install it in CentOS 7?

In my apache conf I've already added the lines to load the mapcache module and 
the mapcache.xml file

LoadModule mapcache_modulemodules/mod_mapcache.so


   
  Require all granted
   
   MapCacheAlias /mapcache "/path/to/directory/mapcache.xml"



I need to leave the previous configuration and add these new lines in the conf 
files?

FcgidInitialEnv "MAPCACHE_CONFIG_FILE" "/path/to/mapcache/mapcache.xml


   IPCCommTimeout 120
   MaxProcessCount 10
   FcgidInitialEnv "MAPCACHE_CONFIG_FILE" "/path/to/mapcache/mapcache.xml"
   
  Order Allow,Deny
  Allow from all
  SetHandler fcgid-script
   
  ScriptAlias /map.fcgi "/path/to/mapcache/src/mapcache"



And then instead of http://myserver/mapcache I need to use 
http://myserver/fcgi-bin to access mapcache fcgi?

Regards,

Sebastiano Laini
Web Developer
Buchanan Computing
___
mapserver-users mailing list
mapserver-users@lists.osgeo.org
https://lists.osgeo.org/mailman/listinfo/mapserver-users