Changes between Version 18 and Version 19 of InstallationGuidelines/Linux/Server/ApacheMySQL

Timestamp:

01/31/12 21:27:07 (13 years ago)

Author:

Fran Boon

Comment:

Apache/MySQL tuning, switch to Git

InstallationGuidelines/Linux/Server/ApacheMySQL

@@ -24 +24 @@
 # Install Admin Tools
 apt-get install -y unzip psmisc mlocate telnet lrzsz vim elinks-lite rcconf htop sudo
+# Install Git
+apt-get install -y git-core
 # Email
 apt-get -y install exim4-config exim4-daemon-light
@@ -31 +33 @@
 ########
 apt-get -y install mysql-server python-mysqldb phpmyadmin mytop
+
+# Tune for smaller RAM setups
+sed -i 's|query_cache_size        = 16M|query_cache_size = 1M|' /etc/mysql/my.cnf
+sed -i 's|key_buffer              = 16M|key_buffer = 1M|' /etc/mysql/my.cnf
+sed -i 's|max_allowed_packet      = 16M|max_allowed_packet = 1M|' /etc/mysql/my.cnf
+
+/etc/init.d/mysql restart
 
 #########
@@ -44 +53 @@
 sed -i 's|</IfModule>|WSGIPassAuthorization On|' /etc/apache2/mods-enabled/wsgi.conf
 echo "</IfModule>" >> /etc/apache2/mods-enabled/wsgi.conf
+
+# Prevent Memory leaks from killing servers
+sed -i 's|MaxRequestsPerChild   0|MaxRequestsPerChild 300|' /etc/apache2/apache2.conf
+
+# Tune for smaller RAM setups
+sed -i 's|MinSpareServers       5|MinSpareServers 3|' /etc/apache2/apache2.conf
+sed -i 's|MaxSpareServers      10|MaxSpareServers 6|' /etc/apache2/apache2.conf
 
 apache2ctl restart
@@ -64 +80 @@
 apt-get -y install python-imaging python-reportlab
 apt-get -y install python-xlwt python-xlrd
-apt-get -y install bzr
 
 #########
@@ -95 +110 @@
 cd web2py
 cd applications
-bzr branch lp:sahana-eden/stable eden
+# @ToDo: Stable branch
+git clone git://github.com/flavour/eden/git
 # Fix permissions
 chown web2py ~web2py
@@ -160 +176 @@
 cd ~web2py/applications/eden
 sed -i 's/deployment_settings.base.migrate = False/deployment_settings.base.migrate = True/g' models/000_config.py
-bzr pull
+git pull
 /usr/local/bin/maintenance
 rm -rf compiled
@@ -205 +221 @@
 # END
 }}}
-
 == After Imaging ==
 [http://eden.sahanafoundation.org/raw-attachment/wiki/InstallationGuidelines/Linux/Server/ApacheMySQL/configure-eden-apache-mysql.sh configure-eden-apache-mysql.sh]