Scale-Up or Scale-Out Your Database
Original post provide by PHP Everywhere - By John LimHave been reading some product literature on database scaling up and scaling out. Scaleup means scaling by moving to a bigger, more powerful server, while scaleout means scaling by adding more CPU boxes to a cluster of database servers.
SQL Server 2005
These are good introductory articles:
Oracle 10g (RAC)
These are much more sophisticated articles. Also can you spot where Oracle 10g RAC beats SQL Server 2005 in scaleout?
- Oracle RAC Best Practices (pdf)
- Practical Guidance for Deploying Large Clusters
- Capacity Planning for Large Commodity Clusters (pdf)
- Performance Collection and Analysis in Large Clusters (pdf)
- Scale-up versus scale-out using Oracle 10g with HP StorageWorks Enterprise Virtual Arrays (pdf). This article is interesting, but is more about large data warehousing benchmarks (where the SuperDome shows its power), and not the typical workload of a web farm environment.
- Testing RAC Scalability on DELL is more representative of the workload in a web farm.
The typical technique used in MySQL for massive parallelism is the Continuous Replication method where a single master db server has read-write access to the database, and the data changes are replicated over to the other database servers, which are read-only. Does anyone know how stable PostgreSQL’s replication projects are and their current status?
Previous Articles:
Phplondon Conference 2008
February 29th (Leap Year Day). phplondon.org announce their third annual community conference to be held at Inmarsat, Old Street, London.This year the conference will run two tracks and include speakers such as Derick Rethans, Wez Furlong, Scott MacVicar and Zoe Slattery.We will also be holding an extended presentation and discussion on frameworks for PHP.Visit our conference site to register.
Php|tek 2008: Chicago
Join us to hear top speakers such as Derick Rethans (eZ Systems), Lucas Nelan (Facebook), Chris Shiflett (OmniTI), Eli White (Digg) and yes, even Terry Chay (Tagged). For the past two years, php|architect's spring conference has sold out weeks before the start date, so if you're interested in attending, don't delay, and be sure to sign up ASAP!
PHP Québec 2008 : Call For Speaker
The Conference will take place in Montreal, Canada between March 12th and 14th, 2008. We are looking for speakers willing to share their expertise with Canadian and United States PHP professionals. The Conference features the PHPLab, where speakers and visitors will find solutions to actual business problems.
PHP London 2007
After the success of 2006 the PHP London user group is staging the UK's second dedicated PHP conference on Friday, 23 February 2007, in London. The conference will be a low-cost event, costing £50 for the day. Speakers include: Rasmus Lerdorf, Cal Evans, Simon Laws and Kevlin Henney.
Php|works 2007 In Atlanta
php|architect is proud to announce php|works 2007, which will take place in Atlanta Georgia (USA) on September 12-14, 2007. This year, the conference once again promises to be an excellent event for PHP developers of all levels, with talks from top PHP experts such as Derick Rethans, Chris Shiflett, Andrei Zmievski, Sara Golemon, and many more (and plenty of new faces, as well).
More Articles:
ADOdb Implementation Of Active Record: Cloning Zend_Db_DataObject
Read the tutorial. This implementation has been incorporated in the main ADOdb code branch since 4.80. Download ADOdb. Enjoy! PS: I noticed that the Preview release lacks the source code of the Zend_Db_DataObject implementation. I wonder why?
Adding Google-like Search Operators To Simple Search Boxes
Give your users instant access to your most important information.
Interaktive PHP Shell
keine 'Fatal Error' abfangen lassen und so jeder Schreibfehler zum Abbruch der Shell führt. Jan Kneschke, der Entwickler meines bevorzugten WebServers lighttpd, hat sich nun dieser Problematik angenommen und hat eine PHP Shell entwickelt, die den eingegebenen PHP Code vor dem Ausführen prüft.
Share Your OPML
Über die Webseite http://share.opml.org/ kann man seine OPML Dateien veröffentlichen und damit die abonnierten RSS Feeds anderen Leuten zugänglich machen. Das ist im Prinzip nicht weiter spektakulär. Der nette Aspekt an der Sache ist, dass man sehen kann, welche Leute die gleichen Feeds abonniert haben und ob sich so möglicherweise noch weitere interessante Feeds entdecken lassen.
Merkwürdiger OSX Absturz [update]
Wie man auf dem Bild erkennt wollte ich lediglich die Web Anwendung mit dem Apache Benchmark Tool (ab) einem kleinen Stresstest unterziehen und hatte dafür aber eigentlich keine wirklich hohen Werte eingestellt. [update] Der Fehler lässt sich reproduzieren. Lasse ich den Benchmark dreimal laufen, friert OSX ein.