Database replication

Replication was added in Tiki5, thanks to SUMO.

This permits to send all write queries to master MySQL server, while the read requests can do to MySQL slave servers.

To use:

add to db/local.php
Copy to clipboard
$shadow_host = 'localhost'; $shadow_user = 'root'; $shadow_pass = 'foobar'; $shadow_dbs = 'tiki4_slave';

See also

  • MySQL
  • MariaDB
  • MySQL SSL
  • Database independence
alias
  • Database replication
  • Master and Slave MySQL
  • Master and Slave Database

The original document is available at https://markdowndoc.tiki.org/MySQL+replication