REPLICATION SLAVE ADMIN Privilege

DETAILS

Grants ability to start/monitor/stop slave and apply binlog events. Added in MariaDB Enterprise Server 10.5 as fine-grained SUPER privilege to reduce the dependency on SUPER. Prior to version 10.5, REPLICATION SLAVE ADMIN was part of SUPER.

REPLICATION SLAVE ADMIN was added in ES 10.5 and is an alias for REPLICATION REPLICA ADMIN.

REPLICATION SLAVE ADMIN was changed in ES10.5.8-5. The following abilities removed from REPLICATION SLAVE ADMIN and now granted with REPLICA MONITOR: SHOW REPLICA STATUS, SHOW SLAVE STATUS, SHOW ALL REPLICAS STATUS, SHOW ALL SLAVES STATUS, SHOW RELAYLOG EVENTS.

In ES10.5.8-5, REPLICATION SLAVE ADMIN grants:

• BINLOG,

• CHANGE MASTER TO ,

• START ALL REPLICAS,

• START ALL SLAVES,

• START REPLICA,

• START SLAVE,

• STOP ALL REPLICAS,

• STOP ALL SLAVES,

• STOP REPLICA,

• STOP SLAVE,

• SET (some variables only).

  • gtid_cleanup_batch_size

  • gtid_ignore_duplicates

  • gtid_pos_auto_engines

  • gtid_slave_pos

  • gtid_strict_mode

  • init_slave

  • relay_log_purge

  • relay_log_recovery

  • replicate_events_marked_for_skip

  • replicate_do_db

  • replicate_do_table

  • replicate_ignore_db

  • replicate_ignore_table

  • replicate_wild_do_table

  • replicate_wild_ignore_table

  • read_binlog_speed_limit

  • slave_compressed_protocol

  • slave_ddl_exec_mode

  • slave_domain_parallel_threads

  • slave_exec_mode

  • slave_max_allowed_packet

  • slave_net_timeout

  • slave_parallel_max_queued

  • slave_parallel_mode

  • slave_parallel_threads

  • slave_parallel_workers

  • slave_run_triggers_for_rbr

  • slave_sql_verify_checksum

  • slave_transaction_retry_interval

  • slave_type_conversions

  • sync_master_info

  • sync_relay_log

  • sync_relay_log_info

Prior to ES10.5.8-5, REPLICATION SLAVE ADMIN grants:

• BINLOG,

• CHANGE MASTER TO ,

• SHOW ALL REPLICAS STATUS ,

• SHOW ALL SLAVES STATUS,

• SHOW RELAYLOG EVENTS,

• SHOW REPLICA STATUS,

• SHOW SLAVE STATUS,

• START ALL REPLICAS,

• START ALL SLAVES,

• START REPLICA,

• START SLAVE,

• STOP ALL REPLICAS,

• STOP ALL SLAVES,

• STOP REPLICA,

• STOP SLAVE,

• SET (some variables only).

  • gtid_cleanup_batch_size

  • gtid_ignore_duplicates

  • gtid_pos_auto_engines

  • gtid_slave_pos

  • gtid_strict_mode

  • init_slave

  • relay_log_purge

  • relay_log_recovery

  • replicate_events_marked_for_skip

  • replicate_do_db

  • replicate_do_table

  • replicate_ignore_db

  • replicate_ignore_table

  • replicate_wild_do_table

  • replicate_wild_ignore_table

  • read_binlog_speed_limit

  • slave_compressed_protocol

  • slave_ddl_exec_mode

  • slave_domain_parallel_threads

  • slave_exec_mode

  • slave_max_allowed_packet

  • slave_net_timeout

  • slave_parallel_max_queued

  • slave_parallel_mode

  • slave_parallel_threads

  • slave_parallel_workers

  • slave_run_triggers_for_rbr

  • slave_sql_verify_checksum

  • slave_transaction_retry_interval

  • slave_type_conversions

  • sync_master_info

  • sync_relay_log

  • sync_relay_log_info

EXTERNAL REFERENCES

• Information specific to MariaDB SkySQL can be found on the REPLICATION SLAVE ADMIN page in the SkySQL Documentation.