Hey there, it seems that Spryker is prepared to handle database connections to read replicas [1], [2

U013KSS3MM0

Hey there, it seems that Spryker is prepared to handle database connections to read replicas [1], [2]. Can we assume that it's working out of the box? Is there anything to consider using it?

[1] https://github.com/spryker/propel/blob/3.29.1/src/Spryker/Shared/Propel/PropelConstants.php#L166
[2] https://github.com/spryker-shop/suite/blob/1.7/config/Shared/config_default.php#L260

Stanislav Matveyev

It's enabled already in https://github.com/spryker-shop/suite/blob/1.7/config/Shared/config_propel.php#L22
It uses Propel infrastructure, see the Propel docs http://propelorm.org/documentation/cookbook/replication.html

so you can use it in your code:

$con = Propel::getReadConnection(MyTableMap::DATABASE_NAME);
$books = BookQuery::create()->find($con);

how it works:

    /**
     * Get a read connection for a given datasource.
     *
     * If the slave connection has not been opened, open it using a random read connection
     * setting for the related datasource. If no read connection setting exist, return the master
     * connection. If the slave connection has already been opened, return it.
     *
     * @param string $name The datasource name that is used to look up the DSN
     *                     from the runtime configuration file. Empty name not allowed.
     *
     * @return \Propel\Runtime\Connection\ConnectionInterface A database connection
     */
    public static function getReadConnection($name)
    {
        return self::$serviceContainer->getReadConnection($name);
    }

U013KSS3MM0

Sounds good! We'll give it a try, thanks!