Search Results
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 |
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. …
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. …
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. …
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 …