Skip to main content
Search type Search syntax
Tags [tag]
Exact "words here"
Author user:1234
user:me (yours)
Score score:3 (3+)
score:0 (none)
Answers answers:3 (3+)
answers:0 (none)
isaccepted:yes
hasaccepted:no
inquestion:1234
Views views:250
Code code:"if (foo != bar)"
Sections title:apples
body:"apples oranges"
URL url:"*.example.com"
Saves in:saves
Status closed:yes
duplicate:no
migrated:no
wiki:no
Types is:question
is:answer
Exclude -[tag]
-apples
For more details on advanced search visit our help page
Results tagged with
Search options not deleted user 119024

Replication is the process of sharing any level of information so as to ensure consistency between redundant hardware/software resources to improve reliability, fault-tolerance, and accessibility

1 vote

MySQL:How to correct a corrupted MySQL binary log on Master server?

The optimal solution that will definitely fix it without any risk of anomalies is to fully re-initialize the replication. … Replication can be expensive if you have terabytes of data, so there may be a way you can restore replication without rebuilding the slave completely. …
Ramisha Farrukh's user avatar
1 vote

What max_allowed_packet is big enough, and why do I need to change it?

So, my suggestion, you may need to reset slave replication coordinates. Use mysqlbinlog on the master to identify where the transactions begin, and look for the adjacent transactions. …
Ramisha Farrukh's user avatar
1 vote

MariaDB replication failure: Fatal error 1236 - binlog shows 'Event truncated'

The optimal solution that will definitely fix it without any risk of anomalies is to fully re-initialize the replication. … Replication can be expensive if you have terabytes of data, so there may be a way you can restore replication without rebuilding the slave completely. …
Ramisha Farrukh's user avatar
1 vote

What can cause TRUNCATE TABLE to take a really long time?

First of all you should use latest version of MySQL or MariaDB as in these version this bug has been fixed. This bug can come up when you DROP or TRUNCATE a table and you have a large buffer pool, the …
Ramisha Farrukh's user avatar