jnunez
-
Posts
3 -
Joined
-
Last visited
Posts posted by jnunez
-
-
5 hours ago, Ian van Marwijk said:
So is there an actual issue you encounter? Or you simply find it a lot? You could try implementing memcache ...
Hi Ian. How are you?. Sorry I didn' explain it completly.
Well, I have a problem:
I have only one website with my banners, when there are more than 1200 visitors on the website at 10:00am, the databases connections passed from 10 to more than 1200 connections per second (My RDS instance connection limit is 1250ps) then the revive platform fails and in the apache error.log I can see this error:
[Mon Aug 29 11:02:01.284807 2016] [:error] [pid 3898] [client 10.240.122.187:52538] PHP Fatal error: Call to undefined method MDB2_Error::setFetchMode() in /var/www/html/lib/pear/DB/QueryTool/Query.php on line 299
My infrastructure consist:
-A Load balancer
-From 1 to 6 instances (Ussually has 2 or 3 with more than 1200 visitors) with 1.6GB of RAM and a 1 CPU 2.5 Ghz
-A Database instance (RDS) 2 CPU and 15GB of RAM.
-A bucket S3 with all images with a CDN.
It is normal that generates so many connections?
How I do an memache with a revive cluster?
-
Hello everybody, I have the following escenary:
I have a EC2 instances cluster and a RDS Database MySQL server, all in AWS. Our website has 1500 visitors per minute, and in a specific hour of the day, the connections pass from 10 to 1200 per second, with 3 EC2 intances, then there are some intermittences.
This is my revive DB configuration
[database]
type=mysql
host="my.db.com"
socket="/var/run/mysqld/mysqld.sock"
port=3306
username=revive
password="mypass"
name=ultra_ads
persistent=
mysql4_compatibility=1
protocol=tcp
compress=
ssl=
capath=
ca=[databaseCharset]
checkComplete=1
clientCharset=[databaseMysql]
statisticsSortBufferSize=[databasePgsql]
schema=Please, tell me if you need any more information or configuration file, I'm really new to this kind of service.
A lot of Database Connections
in Performance, Scalability, and Reliability
Posted · Edited by jnunez
Language
Hi first*... Thank you very much for your help.
What is the best configuration for memcache?