Skip to content

Instantly share code, notes, and snippets.

@xluffy

xluffy/0: Magento 1.12 Enterprise multi-store cluster configuration.md

Forked from parhamr/0: Magento 1.12 Enterprise multi-store cluster configuration.md
Created May 1, 2014 09:22
Show Gist options

  • Select an option

    Learn more about clone URLs
  • Save xluffy/43c0a2f1990a3ca7b877 to your computer and use it in GitHub Desktop.

Select an option

Learn more about clone URLs
Save xluffy/43c0a2f1990a3ca7b877 to your computer and use it in GitHub Desktop.
Download ZIP

Revisions

  1. @parhamr parhamr revised this gist Apr 23, 2014. 1 changed file with 1 addition and 1 deletion.
    2 changes: 1 addition & 1 deletion 0: Magento 1.12 Enterprise multi-store cluster configuration.md
    View file
    Original file line number Diff line number Diff line change
    @@ -73,7 +73,7 @@

    There are 10 hosts behind redundant, highly available hardware firewalls and hardware load balancers.

    All media assets are served through CDNs or deployed to web servers through the application repository.
    All product media assets are managed and served through Adobe’s Scene 7 service. All web media assets are managed through SFTP to a shared media host and distributed in production through Akamai CDNs. Some media assets are deployed to web servers through the application repository.

    ### Performance

  2. @parhamr parhamr revised this gist Apr 23, 2014. 1 changed file with 2 additions and 0 deletions.
    2 changes: 2 additions & 0 deletions 0: Magento 1.12 Enterprise multi-store cluster configuration.md
    View file
    Original file line number Diff line number Diff line change
    @@ -73,6 +73,8 @@

    There are 10 hosts behind redundant, highly available hardware firewalls and hardware load balancers.

    All media assets are served through CDNs or deployed to web servers through the application repository.

    ### Performance

    Over the first 90 days:
  3. @parhamr parhamr revised this gist Apr 9, 2014. 1 changed file with 1 addition and 1 deletion.
    2 changes: 1 addition & 1 deletion 0: Magento 1.12 Enterprise multi-store cluster configuration.md
    View file
    Original file line number Diff line number Diff line change
    @@ -64,7 +64,7 @@

    * 63 million monthly pageviews
    * 3.6 million unique visitors
    * 154,000 monthly checkouts
    * 154,000 monthly checkouts (peak hour: 1,364 transactions)
    * 91% of visitors from the USA
    * 39% of visits from iOS
    * 17% of visits from Android
  4. @parhamr parhamr revised this gist Apr 9, 2014. 1 changed file with 18 additions and 1 deletion.
    19 changes: 18 additions & 1 deletion 0: Magento 1.12 Enterprise multi-store cluster configuration.md
    View file
    Original file line number Diff line number Diff line change
    @@ -51,6 +51,24 @@
    * 34% of visits from iOS
    * 14% of visits from Android

    ## November 2013

    * 48 million monthly pageviews
    * 2.8 million unique visitors
    * 68,000 monthly checkouts
    * 89% of visitors from the USA
    * 39% of visits from iOS
    * 16% of visits from Android

    ## December 2013

    * 63 million monthly pageviews
    * 3.6 million unique visitors
    * 154,000 monthly checkouts
    * 91% of visitors from the USA
    * 39% of visits from iOS
    * 17% of visits from Android

    ## Web hosts

    There are 10 hosts behind redundant, highly available hardware firewalls and hardware load balancers.
    @@ -133,7 +151,6 @@ Over the first 90 days:

    There are two hosts running MySQL 5.6.11 in a master-slave configuration with warm failover.


    ### Performance

    Over the first 90 days:
  5. @parhamr parhamr revised this gist Apr 8, 2014. 1 changed file with 33 additions and 0 deletions.
    33 changes: 33 additions & 0 deletions cache — etc:network:interfaces
    View file
    Original file line number Diff line number Diff line change
    @@ -0,0 +1,33 @@
    # This file describes the network interfaces available on your system
    # and how to activate them. For more information, see interfaces(5).

    # The loopback network interface
    auto lo
    iface lo inet loopback

    auto eth0
    iface eth0 inet manual
    bond-master bond0

    auto eth1
    iface eth1 inet manual
    bond-master bond0

    auto eth2
    iface eth2 inet manual
    bond-master bond0

    auto eth3
    iface eth3 inet manual
    bond-master bond0

    auto bond0
    iface bond0 inet static
    address 10.150.0.18
    netmask 255.255.255.0
    gateway 10.150.0.1
    slaves all
    bond-miimon 100
    bond-mode 5
    up /sbin/ifenslave bond0 eth0 eth1 eth2 eth3
    down /sbin/ifenslave -d bond0 eth0 eth1 eth2 eth3
  6. @parhamr parhamr revised this gist Apr 8, 2014. 1 changed file with 71 additions and 0 deletions.
    71 changes: 71 additions & 0 deletions web — etc:sysctl.conf
    View file
    Original file line number Diff line number Diff line change
    @@ -0,0 +1,71 @@
    # Examples:
    # http://www.thern.org/projects/sysctl.conf
    # http://serverfault.com/questions/415844/linux-webhost-security-settings-in-etc-sysctl-conf

    # Backlog of incoming connections; high values ensure HTTP stability under load
    kern.ipc.somaxconn=4096
    net.core.somaxconn=4096
    net.core.netdev_max_backlog=4096
    net.ipv4.tcp_max_syn_backlog=4096

    #
    # net.inet.tcp.msl defines the Maximum Segment Life -
    #
    # FROM: http://silverwraith.com/papers/freebsd-ddos.php
    # This is the maximum amount of time to wait for an ACK in reply
    # to a SYN-ACK or FIN-ACK, in milliseconds. If an ACK is not received
    # in this time, the segment can be considered "lost" and the network
    # connection is freed.
    net.inet.tcp.msl=7500

    # Decrease TCP keepalive time
    # Default: 7200
    net.ipv4.tcp_keepalive_time=1800

    # max size of shared memory segment
    # possibly kernel.shmmax
    kern.ipc.shmmax=536870912
    kern.ipc.shmall=32768

    # Avoid a smurf attack
    net.ipv4.icmp_echo_ignore_broadcasts = 1

    # Turn on protection for bad icmp error messages
    net.ipv4.icmp_ignore_bogus_error_responses = 1

    # Turn on syncookies for SYN flood attack protection
    net.ipv4.tcp_syncookies = 1

    # Turn on and log spoofed, source routed, and redirect packets
    net.ipv4.conf.all.log_martians = 1
    net.ipv4.conf.default.log_martians = 1

    # No source routed packets here
    net.ipv4.conf.all.accept_source_route = 0
    net.ipv4.conf.default.accept_source_route = 0

    # Make sure no one can alter the routing tables
    net.ipv4.conf.all.accept_redirects = 0
    net.ipv4.conf.default.accept_redirects = 0
    net.ipv4.conf.all.secure_redirects = 0
    net.ipv4.conf.default.secure_redirects = 0

    # Don't act as a router
    net.ipv4.ip_forward = 0
    net.ipv4.conf.all.send_redirects = 0
    net.ipv4.conf.default.send_redirects = 0

    # Don't Log Spoofed Packets, Source Routed Packets, Redirect Packets
    net.ipv4.conf.all.log_martians = 0

    # This will increase the amount of memory available for socket input/output queues
    net.ipv4.tcp_rmem = 4096 25165824 25165824
    net.core.rmem_max = 25165824
    net.core.rmem_default = 25165824
    net.ipv4.tcp_wmem = 4096 65536 25165824
    net.core.wmem_max = 25165824
    net.core.wmem_default = 65536
    net.core.optmem_max = 25165824

    # Limit of open files
    fs.file-max = 131072
  7. @parhamr parhamr revised this gist Dec 20, 2013. No changes.
  8. @parhamr parhamr revised this gist Dec 20, 2013. 1 changed file with 3 additions and 3 deletions.
    6 changes: 3 additions & 3 deletions 0: Magento 1.12 Enterprise multi-store cluster configuration.md
    View file
    Original file line number Diff line number Diff line change
    @@ -102,20 +102,20 @@ Over the first 90 days:

    ### Sessions

    * average of 6–8 million keys
    * average of 6–8 million keys (20–26 GB)
    * commands per second: ~400 (peaking at 1,500 under load)
    * expirations per second: ~40

    ### Backend

    * average of ~1 million keys
    * average of ~1 million keys (6–10 GB)
    * commands per second: ~3,250 (peaking at 5,000 under load)
    * expirations per second: ~100
    * hit rate: ~85%

    ### FPC

    * average of ~450,000 keys
    * average of ~450,000 keys (4–8 GB)
    * commands per second: ~2,000 (peaking at 5,000 under load)
    * expirations per second: ~10
    * hit rate: ~80%
  9. @parhamr parhamr revised this gist Dec 3, 2013. 1 changed file with 3 additions and 3 deletions.
    6 changes: 3 additions & 3 deletions 0: Magento 1.12 Enterprise multi-store cluster configuration.md
    View file
    Original file line number Diff line number Diff line change
    @@ -103,20 +103,20 @@ Over the first 90 days:
    ### Sessions

    * average of 6–8 million keys
    * commands per second: ~400 (peaking at 1,000 under load)
    * commands per second: ~400 (peaking at 1,500 under load)
    * expirations per second: ~40

    ### Backend

    * average of ~1 million keys
    * commands per second: ~3,250
    * commands per second: ~3,250 (peaking at 5,000 under load)
    * expirations per second: ~100
    * hit rate: ~85%

    ### FPC

    * average of ~450,000 keys
    * commands per second: ~2,000 (peaking at 3,000 under load)
    * commands per second: ~2,000 (peaking at 5,000 under load)
    * expirations per second: ~10
    * hit rate: ~80%

  10. @parhamr parhamr revised this gist Dec 2, 2013. 1 changed file with 2 additions and 2 deletions.
    4 changes: 2 additions & 2 deletions 0: Magento 1.12 Enterprise multi-store cluster configuration.md
    View file
    Original file line number Diff line number Diff line change
    @@ -103,7 +103,7 @@ Over the first 90 days:
    ### Sessions

    * average of 6–8 million keys
    * commands per second: ~400
    * commands per second: ~400 (peaking at 1,000 under load)
    * expirations per second: ~40

    ### Backend
    @@ -116,7 +116,7 @@ Over the first 90 days:
    ### FPC

    * average of ~450,000 keys
    * commands per second: ~2,000
    * commands per second: ~2,000 (peaking at 3,000 under load)
    * expirations per second: ~10
    * hit rate: ~80%

  11. @parhamr parhamr revised this gist Oct 31, 2013. 1 changed file with 1 addition and 1 deletion.
    2 changes: 1 addition & 1 deletion 0: Magento 1.12 Enterprise multi-store cluster configuration.md
    View file
    Original file line number Diff line number Diff line change
    @@ -1,6 +1,6 @@
    # Magento Enterprise 1.12 cluster

    [Scaling Magento presentation with 60 slides and notes](https://docs.google.com/a/copiousinc.com/presentation/d/1rHM7LOfzgfol6FEijLjlCpTBPaYJlMbI-WPpZL59Dng/edit)
    [Scaling Magento presentation with 60 slides and notes](https://docs.google.com/a/copiousinc.com/presentation/d/1rHM7LOfzgfol6FEijLjlCpTBPaYJlMbI-WPpZL59Dng/edit), which was then [reviewed by Alan Storm](http://alanstorm.com/scaling_magento_at_copious).

    ## Table of Contents

  12. @parhamr parhamr revised this gist Oct 31, 2013. 1 changed file with 11 additions and 1 deletion.
    12 changes: 11 additions & 1 deletion 0: Magento 1.12 Enterprise multi-store cluster configuration.md
    View file
    Original file line number Diff line number Diff line change
    @@ -1,5 +1,7 @@
    # Magento Enterprise 1.12 cluster

    [Scaling Magento presentation with 60 slides and notes](https://docs.google.com/a/copiousinc.com/presentation/d/1rHM7LOfzgfol6FEijLjlCpTBPaYJlMbI-WPpZL59Dng/edit)

    ## Table of Contents

    * [Summary](#summary)
    @@ -55,6 +57,8 @@ There are 10 hosts behind redundant, highly available hardware firewalls and har

    ### Performance

    Over the first 90 days:

    * site-wide average response time: 282 ms
    * load average: 0.6 to 1.0 (in tests, performance degrades by 35% when load averages hit ~5.0)
    * CPU utilization averages 14%
    @@ -87,6 +91,8 @@ Three Redis instances are used to increase throughput and provide fine-tuning of

    ### Performance

    Over the first 90 days:

    * 3,000 commands per second
    * 0.7 ms average response time
    * load average of 1.0 to 1.5
    @@ -130,6 +136,8 @@ There are two hosts running MySQL 5.6.11 in a master-slave configuration with wa

    ### Performance

    Over the first 90 days:

    * 1,500 commands per second
    * 1.1 ms average response time
    * load average of 0.1 (master) and 0.4 (slave)
    @@ -139,8 +147,10 @@ There are two hosts running MySQL 5.6.11 in a master-slave configuration with wa

    ### Statistics

    Over the first 100 days:

    * 42 TB of transmitted data
    * 23 TB of innodb writes in 90 days
    * 23 TB of innodb writes
    * 8.4 TB of innodb log churn
    * 100% thread cache hit rate
    * 99.996% table cache hit rate (large number of open tables possibly related to MySQL bugs #16244691 and #65384)
  13. @parhamr parhamr revised this gist Oct 31, 2013. 1 changed file with 11 additions and 1 deletion.
    12 changes: 11 additions & 1 deletion Magento Catalog Tests.md
    View file
    Original file line number Diff line number Diff line change
    @@ -23,7 +23,7 @@ my $Test = Test::Builder->new;
    local $| = 1;

    # define configurations here

    #
    # and then use the configurations…

    my $dsn = "dbi:mysql:$sourceDatabase:$sourceHost:$sourcePort";
    @@ -38,6 +38,16 @@ row_ok(sql => "SELECT COUNT(*) AS count FROM catalog_product_entity",
    tests => { '>' => { count => 80000 } },
    label => 'There are more than 80,000 product entity records.');
    $Test->note($sourceConn->selectrow_array('SELECT COUNT(*) AS count FROM catalog_product_entity'));

    # The tests continue…
    #

    # Finalize
    done_testing();

    $sourceConn->disconnect;


    ```

    ### Tests in English
  14. @parhamr parhamr revised this gist Oct 31, 2013. 1 changed file with 72 additions and 0 deletions.
    72 changes: 72 additions & 0 deletions Magento Catalog Tests.md
    View file
    Original file line number Diff line number Diff line change
    @@ -0,0 +1,72 @@
    ## Magento Catalog Tests

    ### Perl

    The Magento catalog tests are written in Perl and run through Ubuntu cron. The `Test::DatabaseRow` module is used as it provides convenient syntax to check values returned from `SELECT` statements. Here’s an excerpt of the test file:

    ```perl
    #!/usr/bin/perl -w
    use strict;
    use warnings;
    use DBI;
    use DBD::mysql;
    use POSIX;

    # Testing dependencies
    use Test::More;
    use Test::Builder;
    use Test::DatabaseRow;

    my $Test = Test::Builder->new;

    # turn on autoflush for progress
    local $| = 1;

    # define configurations here

    # and then use the configurations…

    my $dsn = "dbi:mysql:$sourceDatabase:$sourceHost:$sourcePort";
    our $sourceConn = DBI->connect($dsn, $sourceUser, $sourcePass) || die $DBI::errstr;
    isnt( $sourceConn, undef, "Source database connection is present." );

    local $Test::DatabaseRow::dbh = $sourceConn;

    # Simple counts
    #over 100,000 records 7/23/2013
    row_ok(sql => "SELECT COUNT(*) AS count FROM catalog_product_entity",
    tests => { '>' => { count => 80000 } },
    label => 'There are more than 80,000 product entity records.');
    $Test->note($sourceConn->selectrow_array('SELECT COUNT(*) AS count FROM catalog_product_entity'));
    ```

    ### Tests in English

    SQL has been written to validate these criteria:

    1. There are more than 80,000 product entity records.
    2. There are at least 2,200 categories.
    3. There are more than 80,000 catalog inventory records.
    4. There are at least 30 admin users.
    5. There are at least 2,800 CMS blocks.
    6. There are at least 1,200 CMS pages.
    7. There are at least 400 combo products.
    8. There are at least 50,000 product relations.
    9. There are more than 10,000 in stock and enabled configurable products.
    10. There are 669 EAV attributes.
    11. No catalog rules are active.
    12. Fewer than 0.1 percent of catalog inventory records are missing product records.
    13. Fewer than 1 percent of catalog product records are missing inventory records.
    14. The maximum category nesting level is 6.
    15. There is only one level 0 category.
    16. There are only two level 1 categories.
    17. The largest category has between 2,000 and 3,000 products.
    18. Less than 0.1 percent of categories have non-existent parent categories.
    19. Less than 0.1 percent of categories have non-existent parents.
    20. No simple products are missing SKUs.
    21. One configurable product is missing SKU.
    22. No products have negative inventory.
    23. No parents of EAV entities are missing.
    24. No simple products have prices of zero.
    25. All web stores have Ship to Store methods.

  15. @parhamr parhamr revised this gist Oct 18, 2013. 1 changed file with 1 addition and 1 deletion.
    2 changes: 1 addition & 1 deletion 0: Magento 1.12 Enterprise multi-store cluster configuration.md
    View file
    Original file line number Diff line number Diff line change
    @@ -3,7 +3,7 @@
    ## Table of Contents

    * [Summary](#summary)
    * [August 2013 traffic](#august-2013-traffic
    * [August 2013 traffic](#august-2013-traffic)
    * [Web hosts](#web-hosts)
    * [Performance](#performance)
    * [Configuration](#modules)
  16. @parhamr parhamr revised this gist Oct 18, 2013. 4 changed files with 76 additions and 19 deletions.
    59 changes: 57 additions & 2 deletions 0: Magento 1.12 Enterprise multi-store cluster configuration.md
    View file
    Original file line number Diff line number Diff line change
    @@ -1,12 +1,37 @@
    # Magento 1.12 cluster

    # Magento Enterprise 1.12 cluster

    ## Table of Contents

    * [Summary](#summary)
    * [August 2013 traffic](#august-2013-traffic
    * [Web hosts](#web-hosts)
    * [Performance](#performance)
    * [Configuration](#modules)
    * [Cache hosts](#cache-hosts)
    * [Performance](#performance)
    * [Sessions](#sessions)
    * [Backend](#backend)
    * [FPC](#fpc)
    * [Configuration](#configuration)
    * [Database hosts](#database-hosts)
    * [Performance](#performance)
    * [Statistics](#statistics)
    * [Configuration](#configuration)
    * [Utility hosts](#utility-hosts)

    ------

    ## Summary

    * Peak capacity of 100,000 orders in a day (4,000 an hour or 80/minute burst)
    * 806,000 lines of code (100,000 lines more than core + Zend)
    * 97% PHP
    * 1.6% Ruby
    * 0.45% Perl
    * 0.28% Shell
    * 0.12% Python
    * Admin users: 46
    * Nearly 2,000 internal users (managers and employees)
    * Categories: 2,450 (largest one has 2,400 products)
    * Product entities: 101,000
    * Combo products: 484
    @@ -112,11 +137,41 @@ There are two hosts running MySQL 5.6.11 in a master-slave configuration with wa
    * disk IO averages 1% (master) and 0.5% (slave)
    * network throughput averages 40 mbps transmitted (slave) and 0.7 mbps received (master)

    ### Statistics

    * 42 TB of transmitted data
    * 23 TB of innodb writes in 90 days
    * 8.4 TB of innodb log churn
    * 100% thread cache hit rate
    * 99.996% table cache hit rate (large number of open tables possibly related to MySQL bugs #16244691 and #65384)
    * 99.9999993% of table locks are immediate (most are nightly processes)
    * Innodb_buffer_pool_wait_free: 0
    * Innodb_log_waits: 0
    * 85% query cache hit rate; this doesn’t really mean anything with such high churn rate of data
    * 94.5% of temp tables are in memory (only nightly processes require disk tables)
    * 99.97% of queries are faster than 200 ms; we’ve reached a plateau of optimization
    * The average row lock is a bit slow as a consequence of Magento indexing architecture and our background processing queues
    * Moderate rate of random and sequential reads (table scans!), but we can absorb that overhead with hardware and focus on improving PHP code


    ### Configuration

    Host:

    * Ubuntu 12.04 LTS 64-bit
    * 3.5.0-34-generic GNU/Linux
    * Quad Intel(R) Xeon(R) CPU E7- 2860 @ 2.27GHz (10 cores each)
    * 128 GB buffered DDR3 1333 MHz RAM
    * SSD, RAID 1+0, hardware controller
    * MySQL 5.6.11 with tcmalloc

    See also: [MySQL configurations](#file-data-etc-mysql-my-cnf)


    ## Utility hosts

    These run cron and systems tasks. Daily backups are stored offsite and verified functional! :)

    Scripts are in: Bash, Ruby, Perl, Python, and PHP.

    Chef Server 10 for deployments and configuration management. Database tests, using Perl’s Test::DatabaseRow, are used to catch some human errors.
    18 changes: 13 additions & 5 deletions data etc:mysql:my.cnf
    View file
    Original file line number Diff line number Diff line change
    @@ -30,19 +30,22 @@ sort_buffer_size = 24M
    read_buffer_size = 8M
    read_rnd_buffer_size = 24M
    join_buffer_size = 128M
    # for some nightly processes client sessions set the join buffer to 8 GB

    auto-increment-increment = 1
    auto-increment-offset = 1

    myisam-recover = BACKUP
    max_connections = 400
    max_connect_errors = 10
    max_connections = 1024
    # max connect errors artificially high to support behaviors of NetScaler monitors
    max_connect_errors = 999999
    concurrent_insert = 2
    connect_timeout = 10
    connect_timeout = 5
    wait_timeout = 180
    net_read_timeout = 30
    net_write_timeout = 30
    net_read_timeout = 120
    net_write_timeout = 120
    back_log = 128
    # this table_open_cache might be too low because of MySQL bugs #16244691 and #65384)
    table_open_cache = 12288
    tmp_table_size = 512M
    max_heap_table_size = 512M
    @@ -51,9 +54,12 @@ open-files-limit = 8192
    open-files = 1024

    query_cache_type=1
    # large query limit supports SOAP and REST API integrations
    query_cache_limit = 4M
    # larger than 512 MB query cache size is problematic; this is typically ~60% full
    query_cache_size = 512M

    # set to true on read slaves
    read_only = false

    slow_query_log_file = /var/log/mysql/slow.log
    @@ -72,10 +78,12 @@ server-id=1
    innodb_data_home_dir = /usr/local/mysql/data
    innodb_log_group_home_dir = /usr/local/mysql/data

    # SSD RAID10 technically has a write capacity of 10000 IOPS
    innodb_io_capacity = 400
    innodb_file_per_table
    innodb_table_locks = true
    innodb_lock_wait_timeout = 30
    # These servers have 80 CPU threads; match 1:1
    innodb_thread_concurrency = 80
    innodb_commit_concurrency = 2
    innodb_support_xa = true
    15 changes: 4 additions & 11 deletions web — etc:php5:fpm:php.ini
    View file
    Original file line number Diff line number Diff line change
    @@ -25,15 +25,17 @@ disable_functions = pcntl_alarm,pcntl_fork,pcntl_waitpid,pcntl_wait,pcntl_wifexi
    disable_classes =
    ; user abort is difficult to detect behind load balancers; for safety, complete full requests
    ignore_user_abort = On
    ; realpath_cache_size is much larger than default to support the large file structure of Magento
    realpath_cache_size = 256k
    realpath_cache_ttl = 300
    zend.enable_gc = On
    zend.ze1_compatibility_mode = off
    expose_php = Off
    max_execution_time = 120
    max_input_time = 60
    ;max_input_nesting_level = 64
    ; max input vars is 8000 on admin servers
    max_input_vars = 1000
    ; memory limit is 8 GB on admin servers
    memory_limit = 512M
    error_reporting = E_ALL & ~E_DEPRECATED
    display_errors = Off
    @@ -43,24 +45,16 @@ log_errors_max_len = 1024
    ignore_repeated_errors = Off
    ignore_repeated_source = Off
    report_memleaks = On
    ;report_zend_debug = 0
    track_errors = Off
    ;xmlrpc_errors = 0
    ;xmlrpc_error_number = 0
    html_errors = Off
    ;docref_root = "/phpmanual/"
    ;docref_ext = .html
    ;error_prepend_string = "<span style='color: #ff0000'>"
    ;error_append_string = "</span>"
    error_log = /var/log/php/php5-fpm.error.log
    ;arg_separator.output = "&amp;"
    ;arg_separator.input = ";&"
    variables_order = "GPCS"
    request_order = "GP"
    register_globals = Off
    register_long_arrays = Off
    register_argc_argv = Off
    auto_globals_jit = On
    ; large POST size to support SOAP and REST APIs
    post_max_size = 16M
    magic_quotes_gpc = Off
    magic_quotes_runtime = Off
    @@ -70,7 +64,6 @@ auto_append_file =
    default_mimetype = "text/html"
    enable_dl = Off
    cgi.force_redirect = 1
    ;cgi.nph = 1
    cgi.redirect_status_env = ;
    cgi.fix_pathinfo=1
    file_uploads = On
    3 changes: 2 additions & 1 deletion web — etc:php5:fpm:pool.d:www.conf
    View file
    Original file line number Diff line number Diff line change
    @@ -11,7 +11,8 @@ listen.allowed_clients = 127.0.0.1

    ; a fixed number of child processes
    pm = static
    ; 48 came from trial and error
    ; 6:1 ratio of PHP processes to CPU cores found through trial and error
    ; This is the lowest process count we could deploy without socket resets under crush loads
    pm.max_children = 48

    ; with static process manager, these values don’t matter:
  17. @parhamr parhamr revised this gist Oct 17, 2013. 1 changed file with 17 additions and 17 deletions.
    34 changes: 17 additions & 17 deletions 0: Magento 1.12 Enterprise multi-store cluster configuration.md
    View file
    Original file line number Diff line number Diff line change
    @@ -38,11 +38,11 @@ There are 10 hosts behind redundant, highly available hardware firewalls and har

    ### Configuration

    Ubuntu 12.04 LTS 64-bit
    3.5.0-36-generic GNU/Linux kernel
    Dual Intel(R) Xeon(R) CPU E3-1230 V2 @ 3.30GHz (4 cores each)
    32 GB DDR3 1333 MHz RAM
    PHP-FPM, 5.3.10-1ubuntu3.7
    * Ubuntu 12.04 LTS 64-bit
    * 3.5.0-36-generic GNU/Linux kernel
    * Dual Intel(R) Xeon(R) CPU E3-1230 V2 @ 3.30GHz (4 cores each)
    * 32 GB DDR3 1333 MHz RAM
    * PHP-FPM, 5.3.10-1ubuntu3.7

    ### Modules

    @@ -91,12 +91,12 @@ Three Redis instances are used to increase throughput and provide fine-tuning of

    ### Configuration

    Ubuntu 12.04 LTS 64-bit
    3.2.0-48-generic GNU/Linux kernel
    Quad Intel(R) Xeon(R) CPU E5-2620 0 @ 2.00GHz (6 cores each)
    128 GB buffered DDR3 1333 MHz RAM
    Mechanical disks, RAID 1, hardware controller
    Redis 2.6.11
    * Ubuntu 12.04 LTS 64-bit
    * 3.2.0-48-generic GNU/Linux kernel
    * Quad Intel(R) Xeon(R) CPU E5-2620 0 @ 2.00GHz (6 cores each)
    * 128 GB buffered DDR3 1333 MHz RAM
    * Mechanical disks, RAID 1, hardware controller
    * Redis 2.6.11

    ## Database hosts

    @@ -114,9 +114,9 @@ There are two hosts running MySQL 5.6.11 in a master-slave configuration with wa

    ### Configuration

    Ubuntu 12.04 LTS 64-bit
    3.5.0-34-generic GNU/Linux
    Quad Intel(R) Xeon(R) CPU E7- 2860 @ 2.27GHz (10 cores each)
    128 GB buffered DDR3 1333 MHz RAM
    SSD, RAID 1+0, hardware controller
    MySQL 5.6.11 with tcmalloc
    * Ubuntu 12.04 LTS 64-bit
    * 3.5.0-34-generic GNU/Linux
    * Quad Intel(R) Xeon(R) CPU E7- 2860 @ 2.27GHz (10 cores each)
    * 128 GB buffered DDR3 1333 MHz RAM
    * SSD, RAID 1+0, hardware controller
    * MySQL 5.6.11 with tcmalloc
  18. @parhamr parhamr renamed this gist Oct 17, 2013. 1 changed file with 6 additions and 5 deletions.
    11 changes: 6 additions & 5 deletions ...erprise multi-store cluster configuration → ...rise multi-store cluster configuration.md
    View file
    Original file line number Diff line number Diff line change
    @@ -1,10 +1,11 @@
    # Magento 1.12 cluster

    * 815,000 lines of code (100,000 lines more than core + Zend)
    * 96% PHP
    * 1.7% Perl
    * 1.5% Ruby
    * 0.5% Shell
    * 806,000 lines of code (100,000 lines more than core + Zend)
    * 97% PHP
    * 1.6% Ruby
    * 0.45% Perl
    * 0.28% Shell
    * 0.12% Python
    * Admin users: 46
    * Categories: 2,450 (largest one has 2,400 products)
    * Product entities: 101,000
  19. Reid Parham revised this gist Aug 9, 2013. 1 changed file with 0 additions and 1 deletion.
    1 change: 0 additions & 1 deletion 0: Magento 1.12 Enterprise multi-store cluster configuration
    View file
    Original file line number Diff line number Diff line change
    @@ -41,7 +41,6 @@ Ubuntu 12.04 LTS 64-bit
    3.5.0-36-generic GNU/Linux kernel
    Dual Intel(R) Xeon(R) CPU E3-1230 V2 @ 3.30GHz (4 cores each)
    32 GB DDR3 1333 MHz RAM
    Mechanical disks, RAID 1, hardware controller
    PHP-FPM, 5.3.10-1ubuntu3.7

    ### Modules
  20. Reid Parham revised this gist Aug 9, 2013. 1 changed file with 10 additions and 0 deletions.
    10 changes: 10 additions & 0 deletions 0: Magento 1.12 Enterprise multi-store cluster configuration
    View file
    Original file line number Diff line number Diff line change
    @@ -44,6 +44,16 @@ Dual Intel(R) Xeon(R) CPU E3-1230 V2 @ 3.30GHz (4 cores each)
    Mechanical disks, RAID 1, hardware controller
    PHP-FPM, 5.3.10-1ubuntu3.7

    ### Modules

    * https://github.com/colinmollenhour/Cm_RedisSession
    * https://github.com/colinmollenhour/Cm_Cache_Backend_Redis
    * https://github.com/aligent/CacheObserver.git --branch=models
    * https://github.com/aligent/Lokey_ShippingAdjustments
    * https://github.com/aligent/VF_CustomMenu.git --branch=production
    * https://github.com/Vinai/customer-activation
    * https://github.com/gknoppe-guidance/magento-cachebuster

    ## Cache hosts

    There are two hosts running Redis in a master-slave configuration with automated failover.
  21. Reid Parham revised this gist Aug 8, 2013. 1 changed file with 97 additions and 0 deletions.
    97 changes: 97 additions & 0 deletions data etc:mysql:my.cnf
    View file
    Original file line number Diff line number Diff line change
    @@ -0,0 +1,97 @@
    [client]
    port = 3306
    socket = /var/run/mysqld/mysqld.sock

    [mysqld_safe]
    socket = /var/run/mysqld/mysqld.sock
    nice = 0

    [mysqld]
    user = mysql
    pid-file = /var/run/mysqld/mysqld.pid
    socket = /var/run/mysqld/mysqld.sock
    port = 3306
    basedir = /usr/local/mysql
    # symlinks to SSD RAID 1+0 (ext4 mounted with noatime,data=writeback,noexec)
    datadir = /usr/local/mysql/data
    tmpdir = /usr/local/mysql/tmp
    skip-external-locking
    character-set-server = utf8
    collation-server = utf8_general_ci
    event_scheduler = 0

    bind-address = 10.1.0.10

    key_buffer = 512M
    max_allowed_packet = 64M
    thread_stack = 512K
    thread_cache_size = 512
    sort_buffer_size = 24M
    read_buffer_size = 8M
    read_rnd_buffer_size = 24M
    join_buffer_size = 128M

    auto-increment-increment = 1
    auto-increment-offset = 1

    myisam-recover = BACKUP
    max_connections = 400
    max_connect_errors = 10
    concurrent_insert = 2
    connect_timeout = 10
    wait_timeout = 180
    net_read_timeout = 30
    net_write_timeout = 30
    back_log = 128
    table_open_cache = 12288
    tmp_table_size = 512M
    max_heap_table_size = 512M
    bulk_insert_buffer_size = 512M
    open-files-limit = 8192
    open-files = 1024

    query_cache_type=1
    query_cache_limit = 4M
    query_cache_size = 512M

    read_only = false

    slow_query_log_file = /var/log/mysql/slow.log
    slow_query_log = 0
    long_query_time = 0.2

    expire_logs_days = 10
    max_binlog_size = 1024M
    binlog_cache_size = 32K

    sync_binlog = 0

    log-bin=mysql-bin
    server-id=1

    innodb_data_home_dir = /usr/local/mysql/data
    innodb_log_group_home_dir = /usr/local/mysql/data

    innodb_io_capacity = 400
    innodb_file_per_table
    innodb_table_locks = true
    innodb_lock_wait_timeout = 30
    innodb_thread_concurrency = 80
    innodb_commit_concurrency = 2
    innodb_support_xa = true

    innodb_buffer_pool_size = 32G
    innodb_log_file_size = 512M
    innodb_additional_mem_pool_size = 8M
    innodb_data_file_path = ibdata1:1024M:autoextend
    innodb_file_per_table
    innodb_flush_log_at_trx_commit = 1
    innodb_log_buffer_size = 2G

    skip-federated

    [mysqldump]
    quick
    quote-names
    single-transaction
    max_allowed_packet = 64M
  22. Reid Parham revised this gist Aug 8, 2013. 2 changed files with 46 additions and 0 deletions.
    29 changes: 29 additions & 0 deletions 2: deployment
    View file
    Original file line number Diff line number Diff line change
    @@ -0,0 +1,29 @@
    Open source Chef Server 10.18.2

    The following steps are performed by a Shell script when executed as user deploy on a utility host.

    1. Initialize variables
    2. Get the latest revision hash from GitHub
    3. Disable availability monitoring to prevent alerts over HTTP 503 status
    4. Switch all web and utility hosts to maintenance mode
    5. Deploy utility
    1. Stop Magento’s cron and all Resque workers
    2. Address filesystem dependencies
    3. Chef checks out the defined revision as a new release
    4. Address Magento dependencies
    5. Update all cron tasks and scripts for automation
    6. Deploy all modules
    7. Clear cache
    8. Run any migrations
    9. Start the Magento cron
    10. Start Resque workers
    6. Deploy the first web host
    1. Address filesystem dependencies
    2. Chef checks out the defined revision as a new release
    3. Address Magento dependencies
    4. Deploy all Magento modules
    7. Mark a new deployment in New Relic
    8. Enable availability monitoring services
    9. Disable load balancer services to all other web hosts
    10. Continue deployments on web hosts, sequentially bringing them online
    11. Perform Chef routines for the Endeca hosts
    17 changes: 17 additions & 0 deletions web — packages
    View file
    Original file line number Diff line number Diff line change
    @@ -0,0 +1,17 @@
    curl
    lzf
    mcelog
    modman
    php-apc
    php5-cli
    php5-curl
    php5-dev
    php5-fpm
    php5-gd
    php5-mcrypt
    php5-mysql
    php5-suhosin
    php5-xmlrpc
    phpredis
    ssmtp
    unzip
  23. Reid Parham revised this gist Aug 8, 2013. 1 changed file with 145 additions and 0 deletions.
    145 changes: 145 additions & 0 deletions web — app:etc:local.xml
    View file
    Original file line number Diff line number Diff line change
    @@ -0,0 +1,145 @@
    <?xml version="1.0"?>
    <!--
    /**
    * Magento
    *
    * NOTICE OF LICENSE
    *
    * This source file is subject to the Academic Free License (AFL 3.0)
    * that is bundled with this package in the file LICENSE_AFL.txt.
    * It is also available through the world-wide-web at this URL:
    * http://opensource.org/licenses/afl-3.0.php
    * If you did not receive a copy of the license and are unable to
    * obtain it through the world-wide-web, please send an email
    * to license@magentocommerce.com so we can send you a copy immediately.
    *
    * DISCLAIMER
    *
    * Do not edit or add to this file if you wish to upgrade Magento to newer
    * versions in the future. If you wish to customize Magento for your
    * needs please refer to http://www.magentocommerce.com for more information.
    *
    * @category Mage
    * @package Mage_Core
    * @copyright Copyright (c) 2008 Irubin Consulting Inc. DBA Varien (http://www.varien.com)
    * @license http://opensource.org/licenses/afl-3.0.php Academic Free License (AFL 3.0)
    */
    -->
    <config>
    <global>
    <install>
    <date><![CDATA[Thu, 14 Mar 2013 22:45:22 +0000]]></date>
    </install>
    <crypt>
    <key><![CDATA[redacted]]></key>
    </crypt>
    <disable_local_modules>false</disable_local_modules>
    <resources>
    <db>
    <table_prefix><![CDATA[]]></table_prefix>
    </db>
    <default_setup>
    <connection>
    <host><![CDATA[10.1.0.10]]></host>
    <username><![CDATA[redacted]]></username>
    <password><![CDATA[redacted]]></password>
    <dbname><![CDATA[redacted]]></dbname>
    <initStatements><![CDATA[SET NAMES utf8]]></initStatements>
    <model><![CDATA[mysql4]]></model>
    <type><![CDATA[pdo_mysql]]></type>
    <pdoType><![CDATA[]]></pdoType>
    <active>1</active>
    </connection>
    </default_setup>
    <default_read>
    <connection>
    <use/>
    <host><![CDATA[10.1.0.113]]></host>
    <username><![CDATA[redacted]]></username>
    <password><![CDATA[redacted]]></password>
    <dbname><![CDATA[redacted]]></dbname>
    <type>pdo_mysql</type>
    <model>mysql4</model>
    <initStatements><![CDATA[SET NAMES utf8]]></initStatements>
    <active>1</active>
    </connection>
    </default_read>
    </resources>
    <session_save><![CDATA[db]]></session_save>
    <session_cache_limiter><![CDATA[no-store, no-cache, must-revalidate, post-check=0, pre-check=0]]></session_cache_limiter>
    <redis_session>
    <host><![CDATA[10.1.0.18]]></host> <!-- Specify an absolute path if using a unix socket -->
    <port><![CDATA[6382]]></port>
    <password></password> <!-- Specify if your redis server requires authentication -->
    <timeout><![CDATA[30]]></timeout> <!-- This is the Redis connection timeout, not the locking timeout -->
    <persistent><![CDATA[]]></persistent> <!-- Specify unique string to enable persistent connections. E.g.: sess-db0 -->
    <db><![CDATA[0]]></db>
    <compression_threshold>0</compression_threshold><!-- 0 to disable -->
    <compression_lib><![CDATA[lzf]]></compression_lib>
    <log_broken_locks><![CDATA[1]]></log_broken_locks> <!-- Useful for debugging fatal errors or extremely slow pages -->
    <max_concurrency><![CDATA[48]]></max_concurrency>
    <break_after_frontend><![CDATA[6]]></break_after_frontend> <!-- Frontend arguably doesn't need locking as urgently -->
    <break_after_adminhtml><![CDATA[15]]></break_after_adminhtml>
    <bot_lifetime>300</bot_lifetime> <!-- Bots get shorter session lifetimes. 0 to disable -->
    </redis_session>
    <cache>
    <backend><![CDATA[Cm_Cache_Backend_Redis]]></backend>
    <backend_options>
    <server><![CDATA[10.1.0.18]]></server>
    <port><![CDATA[6383]]></port>
    <persistent><![CDATA[]]></persistent>
    <database><![CDATA[0]]></database>
    <password></password>
    <force_standalone><![CDATA[0]]></force_standalone><!-- 0 for phpredis, 1 for standalone PHP -->
    <connect_retries><![CDATA[2]]></connect_retries>
    <read_timeout><![CDATA[30]]></read_timeout>
    <log_level><![CDATA[4]]></log_level>
    <automatic_cleaning_factor>0</automatic_cleaning_factor>
    <compress_data><![CDATA[1]]></compress_data> <!-- 0-9 for compression level, recommended: 0 or 1 -->
    <compress_tags><![CDATA[1]]></compress_tags> <!-- 0-9 for compression level, recommended: 0 or 1 -->
    <compression_threshold>2048</compression_threshold><!-- Strings below this size will not be compressed -->
    <compression_lib><![CDATA[lzf]]></compression_lib>
    </backend_options>
    </cache>
    <full_page_cache>
    <backend><![CDATA[Cm_Cache_Backend_Redis]]></backend>
    <backend_options>
    <server><![CDATA[10.1.0.18]]></server>
    <port><![CDATA[6384]]></port>
    <persistent><![CDATA[]]></persistent>
    <database><![CDATA[0]]></database>
    <password></password>
    <force_standalone><![CDATA[0]]></force_standalone><!-- 0 for phpredis, 1 for standalone PHP -->
    <connect_retries><![CDATA[2]]></connect_retries>
    <log_level><![CDATA[4]]></log_level>
    <lifetimelimit><![CDATA[86400]]></lifetimelimit> <!-- 24 hours of lifetime for cache record -->
    <compress_data><![CDATA[0]]></compress_data> <!-- DISABLE compression for EE FPC since it already uses compression -->
    </backend_options>
    </full_page_cache>
    </global>
    <admin>
    <routers>
    <adminhtml>
    <args>
    <frontName><![CDATA[admin]]></frontName>
    </args>
    </adminhtml>
    </routers>
    </admin>
    <frontend>
    <events>
    <controller_action_predispatch>
    <observers><log><type>disabled</type></log></observers>
    </controller_action_predispatch>
    <controller_action_postdispatch>
    <observers><log><type>disabled</type></log></observers>
    </controller_action_postdispatch>
    <sales_quote_save_after>
    <observers><log><type>disabled</type></log></observers>
    </sales_quote_save_after>
    <checkout_quote_destroy>
    <observers><log><type>disabled</type></log></observers>
    </checkout_quote_destroy>
    </events>
    </frontend>
    </config>
  24. Reid Parham revised this gist Aug 8, 2013. 1 changed file with 1 addition and 766 deletions.
    767 changes: 1 addition & 766 deletions 1: Magento core_config_data
    View file
    Original file line number Diff line number Diff line change
    @@ -1,4 +1,4 @@
    mysql> select path, value, scope_id from core_config_data where path like 'web%' OR path like 'system%' or path like 'sales%' or path like 'admin%' or path like 'api%' or path like 'customer%' or path like 'cache%' or path like 'catalog%' or path like 'crontab%' or path like 'general%' or path like 'dev%' order by path\G;
    mysql> select path, value, scope_id from core_config_data where path like 'web%' OR path like 'system%' or path like 'admin%' or path like 'api%' or path like 'cache%' or path like 'dev%' order by path\G;
    *************************** 1. row ***************************
    path: admin/captcha/enable
    value: 0
    @@ -7,18 +7,6 @@ scope_id: 0
    path: admin/dashboard/enable_charts
    value: 1
    scope_id: 0
    *************************** 3. row ***************************
    path: admin/emails/forgot_email_identity
    value: general
    scope_id: 0
    *************************** 4. row ***************************
    path: admin/emails/forgot_email_template
    value: admin_emails_forgot_email_template
    scope_id: 0
    *************************** 5. row ***************************
    path: admin/emails/password_reset_link_expiration_period
    value: 1
    scope_id: 0
    *************************** 7. row ***************************
    path: admin/security/lockout_failures
    value: 6
    @@ -99,526 +87,6 @@ scope_id: 0
    path: cache/expires/page_cache
    value:
    scope_id: 0
    *************************** 27. row ***************************
    path: catalog/category/root_id
    value: 2
    scope_id: 0
    *************************** 28. row ***************************
    path: catalog/custom_options/date_fields_order
    value: m,d,y
    scope_id: 0
    *************************** 29. row ***************************
    path: catalog/custom_options/time_format
    value: 12h
    scope_id: 0
    *************************** 30. row ***************************
    path: catalog/custom_options/use_calendar
    value: 0
    scope_id: 0
    *************************** 31. row ***************************
    path: catalog/custom_options/year_range
    value: ,
    scope_id: 0
    *************************** 32. row ***************************
    path: catalog/downloadable/content_disposition
    value: inline
    scope_id: 0
    *************************** 33. row ***************************
    path: catalog/downloadable/disable_guest_checkout
    value: 1
    scope_id: 0
    *************************** 34. row ***************************
    path: catalog/downloadable/downloads_number
    value: 0
    scope_id: 0
    *************************** 35. row ***************************
    path: catalog/downloadable/links_target_new_window
    value: 1
    scope_id: 0
    *************************** 36. row ***************************
    path: catalog/downloadable/links_title
    value: Links
    scope_id: 0
    *************************** 37. row ***************************
    path: catalog/downloadable/order_item_status
    value: 9
    scope_id: 0
    *************************** 38. row ***************************
    path: catalog/downloadable/samples_title
    value: Samples
    scope_id: 0
    *************************** 39. row ***************************
    path: catalog/downloadable/shareable
    value: 0
    scope_id: 0
    *************************** 40. row ***************************
    path: catalog/enterprise_targetrule/crosssell_position_behavior
    value: 0
    scope_id: 0
    *************************** 41. row ***************************
    path: catalog/enterprise_targetrule/crosssell_position_limit
    value: 5
    scope_id: 0
    *************************** 42. row ***************************
    path: catalog/enterprise_targetrule/crosssell_rotation_mode
    value: 0
    scope_id: 0
    *************************** 43. row ***************************
    path: catalog/enterprise_targetrule/related_position_behavior
    value: 0
    scope_id: 0
    *************************** 44. row ***************************
    path: catalog/enterprise_targetrule/related_position_limit
    value: 6
    scope_id: 0
    *************************** 45. row ***************************
    path: catalog/enterprise_targetrule/related_rotation_mode
    value: 0
    scope_id: 0
    *************************** 46. row ***************************
    path: catalog/enterprise_targetrule/upsell_position_behavior
    value: 0
    scope_id: 0
    *************************** 47. row ***************************
    path: catalog/enterprise_targetrule/upsell_position_limit
    value: 8
    scope_id: 0
    *************************** 48. row ***************************
    path: catalog/enterprise_targetrule/upsell_rotation_mode
    value: 0
    scope_id: 0
    *************************** 49. row ***************************
    path: catalog/frontend/default_sort_by
    value: position
    scope_id: 0
    *************************** 50. row ***************************
    path: catalog/frontend/flat_catalog_category
    value: 1
    scope_id: 0
    *************************** 51. row ***************************
    path: catalog/frontend/flat_catalog_product
    value: 1
    scope_id: 0
    *************************** 52. row ***************************
    path: catalog/frontend/grid_per_page
    value: 24
    scope_id: 0
    *************************** 53. row ***************************
    path: catalog/frontend/grid_per_page_values
    value: 24,48,96
    scope_id: 0
    *************************** 54. row ***************************
    path: catalog/frontend/list_allow_all
    value: 0
    scope_id: 0
    *************************** 55. row ***************************
    path: catalog/frontend/list_mode
    value: grid
    scope_id: 0
    *************************** 56. row ***************************
    path: catalog/frontend/list_per_page
    value: 10
    scope_id: 0
    *************************** 57. row ***************************
    path: catalog/frontend/list_per_page_values
    value: 5,10,15,20,25
    scope_id: 0
    *************************** 58. row ***************************
    path: catalog/frontend/parse_url_directives
    value: 1
    scope_id: 0
    *************************** 59. row ***************************
    path: catalog/layered_navigation/display_product_count
    value: 1
    scope_id: 0
    *************************** 60. row ***************************
    path: catalog/layered_navigation/price_range_calculation
    value: auto
    scope_id: 0
    *************************** 61. row ***************************
    path: catalog/navigation/max_depth
    value: 2
    scope_id: 0
    *************************** 62. row ***************************
    path: catalog/price/scope
    value: 0
    scope_id: 0
    *************************** 63. row ***************************
    path: catalog/productalert/allow_price
    value: 0
    scope_id: 0
    *************************** 64. row ***************************
    path: catalog/productalert/allow_stock
    value: 0
    scope_id: 0
    *************************** 65. row ***************************
    path: catalog/productalert/email_identity
    value: general
    scope_id: 0
    *************************** 66. row ***************************
    path: catalog/productalert/email_price_template
    value: catalog_productalert_email_price_template
    scope_id: 0
    *************************** 67. row ***************************
    path: catalog/productalert/email_stock_template
    value: catalog_productalert_email_stock_template
    scope_id: 0
    *************************** 68. row ***************************
    path: catalog/productalert_cron/error_email
    value: NULL
    scope_id: 0
    *************************** 69. row ***************************
    path: catalog/productalert_cron/error_email_identity
    value: general
    scope_id: 0
    *************************** 70. row ***************************
    path: catalog/productalert_cron/error_email_template
    value: catalog_productalert_cron_error_email_template
    scope_id: 0
    *************************** 71. row ***************************
    path: catalog/productalert_cron/frequency
    value: D
    scope_id: 0
    *************************** 72. row ***************************
    path: catalog/productalert_cron/time
    value: 00,00,00
    scope_id: 0
    *************************** 73. row ***************************
    path: catalog/recently_products/compared_count
    value: 5
    scope_id: 0
    *************************** 74. row ***************************
    path: catalog/recently_products/scope
    value: website
    scope_id: 0
    *************************** 75. row ***************************
    path: catalog/recently_products/viewed_count
    value: 5
    scope_id: 0
    *************************** 76. row ***************************
    path: catalog/review/allow_guest
    value: 1
    scope_id: 0
    *************************** 77. row ***************************
    path: catalog/review/auto_approve
    value: 0
    scope_id: 0
    *************************** 78. row ***************************
    path: catalog/search/engine
    value: catalogsearch/fulltext_engine
    scope_id: 0
    *************************** 79. row ***************************
    path: catalog/search/max_query_length
    value: 128
    scope_id: 0
    *************************** 80. row ***************************
    path: catalog/search/max_query_words
    value: 10
    scope_id: 0
    *************************** 81. row ***************************
    path: catalog/search/min_query_length
    value: 1
    scope_id: 0
    *************************** 82. row ***************************
    path: catalog/search/search_recommendations_count
    value: 5
    scope_id: 0
    *************************** 83. row ***************************
    path: catalog/search/search_recommendations_count_results_enabled
    value: 0
    scope_id: 0
    *************************** 84. row ***************************
    path: catalog/search/search_recommendations_enabled
    value: 0
    scope_id: 0
    *************************** 85. row ***************************
    path: catalog/search/search_type
    value: 1
    scope_id: 0
    *************************** 86. row ***************************
    path: catalog/search/use_layered_navigation_count
    value: 2000
    scope_id: 0
    *************************** 87. row ***************************
    path: catalog/seo/category_canonical_tag
    value: 1
    scope_id: 0
    *************************** 88. row ***************************
    path: catalog/seo/category_url_suffix
    value: .html
    scope_id: 0
    *************************** 89. row ***************************
    path: catalog/seo/product_canonical_tag
    value: 1
    scope_id: 0
    *************************** 90. row ***************************
    path: catalog/seo/product_url_suffix
    value: .html
    scope_id: 0
    *************************** 91. row ***************************
    path: catalog/seo/product_use_categories
    value: 0
    scope_id: 0
    *************************** 92. row ***************************
    path: catalog/seo/save_rewrites_history
    value: 1
    scope_id: 0
    *************************** 93. row ***************************
    path: catalog/seo/search_terms
    value: 1
    scope_id: 0
    *************************** 94. row ***************************
    path: catalog/seo/site_map
    value: 1
    scope_id: 0
    *************************** 95. row ***************************
    path: catalog/seo/title_separator
    value: -
    scope_id: 0
    *************************** 96. row ***************************
    path: catalog/sitemap/brands_url_key
    value: brands
    scope_id: 0
    *************************** 97. row ***************************
    path: catalog/sitemap/lines_perpage
    value: 30
    scope_id: 0
    *************************** 98. row ***************************
    path: catalog/sitemap/tree_mode
    value: 0
    scope_id: 0
    *************************** 99. row ***************************
    path: cataloginventory/item_options/auto_return
    value: 0
    scope_id: 0
    *************************** 100. row ***************************
    path: cataloginventory/item_options/backorders
    value: 0
    scope_id: 0
    *************************** 101. row ***************************
    path: cataloginventory/item_options/enable_qty_increments
    value: 0
    scope_id: 0
    *************************** 102. row ***************************
    path: cataloginventory/item_options/manage_stock
    value: 1
    scope_id: 0
    *************************** 103. row ***************************
    path: cataloginventory/item_options/max_sale_qty
    value: 10000
    scope_id: 0
    *************************** 104. row ***************************
    path: cataloginventory/item_options/min_qty
    value: 0
    scope_id: 0
    *************************** 105. row ***************************
    path: cataloginventory/item_options/min_sale_qty
    value: a:0:{}
    scope_id: 0
    *************************** 106. row ***************************
    path: cataloginventory/item_options/notify_stock_qty
    value: 1
    scope_id: 0
    *************************** 107. row ***************************
    path: cataloginventory/options/can_back_in_stock
    value: 1
    scope_id: 0
    *************************** 108. row ***************************
    path: cataloginventory/options/can_subtract
    value: 1
    scope_id: 0
    *************************** 109. row ***************************
    path: cataloginventory/options/show_out_of_stock
    value: 0
    scope_id: 0
    *************************** 110. row ***************************
    path: cataloginventory/options/stock_threshold_qty
    value: 0
    scope_id: 0
    *************************** 111. row ***************************
    path: crontab/jobs/catalog_product_alert/run/model
    value: productalert/observer::process
    scope_id: 0
    *************************** 112. row ***************************
    path: crontab/jobs/catalog_product_alert/schedule/cron_expr
    value: 0 0 * * *
    scope_id: 0
    *************************** 113. row ***************************
    path: crontab/jobs/log_clean/run/model
    value: log/cron::logClean
    scope_id: 0
    *************************** 114. row ***************************
    path: crontab/jobs/log_clean/schedule/cron_expr
    value:
    scope_id: 0
    *************************** 116. row ***************************
    path: crontab/jobs/sitemap_generate/run/model
    value: sitemap/observer::scheduledGenerateSitemaps
    scope_id: 0
    *************************** 117. row ***************************
    path: crontab/jobs/sitemap_generate/schedule/cron_expr
    value: 0 0 * * *
    scope_id: 0
    *************************** 118. row ***************************
    path: customer/account_share/scope
    value: 1
    scope_id: 0
    *************************** 119. row ***************************
    path: customer/address/dob_show
    value:
    scope_id: 0
    *************************** 120. row ***************************
    path: customer/address/middlename_show
    value: 0
    scope_id: 0
    *************************** 121. row ***************************
    path: customer/address/prefix_options
    value: -----------------------------117999604518204827016685 60562 Content-Disposition: form-data; name="groups[address][fields][middlename_show][value]" 0
    scope_id: 0
    *************************** 122. row ***************************
    path: customer/address/prefix_show
    value:
    scope_id: 0
    *************************** 123. row ***************************
    path: customer/address/street_lines
    value: 2
    scope_id: 0
    *************************** 124. row ***************************
    path: customer/address/suffix_options
    value: NULL
    scope_id: 0
    *************************** 125. row ***************************
    path: customer/address/suffix_show
    value:
    scope_id: 0
    *************************** 126. row ***************************
    path: customer/address/taxvat_show
    value:
    scope_id: 0
    *************************** 132. row ***************************
    path: customer/captcha/enable
    value: 0
    scope_id: 0
    *************************** 133. row ***************************
    path: customer/create_account/auto_group_assign
    value: 0
    scope_id: 0
    *************************** 134. row ***************************
    path: customer/create_account/confirm
    value: 0
    scope_id: 0
    *************************** 135. row ***************************
    path: customer/create_account/default_group
    value: 1
    scope_id: 0
    *************************** 136. row ***************************
    path: customer/create_account/email_confirmation_template
    value: customer_create_account_email_confirmation_template
    scope_id: 0
    *************************** 137. row ***************************
    path: customer/create_account/email_confirmed_template
    value: 14
    scope_id: 0
    *************************** 138. row ***************************
    path: customer/create_account/email_domain
    value: company-name.com
    scope_id: 0
    *************************** 139. row ***************************
    path: customer/create_account/email_identity
    value: general
    scope_id: 0
    *************************** 140. row ***************************
    path: customer/create_account/email_template
    value: 14
    scope_id: 0
    *************************** 141. row ***************************
    path: customer/create_account/generate_human_friendly_id
    value: 0
    scope_id: 0
    *************************** 142. row ***************************
    path: customer/create_account/minimum_age
    value: 13
    scope_id: 0
    *************************** 143. row ***************************
    path: customer/create_account/vat_frontend_visibility
    value: 0
    scope_id: 0
    *************************** 144. row ***************************
    path: customer/create_account/viv_disable_auto_group_assign_default
    value: 0
    scope_id: 0
    *************************** 145. row ***************************
    path: customer/customeractivation/activation_status_default
    value: 1
    scope_id: 0
    *************************** 146. row ***************************
    path: customer/customeractivation/alert_admin
    value: 0
    scope_id: 0
    *************************** 147. row ***************************
    path: customer/customeractivation/alert_customer
    value: 0
    scope_id: 0
    *************************** 148. row ***************************
    path: customer/customeractivation/always_send_admin_email
    value: 0
    scope_id: 0
    *************************** 149. row ***************************
    path: customer/customeractivation/disable_ext
    value: 0
    scope_id: 0
    *************************** 150. row ***************************
    path: customer/enterprise_customerbalance/email_identity
    value: general
    scope_id: 0
    *************************** 151. row ***************************
    path: customer/enterprise_customerbalance/email_template
    value: customer_enterprise_customerbalance_email_template
    scope_id: 0
    *************************** 152. row ***************************
    path: customer/enterprise_customerbalance/is_enabled
    value: 1
    scope_id: 0
    *************************** 153. row ***************************
    path: customer/enterprise_customerbalance/refund_automatically
    value: 0
    scope_id: 0
    *************************** 154. row ***************************
    path: customer/enterprise_customerbalance/show_history
    value: 1
    scope_id: 0
    *************************** 155. row ***************************
    path: customer/enterprise_customersegment/is_enabled
    value: 1
    scope_id: 0
    *************************** 156. row ***************************
    path: customer/online_customers/online_minutes_interval
    value: 60
    scope_id: 0
    *************************** 157. row ***************************
    path: customer/password/forgot_email_identity
    value: support
    scope_id: 0
    *************************** 158. row ***************************
    path: customer/password/forgot_email_template
    value: customer_password_forgot_email_template
    scope_id: 0
    *************************** 159. row ***************************
    path: customer/password/remind_email_template
    value: customer_password_remind_email_template
    scope_id: 0
    *************************** 160. row ***************************
    path: customer/password/reset_link_expiration_period
    value: 1
    scope_id: 0
    *************************** 161. row ***************************
    path: customer/startup/redirect_dashboard
    value: 1
    scope_id: 0
    *************************** 162. row ***************************
    path: customer/startup/redirect_dashboard
    value: 0
    scope_id: 2
    *************************** 163. row ***************************
    path: dev/css/merge_css_files
    value: 0
    @@ -663,238 +131,6 @@ scope_id: 0
    path: dev/translate_inline/active_admin
    value: 0
    scope_id: 0
    *************************** 180. row ***************************
    path: general/country/allow
    value: AG,AW,AU,BS,BB,BE,BM,BR,VG,CA,KY,CL,CO,CR,DK,EC,FI,FR,DE,GD,HK,HU,IE,IT,JM,JP,MX,NL,AN,NZ,NO,PE,PH,PL,PT,KN,LC,SG,KR,ES,SE,CH,TH,TT,TC,AE,GB,US
    scope_id: 0
    *************************** 181. row ***************************
    path: general/country/allow
    value: US
    scope_id: 2
    *************************** 182. row ***************************
    path: general/country/default
    value: US
    scope_id: 0
    *************************** 183. row ***************************
    path: general/country/eu_countries
    value: AT,BE,BG,CY,CZ,DK,EE,FI,FR,DE,GR,HU,IE,IT,LV,LT,LU,MT,NL,PL,PT,RO,SK,SI,ES,SE,GB
    scope_id: 0
    *************************** 184. row ***************************
    path: general/country/optional_zip_countries
    value: HK,IE,MO,PA
    scope_id: 0
    *************************** 185. row ***************************
    path: general/locale/code
    value: en_US
    scope_id: 0
    *************************** 186. row ***************************
    path: general/locale/firstday
    value: 0
    scope_id: 0
    *************************** 187. row ***************************
    path: general/locale/timezone
    value: America/Los_Angeles
    scope_id: 0
    *************************** 188. row ***************************
    path: general/locale/weekend
    value: 0,6
    scope_id: 0
    *************************** 189. row ***************************
    path: general/region/display_all
    value: 1
    scope_id: 0
    *************************** 190. row ***************************
    path: general/region/state_required
    value: CA,FR,DE,ES,CH,US
    scope_id: 0
    *************************** 191. row ***************************
    path: general/store_information/address
    value: NULL
    scope_id: 0
    *************************** 192. row ***************************
    path: general/store_information/merchant_country
    value: NULL
    scope_id: 0
    *************************** 193. row ***************************
    path: general/store_information/merchant_vat_number
    value: NULL
    scope_id: 0
    *************************** 194. row ***************************
    path: general/store_information/name
    value: NULL
    scope_id: 0
    *************************** 195. row ***************************
    path: general/store_information/phone
    value: NULL
    scope_id: 0
    *************************** 196. row ***************************
    path: sales/dashboard/use_aggregated_data
    value: 0
    scope_id: 0
    *************************** 197. row ***************************
    path: sales/enterprise_salesarchive/active
    value: 0
    scope_id: 0
    *************************** 198. row ***************************
    path: sales/enterprise_salesarchive/age
    value: 30
    scope_id: 0
    *************************** 199. row ***************************
    path: sales/enterprise_salesarchive/order_statuses
    value: complete,closed
    scope_id: 0
    *************************** 200. row ***************************
    path: sales/general/hide_customer_ip
    value: 0
    scope_id: 0
    *************************** 201. row ***************************
    path: sales/gift_options/allow_items
    value: 0
    scope_id: 0
    *************************** 202. row ***************************
    path: sales/gift_options/allow_order
    value: 0
    scope_id: 0
    *************************** 203. row ***************************
    path: sales/identity/address
    value: NULL
    scope_id: 0
    *************************** 204. row ***************************
    path: sales/minimum_order/active
    value: 0
    scope_id: 0
    *************************** 205. row ***************************
    path: sales/minimum_order/amount
    value: NULL
    scope_id: 0
    *************************** 206. row ***************************
    path: sales/minimum_order/description
    value: NULL
    scope_id: 0
    *************************** 207. row ***************************
    path: sales/minimum_order/error_message
    value: NULL
    scope_id: 0
    *************************** 208. row ***************************
    path: sales/minimum_order/multi_address
    value: 0
    scope_id: 0
    *************************** 209. row ***************************
    path: sales/minimum_order/multi_address_description
    value: NULL
    scope_id: 0
    *************************** 210. row ***************************
    path: sales/minimum_order/multi_address_error_message
    value: NULL
    scope_id: 0
    *************************** 211. row ***************************
    path: sales/msrp/apply_for_all
    value: 0
    scope_id: 0
    *************************** 212. row ***************************
    path: sales/msrp/display_price_type
    value: 1
    scope_id: 0
    *************************** 213. row ***************************
    path: sales/msrp/enabled
    value: 0
    scope_id: 0
    *************************** 216. row ***************************
    path: sales/product_sku/my_account_enable
    value: 0
    scope_id: 0
    *************************** 217. row ***************************
    path: sales/reorder/allow
    value: 1
    scope_id: 0
    *************************** 218. row ***************************
    path: sales/setstartordernumber/credit
    value: NULL
    scope_id: 0
    *************************** 219. row ***************************
    path: sales/setstartordernumber/credit
    value: 510000000000
    scope_id: 2
    *************************** 220. row ***************************
    path: sales/setstartordernumber/disable_padding
    value: 0
    scope_id: 0
    *************************** 221. row ***************************
    path: sales/setstartordernumber/disable_prefix
    value: 0
    scope_id: 0
    *************************** 222. row ***************************
    path: sales/setstartordernumber/extra_increment
    value: NULL
    scope_id: 0
    *************************** 223. row ***************************
    path: sales/setstartordernumber/invoice
    value: NULL
    scope_id: 0
    *************************** 224. row ***************************
    path: sales/setstartordernumber/invoice
    value: 510000000000
    scope_id: 2
    *************************** 225. row ***************************
    path: sales/setstartordernumber/order
    value: 160000000071
    scope_id: 0
    *************************** 226. row ***************************
    path: sales/setstartordernumber/order
    value: 510000000000
    scope_id: 2
    *************************** 227. row ***************************
    path: sales/setstartordernumber/order
    value: 150000100
    scope_id: 1
    *************************** 228. row ***************************
    path: sales/setstartordernumber/override
    value: 0
    scope_id: 0
    *************************** 229. row ***************************
    path: sales/setstartordernumber/override
    value: 1
    scope_id: 1
    *************************** 230. row ***************************
    path: sales/setstartordernumber/shipment
    value: NULL
    scope_id: 0
    *************************** 231. row ***************************
    path: sales/setstartordernumber/shipment
    value: 510000000000
    scope_id: 2
    *************************** 232. row ***************************
    path: sales/totals_sort/customerbalance
    value: 95
    scope_id: 0
    *************************** 233. row ***************************
    path: sales/totals_sort/discount
    value: 20
    scope_id: 0
    *************************** 234. row ***************************
    path: sales/totals_sort/giftcardaccount
    value: 90
    scope_id: 0
    *************************** 235. row ***************************
    path: sales/totals_sort/grand_total
    value: 100
    scope_id: 0
    *************************** 236. row ***************************
    path: sales/totals_sort/shipping
    value: 30
    scope_id: 0
    *************************** 237. row ***************************
    path: sales/totals_sort/subtotal
    value: 10
    scope_id: 0
    *************************** 238. row ***************************
    path: sales/totals_sort/tax
    value: 40
    scope_id: 0
    *************************** 239. row ***************************
    path: sales/totals_sort/weee
    value: 50
    scope_id: 0
    *************************** 288. row ***************************
    path: system/adminnotification/frequency
    value: 24
    @@ -1211,4 +447,3 @@ scope_id: 0
    path: web/url/use_store
    value: 0
    scope_id: 0
    366 rows in set (0.00 sec)
  25. Reid Parham revised this gist Aug 8, 2013. 1 changed file with 1214 additions and 0 deletions.
    1,214 changes: 1,214 additions & 0 deletions 1: Magento core_config_data
    View file
    Original file line number Diff line number Diff line change
    @@ -0,0 +1,1214 @@
    mysql> select path, value, scope_id from core_config_data where path like 'web%' OR path like 'system%' or path like 'sales%' or path like 'admin%' or path like 'api%' or path like 'customer%' or path like 'cache%' or path like 'catalog%' or path like 'crontab%' or path like 'general%' or path like 'dev%' order by path\G;
    *************************** 1. row ***************************
    path: admin/captcha/enable
    value: 0
    scope_id: 0
    *************************** 2. row ***************************
    path: admin/dashboard/enable_charts
    value: 1
    scope_id: 0
    *************************** 3. row ***************************
    path: admin/emails/forgot_email_identity
    value: general
    scope_id: 0
    *************************** 4. row ***************************
    path: admin/emails/forgot_email_template
    value: admin_emails_forgot_email_template
    scope_id: 0
    *************************** 5. row ***************************
    path: admin/emails/password_reset_link_expiration_period
    value: 1
    scope_id: 0
    *************************** 7. row ***************************
    path: admin/security/lockout_failures
    value: 6
    scope_id: 0
    *************************** 8. row ***************************
    path: admin/security/lockout_threshold
    value: 30
    scope_id: 0
    *************************** 9. row ***************************
    path: admin/security/password_is_forced
    value: 1
    scope_id: 0
    *************************** 10. row ***************************
    path: admin/security/password_lifetime
    value: 90
    scope_id: 0
    *************************** 11. row ***************************
    path: admin/security/session_cookie_lifetime
    value: 900
    scope_id: 0
    *************************** 12. row ***************************
    path: admin/security/use_case_sensitive_login
    value: 0
    scope_id: 0
    *************************** 13. row ***************************
    path: admin/security/use_form_key
    value: 1
    scope_id: 0
    *************************** 14. row ***************************
    path: admin/startup/page
    value: dashboard
    scope_id: 0
    *************************** 15. row ***************************
    path: admin/url/use_custom
    value: 0
    scope_id: 0
    *************************** 16. row ***************************
    path: admin/url/use_custom_path
    value: 0
    scope_id: 0
    *************************** 17. row ***************************
    path: api/config/charset
    value: UTF-8
    scope_id: 0
    *************************** 18. row ***************************
    path: api/config/compliance_wsi
    value: 0
    scope_id: 0
    *************************** 19. row ***************************
    path: api/config/session_timeout
    value: 86400
    scope_id: 0
    *************************** 20. row ***************************
    path: api/config/wsdl_cache_enabled
    value: 1
    scope_id: 0
    *************************** 21. row ***************************
    path: cache/expires/catalog_category_view
    value:
    scope_id: 0
    *************************** 22. row ***************************
    path: cache/expires/catalog_product_list
    value:
    scope_id: 0
    *************************** 23. row ***************************
    path: cache/expires/cms_block
    value:
    scope_id: 0
    *************************** 24. row ***************************
    path: cache/expires/cms_page
    value:
    scope_id: 0
    *************************** 25. row ***************************
    path: cache/expires/lightspeed
    value:
    scope_id: 0
    *************************** 26. row ***************************
    path: cache/expires/page_cache
    value:
    scope_id: 0
    *************************** 27. row ***************************
    path: catalog/category/root_id
    value: 2
    scope_id: 0
    *************************** 28. row ***************************
    path: catalog/custom_options/date_fields_order
    value: m,d,y
    scope_id: 0
    *************************** 29. row ***************************
    path: catalog/custom_options/time_format
    value: 12h
    scope_id: 0
    *************************** 30. row ***************************
    path: catalog/custom_options/use_calendar
    value: 0
    scope_id: 0
    *************************** 31. row ***************************
    path: catalog/custom_options/year_range
    value: ,
    scope_id: 0
    *************************** 32. row ***************************
    path: catalog/downloadable/content_disposition
    value: inline
    scope_id: 0
    *************************** 33. row ***************************
    path: catalog/downloadable/disable_guest_checkout
    value: 1
    scope_id: 0
    *************************** 34. row ***************************
    path: catalog/downloadable/downloads_number
    value: 0
    scope_id: 0
    *************************** 35. row ***************************
    path: catalog/downloadable/links_target_new_window
    value: 1
    scope_id: 0
    *************************** 36. row ***************************
    path: catalog/downloadable/links_title
    value: Links
    scope_id: 0
    *************************** 37. row ***************************
    path: catalog/downloadable/order_item_status
    value: 9
    scope_id: 0
    *************************** 38. row ***************************
    path: catalog/downloadable/samples_title
    value: Samples
    scope_id: 0
    *************************** 39. row ***************************
    path: catalog/downloadable/shareable
    value: 0
    scope_id: 0
    *************************** 40. row ***************************
    path: catalog/enterprise_targetrule/crosssell_position_behavior
    value: 0
    scope_id: 0
    *************************** 41. row ***************************
    path: catalog/enterprise_targetrule/crosssell_position_limit
    value: 5
    scope_id: 0
    *************************** 42. row ***************************
    path: catalog/enterprise_targetrule/crosssell_rotation_mode
    value: 0
    scope_id: 0
    *************************** 43. row ***************************
    path: catalog/enterprise_targetrule/related_position_behavior
    value: 0
    scope_id: 0
    *************************** 44. row ***************************
    path: catalog/enterprise_targetrule/related_position_limit
    value: 6
    scope_id: 0
    *************************** 45. row ***************************
    path: catalog/enterprise_targetrule/related_rotation_mode
    value: 0
    scope_id: 0
    *************************** 46. row ***************************
    path: catalog/enterprise_targetrule/upsell_position_behavior
    value: 0
    scope_id: 0
    *************************** 47. row ***************************
    path: catalog/enterprise_targetrule/upsell_position_limit
    value: 8
    scope_id: 0
    *************************** 48. row ***************************
    path: catalog/enterprise_targetrule/upsell_rotation_mode
    value: 0
    scope_id: 0
    *************************** 49. row ***************************
    path: catalog/frontend/default_sort_by
    value: position
    scope_id: 0
    *************************** 50. row ***************************
    path: catalog/frontend/flat_catalog_category
    value: 1
    scope_id: 0
    *************************** 51. row ***************************
    path: catalog/frontend/flat_catalog_product
    value: 1
    scope_id: 0
    *************************** 52. row ***************************
    path: catalog/frontend/grid_per_page
    value: 24
    scope_id: 0
    *************************** 53. row ***************************
    path: catalog/frontend/grid_per_page_values
    value: 24,48,96
    scope_id: 0
    *************************** 54. row ***************************
    path: catalog/frontend/list_allow_all
    value: 0
    scope_id: 0
    *************************** 55. row ***************************
    path: catalog/frontend/list_mode
    value: grid
    scope_id: 0
    *************************** 56. row ***************************
    path: catalog/frontend/list_per_page
    value: 10
    scope_id: 0
    *************************** 57. row ***************************
    path: catalog/frontend/list_per_page_values
    value: 5,10,15,20,25
    scope_id: 0
    *************************** 58. row ***************************
    path: catalog/frontend/parse_url_directives
    value: 1
    scope_id: 0
    *************************** 59. row ***************************
    path: catalog/layered_navigation/display_product_count
    value: 1
    scope_id: 0
    *************************** 60. row ***************************
    path: catalog/layered_navigation/price_range_calculation
    value: auto
    scope_id: 0
    *************************** 61. row ***************************
    path: catalog/navigation/max_depth
    value: 2
    scope_id: 0
    *************************** 62. row ***************************
    path: catalog/price/scope
    value: 0
    scope_id: 0
    *************************** 63. row ***************************
    path: catalog/productalert/allow_price
    value: 0
    scope_id: 0
    *************************** 64. row ***************************
    path: catalog/productalert/allow_stock
    value: 0
    scope_id: 0
    *************************** 65. row ***************************
    path: catalog/productalert/email_identity
    value: general
    scope_id: 0
    *************************** 66. row ***************************
    path: catalog/productalert/email_price_template
    value: catalog_productalert_email_price_template
    scope_id: 0
    *************************** 67. row ***************************
    path: catalog/productalert/email_stock_template
    value: catalog_productalert_email_stock_template
    scope_id: 0
    *************************** 68. row ***************************
    path: catalog/productalert_cron/error_email
    value: NULL
    scope_id: 0
    *************************** 69. row ***************************
    path: catalog/productalert_cron/error_email_identity
    value: general
    scope_id: 0
    *************************** 70. row ***************************
    path: catalog/productalert_cron/error_email_template
    value: catalog_productalert_cron_error_email_template
    scope_id: 0
    *************************** 71. row ***************************
    path: catalog/productalert_cron/frequency
    value: D
    scope_id: 0
    *************************** 72. row ***************************
    path: catalog/productalert_cron/time
    value: 00,00,00
    scope_id: 0
    *************************** 73. row ***************************
    path: catalog/recently_products/compared_count
    value: 5
    scope_id: 0
    *************************** 74. row ***************************
    path: catalog/recently_products/scope
    value: website
    scope_id: 0
    *************************** 75. row ***************************
    path: catalog/recently_products/viewed_count
    value: 5
    scope_id: 0
    *************************** 76. row ***************************
    path: catalog/review/allow_guest
    value: 1
    scope_id: 0
    *************************** 77. row ***************************
    path: catalog/review/auto_approve
    value: 0
    scope_id: 0
    *************************** 78. row ***************************
    path: catalog/search/engine
    value: catalogsearch/fulltext_engine
    scope_id: 0
    *************************** 79. row ***************************
    path: catalog/search/max_query_length
    value: 128
    scope_id: 0
    *************************** 80. row ***************************
    path: catalog/search/max_query_words
    value: 10
    scope_id: 0
    *************************** 81. row ***************************
    path: catalog/search/min_query_length
    value: 1
    scope_id: 0
    *************************** 82. row ***************************
    path: catalog/search/search_recommendations_count
    value: 5
    scope_id: 0
    *************************** 83. row ***************************
    path: catalog/search/search_recommendations_count_results_enabled
    value: 0
    scope_id: 0
    *************************** 84. row ***************************
    path: catalog/search/search_recommendations_enabled
    value: 0
    scope_id: 0
    *************************** 85. row ***************************
    path: catalog/search/search_type
    value: 1
    scope_id: 0
    *************************** 86. row ***************************
    path: catalog/search/use_layered_navigation_count
    value: 2000
    scope_id: 0
    *************************** 87. row ***************************
    path: catalog/seo/category_canonical_tag
    value: 1
    scope_id: 0
    *************************** 88. row ***************************
    path: catalog/seo/category_url_suffix
    value: .html
    scope_id: 0
    *************************** 89. row ***************************
    path: catalog/seo/product_canonical_tag
    value: 1
    scope_id: 0
    *************************** 90. row ***************************
    path: catalog/seo/product_url_suffix
    value: .html
    scope_id: 0
    *************************** 91. row ***************************
    path: catalog/seo/product_use_categories
    value: 0
    scope_id: 0
    *************************** 92. row ***************************
    path: catalog/seo/save_rewrites_history
    value: 1
    scope_id: 0
    *************************** 93. row ***************************
    path: catalog/seo/search_terms
    value: 1
    scope_id: 0
    *************************** 94. row ***************************
    path: catalog/seo/site_map
    value: 1
    scope_id: 0
    *************************** 95. row ***************************
    path: catalog/seo/title_separator
    value: -
    scope_id: 0
    *************************** 96. row ***************************
    path: catalog/sitemap/brands_url_key
    value: brands
    scope_id: 0
    *************************** 97. row ***************************
    path: catalog/sitemap/lines_perpage
    value: 30
    scope_id: 0
    *************************** 98. row ***************************
    path: catalog/sitemap/tree_mode
    value: 0
    scope_id: 0
    *************************** 99. row ***************************
    path: cataloginventory/item_options/auto_return
    value: 0
    scope_id: 0
    *************************** 100. row ***************************
    path: cataloginventory/item_options/backorders
    value: 0
    scope_id: 0
    *************************** 101. row ***************************
    path: cataloginventory/item_options/enable_qty_increments
    value: 0
    scope_id: 0
    *************************** 102. row ***************************
    path: cataloginventory/item_options/manage_stock
    value: 1
    scope_id: 0
    *************************** 103. row ***************************
    path: cataloginventory/item_options/max_sale_qty
    value: 10000
    scope_id: 0
    *************************** 104. row ***************************
    path: cataloginventory/item_options/min_qty
    value: 0
    scope_id: 0
    *************************** 105. row ***************************
    path: cataloginventory/item_options/min_sale_qty
    value: a:0:{}
    scope_id: 0
    *************************** 106. row ***************************
    path: cataloginventory/item_options/notify_stock_qty
    value: 1
    scope_id: 0
    *************************** 107. row ***************************
    path: cataloginventory/options/can_back_in_stock
    value: 1
    scope_id: 0
    *************************** 108. row ***************************
    path: cataloginventory/options/can_subtract
    value: 1
    scope_id: 0
    *************************** 109. row ***************************
    path: cataloginventory/options/show_out_of_stock
    value: 0
    scope_id: 0
    *************************** 110. row ***************************
    path: cataloginventory/options/stock_threshold_qty
    value: 0
    scope_id: 0
    *************************** 111. row ***************************
    path: crontab/jobs/catalog_product_alert/run/model
    value: productalert/observer::process
    scope_id: 0
    *************************** 112. row ***************************
    path: crontab/jobs/catalog_product_alert/schedule/cron_expr
    value: 0 0 * * *
    scope_id: 0
    *************************** 113. row ***************************
    path: crontab/jobs/log_clean/run/model
    value: log/cron::logClean
    scope_id: 0
    *************************** 114. row ***************************
    path: crontab/jobs/log_clean/schedule/cron_expr
    value:
    scope_id: 0
    *************************** 116. row ***************************
    path: crontab/jobs/sitemap_generate/run/model
    value: sitemap/observer::scheduledGenerateSitemaps
    scope_id: 0
    *************************** 117. row ***************************
    path: crontab/jobs/sitemap_generate/schedule/cron_expr
    value: 0 0 * * *
    scope_id: 0
    *************************** 118. row ***************************
    path: customer/account_share/scope
    value: 1
    scope_id: 0
    *************************** 119. row ***************************
    path: customer/address/dob_show
    value:
    scope_id: 0
    *************************** 120. row ***************************
    path: customer/address/middlename_show
    value: 0
    scope_id: 0
    *************************** 121. row ***************************
    path: customer/address/prefix_options
    value: -----------------------------117999604518204827016685 60562 Content-Disposition: form-data; name="groups[address][fields][middlename_show][value]" 0
    scope_id: 0
    *************************** 122. row ***************************
    path: customer/address/prefix_show
    value:
    scope_id: 0
    *************************** 123. row ***************************
    path: customer/address/street_lines
    value: 2
    scope_id: 0
    *************************** 124. row ***************************
    path: customer/address/suffix_options
    value: NULL
    scope_id: 0
    *************************** 125. row ***************************
    path: customer/address/suffix_show
    value:
    scope_id: 0
    *************************** 126. row ***************************
    path: customer/address/taxvat_show
    value:
    scope_id: 0
    *************************** 132. row ***************************
    path: customer/captcha/enable
    value: 0
    scope_id: 0
    *************************** 133. row ***************************
    path: customer/create_account/auto_group_assign
    value: 0
    scope_id: 0
    *************************** 134. row ***************************
    path: customer/create_account/confirm
    value: 0
    scope_id: 0
    *************************** 135. row ***************************
    path: customer/create_account/default_group
    value: 1
    scope_id: 0
    *************************** 136. row ***************************
    path: customer/create_account/email_confirmation_template
    value: customer_create_account_email_confirmation_template
    scope_id: 0
    *************************** 137. row ***************************
    path: customer/create_account/email_confirmed_template
    value: 14
    scope_id: 0
    *************************** 138. row ***************************
    path: customer/create_account/email_domain
    value: company-name.com
    scope_id: 0
    *************************** 139. row ***************************
    path: customer/create_account/email_identity
    value: general
    scope_id: 0
    *************************** 140. row ***************************
    path: customer/create_account/email_template
    value: 14
    scope_id: 0
    *************************** 141. row ***************************
    path: customer/create_account/generate_human_friendly_id
    value: 0
    scope_id: 0
    *************************** 142. row ***************************
    path: customer/create_account/minimum_age
    value: 13
    scope_id: 0
    *************************** 143. row ***************************
    path: customer/create_account/vat_frontend_visibility
    value: 0
    scope_id: 0
    *************************** 144. row ***************************
    path: customer/create_account/viv_disable_auto_group_assign_default
    value: 0
    scope_id: 0
    *************************** 145. row ***************************
    path: customer/customeractivation/activation_status_default
    value: 1
    scope_id: 0
    *************************** 146. row ***************************
    path: customer/customeractivation/alert_admin
    value: 0
    scope_id: 0
    *************************** 147. row ***************************
    path: customer/customeractivation/alert_customer
    value: 0
    scope_id: 0
    *************************** 148. row ***************************
    path: customer/customeractivation/always_send_admin_email
    value: 0
    scope_id: 0
    *************************** 149. row ***************************
    path: customer/customeractivation/disable_ext
    value: 0
    scope_id: 0
    *************************** 150. row ***************************
    path: customer/enterprise_customerbalance/email_identity
    value: general
    scope_id: 0
    *************************** 151. row ***************************
    path: customer/enterprise_customerbalance/email_template
    value: customer_enterprise_customerbalance_email_template
    scope_id: 0
    *************************** 152. row ***************************
    path: customer/enterprise_customerbalance/is_enabled
    value: 1
    scope_id: 0
    *************************** 153. row ***************************
    path: customer/enterprise_customerbalance/refund_automatically
    value: 0
    scope_id: 0
    *************************** 154. row ***************************
    path: customer/enterprise_customerbalance/show_history
    value: 1
    scope_id: 0
    *************************** 155. row ***************************
    path: customer/enterprise_customersegment/is_enabled
    value: 1
    scope_id: 0
    *************************** 156. row ***************************
    path: customer/online_customers/online_minutes_interval
    value: 60
    scope_id: 0
    *************************** 157. row ***************************
    path: customer/password/forgot_email_identity
    value: support
    scope_id: 0
    *************************** 158. row ***************************
    path: customer/password/forgot_email_template
    value: customer_password_forgot_email_template
    scope_id: 0
    *************************** 159. row ***************************
    path: customer/password/remind_email_template
    value: customer_password_remind_email_template
    scope_id: 0
    *************************** 160. row ***************************
    path: customer/password/reset_link_expiration_period
    value: 1
    scope_id: 0
    *************************** 161. row ***************************
    path: customer/startup/redirect_dashboard
    value: 1
    scope_id: 0
    *************************** 162. row ***************************
    path: customer/startup/redirect_dashboard
    value: 0
    scope_id: 2
    *************************** 163. row ***************************
    path: dev/css/merge_css_files
    value: 0
    scope_id: 0
    *************************** 164. row ***************************
    path: dev/debug/profiler
    value: 0
    scope_id: 0
    *************************** 165. row ***************************
    path: dev/js/deprecation
    value: 0
    scope_id: 0
    *************************** 166. row ***************************
    path: dev/js/merge_files
    value: 0
    scope_id: 0
    *************************** 167. row ***************************
    path: dev/log/active
    value: 1
    scope_id: 0
    *************************** 168. row ***************************
    path: dev/log/exception_file
    value: exception.log
    scope_id: 0
    *************************** 169. row ***************************
    path: dev/log/file
    value: system.log
    scope_id: 0
    *************************** 173. row ***************************
    path: dev/restrict/allow_ips
    value: NULL
    scope_id: 0
    *************************** 174. row ***************************
    path: dev/template/allow_symlink
    value: 1
    scope_id: 0
    *************************** 175. row ***************************
    path: dev/translate_inline/active
    value: 0
    scope_id: 0
    *************************** 176. row ***************************
    path: dev/translate_inline/active_admin
    value: 0
    scope_id: 0
    *************************** 180. row ***************************
    path: general/country/allow
    value: AG,AW,AU,BS,BB,BE,BM,BR,VG,CA,KY,CL,CO,CR,DK,EC,FI,FR,DE,GD,HK,HU,IE,IT,JM,JP,MX,NL,AN,NZ,NO,PE,PH,PL,PT,KN,LC,SG,KR,ES,SE,CH,TH,TT,TC,AE,GB,US
    scope_id: 0
    *************************** 181. row ***************************
    path: general/country/allow
    value: US
    scope_id: 2
    *************************** 182. row ***************************
    path: general/country/default
    value: US
    scope_id: 0
    *************************** 183. row ***************************
    path: general/country/eu_countries
    value: AT,BE,BG,CY,CZ,DK,EE,FI,FR,DE,GR,HU,IE,IT,LV,LT,LU,MT,NL,PL,PT,RO,SK,SI,ES,SE,GB
    scope_id: 0
    *************************** 184. row ***************************
    path: general/country/optional_zip_countries
    value: HK,IE,MO,PA
    scope_id: 0
    *************************** 185. row ***************************
    path: general/locale/code
    value: en_US
    scope_id: 0
    *************************** 186. row ***************************
    path: general/locale/firstday
    value: 0
    scope_id: 0
    *************************** 187. row ***************************
    path: general/locale/timezone
    value: America/Los_Angeles
    scope_id: 0
    *************************** 188. row ***************************
    path: general/locale/weekend
    value: 0,6
    scope_id: 0
    *************************** 189. row ***************************
    path: general/region/display_all
    value: 1
    scope_id: 0
    *************************** 190. row ***************************
    path: general/region/state_required
    value: CA,FR,DE,ES,CH,US
    scope_id: 0
    *************************** 191. row ***************************
    path: general/store_information/address
    value: NULL
    scope_id: 0
    *************************** 192. row ***************************
    path: general/store_information/merchant_country
    value: NULL
    scope_id: 0
    *************************** 193. row ***************************
    path: general/store_information/merchant_vat_number
    value: NULL
    scope_id: 0
    *************************** 194. row ***************************
    path: general/store_information/name
    value: NULL
    scope_id: 0
    *************************** 195. row ***************************
    path: general/store_information/phone
    value: NULL
    scope_id: 0
    *************************** 196. row ***************************
    path: sales/dashboard/use_aggregated_data
    value: 0
    scope_id: 0
    *************************** 197. row ***************************
    path: sales/enterprise_salesarchive/active
    value: 0
    scope_id: 0
    *************************** 198. row ***************************
    path: sales/enterprise_salesarchive/age
    value: 30
    scope_id: 0
    *************************** 199. row ***************************
    path: sales/enterprise_salesarchive/order_statuses
    value: complete,closed
    scope_id: 0
    *************************** 200. row ***************************
    path: sales/general/hide_customer_ip
    value: 0
    scope_id: 0
    *************************** 201. row ***************************
    path: sales/gift_options/allow_items
    value: 0
    scope_id: 0
    *************************** 202. row ***************************
    path: sales/gift_options/allow_order
    value: 0
    scope_id: 0
    *************************** 203. row ***************************
    path: sales/identity/address
    value: NULL
    scope_id: 0
    *************************** 204. row ***************************
    path: sales/minimum_order/active
    value: 0
    scope_id: 0
    *************************** 205. row ***************************
    path: sales/minimum_order/amount
    value: NULL
    scope_id: 0
    *************************** 206. row ***************************
    path: sales/minimum_order/description
    value: NULL
    scope_id: 0
    *************************** 207. row ***************************
    path: sales/minimum_order/error_message
    value: NULL
    scope_id: 0
    *************************** 208. row ***************************
    path: sales/minimum_order/multi_address
    value: 0
    scope_id: 0
    *************************** 209. row ***************************
    path: sales/minimum_order/multi_address_description
    value: NULL
    scope_id: 0
    *************************** 210. row ***************************
    path: sales/minimum_order/multi_address_error_message
    value: NULL
    scope_id: 0
    *************************** 211. row ***************************
    path: sales/msrp/apply_for_all
    value: 0
    scope_id: 0
    *************************** 212. row ***************************
    path: sales/msrp/display_price_type
    value: 1
    scope_id: 0
    *************************** 213. row ***************************
    path: sales/msrp/enabled
    value: 0
    scope_id: 0
    *************************** 216. row ***************************
    path: sales/product_sku/my_account_enable
    value: 0
    scope_id: 0
    *************************** 217. row ***************************
    path: sales/reorder/allow
    value: 1
    scope_id: 0
    *************************** 218. row ***************************
    path: sales/setstartordernumber/credit
    value: NULL
    scope_id: 0
    *************************** 219. row ***************************
    path: sales/setstartordernumber/credit
    value: 510000000000
    scope_id: 2
    *************************** 220. row ***************************
    path: sales/setstartordernumber/disable_padding
    value: 0
    scope_id: 0
    *************************** 221. row ***************************
    path: sales/setstartordernumber/disable_prefix
    value: 0
    scope_id: 0
    *************************** 222. row ***************************
    path: sales/setstartordernumber/extra_increment
    value: NULL
    scope_id: 0
    *************************** 223. row ***************************
    path: sales/setstartordernumber/invoice
    value: NULL
    scope_id: 0
    *************************** 224. row ***************************
    path: sales/setstartordernumber/invoice
    value: 510000000000
    scope_id: 2
    *************************** 225. row ***************************
    path: sales/setstartordernumber/order
    value: 160000000071
    scope_id: 0
    *************************** 226. row ***************************
    path: sales/setstartordernumber/order
    value: 510000000000
    scope_id: 2
    *************************** 227. row ***************************
    path: sales/setstartordernumber/order
    value: 150000100
    scope_id: 1
    *************************** 228. row ***************************
    path: sales/setstartordernumber/override
    value: 0
    scope_id: 0
    *************************** 229. row ***************************
    path: sales/setstartordernumber/override
    value: 1
    scope_id: 1
    *************************** 230. row ***************************
    path: sales/setstartordernumber/shipment
    value: NULL
    scope_id: 0
    *************************** 231. row ***************************
    path: sales/setstartordernumber/shipment
    value: 510000000000
    scope_id: 2
    *************************** 232. row ***************************
    path: sales/totals_sort/customerbalance
    value: 95
    scope_id: 0
    *************************** 233. row ***************************
    path: sales/totals_sort/discount
    value: 20
    scope_id: 0
    *************************** 234. row ***************************
    path: sales/totals_sort/giftcardaccount
    value: 90
    scope_id: 0
    *************************** 235. row ***************************
    path: sales/totals_sort/grand_total
    value: 100
    scope_id: 0
    *************************** 236. row ***************************
    path: sales/totals_sort/shipping
    value: 30
    scope_id: 0
    *************************** 237. row ***************************
    path: sales/totals_sort/subtotal
    value: 10
    scope_id: 0
    *************************** 238. row ***************************
    path: sales/totals_sort/tax
    value: 40
    scope_id: 0
    *************************** 239. row ***************************
    path: sales/totals_sort/weee
    value: 50
    scope_id: 0
    *************************** 288. row ***************************
    path: system/adminnotification/frequency
    value: 24
    scope_id: 0
    *************************** 289. row ***************************
    path: system/adminnotification/use_https
    value: 1
    scope_id: 0
    *************************** 290. row ***************************
    path: system/backup/enabled
    value: 0
    scope_id: 0
    *************************** 291. row ***************************
    path: system/cron/history_cleanup_every
    value: 10
    scope_id: 0
    *************************** 292. row ***************************
    path: system/cron/history_failure_lifetime
    value: 600
    scope_id: 0
    *************************** 293. row ***************************
    path: system/cron/history_success_lifetime
    value: 60
    scope_id: 0
    *************************** 294. row ***************************
    path: system/cron/schedule_ahead_for
    value: 20
    scope_id: 0
    *************************** 295. row ***************************
    path: system/cron/schedule_generate_every
    value: 15
    scope_id: 0
    *************************** 296. row ***************************
    path: system/cron/schedule_lifetime
    value: 15
    scope_id: 0
    *************************** 297. row ***************************
    path: system/currency/installed
    value: AFN,ALL,DZD,AOA,ARS,AMD,AWG,AUD,AZN,AZM,BSD,BHD,BDT,BBD,BYR,BZD,BMD,BTN,BOB,BAM,BWP,BRL,GBP,BND,BGN,BUK,BIF,XOF,XPF,KHR,CAD,CVE,KYD,CLP,CNY,COP,KMF,CDF,CRC,HRK,CUP,CZK,DKK,DJF,DOP,XCD,EGP,SVC,GQE,ERN,EEK,ETB,EUR,FKP,FJD,GMD,GEK,GHS,GIP,GTQ,GNF,GYD,HTG,HNL,HKD,HUF,ISK,INR,IDR,IRR,IQD,JMD,JPY,JOD,KZT,KES,KWD,KGS,LAK,LVL,LBP,LSL,LRD,LYD,LTL,MOP,MKD,MGA,MWK,MYR,MVR,LSM,MRO,MUR,MXN,MDL,MNT,MAD,MZN,MMK,NAD,NPR,ANG,ILS,NZD,NIC,NGN,KPW,NOK,ROL,TRL,OMR,PKR,PAB,PGK,PYG,PEN,PHP,PLN,QAR,RHD,RON,RUB,RWF,SHP,STD,SAR,RSD,SCR,SLL,SGD,SKK,SBD,SOS,ZAR,KRW,LKR,SDG,SRD,SZL,SEK,CHF,SYP,TWD,TJS,TZS,THB,TOP,TTD,TND,TRY,TMM,USD,UGX,UAH,AED,UYU,UZS,VUV,VEB,VND,CHE,CHW,WST,YER,ZMK,ZWD
    scope_id: 0
    *************************** 298. row ***************************
    path: system/discountoptimiser/disable_for_add_to_cart
    value: 0
    scope_id: 0
    *************************** 299. row ***************************
    path: system/discountoptimiser/enabled
    value: 0
    scope_id: 0
    *************************** 300. row ***************************
    path: system/guidance_cachebuster/is_enabled
    value: 1
    scope_id: 0
    *************************** 301. row ***************************
    path: system/log/clean_after_day
    value: 180
    scope_id: 0
    *************************** 302. row ***************************
    path: system/log/enabled
    value: 0
    scope_id: 0
    *************************** 303. row ***************************
    path: system/log/error_email
    value:
    scope_id: 0
    *************************** 304. row ***************************
    path: system/log/error_email_identity
    value: general
    scope_id: 0
    *************************** 305. row ***************************
    path: system/log/error_email_template
    value: system_log_error_email_template
    scope_id: 0
    *************************** 306. row ***************************
    path: system/log/frequency
    value: D
    scope_id: 0
    *************************** 307. row ***************************
    path: system/log/time
    value: 00,00,00
    scope_id: 0
    *************************** 308. row ***************************
    path: system/page_cache/allowed_depth
    value: 4
    scope_id: 0
    *************************** 309. row ***************************
    path: system/page_cache/max_cache_size
    value: 8192
    scope_id: 0
    *************************** 310. row ***************************
    path: system/page_crawl/enable
    value: 0
    scope_id: 0
    *************************** 311. row ***************************
    path: system/smtp/disable
    value: 0
    scope_id: 0
    *************************** 312. row ***************************
    path: system/smtp/host
    value: localhost
    scope_id: 0
    *************************** 313. row ***************************
    path: system/smtp/port
    value: 25
    scope_id: 0
    *************************** 314. row ***************************
    path: system/smtppro/option
    value: smtp
    scope_id: 0
    *************************** 315. row ***************************
    path: system/smtpsettings/authentication
    value: login
    scope_id: 0
    *************************** 316. row ***************************
    path: system/smtpsettings/host
    value: smtp.sendgrid.net
    scope_id: 0
    *************************** 317. row ***************************
    path: system/smtpsettings/password
    value: [redacted]
    scope_id: 0
    *************************** 318. row ***************************
    path: system/smtpsettings/port
    value: 587
    scope_id: 0
    *************************** 319. row ***************************
    path: system/smtpsettings/ssl
    value: tls
    scope_id: 0
    *************************** 320. row ***************************
    path: system/smtpsettings/username
    value: company-name
    scope_id: 0
    *************************** 321. row ***************************
    path: web/browser_capabilities/cookies
    value: 1
    scope_id: 0
    *************************** 322. row ***************************
    path: web/browser_capabilities/javascript
    value: 1
    scope_id: 0
    *************************** 323. row ***************************
    path: web/cookie/cookie_domain
    value: NULL
    scope_id: 0
    *************************** 324. row ***************************
    path: web/cookie/cookie_httponly
    value: 1
    scope_id: 0
    *************************** 325. row ***************************
    path: web/cookie/cookie_lifetime
    value: 7776000
    scope_id: 0
    *************************** 326. row ***************************
    path: web/cookie/cookie_path
    value: NULL
    scope_id: 0
    *************************** 327. row ***************************
    path: web/cookie/cookie_restriction
    value: 0
    scope_id: 0
    *************************** 328. row ***************************
    path: web/default/cms_home_page
    value: home
    scope_id: 0
    *************************** 329. row ***************************
    path: web/default/cms_home_page
    value: internal_home
    scope_id: 2
    *************************** 330. row ***************************
    path: web/default/cms_no_cookies
    value: enable-cookies
    scope_id: 0
    *************************** 331. row ***************************
    path: web/default/cms_no_route
    value: page-not-found-flat
    scope_id: 0
    *************************** 332. row ***************************
    path: web/default/cms_store_home_page
    value: internal_home
    scope_id: 0
    *************************** 333. row ***************************
    path: web/default/front
    value: cms
    scope_id: 0
    *************************** 334. row ***************************
    path: web/default/no_route
    value: cms/index/noRoute
    scope_id: 0
    *************************** 335. row ***************************
    path: web/default/show_cms_breadcrumbs
    value: 1
    scope_id: 0
    *************************** 336. row ***************************
    path: web/polls/poll_check_by_ip
    value: 0
    scope_id: 0
    *************************** 337. row ***************************
    path: web/secure/base_js_url
    value: {{secure_base_url}}js/
    scope_id: 0
    *************************** 338. row ***************************
    path: web/secure/base_js_url
    value: https://internal.company-name.com/js/
    scope_id: 2
    *************************** 339. row ***************************
    path: web/secure/base_link_url
    value: {{secure_base_url}}
    scope_id: 0
    *************************** 340. row ***************************
    path: web/secure/base_media_url
    value: https://static.company-name.com/skin/frontend/company-name/default/
    scope_id: 0
    *************************** 341. row ***************************
    path: web/secure/base_media_url
    value: https://internal.company-name.com/skin/
    scope_id: 2
    *************************** 342. row ***************************
    path: web/secure/base_media_url
    value: https://static.company-name.com/skin/frontend/company-name/default/
    scope_id: 2
    *************************** 343. row ***************************
    path: web/secure/base_skin_url
    value: {{secure_base_url}}skin/
    scope_id: 0
    *************************** 344. row ***************************
    path: web/secure/base_skin_url
    value: {{secure_base_url}}skin/
    scope_id: 2
    *************************** 345. row ***************************
    path: web/secure/base_url
    value: https://www.company-name.com/
    scope_id: 0
    *************************** 346. row ***************************
    path: web/secure/base_url
    value: https://internal.company-name.com/
    scope_id: 2
    *************************** 347. row ***************************
    path: web/secure/offloader_header
    value: SSL_OFFLOADED
    scope_id: 0
    *************************** 348. row ***************************
    path: web/secure/use_in_adminhtml
    value: 1
    scope_id: 0
    *************************** 349. row ***************************
    path: web/secure/use_in_frontend
    value: 1
    scope_id: 0
    *************************** 350. row ***************************
    path: web/seo/use_rewrites
    value: 1
    scope_id: 0
    *************************** 351. row ***************************
    path: web/session/use_frontend_sid
    value: 0
    scope_id: 0
    *************************** 352. row ***************************
    path: web/session/use_http_user_agent
    value: 0
    scope_id: 0
    *************************** 353. row ***************************
    path: web/session/use_http_via
    value: 0
    scope_id: 0
    *************************** 354. row ***************************
    path: web/session/use_http_x_forwarded_for
    value: 1
    scope_id: 0
    *************************** 355. row ***************************
    path: web/session/use_remote_addr
    value: 0
    scope_id: 0
    *************************** 356. row ***************************
    path: web/unsecure/base_js_url
    value: {{unsecure_base_url}}js/
    scope_id: 0
    *************************** 357. row ***************************
    path: web/unsecure/base_js_url
    value: http://internal.company-name.com/js/
    scope_id: 2
    *************************** 358. row ***************************
    path: web/unsecure/base_link_url
    value: {{unsecure_base_url}}
    scope_id: 0
    *************************** 359. row ***************************
    path: web/unsecure/base_media_url
    value: http://static.company-name.com/skin/frontend/company-name/default/
    scope_id: 0
    *************************** 360. row ***************************
    path: web/unsecure/base_media_url
    value: http://static.company-name.com/skin/frontend/company-name/default/
    scope_id: 2
    *************************** 361. row ***************************
    path: web/unsecure/base_skin_url
    value: {{unsecure_base_url}}skin/
    scope_id: 0
    *************************** 362. row ***************************
    path: web/unsecure/base_skin_url
    value: {{unsecure_base_url}}skin/
    scope_id: 2
    *************************** 363. row ***************************
    path: web/unsecure/base_url
    value: http://www.company-name.com/
    scope_id: 0
    *************************** 364. row ***************************
    path: web/unsecure/base_url
    value: http://internal.company-name.com/
    scope_id: 2
    *************************** 365. row ***************************
    path: web/url/redirect_to_base
    value: 0
    scope_id: 0
    *************************** 366. row ***************************
    path: web/url/use_store
    value: 0
    scope_id: 0
    366 rows in set (0.00 sec)
  26. Reid Parham revised this gist Aug 7, 2013. 1 changed file with 24 additions and 0 deletions.
    24 changes: 24 additions & 0 deletions 0: Magento 1.12 Enterprise multi-store cluster configuration
    View file
    Original file line number Diff line number Diff line change
    @@ -52,6 +52,7 @@ Three Redis instances are used to increase throughput and provide fine-tuning of

    ### Performance

    * 3,000 commands per second
    * 0.7 ms average response time
    * load average of 1.0 to 1.5
    * CPU utilization averages 7%
    @@ -86,3 +87,26 @@ Quad Intel(R) Xeon(R) CPU E5-2620 0 @ 2.00GHz (6 cores each)
    128 GB buffered DDR3 1333 MHz RAM
    Mechanical disks, RAID 1, hardware controller
    Redis 2.6.11

    ## Database hosts

    There are two hosts running MySQL 5.6.11 in a master-slave configuration with warm failover.


    ### Performance

    * 1,500 commands per second
    * 1.1 ms average response time
    * load average of 0.1 (master) and 0.4 (slave)
    * CPU utilization averages 0% (master) and 1.5% (slave)
    * disk IO averages 1% (master) and 0.5% (slave)
    * network throughput averages 40 mbps transmitted (slave) and 0.7 mbps received (master)

    ### Configuration

    Ubuntu 12.04 LTS 64-bit
    3.5.0-34-generic GNU/Linux
    Quad Intel(R) Xeon(R) CPU E7- 2860 @ 2.27GHz (10 cores each)
    128 GB buffered DDR3 1333 MHz RAM
    SSD, RAID 1+0, hardware controller
    MySQL 5.6.11 with tcmalloc
  27. Reid Parham revised this gist Aug 7, 2013. No changes.
  28. Reid Parham revised this gist Aug 7, 2013. No changes.
  29. Reid Parham renamed this gist Aug 7, 2013. 1 changed file with 0 additions and 0 deletions.
    0 0: cluster setup → ...erprise multi-store cluster configuration
    View file
    File renamed without changes.
  30. Reid Parham revised this gist Aug 7, 2013. No changes.