MySQL Forums
Forum List  »  Replication

Re: Asynchronous Replication
Posted by: A J
Date: March 01, 2016 08:40AM

Thank you.

There is no hostname available.

In generel a SSH tunnel fits very well.

One very easy example would be

<< mysqldump -uUser -pPassword DataBaseName | ssh root@rootserver.com "mysql -uRemoteUser -pRemotePasswird -h mysql.rootserver.com DataBaseName" >>

which in fact copies the whole database. But I just want to copy the stuff that is NOT already in the remote database which comes near to a partial replication.

Usage is handling a huge amount of logfiles and every day every plant creates a bunch of them which I want to have at a central database.

Options: ReplyQuote


Subject
Views
Written By
Posted
1502
A J
February 24, 2016 05:02AM
775
February 26, 2016 01:51PM
Re: Asynchronous Replication
812
A J
March 01, 2016 08:40AM
737
March 06, 2016 11:15PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.