Post Profile

Using the super_read_only system variable

This blog post will discuss how to use the MySQL super_read_only system variable. It is well known that replica servers in a master/slave configuration, to avoid breaking replication due to duplicate keys, missing rows or other similar issues, should not receive write queries. It’s a good practice to set [crayon-57eabfdcc1874180652561-i/] on slave servers to prevent any […]
read more


Related Posts

Estimating potential for MySQL 5.7 parallel replication

Programming / Database Development : MySQL Performance Blog

Unlike MySQL 5.6, where parallel replication can only be used when replicas have several schemas, MySQL 5.7 replicas can read binlog group commit information coming from the master to replicate transactions in parallel even when...

Actively monitoring replication connectivity with MySQL’s heartbeat

Programming / Database Development : MySQL Performance Blog

Until MySQL 5.5 the only variable used to identify a network connectivity problem between Master and Slave was slave-net-timeout. This variable specifies the number of seconds to wait for more Binary Logs events from the master befo...

RESET SLAVE vs. RESET SLAVE ALL: Disconnecting a replication slave is easier with MySQL 5.5+

Programming / Database Development : MySQL Performance Blog

It’s not uncommon to promote a server from slave to master. One of the key things to protect your data integrity is to make sure that the promoted slave is permanently disconnected from its old master. If not, it may get writes from...

New variable slave_max_allowed_packet for slave servers

Programming / Database Development : MySQL Performance Blog

One month ago I wrote about how a big read_buffer_size could break the replication. The bug is indeed not solved but now there is an official workaround to ease this problem using a new configuration variable: slave_max_allowed_pack...

A deceiving error message while setting a replication slave

Programming / Database Development : The Data Charmer

I was setting up a slave manually for a quick-and-dirty experiment, when I found this one:mysql %gt; slave start;ERROR 1200 (HY000): The server is not configured as slave; fix in config file or with CHANGE MASTER TOHmm... I did the ...


Copyright © 2016 Regator, LLC