Configuring slave from EC2 master to Amazon RDS slave Announcing the arrival of Valued...
Generate an RGB colour grid
What is the meaning of the simile “quick as silk”?
Most bit efficient text communication method?
Is there a kind of relay only consumes power when switching?
Where are Serre’s lectures at Collège de France to be found?
Compare a given version number in the form major.minor.build.patch and see if one is less than the other
Why do we bend a book to keep it straight?
How to tell that you are a giant?
Can a new player join a group only when a new campaign starts?
Irreducible of finite Krull dimension implies quasi-compact?
How to answer "Have you ever been terminated?"
Can an alien society believe that their star system is the universe?
Trademark violation for app?
An adverb for when you're not exaggerating
Is it ethical to give a final exam after the professor has quit before teaching the remaining chapters of the course?
Why aren't air breathing engines used as small first stages
また usage in a dictionary
How to down pick a chord with skipped strings?
Can you use the Shield Master feat to shove someone before you make an attack by using a Readied action?
Can anything be seen from the center of the Boötes void? How dark would it be?
When a candle burns, why does the top of wick glow if bottom of flame is hottest?
Maximum summed powersets with non-adjacent items
How do I make this wiring inside cabinet safer? (Pic)
Why are there no cargo aircraft with "flying wing" design?
Configuring slave from EC2 master to Amazon RDS slave
Announcing the arrival of Valued Associate #679: Cesar Manara
Planned maintenance scheduled April 17/18, 2019 at 00:00UTC (8:00pm US/Eastern)Replication from EC2 Master to RDS Slave - Connecting to masterCreate a mysql slave database from master databaseMySQL slave replicates changes that are in neither binlog_do_db nor replicate_do_dbmysql master/master replication problemmysql 5.6 gtid replication slave stuck (system lock)?max allowed packet keep changingMaster/Slave MySQL error in replicationMySQL replication error from 5.5 -> 5.6Why isn't my MySQL replication filter working?error connecting to master 'replica@192.168.57.10:3306' mac-ubuntuMySQL Replication Error - Deadlock
.everyoneloves__top-leaderboard:empty,.everyoneloves__mid-leaderboard:empty,.everyoneloves__bot-mid-leaderboard:empty{ margin-bottom:0;
}
I am configuring replication from EC2 master to Amazon RDS instance.
After starting the slave, I don't see any errors but I see slave_IO:
_thread is connecting.
Master version:5.6.23
Slave Version:5.6.19
show slave status G
mysql> show slave status G
*************************** 1. row ***************************
Slave_IO_State: Connecting to master
Master_Host: XXXXXXXXXXX
Master_User: XXXXXX
Master_Port: 3306
Connect_Retry: 60
Master_Log_File: cli-bin.000032
Read_Master_Log_Pos: 713
Relay_Log_File: relaylog.000001
Relay_Log_Pos: 4
Relay_Master_Log_File: cli-bin.000032
Slave_IO_Running: Connecting
Slave_SQL_Running: Yes
Replicate_Do_DB:
Replicate_Ignore_DB:
Replicate_Do_Table:
Replicate_Ignore_Table: mysql.plugin,innodb_memcache.cache_policies,mysql.rds_sysinfo,mysql.rds_replication_status,mysql.rds_history,innodb_memcache.config_options
Replicate_Wild_Do_Table:
Replicate_Wild_Ignore_Table:
Last_Errno: 0
Last_Error:
Skip_Counter: 0
Exec_Master_Log_Pos: 713
Relay_Log_Space: 618
Until_Condition: None
Until_Log_File:
Until_Log_Pos: 0
Master_SSL_Allowed: No
Master_SSL_CA_File:
Master_SSL_CA_Path:
Master_SSL_Cert:
Master_SSL_Cipher:
Master_SSL_Key:
Seconds_Behind_Master: NULL
Master_SSL_Verify_Server_Cert: No
Last_IO_Errno: 0
Last_IO_Error:
Last_SQL_Errno: 0
Last_SQL_Error:
Replicate_Ignore_Server_Ids:
Master_Server_Id: 0
Master_UUID:
Master_Info_File: mysql.slave_master_info
SQL_Delay: 0
SQL_Remaining_Delay: NULL
Slave_SQL_Running_State: Slave has read all relay log; waiting for the slave I/O thread to update it
Master_Retry_Count: 86400
Master_Bind:
Last_IO_Error_Timestamp:
Last_SQL_Error_Timestamp:
Master_SSL_Crl:
Master_SSL_Crlpath:
Retrieved_Gtid_Set:
Executed_Gtid_Set:
Auto_Position: 0
1 row in set (0.00 sec)
show global variables
mysql> show global variables like '%old_passwords%';
+---------------+-------+
| Variable_name | Value |
+---------------+-------+
| old_passwords | 0 |
+---------------+-------+
1 row in set (0.01 sec)
mysql> show global variables like '%secure_auth%';
+---------------+-------+
| Variable_name | Value |
+---------------+-------+
| secure_auth | OFF |
+---------------+-------+
1 row in set (0.00 sec)
====================
The problem is Slave_IO_state is connecting and Slave_io_thread is connecting state but replication is not happening.
mysql replication amazon-rds amazon-ec2
edited Sep 18 '15 at 12:13
Paul White♦
54.2k14288461
asked Mar 18 '15 at 11:15
chandu lakkinenichandu lakkineni
112
bumped to the homepage by Community♦ 4 mins ago
This question has answers that may be good or bad; the system has marked it active so that they can be reviewed.
add a comment |
I am configuring replication from EC2 master to Amazon RDS instance.
After starting the slave, I don't see any errors but I see slave_IO:
_thread is connecting.
Master version:5.6.23
Slave Version:5.6.19
show slave status G
mysql> show slave status G
*************************** 1. row ***************************
Slave_IO_State: Connecting to master
Master_Host: XXXXXXXXXXX
Master_User: XXXXXX
Master_Port: 3306
Connect_Retry: 60
Master_Log_File: cli-bin.000032
Read_Master_Log_Pos: 713
Relay_Log_File: relaylog.000001
Relay_Log_Pos: 4
Relay_Master_Log_File: cli-bin.000032
Slave_IO_Running: Connecting
Slave_SQL_Running: Yes
Replicate_Do_DB:
Replicate_Ignore_DB:
Replicate_Do_Table:
Replicate_Ignore_Table: mysql.plugin,innodb_memcache.cache_policies,mysql.rds_sysinfo,mysql.rds_replication_status,mysql.rds_history,innodb_memcache.config_options
Replicate_Wild_Do_Table:
Replicate_Wild_Ignore_Table:
Last_Errno: 0
Last_Error:
Skip_Counter: 0
Exec_Master_Log_Pos: 713
Relay_Log_Space: 618
Until_Condition: None
Until_Log_File:
Until_Log_Pos: 0
Master_SSL_Allowed: No
Master_SSL_CA_File:
Master_SSL_CA_Path:
Master_SSL_Cert:
Master_SSL_Cipher:
Master_SSL_Key:
Seconds_Behind_Master: NULL
Master_SSL_Verify_Server_Cert: No
Last_IO_Errno: 0
Last_IO_Error:
Last_SQL_Errno: 0
Last_SQL_Error:
Replicate_Ignore_Server_Ids:
Master_Server_Id: 0
Master_UUID:
Master_Info_File: mysql.slave_master_info
SQL_Delay: 0
SQL_Remaining_Delay: NULL
Slave_SQL_Running_State: Slave has read all relay log; waiting for the slave I/O thread to update it
Master_Retry_Count: 86400
Master_Bind:
Last_IO_Error_Timestamp:
Last_SQL_Error_Timestamp:
Master_SSL_Crl:
Master_SSL_Crlpath:
Retrieved_Gtid_Set:
Executed_Gtid_Set:
Auto_Position: 0
1 row in set (0.00 sec)
show global variables
mysql> show global variables like '%old_passwords%';
+---------------+-------+
| Variable_name | Value |
+---------------+-------+
| old_passwords | 0 |
+---------------+-------+
1 row in set (0.01 sec)
mysql> show global variables like '%secure_auth%';
+---------------+-------+
| Variable_name | Value |
+---------------+-------+
| secure_auth | OFF |
+---------------+-------+
1 row in set (0.00 sec)
====================
The problem is Slave_IO_state is connecting and Slave_io_thread is connecting state but replication is not happening.
mysql replication amazon-rds amazon-ec2
edited Sep 18 '15 at 12:13
Paul White♦
54.2k14288461
asked Mar 18 '15 at 11:15
chandu lakkinenichandu lakkineni
112
bumped to the homepage by Community♦ 4 mins ago
This question has answers that may be good or bad; the system has marked it active so that they can be reviewed.
add a comment |
I am configuring replication from EC2 master to Amazon RDS instance.
After starting the slave, I don't see any errors but I see slave_IO:
_thread is connecting.
Master version:5.6.23
Slave Version:5.6.19
show slave status G
mysql> show slave status G
*************************** 1. row ***************************
Slave_IO_State: Connecting to master
Master_Host: XXXXXXXXXXX
Master_User: XXXXXX
Master_Port: 3306
Connect_Retry: 60
Master_Log_File: cli-bin.000032
Read_Master_Log_Pos: 713
Relay_Log_File: relaylog.000001
Relay_Log_Pos: 4
Relay_Master_Log_File: cli-bin.000032
Slave_IO_Running: Connecting
Slave_SQL_Running: Yes
Replicate_Do_DB:
Replicate_Ignore_DB:
Replicate_Do_Table:
Replicate_Ignore_Table: mysql.plugin,innodb_memcache.cache_policies,mysql.rds_sysinfo,mysql.rds_replication_status,mysql.rds_history,innodb_memcache.config_options
Replicate_Wild_Do_Table:
Replicate_Wild_Ignore_Table:
Last_Errno: 0
Last_Error:
Skip_Counter: 0
Exec_Master_Log_Pos: 713
Relay_Log_Space: 618
Until_Condition: None
Until_Log_File:
Until_Log_Pos: 0
Master_SSL_Allowed: No
Master_SSL_CA_File:
Master_SSL_CA_Path:
Master_SSL_Cert:
Master_SSL_Cipher:
Master_SSL_Key:
Seconds_Behind_Master: NULL
Master_SSL_Verify_Server_Cert: No
Last_IO_Errno: 0
Last_IO_Error:
Last_SQL_Errno: 0
Last_SQL_Error:
Replicate_Ignore_Server_Ids:
Master_Server_Id: 0
Master_UUID:
Master_Info_File: mysql.slave_master_info
SQL_Delay: 0
SQL_Remaining_Delay: NULL
Slave_SQL_Running_State: Slave has read all relay log; waiting for the slave I/O thread to update it
Master_Retry_Count: 86400
Master_Bind:
Last_IO_Error_Timestamp:
Last_SQL_Error_Timestamp:
Master_SSL_Crl:
Master_SSL_Crlpath:
Retrieved_Gtid_Set:
Executed_Gtid_Set:
Auto_Position: 0
1 row in set (0.00 sec)
show global variables
mysql> show global variables like '%old_passwords%';
+---------------+-------+
| Variable_name | Value |
+---------------+-------+
| old_passwords | 0 |
+---------------+-------+
1 row in set (0.01 sec)
mysql> show global variables like '%secure_auth%';
+---------------+-------+
| Variable_name | Value |
+---------------+-------+
| secure_auth | OFF |
+---------------+-------+
1 row in set (0.00 sec)
====================
The problem is Slave_IO_state is connecting and Slave_io_thread is connecting state but replication is not happening.
mysql replication amazon-rds amazon-ec2
edited Sep 18 '15 at 12:13
Paul White♦
54.2k14288461
asked Mar 18 '15 at 11:15
chandu lakkinenichandu lakkineni
112
I am configuring replication from EC2 master to Amazon RDS instance.
After starting the slave, I don't see any errors but I see slave_IO:
_thread is connecting.
Master version:5.6.23
Slave Version:5.6.19
show slave status G
mysql> show slave status G
*************************** 1. row ***************************
Slave_IO_State: Connecting to master
Master_Host: XXXXXXXXXXX
Master_User: XXXXXX
Master_Port: 3306
Connect_Retry: 60
Master_Log_File: cli-bin.000032
Read_Master_Log_Pos: 713
Relay_Log_File: relaylog.000001
Relay_Log_Pos: 4
Relay_Master_Log_File: cli-bin.000032
Slave_IO_Running: Connecting
Slave_SQL_Running: Yes
Replicate_Do_DB:
Replicate_Ignore_DB:
Replicate_Do_Table:
Replicate_Ignore_Table: mysql.plugin,innodb_memcache.cache_policies,mysql.rds_sysinfo,mysql.rds_replication_status,mysql.rds_history,innodb_memcache.config_options
Replicate_Wild_Do_Table:
Replicate_Wild_Ignore_Table:
Last_Errno: 0
Last_Error:
Skip_Counter: 0
Exec_Master_Log_Pos: 713
Relay_Log_Space: 618
Until_Condition: None
Until_Log_File:
Until_Log_Pos: 0
Master_SSL_Allowed: No
Master_SSL_CA_File:
Master_SSL_CA_Path:
Master_SSL_Cert:
Master_SSL_Cipher:
Master_SSL_Key:
Seconds_Behind_Master: NULL
Master_SSL_Verify_Server_Cert: No
Last_IO_Errno: 0
Last_IO_Error:
Last_SQL_Errno: 0
Last_SQL_Error:
Replicate_Ignore_Server_Ids:
Master_Server_Id: 0
Master_UUID:
Master_Info_File: mysql.slave_master_info
SQL_Delay: 0
SQL_Remaining_Delay: NULL
Slave_SQL_Running_State: Slave has read all relay log; waiting for the slave I/O thread to update it
Master_Retry_Count: 86400
Master_Bind:
Last_IO_Error_Timestamp:
Last_SQL_Error_Timestamp:
Master_SSL_Crl:
Master_SSL_Crlpath:
Retrieved_Gtid_Set:
Executed_Gtid_Set:
Auto_Position: 0
1 row in set (0.00 sec)
show global variables
mysql> show global variables like '%old_passwords%';
+---------------+-------+
| Variable_name | Value |
+---------------+-------+
| old_passwords | 0 |
+---------------+-------+
1 row in set (0.01 sec)
mysql> show global variables like '%secure_auth%';
+---------------+-------+
| Variable_name | Value |
+---------------+-------+
| secure_auth | OFF |
+---------------+-------+
1 row in set (0.00 sec)
====================
The problem is Slave_IO_state is connecting and Slave_io_thread is connecting state but replication is not happening.
mysql replication amazon-rds amazon-ec2
mysql replication amazon-rds amazon-ec2
edited Sep 18 '15 at 12:13
Paul White♦
54.2k14288461
asked Mar 18 '15 at 11:15
chandu lakkinenichandu lakkineni
112
edited Sep 18 '15 at 12:13
Paul White♦
54.2k14288461
asked Mar 18 '15 at 11:15
chandu lakkinenichandu lakkineni
112
edited Sep 18 '15 at 12:13
Paul White♦
54.2k14288461
edited Sep 18 '15 at 12:13
Paul White♦
54.2k14288461
edited Sep 18 '15 at 12:13
Paul White♦
54.2k14288461
54.2k14288461
asked Mar 18 '15 at 11:15
chandu lakkinenichandu lakkineni
112
asked Mar 18 '15 at 11:15
chandu lakkinenichandu lakkineni
112
asked Mar 18 '15 at 11:15
chandu lakkinenichandu lakkineni
112
112
bumped to the homepage by Community♦ 4 mins ago
This question has answers that may be good or bad; the system has marked it active so that they can be reviewed.
bumped to the homepage by Community♦ 4 mins ago
This question has answers that may be good or bad; the system has marked it active so that they can be reviewed.
add a comment |
add a comment |
1 Answer
1
active
oldest
votes
Community Wiki answer generated from question comments by jynus:
You may not have opened the right ports or provided the REPLICATION SLAVE permissions:
Using Replication to Export MySQL 5.6 Data
Also see this answer:
Replication from EC2 Master to RDS Slave - Connecting to master
add a comment |
Your Answer
StackExchange.ready(function() {
var channelOptions = {
tags: "".split(" "),
id: "182"
};
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: false,
noModals: true,
showLowRepImageUploadWarning: true,
reputationToPostImages: null,
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%2fdba.stackexchange.com%2fquestions%2f95566%2fconfiguring-slave-from-ec2-master-to-amazon-rds-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
Community Wiki answer generated from question comments by jynus:
You may not have opened the right ports or provided the REPLICATION SLAVE permissions:
Using Replication to Export MySQL 5.6 Data
Also see this answer:
Replication from EC2 Master to RDS Slave - Connecting to master
add a comment |
Community Wiki answer generated from question comments by jynus:
You may not have opened the right ports or provided the REPLICATION SLAVE permissions:
Using Replication to Export MySQL 5.6 Data
Also see this answer:
Replication from EC2 Master to RDS Slave - Connecting to master
add a comment |
Community Wiki answer generated from question comments by jynus:
You may not have opened the right ports or provided the REPLICATION SLAVE permissions:
Using Replication to Export MySQL 5.6 Data
Also see this answer:
Replication from EC2 Master to RDS Slave - Connecting to master
Community Wiki answer generated from question comments by jynus:
You may not have opened the right ports or provided the REPLICATION SLAVE permissions:
Using Replication to Export MySQL 5.6 Data
Also see this answer:
Replication from EC2 Master to RDS Slave - Connecting to master
edited Apr 13 '17 at 12:42
community wiki
2 revs
Paul White
add a comment |
add a comment |
Thanks for contributing an answer to Database Administrators Stack Exchange!
- 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%2fdba.stackexchange.com%2fquestions%2f95566%2fconfiguring-slave-from-ec2-master-to-amazon-rds-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
