How to stop mysql writes globally for certain period of time?

MySQL & MariaDB Percona Distribution for MySQL
1

Checking something similar to FLUSH TABLES WITH READ LOCK but need to stop writes even when the current session where the above command issued is active.

Changing user privileges throw error to user. So thinking of any better way of freezing writes in MySQL. Any leads would be helpful.

Thanks ahead!

1 Like
2

Hello, check out super-read-only option

2 Likes
3

I’d like to understand your need for this. Can you explain the use case?

SET GLOBAL super_read_only=1

1 Like
4

Need to freeze writes in MySQL level during DC switch. Any option available in community edition ?

1 Like
5

@preethi_subbu, yes, see above.

1 Like