aoepeople/aoe_dbretry

Magento DB adapter that will retry lost connections and deadlocks

Installs: 42 812

Dependents: 0

Suggesters: 0

Security: 0

Stars: 67

Watchers: 45

Forks: 16

Open Issues: 4

Type:magento-module

dev-master 2018-01-25 10:04 UTC

This package is not auto-updated.

Last update: 2020-11-27 21:43:03 UTC


README

AOE

Aoe_DbRetry Magento Module Build Status

License

OSL v3.0

Contributors

Compatability

  • Module Dependencies
    • Mage_Core (implicit)

Description

This module is very simple and focus on one task. It replaces the DB adapter with an extended version that will retry queries if the connection is lost, the query cannot obtain a needed lock, or a deadlock occours. These three situations are detected via exception messages. The underlying (parent) code actually wraps at least one of these exceptions up inside another exception, so we check for that and unwrap the exception if needed.

Configuration

  • </app/etc/local.xml>/config/global/resources/{connection name}/connection/retries
    • {connection_name} is referring to the named connection, like 'default_setup' which is the default connection
    • Integer number between 0 and 5 that indicates how many times to retry the query
    • Default value is 5 retries
  • </app/etc/local.xml>/config/global/resources/{connection name}/connection/retry_power
    • {connection_name} is referring to the named connection, like 'default_setup' which is the default connection
    • Integer number between 1 and 5 that indicate the power of the exponential backoff feature
    • Default value is 2
    • Used in: {sleep seconds} = pow({try}, {retry_power})

NOTES

  • This module is currently being written for PHP 5.4+ and Magento CE 1.8+ support only.
  • When PHP 5.4 hits EOL, the minimum requirements will be updated to reflect this.