…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…and you’re wasting resources. This is the reason for some cheap environments to have Web servers also on database boxes…
Post: Rendundant Array of Inexpensive Servers
August 21, 2008 By 15 Comments
…Web server and putting it online) to be automatic or done with simple manual command. For complex and…servers before you put the load on them. I’ve seen multiple cases when something would go wrong and all servers of same configuration will experience the same…
Post: A piece of Sun/MySQL Marketing
February 27, 2008 By 7 Comments
… Virtualization, OS, Database Server, Web Server are all different. This pretty much means you have no clue on what is the best on the component… same the same about other components. Looking at container configuration – setting up 6 containers on the same box to run different MySQL and Web instances…
Post: Economics of Performance Optimization
March 13, 2008 By 9 Comments
… risks. On the Hardware side things are not so trivial as well. First there is Scale-Up of using more powerful server and there… it and get 10x capacity compared to naive implementation. At the same time one would likely get couple of boxes to spread Web and Database instances and establish…
Post: Heikki Tuuri answers to Innodb questions, Part II
November 4, 2007 By 13 Comments
…the database buffer pool can buffer many writes to the same…the number varied more, depending on the availability of RAM? On a dedicated server for Mysql you will still need some memory for the OS and the…
Post: MySQL Replication vs DRBD Battles
April 28, 2008 By 12 Comments
…the database’s standpoint. And, nothing stops you from running two databases on two servers on…the data at the same time as running reporting queries on last month. All last month will be hot on the…
Post: TPC-H Run on MySQL 5.1 and 6.0
April 10, 2008 By 16 Comments
… and 100G data sets which was CPU bound and IO bound box on the Dell 2950 box w…ran concurrently, same can be told about 8 hard drives which this box had….database size for which you can find results published on TPC Web site. For example These Are results recently published for Microsoft SQL Server…
Post: MySQL Sizing questions
June 23, 2006 By 4 Comments
…box (including search etc). Actually with proper optimization you can even get it to 5000 orders/min from the same single server…the same for database server handling custom application – no it is not. So am I saying we do not need any sizing at all and…
Post: Large result sets vs. compression protocol
December 20, 2007 By 6 Comments
… Web application is on the same host as the database. When the database is on a dedicated server then compression essentially means trading CPU time (on both server and … The bottom line: if you’re fetching big result sets to the client, and client and MySQL are on different boxes, and the connection…
Post: When would you use SAN with MySQL ?
March 9, 2009 By 18 Comments
…on the server too which will make read caching more efficient in its memory while write buffering can too be done by MySQL and…and they look to do the same with MySQL. This works though I do not think it is the…
