Skip to main content

Posts

MyISAM to InnoDB? Why and How

MySQL has a pluggable storage engine architecture that allows users to select the best storage engine for their application and workload. While InnoDB is by far the most popular storage engine, some users had to rely on MyISAM for its Full text search capabilities, and in some cases better performance in applications not needing transactional capabilities. Those reasons have now vanished with the release of MySQL 5.6. The best MySQL release ever indeed delivers native support for full-text search in InnoDB along with significant performance improvements. Users therefore no longer have to live with trade-offs and can rely on InnoDB for their various use cases. In this technical webinar Dale Dasker, MySQL Technical Consultant, will review some of InnoDB’s new features, including Full Text search, and improvements that have boosted InnoDB’s performance. Dale will also show you how to migrate your applications and data from MyISAM to InnoDB. He’ll include specific examples ...

Installing NGINX and PHP-FPM - Setup for NGINX

You've  gotten your system ready  to install PHP-FPM. Now this is the most complicated and quite possibly the hardest piece to the setup. Here is the overwhelming and complicated command set that you will need to enter in order to get NGINX and PHP-FPM installed on your Debian System. apt-get -t squeeze-backports install nginx-extras; apt-get install php5 php5-fpm php5-common php5-curl php5-dev php5-gd php5-imagick php5-mcrypt php5-memcache php5-mysql php5-pspell php5-snmp php5-sqlite php5-xmlrpc php5-xsl php-pear libssh2-php php5-cli At this time I create a system user for NGINX. adduser --system --no-create-home nginx This command simply creates a system user with no home directory. We will use this User later in our setup. WOW, that was tough! I know you may be tired, so this is a good time to take a break. Well now that we have installing NGINX out of the way, we can proceed to setting up NGINX and PHP-FPM to work on your system. If you are coming f...

Installing NGINX and PHP-FPM - Setup for NGINX

You've  gotten your system ready  to install PHP-FPM. Now this is the most complicated and quite possibly the hardest piece to the setup. Here is the overwhelming and complicated command set that you will need to enter in order to get NGINX and PHP-FPM installed on your Debian System. apt-get -t squeeze-backports install nginx-extras; apt-get install php5 php5-fpm php5-common php5-curl php5-dev php5-gd php5-imagick php5-mcrypt php5-memcache php5-mysql php5-pspell php5-snmp php5-sqlite php5-xmlrpc php5-xsl php-pear libssh2-php php5-cli At this time I create a system user for NGINX. adduser --system --no-create-home nginx This command simply creates a system user with no home directory. We will use this User later in our setup. WOW, that was tough! I know you may be tired, so this is a good time to take a break.

Nginx Support Enables Massive Web Application Scaling

Your web applications need to scale, especially during demanding traffic events. Nginx is a high-performance web server and reverse proxy that can help you do that. Today, we are extending our Managed Cloud  Fanatical Support to include the installation, troubleshooting, patching and performance tuning of Nginx. Specifics of what is supported can be found in the Knowledge Center article about  Cloud Servers with Managed Service Level – Spheres of Support . At its heart, Nginx is a web server, a very fast web server! The key to Nginx’s speed is its asynchronous or event driven model for serving out objects where each request and response is seen as an individual event that is then forgotten until the next event. By comparison, Apache uses a threaded model where each request ties up resources until the full request is made, responded to and the connection is terminated. There are three common use-cases where Nginx really stands out, and your Managed Cloud Support Team ca...

Step By Step Guide To Install Memcache On Linux

This post is more like a note to me, so that in future I can look up for steps involved in installing  memcache  on Linux servers like Centos or RHEL. Those of you who  follow me on twitter , will know that me and my friends spends hours trying to install memcache on one of our web server. Normally this is a five minute job, but unfortunately for us those tricks did not work out. So if you have tried YUM and APT-GET and still could not install the memcache then read on, to find the alternate( read manual, without magic ) way of doing it. When we talk about Memcache their two things that needs to be installed Memcache Daemon  know as memcached, and Memcache client  for your programing language, in this case PHP. Installing Memcache Daemon Note these steps has been taken from http://in2.php.net/manual/en/memcache.installation.php Steps to install Libevent(memcached dependency) First we need to check if libevent is installed or not? type...

PrestaShop vs Magento which is better for e-commerce

The most widespread shopping platform. There is no need to say anything more. You all know this shopping cart. It’s Magento!  One of the most user-friendly and easy to operate shopping carts. It’s  PrestaShop ! So, let’s get ready to rumble!!! Who is where It is an open source and free to download shopping cart. Magento community is extremely big and includes around 375 000 of people. More than 100 000 of Internet shops are based on Magento. The platform is available in 60 languages and this number continues to grow! Incredibly, but it seems that at the moment Magento is one of the best options and it definitely wins the first round. Don’t forget that PrestaShop is also an open source platform. And it is available in more than 40 languages. At the moment more than 50 000 of Web stores are using this platform. This number is constantly growing from year to year with amazing speed. And what is even more important all users agree that PrestaShop has far more user-fri...

How to: Dealer Locator extension for Magento

In this article I will try to explain how to build a “Dealer Locator” extension for Magento. This article is all about extension concepts, structure and planing and not the code itself. First we will start with scoping the feature. What functionality should it have? In our example, let’s imagine a client that wants a dealer locator to have “Search by nearest dealer based on ZIP/Postcode”, “Search by State”, “Search by dealer company name”. Search results should be displayed primarily on Google Map, plus it would be nice to have a table listing for those disliking the map visual style. If we extend this a bit further, we soon come to realisation that “dealers” themselves should be a customers in our Magento system. Justification for this lies in a fact that dealers should be able to do a regular purchases on our Magento store like any other customer just with special prices applied to products. Since customer in Magento has to have a customer g...