Even though issue 03.05 is not out yet, I am already deep in thought about my next article for International PHP Magazine. I'm planning to tap my experience architecting and building scalable web server farms for PHP/MySQL applications to bring you an overview of the issues involved. Combined with the forthcoming issue on Enterprise PHP Coding Standards, this should flesh out some of my thinking and experience implementing PHP solutions for business-critical applications.
Some of the issues I'm considering tackling in my "Farming PHP" article include:
Load Balancing versus Round-Robin DNS
Web Log Aggregation
Separating the PHP and SQL layers via a private network:
Configuring multiple interfaces
Naming the network via /etc/hosts
Hardening the network
For failover using heartbeat
To offload read-only reporting
For local read-only operations
Similarities to a compiled model
Establishing homogeneous user/group permissions and root trust
Setting up incremental, periodic file push when necessary
Maintaining versioning on source code for possible rollback
Sound interesting? Stay tuned for more as I flesh out my thinking, prepare diagrams, and otherwise sift through my experiences bringing best-practice scalability to the powerhouse web development combination of PHP and MySQL.