[Flow] SQL Master-Slave Configuration

Beat Guggisberg beat.guggisberg at eglionline.ch
Thu Sep 25 17:17:45 CEST 2014


Hi

I have a MySQL setup with a masterserver and a slave instance on the maschines where my flow-installation is.

My configuration looks like:
TYPO3:
  Flow:
    persistence:
      backendOptions:
        wrapperClass: 'Doctrine\DBAL\Connections\MasterSlaveConnection'
        master:
          host: 'mysqlmaster'
          dbname: 'flow'
          user: 'rw'
          password: '********'
        slaves:
          slave1:
            host: '127.0.0.1'
            dbname: 'flow'
            user: 'ro'
            password: '********'

Now i get some problems.
The doctrine:migrate works fine, all Tables are created.
When i now login to the site, it stores the typo3_flow_security_account but it does not create the entrys in typo3_flow_security_account_roles_join.
This cant work because typo3_flow_security_policy_role is empty.

With the config
TYPO3:
  Flow:
    persistence:
      backendOptions:
        host: 'mysqlmaster'
        dbname: 'flow'
        user: 'rw'
        password: '********'

typo3_flow_security_policy_role gets automaticaly filled with all the roles defined and so the creation of an account with roles also works.

Is this a Bug or do i miss something?

Thanks and regards
Beat


More information about the Flow mailing list