Vadim, Yeah. You can do standard benchmarks basically having single server. Cluster benchmarks require proper lab with network setup correctly etc… realistic as this is what we frequently have – tens of web servers can be talking to single MySQL server or cluster.
Comment: Should MySQL and Web Server share the same box ?
April 23, 2012 By 9 Comments
Hello Peter, It sounds like splitting the servers for both MySQL and web, will require external help either experienced developer or assistance from hosting server to split the servers. Not something easy to do even for the good-known forum owner ?
Post: Should MySQL and Web Server share the same box ?
October 16, 2006 By 9 Comments
… system in MySQL+Apache pairs or split MySQL And Web Server and place them on different boxes. Generally using separate boxes for MySQL and Web Servers is rather good practice. It is more secure – Compromising your web server does not directly give access…
Post: High availability for MySQL on Amazon EC2 - Part 6 - Publishing server location
February 16, 2011 By Leave a Comment
… HA MySQL service running on EC2. We now need to find a way to point the web servers or application servers to the HA MySQL… instance) that publishes the IP address of a newly created MySQL server. MYSQL_IP=`ec2-describe-instances -K $PK -C $CERT $NEW_INSTANCE…/update_mysql ubuntu@$IP sudo ./update_xinetd.sh $MYSQL_IP done < $TMPFILE rm $TMPFILE There are many ways to configure web/application servers, I…
Post: How Web Services world affect LAMP Stack
May 22, 2006 By 1 Comment
… for client and server application development which you might want to take into account. If you’re developing Web Service Server application you… another web application: More workers required. In my post yesterday I mentioned you might need only few “workers” – actively working web server processes… frequently you can call Web Services. So you might want to cache data on Disk – in files or MySQL tables. There are…
Post: MySQL Limitations Part 4: One thread per connection
October 27, 2010 By 14 Comments
… post is about the way MySQL handles connections, allocating one thread per connection to the server. MySQL is a single process with multiple… in the main use cases for the server. There are a lot of things MySQL doesn’t do well, but it doesn… because MySQL is a multi-threaded database for Web usage that tends to be used in sharded environments with tons of application servers…
Post: Debugging sleeping connections with MySQL
February 8, 2007 By 28 Comments
… timeouts properly. Or may be you have several connections to MySQL server and right now running query which takes that long ? In… memcached connections. Few MySQL connections (to the same host, which if usually bad idea) and connection to some external web server. You can… only helpful to debug sleeping connections with MySQL but many other cases when you see web application locking up or starting to…
Post: A piece of Sun/MySQL Marketing
February 27, 2008 By 7 Comments
… level. As you can see Everything – Hardware, Virtualization, OS, Database Server, Web Server are all different. This pretty much means you have no… up 6 containers on the same box to run different MySQL and Web instances looks highly dubious to me…. at least this… from what you would see in even typical MySQL DB box, Not mentioning Web box which typically would have very little if…
Post: Rendundant Array of Inexpensive Servers
August 21, 2008 By 15 Comments
… – for frequent failures you want to recovery (like getting spare Web server and putting it online) to be automatic or done with… and (in particular if you use MySQL Replication for HA) the switch to the new server may not be 100% clean with… may have “spares” to provide extra on demand capacity for web servers or memcached quite easily, or say increase number of slaves…
Post: Web Site Optimization: FrontEnd and BackEnd
June 26, 2008 By 12 Comments
… problems in this are going beyond Apache, PHP, Memcache and MySQL. A lot of talks on this conference was focusing on… called “FrontEnd”. The meaning of Frontend is not the frontend web server commonly used in many architectures but rather optimization on the… and only 10% fetching data from MySQL database it does not make sense to focus on MySQL optimization. If 90% is spent…
