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:

Convert apache htaccess rewrite rules to nginx rewrite rules automatically

The people @plesk builded a nice extension for converting htaccess content to nginx directives. Keep in mind : for plesk 11.5 and up !

Use the following plesk extension : “https://ext.plesk.com/packages/b33b9ba7-72c7-43a5-8454-f58236340563-htaccess-to-nginx”

No Comments
Dec, 21, 2016
Angelo Schalley
Certificates, html / php, Plesk Linux, security

Go to your hosting configuration in Plesk :

Additional Apache directives

Add the following to Additional directives for HTTP :

Redirect / https://domain.com/

All http requests will be redirected to https://domain.com

Setting up MySQL replication with existing data Master – Slave

Setting up MySQL replication with existing data Master – Slave

Convert apache htaccess rewrite rules to nginx rewrite rules automatically

auto redirect http to https plesk apache nginx directives

Categories