REPLICATION REPLICA Privilege

Overview

In 10.6 ES, 10.5 ES:

Grants ability to read binary log events from the primary (needed by replicas). Added in MariaDB Enterprise Server 10.5 as alias of REPLICATION SLAVE.

In 10.4 ES:

Not present

See also: Privileges in 10.6 ES, in 10.5 ES, and in 10.4 ES

DETAILS

  • Grants ability to read binary log events from the primary. REQUIRED by replicas.

  • REPLICATION REPLICA was added as an alias for REPLICATION SLAVE in ES 10.5.

  • In ES10.5, REPLICATION SLAVE can no longer execute SHOW RELAYLOG EVENTS. In ES10.5 versions earlier than ES10.5.8-5, SHOW RELAYLOG EVENTS requires REPLICATION REPLICA ADMIN. In ES10.5.8-5, SHOW RELAYLOG EVENTS requires REPLICA MONITOR.

  • In ES10.5 REPLICATION SLAVE can no longer execute SHOW BINLOG EVENTS. SHOW BINLOG EVENTS requires BINLOG MONITOR.

  • If a user upgrades from ES10.4 or earlier to ES10.5.8-5 or later, any users with REPLICATION CLIENT and REPLICATION SLAVE privileges will automatically be granted the REPLICA MONITOR privilege. This privilege upgrade happens upon server startup, so mysql_upgrade is not required.

  • The upgrade behavior does not apply to minor release upgrades that upgrade from ES10.5.6-4 or earlier ES10.5.x release to ES10.5.8-5 or later.

CHANGE HISTORY

Release Series

History

10.6 Enterprise

  • Present starting in MariaDB Enterprise Server 10.6.4-1.

10.5 Enterprise

  • Added in MariaDB Enterprise Server 10.5.3-1.

10.4 Enterprise

  • Not present.

EXTERNAL REFERENCES