Issue Feature Closed

#55157Support for MySQL replication

Pascal Dürsteler 01/20/14, 10:42 updated 12/12/14, 23:41

Description

I made a setup which runs on two different hosts, with a MySQL master (A) and slave (B) replication. However, there is IMHO a lot of optimization potential.

The main problem occurs when visiting the page on B. As TYPO3 wants to write data to e.g fe_session_data or index_*, the slave will lock up on the next few transactions because of a duplicate primary key error. However, setting B’s mysql to read only will result in failed queries.

Related: http://forge.typo3.org/issues/17088

I am not sure if that would generally help, but maybe an option in the install tool to set the TYPO3 instance to a “slave” mode would trigger a switch in the persistence layer to not execute INSERT and UPDATE statements on the slave. Of course, this would be extension- and setup-dependent, because you can’t e.g. edit your fe_user profile on the slave then.

I just wanted to “braindump” this here, maybe it results in a constructive discussion and an enhancement to TYPO3, or it gets ignored or buried.

Reviews 0

No change resolves or names this issue in its commit message, and no comment links one.