Zend Framework应用层的Master/Slave切换

2021-12-29 00:00:00 php zend-framework datamapper master-slave

我正在编写一个应用程序，它需要在应用程序层内进行主/从切换.就像现在一样，我在创建映射器时实例化一个 Zend_Db_Table 对象，然后 setDefaultAdapter 到从属设备.

I am writing an application which requires the Master/Slave switch to happen inside the application layer. As it is right now, I instantiate a Zend_Db_Table object on creation of the mapper, and then setDefaultAdapter to the slave.

现在在基本映射器类中，我有以下方法:

Now inside of the base mapper classe, I have the following method:

public function useWriteAdapter()
{
    if(Zend_Db_Table_Abstract::getDefaultAdapter() != $this->_writeDb)
    {
        Zend_Db_Table_Abstract::setDefaultAdapter($this->_writeDb);
        $this->_tableGateway = new Zend_Db_Table($this->_tableName);
    }
}

我需要对此进行完整性检查.我不认为开销太大，我只是怀疑一定有更好的方法.

I need a sanity check on this. I don't think the overhead is too much, I just suspect there must be a better way.

推荐答案

Zend_Db_Table_Row_Abstract 类型的对象会记住产生它的 Table 对象.但是您可以在调用 save() 之前更改关联的 Table.

An object of type Zend_Db_Table_Row_Abstract remembers what Table object produced it. But you can change the associated Table before you call save().

$readDb = Zend_Db::factory(...);  // replica
$writeDb = Zend_Db::factory(...); // master
Zend_Db_Table::setDefaultAdapter($readDb);

$myReadTable = new MyTable(); // use default adapter
$myWriteTable = new MyTable($writeDb);

$row = $myTable->find(1234)->current();

$row->column1 = 'value';

$row->setTable($myWriteTable);

$row->save();

相关文章