This excellent article talks about database performance on very big system at Twitter and Paypal. The article is originated from iTnews.com.au Driving big performance using MySQL Engineers at Twitter, Paypal have joined Facebook in offering a look under the hood of the massive MySQL deployments that drive their web services. Database […]
Yearly Archives: 2012
19 posts
This article mentions common problems when performing pagination on a big data set and solutions to overcome them. Scenario When querying with a large dataset, we often use SELCT …. ORDER BY a,b,c LIMIT M, N , but do we know how does this query perform? Let’s look at the […]
PHPUnit is the de-facto standard for unit testing in PHP projects. It provides both a framework that makes the writing of tests easy as well as the functionality to easily run the tests and analyse their results. Install PEAR Download go-pear.phar Run php go-pear.phar Install PHPUnit If using a local installation, […]
Our centos system with AMD Cool and Quite activated seems to be slower under load than without cpu scaling. Another point is running a vmware server on such a host – will this feature work probably? Follow these steps to turn it off, just to make sure 😉 To immediate […]
This article mentions show popular configuration notes in popular softwares on PHP-based server: Apache, Nginx, PHP, and MySQL. 1. MySQL Should use MySQLTunner tool to analyze query_cache_size parameter is used to allocate an amount of memory to cache the frequently executed queries and return the result set back to the client. E.g.: 128M […]
This post explains how to add a new slave to the existing MySQL replication. New slave server can be added to the MySQL replication without stopping master or shutting down existing slave server. You will have to temporarily stop replication on the slave server in order to take the current […]
This article shows how to solve the error when installing Python 2.6.7 on CentOS 6: “Yum broken: No module named yum”. When installing the dropbox service in Linux command line, I did compile python 2.6.7 from source, and after that, the yum command line stopped working. As you can see, […]
This article provides basic background about location aware DNS and how to setup it to work with Bind. Article can be found at Geolocation-aware DNS with Bind. This can be referred to Bind-GeoIP and GeoDNS Bind Patch. Some bash script can be found at http://phix.me/geodns/ Can also refer to the topic “How to build […]
This article discusses on how to do Load sharing with DNS (Domain Name System). Introduction: A DNS based approach is a classical approach to sharing the load between multiple servers. DNS responds to domain name look-up requests issued by clients and returns the corresponding IP address. DNS is an Internet […]
The instructions below will walk you through the process of installing the X window system, GNOME desktop environment, and configuring VNC so that you can access it remotely. yum -y upgrade yum -y groupinstall “GNOME Desktop Environment” yum -y install vnc-server As a general rule of thumb you should never […]