Percona Server moved to https://jira.percona.com/projects/PS

  1. Bug #1539504
  2. Comment #1

Comment 1 for bug 1539504

Revision history for this message
Shahriyar Rzayev (rzayev-sehriyar) wrote :

Hi,

According to Documentation:

http://dev.mysql.com/doc/refman/5.6/en/server-system-variables.html#sysvar_read_only

Even with read_only enabled, the server permits these operations:

    Updates performed by slave threads, if the server is a replication slave. In replication setups, it can be useful to enable read_only on slave servers to ensure that slaves accept updates only from the master server and not from clients.

    Use of ANALYZE TABLE or OPTIMIZE TABLE statements. The purpose of read-only mode is to prevent changes to table structure or contents. Analysis and optimization do not qualify as such changes. This means, for example, that consistency checks on read-only replication slaves can be performed with mysqlcheck --all-databases --analyze.

    Operations on TEMPORARY tables.

So Operations on TEMPORARY tables enabled with read_only.

If it is not related to your report then please provide more information such as, which version you have been used? configuration options both for master and slave server, the error log portions and anything you think will be valuable.