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 DNSWeb Log AggregationSeparating the PHP and SQL layers via a private network:
- Configuring multiple interfacesNaming the network via /etc/hostsHardening the network
- For failover using heartbeatTo offload read-only reportingFor backupFor local read-only operations
- Similarities to a compiled modelEstablishing homogeneous user/group permissions and root trustSetting up incremental, periodic file push when necessaryOptional encodingMaintaining 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.