Amazon RDS replication with external slaveMysql slave fails to resume from master if master restartedrepairing mysql replicationMySQL replication issues after a power outagePercona system tables corruptedMysql master-master not replicatingmysql - SQL slave thread is not applying changesSetup a mysql replication, but new data are not updatedAmazon RDS to EC2 replication--log-slave-updates is OFF but some updates are still logged to the slave binary log?RDS slave (read replica) not replication
2019 gold coins to share
How do free-speech protections in the United States apply in public to corporate misrepresentations?
Separate SPI data
Live action TV show where High school Kids go into the virtual world and have to clear levels
Is it possible to fly backward if you have really strong headwind?
Are polynomials with the same roots identical?
Does the Nuka-Cola bottler actually generate nuka cola?
Getting UPS Power from One Room to Another
How to befriend someone who doesn't like to talk?
Who voices the small round football sized demon In Good Omens
Is Lambda Calculus purely syntactic?
Analogy between an unknown in an argument, and a contradiction in the principle of explosion
Can the removal of a duty-free sales trolley result in a measurable reduction in emissions?
Did Apple bundle a specific monitor with the Apple II+ for schools?
Does putting salt first make it easier for attacker to bruteforce the hash?
Why am I getting a strange double quote (“) in Open Office instead of the ordinary one (")?
tabular: caption and align problem
Why was this person allowed to become Grand Maester?
Non-aqueous eyes?
UTC timestamp format for launch vehicles
The origin of the Russian proverb about two hares
Why AM-GM inequality showing different results?
A word that means "blending into a community too much"
What aircraft was used as Air Force One for the flight between Southampton and Shannon?
Amazon RDS replication with external slave
Mysql slave fails to resume from master if master restartedrepairing mysql replicationMySQL replication issues after a power outagePercona system tables corruptedMysql master-master not replicatingmysql - SQL slave thread is not applying changesSetup a mysql replication, but new data are not updatedAmazon RDS to EC2 replication--log-slave-updates is OFF but some updates are still logged to the slave binary log?RDS slave (read replica) not replication
.everyoneloves__top-leaderboard:empty,.everyoneloves__mid-leaderboard:empty,.everyoneloves__bot-mid-leaderboard:empty height:90px;width:728px;box-sizing:border-box;
I've recently configured a replication with an external MySQL master and RDS as slave but now I need to reverse that config and use RDS as master and the other instance as slave.
Actually I use a vpn and the other instance is outside AWS.
I changed the server host and password but I got this error:
141103 11:35:44 [ERROR] Error reading packet from server: Binary log is not open ( server_errno=1236)
141103 11:35:44 [ERROR] Slave I/O: Got fatal error 1236 from master when reading data from binary log: 'Binary log is not open', Error_code: 1236
141103 11:35:44 [Note] Slave I/O thread exiting, read up to log 'mysql-bin.000007', position 284079763
141103 11:37:09 [Note] Error reading relay log event: slave SQL thread was killed
Perhaps I didn't get the right log filename and postion? but I can't find them in to RDS.
amazon-web-services replication rds
edited Mar 23 '15 at 15:41
HopelessN00b
48.7k25117194
asked Nov 3 '14 at 12:09
DaveDave
12
add a comment |
I've recently configured a replication with an external MySQL master and RDS as slave but now I need to reverse that config and use RDS as master and the other instance as slave.
Actually I use a vpn and the other instance is outside AWS.
I changed the server host and password but I got this error:
141103 11:35:44 [ERROR] Error reading packet from server: Binary log is not open ( server_errno=1236)
141103 11:35:44 [ERROR] Slave I/O: Got fatal error 1236 from master when reading data from binary log: 'Binary log is not open', Error_code: 1236
141103 11:35:44 [Note] Slave I/O thread exiting, read up to log 'mysql-bin.000007', position 284079763
141103 11:37:09 [Note] Error reading relay log event: slave SQL thread was killed
Perhaps I didn't get the right log filename and postion? but I can't find them in to RDS.
amazon-web-services replication rds
edited Mar 23 '15 at 15:41
HopelessN00b
48.7k25117194
asked Nov 3 '14 at 12:09
DaveDave
12
add a comment |
I've recently configured a replication with an external MySQL master and RDS as slave but now I need to reverse that config and use RDS as master and the other instance as slave.
Actually I use a vpn and the other instance is outside AWS.
I changed the server host and password but I got this error:
141103 11:35:44 [ERROR] Error reading packet from server: Binary log is not open ( server_errno=1236)
141103 11:35:44 [ERROR] Slave I/O: Got fatal error 1236 from master when reading data from binary log: 'Binary log is not open', Error_code: 1236
141103 11:35:44 [Note] Slave I/O thread exiting, read up to log 'mysql-bin.000007', position 284079763
141103 11:37:09 [Note] Error reading relay log event: slave SQL thread was killed
Perhaps I didn't get the right log filename and postion? but I can't find them in to RDS.
amazon-web-services replication rds
edited Mar 23 '15 at 15:41
HopelessN00b
48.7k25117194
asked Nov 3 '14 at 12:09
DaveDave
12
I've recently configured a replication with an external MySQL master and RDS as slave but now I need to reverse that config and use RDS as master and the other instance as slave.
Actually I use a vpn and the other instance is outside AWS.
I changed the server host and password but I got this error:
141103 11:35:44 [ERROR] Error reading packet from server: Binary log is not open ( server_errno=1236)
141103 11:35:44 [ERROR] Slave I/O: Got fatal error 1236 from master when reading data from binary log: 'Binary log is not open', Error_code: 1236
141103 11:35:44 [Note] Slave I/O thread exiting, read up to log 'mysql-bin.000007', position 284079763
141103 11:37:09 [Note] Error reading relay log event: slave SQL thread was killed
Perhaps I didn't get the right log filename and postion? but I can't find them in to RDS.
amazon-web-services replication rds
amazon-web-services replication rds
edited Mar 23 '15 at 15:41
HopelessN00b
48.7k25117194
asked Nov 3 '14 at 12:09
DaveDave
12
edited Mar 23 '15 at 15:41
HopelessN00b
48.7k25117194
asked Nov 3 '14 at 12:09
DaveDave
12
edited Mar 23 '15 at 15:41
HopelessN00b
48.7k25117194
edited Mar 23 '15 at 15:41
HopelessN00b
48.7k25117194
edited Mar 23 '15 at 15:41
HopelessN00b
48.7k25117194
48.7k25117194
asked Nov 3 '14 at 12:09
DaveDave
12
asked Nov 3 '14 at 12:09
DaveDave
12
asked Nov 3 '14 at 12:09
DaveDave
12
12
add a comment |
add a comment |
1 Answer
1
active
oldest
votes
Finding the right position is kind of tricky.
- Spin up a RDS read replica
- stop the replication manually with
mysql.rds_stop_replication - use
mysql> SHOW SLAVE STATUSGto get needed information for the next steps - the
Exec_Master_Log_Posvariable will tell you the master binlog position the slave currently is - the binlog file name can be found in variable
Relay_Master_Log_File
One additional advice: be careful with this setup. It is not officially supported by AWS to run a permanent replication to an external slave. Pleas see ...
http://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/MySQL.Procedural.Exporting.NonRDSRepl.html
answered Nov 22 '14 at 17:45
phpworkxphpworkx
1
add a comment |
Your Answer
StackExchange.ready(function()
var channelOptions =
tags: "".split(" "),
id: "2"
;
initTagRenderer("".split(" "), "".split(" "), channelOptions);
StackExchange.using("externalEditor", function()
// Have to fire editor after snippets, if snippets enabled
if (StackExchange.settings.snippets.snippetsEnabled)
StackExchange.using("snippets", function()
createEditor();
);
else
createEditor();
);
function createEditor()
StackExchange.prepareEditor(
heartbeatType: 'answer',
autoActivateHeartbeat: false,
convertImagesToLinks: true,
noModals: true,
showLowRepImageUploadWarning: true,
reputationToPostImages: 10,
bindNavPrevention: true,
postfix: "",
imageUploader:
brandingHtml: "Powered by u003ca class="icon-imgur-white" href="https://imgur.com/"u003eu003c/au003e",
contentPolicyHtml: "User contributions licensed under u003ca href="https://creativecommons.org/licenses/by-sa/3.0/"u003ecc by-sa 3.0 with attribution requiredu003c/au003e u003ca href="https://stackoverflow.com/legal/content-policy"u003e(content policy)u003c/au003e",
allowUrls: true
,
onDemand: true,
discardSelector: ".discard-answer"
,immediatelyShowMarkdownHelp:true
);
);
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function ()
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fserverfault.com%2fquestions%2f641595%2famazon-rds-replication-with-external-slave%23new-answer', 'question_page');
);
Post as a guest
Required, but never shown
1 Answer
1
active
oldest
votes
1 Answer
1
active
oldest
votes
active
oldest
votes
active
oldest
votes
Finding the right position is kind of tricky.
- Spin up a RDS read replica
- stop the replication manually with
mysql.rds_stop_replication - use
mysql> SHOW SLAVE STATUSGto get needed information for the next steps - the
Exec_Master_Log_Posvariable will tell you the master binlog position the slave currently is - the binlog file name can be found in variable
Relay_Master_Log_File
One additional advice: be careful with this setup. It is not officially supported by AWS to run a permanent replication to an external slave. Pleas see ...
http://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/MySQL.Procedural.Exporting.NonRDSRepl.html
answered Nov 22 '14 at 17:45
phpworkxphpworkx
1
add a comment |
Finding the right position is kind of tricky.
- Spin up a RDS read replica
- stop the replication manually with
mysql.rds_stop_replication - use
mysql> SHOW SLAVE STATUSGto get needed information for the next steps - the
Exec_Master_Log_Posvariable will tell you the master binlog position the slave currently is - the binlog file name can be found in variable
Relay_Master_Log_File
One additional advice: be careful with this setup. It is not officially supported by AWS to run a permanent replication to an external slave. Pleas see ...
http://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/MySQL.Procedural.Exporting.NonRDSRepl.html
answered Nov 22 '14 at 17:45
phpworkxphpworkx
1
add a comment |
Finding the right position is kind of tricky.
- Spin up a RDS read replica
- stop the replication manually with
mysql.rds_stop_replication - use
mysql> SHOW SLAVE STATUSGto get needed information for the next steps - the
Exec_Master_Log_Posvariable will tell you the master binlog position the slave currently is - the binlog file name can be found in variable
Relay_Master_Log_File
One additional advice: be careful with this setup. It is not officially supported by AWS to run a permanent replication to an external slave. Pleas see ...
http://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/MySQL.Procedural.Exporting.NonRDSRepl.html
answered Nov 22 '14 at 17:45
phpworkxphpworkx
1
Finding the right position is kind of tricky.
- Spin up a RDS read replica
- stop the replication manually with
mysql.rds_stop_replication - use
mysql> SHOW SLAVE STATUSGto get needed information for the next steps - the
Exec_Master_Log_Posvariable will tell you the master binlog position the slave currently is - the binlog file name can be found in variable
Relay_Master_Log_File
One additional advice: be careful with this setup. It is not officially supported by AWS to run a permanent replication to an external slave. Pleas see ...
http://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/MySQL.Procedural.Exporting.NonRDSRepl.html
answered Nov 22 '14 at 17:45
phpworkxphpworkx
1
answered Nov 22 '14 at 17:45
phpworkxphpworkx
1
answered Nov 22 '14 at 17:45
phpworkxphpworkx
1
answered Nov 22 '14 at 17:45
phpworkxphpworkx
1
1
add a comment |
add a comment |
Thanks for contributing an answer to Server Fault!
- Please be sure to answer the question. Provide details and share your research!
But avoid …
- Asking for help, clarification, or responding to other answers.
- Making statements based on opinion; back them up with references or personal experience.
To learn more, see our tips on writing great answers.
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function ()
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fserverfault.com%2fquestions%2f641595%2famazon-rds-replication-with-external-slave%23new-answer', 'question_page');
);
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
