Setting up MySQL replication with existing data Master – Slave

8 Comments
Jan, 16, 2017
Angelo Schalley
html / php, joomla, Linux, MySQL, Plesk Linux

This is a step-by-step guide on how to replicate an existing MySQL server. The server is live and contains data and needs a constant backup companion.

Many tutorials focus on how to setup replication when no data is present on the system. That’s an ideal solution if you’re building a new setup, but in case you’ve got a server that already has data present then here’s how to accomplish the this:

No Comments
Nov, 18, 2016
Angelo Schalley
DNS, Linux, MySQL, Networking, Plesk Linux, PowerDNS

Well I ran into a problem when running a large PowerDNS installation with over 1000 domains and was planning a IP migration of the primary DNS server running at my company.

No Comments
Feb, 04, 2013
Angelo Schalley
Cisco, MS SQL, MySQL, Networking, security

sh runn timeout (check default timeout settings)

access-list oracle-1521 permit tcp host 10.26.x.x host 10.25.x.x (or make the access-list specific for a certain protocol)

class-map oracle-1521
match access-list oracle-1521
exit

policy-map global_policy
class oracle-1521
set connection timeout tcp 0:0:0 reset (setting no timeout for the specific access-list, DCD will determine with probes if the session needs to be torn down)

Category Archives: MySQL

Setting up MySQL replication with existing data Master – Slave

Updating PowerDNS superserver MySQL slave replication

Dead Connection Detection DCD Cisco ASA

Categories