Ygthkb

How can I highlight parts in a screenshot

Sometimes a banana is just a banana

Giving a talk in my old university, how prominently should I tell students my salary?

Split a number into equal parts given the number of parts

Are all UTXOs locked by an address spent in a transaction?

Misplaced tyre lever - alternatives?

How to get the first element while continue streaming?

GDAL GetGeoTransform Documentation -- Is there an oversight, or what am I misunderstanding?

Why would the IRS ask for birth certificates or even audit a small tax return?

Book about a time-travel war fought by computers

Called into a meeting and told we are being made redundant (laid off) and "not to share outside". Can I tell my partner?

Correct physics behind the colors on CD (compact disc)?

function only contains jump discontinuity but is not piecewise continuous

“I had a flat in the centre of town, but I didn’t like living there, so …”

Is there any relevance to Thor getting his hair cut other than comedic value?

Ahoy, Ye Traveler!

Are small insurances worth it

How do I deal with being envious of my own players?

Is there a frame of reference in which I was born before I was conceived?

If nine coins are tossed, what is the probability that the number of heads is even?

Why are special aircraft used for the carriers in the United States Navy?

How does signal strength relate to bandwidth?

Are there other characters in the Star Wars universe who had damaged bodies and needed to wear an outfit like Darth Vader?

Where is this quote about overcoming the impossible said in "Interstellar"?

MySql slaves on Amazon EC2 RHEL 7.6 server not getting connected automatically after mysql service restart on master

Broken mysql replication on slave server (error 1236)MySQL slave replicates changes that are in neither binlog_do_db nor replicate_do_dbConfiguring slave from EC2 master to Amazon RDS slaveMysql Replication backup and restoration failed multipal timeSlave_IO_Running: Connecting in Master-Slave ReplicationMaster/Slave MySQL error in replicationWhy isn't my MySQL replication filter working?error connecting to master 'replica@192.168.57.10:3306' mac-ubuntuCreate a mysql replication from multiple master and single slave server?MySQL Replication Error - Deadlock

0

I have setup MySQL Master - slave replication on Amazon EC2 instance.
OS : RHEL 7.6
MySQL Version: 8.0.13
Mater server IP : 192.168.1.128
Slave server IP : 192.168.1.129

I have two ec2 instance on which i have configured one ec2 as Master and another one as its slave.
I have created user "replicator" on master server for replication with " %" host.
After executing change master statement on slave server as mentioned below.

CHANGE MASTER TO MASTER_HOST='192.168.1.128',MASTER_USER='replicator', MASTER_PASSWORD='Replication@123', MASTER_HEARTBEAT_PERIOD=5, MASTER_LOG_FILE='mysql-bin.000063', MASTER_LOG_POS=195;

I have executed start slave and show slave statusG command on slave server i.e. on 192.168.1.129 .
i have got following error:

    Slave_IO_State: Connecting to master

         Master_Host: 192.168.1.128

         Master_User: replicator

    Slave_IO_Running: Connecting

   Slave_SQL_Running: Yes

       Last_IO_Error: error connecting to master replication@192.168.1.128:3306 - retry-time: 60  retries: 8

Then i have taken login to master mysql server from slave server i.e.
mysql -u replicator -p -h192.168.1.128
slave started sucessfully.

show slave statusG ouput:

    Slave_IO_Running: Yes

   Slave_SQL_Running: Yes

After all these i came to know that i have to repeat this step i.e. mysql -u replicator -p -h192.168.1.128 from slave server every time whenever master MySQL service restart. Otherwise replication will not take place and we will get the same error as describe above i,e. error connecting to master 'replication@192.168.1.128:3306'

!! Thanks for any help in advance !!

mysql

share

edited 24 secs ago

Rahul Kanaujia

asked 6 mins ago

Rahul KanaujiaRahul Kanaujia

1

New contributor

Rahul Kanaujia is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.

add a comment | 

0

I have setup MySQL Master - slave replication on Amazon EC2 instance.
OS : RHEL 7.6
MySQL Version: 8.0.13
Mater server IP : 192.168.1.128
Slave server IP : 192.168.1.129

I have two ec2 instance on which i have configured one ec2 as Master and another one as its slave.
I have created user "replicator" on master server for replication with " %" host.
After executing change master statement on slave server as mentioned below.

