mirror of
https://github.com/MariaDB/server.git
synced 2025-02-06 22:02:20 +01:00
25b5c63905
This commit adds 3 new status variables to 'show all slaves status':
- Master_last_event_time ; timestamp of the last event read from the
master by the IO thread.
- Slave_last_event_time ; Master timestamp of the last event committed
on the slave.
- Master_Slave_time_diff: The difference of the above two timestamps.
All the above variables are NULL until the slave has started and the
slave has read one query event from the master that changes data.
- Added information_schema.slave_status, which allows us to remove:
- show_master_info(), show_master_info_get_fields(),
send_show_master_info_data(), show_all_master_info()
- class Sql_cmd_show_slave_status.
- Protocol::store(I_List<i_string_pair>* str_list) as it is not
used anymore.
- Changed old SHOW SLAVE STATUS and SHOW ALL SLAVES STATUS to
use the SELECT code path, as all other SHOW ... STATUS commands.
Other things:
- Xid_log_time is set to time of commit to allow slave that reads the
binary log to calculate Master_last_event_time and
Slave_last_event_time.
This is needed as there is not 'exec_time' for row events.
- Fixed that Load_log_event calculates exec_time identically to
Query_event.
- Updated RESET SLAVE to reset Master/Slave_last_event_time
- Updated SQL thread's update on first transaction read-in to
only update Slave_last_event_time on group events.
- Fixed possible (unlikely) bugs in sql_show.cc ...old_format() functions
if allocation of 'field' would fail.
Reviewed By:
Brandon Nesterenko <brandon.nesterenko@mariadb.com>
Kristian Nielsen <knielsen@knielsen-hq.org>
92 lines
3 KiB
Text
92 lines
3 KiB
Text
# ==== Purpose ====
|
|
#
|
|
# SLAVE MONITOR privilege is required to execute following commands.
|
|
# SHOW SLAVE STATUS
|
|
# SHOW RELAYLOG EVENTS
|
|
#
|
|
# ==== Implementation ====
|
|
#
|
|
# Step1: GRANT ALL privileges for a new user 'user1' and then REVOKE
|
|
# SLAVE MONITOR privileges.
|
|
# Step2: Execute SHOW SLAVE STAUTS/SHOW RELAYLOG EVENTS commands and expect
|
|
# ER_SPECIFIC_ACCESS_DENIED_ERROR. This also verifies that REPLICATION
|
|
# SLAVE ADMIN privilege is not required for these two commands.
|
|
# Step3: GRANT SLAVE MONITOR privilege and observe that both commands are
|
|
# allowd to execute.
|
|
#
|
|
# ==== References ====
|
|
#
|
|
# MDEV-23610: Slave user can't run "SHOW SLAVE STATUS" anymore after upgrade
|
|
# to 10.5, mysql_upgrade should take of that
|
|
# MDEV-23918: admin privlege required to view contents of relay logs in 10.5
|
|
#
|
|
|
|
--source include/not_embedded.inc
|
|
|
|
CREATE USER user1@localhost IDENTIFIED BY '';
|
|
GRANT ALL PRIVILEGES ON *.* TO user1@localhost;
|
|
REVOKE SLAVE MONITOR ON *.* FROM user1@localhost;
|
|
FLUSH PRIVILEGES;
|
|
|
|
--connect(con1,localhost,user1,,)
|
|
--connection con1
|
|
SHOW GRANTS;
|
|
|
|
--echo #
|
|
--echo # Verify that having REPLICATION SLAVE ADMIN doesn't allow SHOW SLAVE STATUS
|
|
--echo # Expected error: Access denied; you need (at least one of) the SLAVE MONITOR privilege(s) for this operation
|
|
--echo #
|
|
--error ER_SPECIFIC_ACCESS_DENIED_ERROR
|
|
SHOW SLAVE STATUS;
|
|
--error ER_SPECIFIC_ACCESS_DENIED_ERROR
|
|
SELECT * from information_schema.slave_status;
|
|
|
|
--echo #
|
|
--echo # Verify that having REPLICATION SLAVE ADMIN doesn't allow SHOW RELAYLOG EVENTS
|
|
--echo # Expected error: Access denied; you need (at least one of) the REPLICA MONITOR
|
|
--echo # privilege(s) for this operation
|
|
--echo #
|
|
--disable_ps_protocol
|
|
--error ER_SPECIFIC_ACCESS_DENIED_ERROR
|
|
SHOW RELAYLOG EVENTS;
|
|
--enable_ps_protocol
|
|
--disconnect con1
|
|
|
|
--echo #
|
|
--echo # SHOW SLAVE STATUS and SHOW RELAYLOG EVENTS are allowed with SLAVE MONITOR privilege
|
|
--echo #
|
|
|
|
--connection default
|
|
GRANT SLAVE MONITOR ON *.* TO user1@localhost;
|
|
FLUSH PRIVILEGES;
|
|
|
|
--connect(con1,localhost,user1,,)
|
|
--connection con1
|
|
SHOW GRANTS;
|
|
|
|
--disable_result_log
|
|
SHOW SLAVE STATUS;
|
|
--disable_ps_protocol
|
|
SHOW RELAYLOG EVENTS;
|
|
--enable_ps_protocol
|
|
--enable_result_log
|
|
--disconnect con1
|
|
|
|
--connection default
|
|
DROP USER user1@localhost;
|
|
|
|
--echo #
|
|
--echo # MDEV-25030 Upgrade to 10.5.9 breaks root's ability to grant
|
|
--echo #
|
|
insert mysql.global_priv values ('bar', 'foo7', '{"access":274877906943,"version_id":100507,"plugin":"mysql_native_password","authentication_string":""}'),
|
|
('bar', 'foo8', '{"access":274877906943,"version_id":100508,"plugin":"mysql_native_password","authentication_string":""}'),
|
|
('bar', 'foo9', '{"access":274877906943,"version_id":100509,"plugin":"mysql_native_password","authentication_string":""}');
|
|
flush privileges;
|
|
show grants for foo7@bar;
|
|
show grants for foo8@bar;
|
|
show grants for foo9@bar;
|
|
drop user foo7@bar, foo8@bar, foo9@bar;
|
|
|
|
--echo #
|
|
--echo # End of 10.5 tests
|
|
--echo #
|