Showing entries 1 to 6
Displaying posts with tag: PrestaShop (reset)
MariaDB 10.1 vs MySQL 5.7: Real-World Performances

I) The Best Performances Ever ? Let’s have a closer look

MariaDB 10.1 and MySQL 5.7 have been officially GAed for a few weeks now, and each company claims to have awesome performances.

MariaDB claims that the biggest improvement on its new version is scalability on massively multithreaded hardware, reaching more than 1 million queries per second on a simplified OLTP benchmark.

On the MySQL side, the same type of improvement is achieved on mixed OLTP_RO benchmark.

II) The Real-World Performances

OLTP benchmarks are great, but what is the behaviour of MySQL / MariaDB on real …

[Read more]
PrestaShop a new level of performances

I) What’s new in PrestaShop

A lot of things have been improved on PrestaShop :

  • Design
  • Invoices
  • Search
  • Performance : we have done a lot of work to improve the overall performances of PrestaShop, and reached in some cases a whooping 10x improvement.

Let’s now dig into the optimizations we have put in place, and do some benchmarks.

II) Which parts of PrestaShop are faster? 1) Faster single-threaded performances

Thanks to our internal tools (to be publicly released soon!), we quickly identified the bottlenecks of PrestaShop which were impacting directly the generation time of the pages, and hence the SEO and the user satisfaction.

At the PHP level, without the cache activated, after launching a crawl on a real shop, we collected all the datas we needed in a few minutes :

[Read more]
Resources for Database Clusters: New Chef Cookbook, New Devops Webinar for eCommerce and More

Check Out Our Latest Technical Resources for MySQL, MariaDB & MongoDB Clusters

Like every month this year, we have created new content and tools for you; here is a summary of what we’ve published this December. Please do check it out and let us know if you have any comments or feedback.

And thank you for following us in the past 12 months and for your fidelity; we look forward to “seeing” you next year as well and wish you a great start to 2015!


New Live Technical Webinars


Infrastructure automation isn’t easy, but it’s not rocket science either, says Riaan Nolan. Riaan has been in operations for the past decade, and has built over a dozen eCommerce …

[Read more]
How to setup High Availability PrestaShop on multiple servers with MariaDB Galera Cluster

November 7, 2014 By Severalnines

PrestaShop is a popular open source e-commerce software powering over 200,000 online stores, according to the company. We’ve seen a bit of interest into high availability PrestaShop setups, so this post will show you how to achieve that on multiple servers. Note that this setup not only caters for failures, but by load balancing traffic across multiple servers, it also allows the system to scale and handle more users.

This post is similar to our previous posts on web application scalability and high availability:

[Read more]
[PrestaShop] Carrier selection by postal code

To select the carrier / delivery method in PrestaShop by the postal code of the delivery address, create a file Address.php in /override/classes with this content:

class Address extends AddressCore
    protected static function getPostcodeByAddress($id_address) {
        $row = Db::getInstance()->getRow('
            SELECT `postcode`
            FROM '._DB_PREFIX_.'address a
            WHERE a.`id_address` = '.(int)($id_address));
        return $row['postcode'];

    public static function getZoneById($id_address)
        $postcode = self::getPostcodeByAddress($id_address);
        if (in_array($postcode, Array(1050)))
            return 1;
        elseif (in_array($postcode, Array(2000)))
            return 10;
        return 0;

In this example, postal code 1050 is assigned to the carrier with ID 1 and postal code 2000 is assigned to carrier ID 10 (see the carrier list …

[Read more]
[PrestaShop] Converting .htaccess to nginx include files

If you use PrestaShop and nginx, you may find this script to convert PrestaShop’s .htaccess rules into an nginx rule file useful:

print <<EOF;
fastcgi_buffers           16 128k;
fastcgi_busy_buffers_size 128k;
fastcgi_buffer_size       128k;
client_body_buffer_size   128k;
while (<>) {
    if (/^RewriteRule \^(.*) \[L\]$/) { print "rewrite ^/$1? break;\n"; }
    if (/^RewriteRule \^(.*) \[QSA,L\]$/) { print "rewrite ^/$1 break;\n"; }
    if (/^ErrorDocument (\d+) (.*)$/) { print "error_page $1 = $2;\n"; }

Save as and run with ./ <.htaccess >.htaccess.nginx. Then don’t forget to include .htaccess.nginx into your nginx site configuration and reload nginx.

If you have multiple languages or an other configuration that includes { brackets }, you may have to adapt the script.

Tested with PrestaShop …

[Read more]
Showing entries 1 to 6