CHANGE MASTER TO MASTER_HOST='192.168.1.128',MASTER_USER='replicator', MASTER_PASSWORD='Replication@123', MASTER_HEARTBEAT_PERIOD=5, MASTER_LOG_FILE='mysql-bin.000063', MASTER_LOG_POS=195;

I have executed start slave and show slave statusG command on slave server i.e. on 192.168.1.129 .
i have got following error:

    Slave_IO_State: Connecting to master

         Master_Host: 192.168.1.128

         Master_User: replicator

    Slave_IO_Running: Connecting

   Slave_SQL_Running: Yes

       Last_IO_Error: error connecting to master replication@192.168.1.128:3306 - retry-time: 60  retries: 8

Then i have taken login to master mysql server from slave server i.e.
mysql -u replicator -p -h192.168.1.128
slave started sucessfully.

show slave statusG ouput:

    Slave_IO_Running: Yes

   Slave_SQL_Running: Yes

After all these i came to know that i have to repeat this step i.e. mysql -u replicator -p -h192.168.1.128 from slave server every time whenever master MySQL service restart. Otherwise replication will not take place and we will get the same error as describe above i,e. error connecting to master 'replication@192.168.1.128:3306'

!! Thanks for any help in advance !!

mysql

share

edited 24 secs ago

Rahul Kanaujia

asked 6 mins ago

Rahul KanaujiaRahul Kanaujia

1

New contributor

Rahul Kanaujia is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.

add a comment | 

I have setup MySQL Master - slave replication on Amazon EC2 instance.
OS : RHEL 7.6
MySQL Version: 8.0.13
Mater server IP : 192.168.1.128
Slave server IP : 192.168.1.129

I have two ec2 instance on which i have configured one ec2 as Master and another one as its slave.
I have created user "replicator" on master server for replication with " %" host.
After executing change master statement on slave server as mentioned below.

CHANGE MASTER TO MASTER_HOST='192.168.1.128',MASTER_USER='replicator', MASTER_PASSWORD='Replication@123', MASTER_HEARTBEAT_PERIOD=5, MASTER_LOG_FILE='mysql-bin.000063', MASTER_LOG_POS=195;

I have executed start slave and show slave statusG command on slave server i.e. on 192.168.1.129 .
i have got following error:

    Slave_IO_State: Connecting to master

         Master_Host: 192.168.1.128

         Master_User: replicator

    Slave_IO_Running: Connecting

   Slave_SQL_Running: Yes

       Last_IO_Error: error connecting to master replication@192.168.1.128:3306 - retry-time: 60  retries: 8

Then i have taken login to master mysql server from slave server i.e.
mysql -u replicator -p -h192.168.1.128
slave started sucessfully.

show slave statusG ouput:

    Slave_IO_Running: Yes

   Slave_SQL_Running: Yes

After all these i came to know that i have to repeat this step i.e. mysql -u replicator -p -h192.168.1.128 from slave server every time whenever master MySQL service restart. Otherwise replication will not take place and we will get the same error as describe above i,e. error connecting to master 'replication@192.168.1.128:3306'

!! Thanks for any help in advance !!

mysql

share

edited 24 secs ago

Rahul Kanaujia

asked 6 mins ago

Rahul KanaujiaRahul Kanaujia

1

New contributor

Rahul Kanaujia is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.

    Slave_IO_State: Connecting to master

         Master_Host: 192.168.1.128

         Master_User: replicator

    Slave_IO_Running: Connecting

   Slave_SQL_Running: Yes

       Last_IO_Error: error connecting to master replication@192.168.1.128:3306 - retry-time: 60  retries: 8

    Slave_IO_Running: Yes

   Slave_SQL_Running: Yes

share

edited 24 secs ago

Rahul Kanaujia

asked 6 mins ago

Rahul KanaujiaRahul Kanaujia

1

New contributor

Rahul Kanaujia is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.

share

edited 24 secs ago

Rahul Kanaujia

asked 6 mins ago

Rahul KanaujiaRahul Kanaujia

1

New contributor

Rahul Kanaujia is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.

asked 6 mins ago

Rahul KanaujiaRahul Kanaujia

1

New contributor

Rahul Kanaujia is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.

asked 6 mins ago

Rahul KanaujiaRahul Kanaujia

1