Development, Analysis And Research
by Andrew Johnstone
Posts Tagged ‘PHP’
A nice tip for logging data against apache logs within requests. Apache_note is a wrapper for Apache’s table_get and table_set. It edits the table of notes that exists during a request. The table’s purpose is to allow Apache modules to communicate. if (function_exists(‘apache_note’)) { if (isset($_SESSION) && !empty($_SESSION)) { apache_note(‘session_id’, session_id()); apache_note(‘users_id’, isset($_SESSION['users_id'])? $_SESSION['users_id'] : [...]
- No Comments
- Tags: Apache, Apache Logs, Graphite, Logster, LogTailer, PHP, Python
Vagrant is simply a wrapper around Virtualbox headless that allows for provisioning virtual machines with support for puppet, chef-solo, chef, and bash. This allows you to automate the deployment and sandboxing of development sites. Additional base box images can be found at vagrantbox.es. Installing Vagrant apt-get install -y ruby1.9.1 ruby1.9.1-dev ln -svf /usr/bin/ruby1.9.1 /etc/alternatives/ruby gem [...]
- No Comments
- Tags: Bash, MySQL, PHP, Slack, Virtualbox, Virtualization
PHP5.3 autoload/class_exists fail
In: PHP
10 Dec 2011Every now and then I come across a problem with PHPs autoloading whereby class_exists fails to autoload classes. I’ve noticed this with a number of PHP versions, most recently with 5.3.2-1ubuntu4.9. Typically I’ve resolved this by simply upgrading the PHP version. In the following example the initial class_exists fails until you instantiate the object and [...]
- No Comments
- Tags: Autoload, PHP
Memcached multigets – ubuntu vs debian
14 Jun 2011I Spent a little while yesterday investigating why memcached causes problems with multigets returning results and ended up comparing debian vs ubuntu. I tested from virtual machines and physical hardware of relative specs. I have also tried a combination of libmemcached libraries and tuned the tcp stack, however here are some of the results from [...]
- (2) Comments
- Tags: Debian, Memcached, PHP, Ubuntu
One of our clients Gorkana was bought by Durrants. As such I have been working on integrating and merging data. As a result I wrote a script to synchronize data between MySQL and Oracle, which is presently a one way synchronization. The implementation The script(s) to synchronize data was broken into a few scripts. Automatically [...]
- No Comments
- Tags: MySQL, Networking, Oracle, PHP, VPN
Emailing Attachments: Exim Filters and PHP streams
In: PHP
31 May 2010A while back a colleague and myself had a two week sprint to ensure that we could deliver 20k emails with up to 5mb attachments each. We experimented with 4k emails at 5mb each sending straight through the MTA, which we found to cause excessive load on the servers. Using exim filters we could add [...]
- No Comments
- Tags: Exim, Mail, PHP
Soap, XmlRpc and Rest with the Zend Framework
20 Feb 2008The Project I was recently working on a project to expose our trading systems via XmlRpc, Rest and SOAP. It was quite an interesting project, which took two of us three weeks to develop (Amongst other things). This involved creating a testbed, that would automatically generate the payload and response for each protocol. The parameters [...]
- No Comments
- Tags: API, PHP, Rest, Soap, Zend Framework, ZF
MySQL & PHP Performance Optimization Tips
25 Jun 2007In high performance web applications you will always have bottlenecks within your application. Identifying these bottlenecks and optimizing is a tedious task and typically show themselves underload. A single bad/unindexed query can bring a server to its knees. A large number of rows will also help to highlight any poor queries, and on very large [...]
- (1) Comment
- Tags: MySQL, Optimization, PHP
PHP/MySQL & the Real Time dilemma
26 Dec 2006Introduction Currently I’m working with stock market data, and its quite an interesting topic when we are getting to the point of real time data as it brings a number of new concepts into the mix. The first challenge is to import information from the feeds into our databases (MySQL), whilst this should be a [...]
- No Comments
- Tags: Ajax, MySQL, PHP
Large Binary Data and Blob’s
19 Oct 2006recently read “Binaries Belong in the Database Too” on sitepoint.com, and thought I would shed some light with regard to my experience of storing files in databases. I’m sure many of you have known this to be a taboo practice, and I would certainly agree depending on the database. A project I worked on for [...]
- No Comments
- Tags: MySQL, PHP
About this blog
Andrew Johnstone is a software engineer / lead developer working at Everlution Software.
Photostream
Archives
- January 2012
- December 2011
- June 2011
- February 2011
- January 2011
- December 2010
- July 2010
- May 2010
- April 2010
- January 2010
- December 2009
- October 2009
- June 2009
- February 2008
- July 2007
- June 2007
- April 2007
- December 2006
- October 2006
- August 2006
- July 2006
- April 2006
- March 2006
- February 2006
- January 2006
- December 2005
- November 2005
- October 2005
- August 2005
- July 2005
- June 2005
- March 2005
- June 2004
- apt-get unattended / non-interactive installation | Development, Analysis And Research: [...] previously wrote about “Installing Java & MySQL – unattended/non-interactive insta [...]
- franck: http://en.wikipedia.org/wiki/FreeBSD_jail [...]
- franck: That web server should not live in such close proximity to that SMTP server... chroot/jail may be th [...]
- Vagrant – Automating PHP Installation with bash/slack for continuous deployment | Development, Analysis And Research: [...] More examples of installing MySQL unattended can be found at Installing Java & MySQL – u [...]
- Can the NIC ucarp uses be bridged? - Admins Goodies: [...] http://ajohnstone.com/achives/running-several-vips-on-the-same-interface-with-ucarp-and-haprox [...]
- apt-get unattended / non-interactive installation
- PHP apache_note, Graphite & Logster for logging
- Vagrant – Automating PHP/MySQL Installation with bash/slack for continuous deployment
- PHP5.3 autoload/class_exists fail
- Selenium
- Installing Java & MySQL – unattended/non-interactive installation
- Memcached multigets – ubuntu vs debian
- Optimizing and testing MySQL over NFS with NetAPP
- MySQL oddity with disappearing body of stored procedures
- MySQL to Oracle synchronization using PHP over VPNC