Re: Can mysql replication slower down Master Server performance?

[Rick James]

ssh uses encryption, which uses CPU cycles. nc (netcat) does not. (ssh is more secure.)

Can you move most of the reads to Slaves? You can scale for more reads by adding more Slaves.

> Now when DML operations are about to operate on SLAVE via binlogs would there be any impact on Master's performance.
I don't understand your sentence. Is it a question? Do you have a DML example?

The Master and the Slave are two separate machines, correct? And they do not share the same physical disk(s), correct?

> Ofcourse its not going to use SSH as it uses mysql socket to connect.
Eh? SSH uses the network, not the socket??

Replication impacts the Master in these ways:
* Writing to the binlog (disk I/O)
* Writing to the slave (via network, presumably Ethernet)

These impact performance:
innodb_flush_log_at_trx_commit
innodb_doublewrite
sync_binlog