The past few days I have been working on setting up a second QNAP NAS as a backup for my files on my primary QNAP, using realtime syncing – which works ridiculously smooth. I have some MySQL databases on my primary QNAP as well, but syncing the data doesn’t seem to be part of the plan of the backup tools provided by QNAP.
Lucky me: MySQL has a great replication mechanism build in, so you can replicate one database (master) to another (slave). The setup is easy, albeit confusing when you just start looking into this. Synchronisation is done asynchronous, meaning: changes in the data on the master will be applied to the data on the slave, but the slave doesn’t need to be permanently connected. Missed changes, when not connected, will be “saved” and when a connection is established again, will be applied.
In this article I’ll show you how to do this for two MySQL setups (QNAP), where one serves as Master (Original) and the other as Slave (Backup).
Ad Blocking Detected Please consider disabling your ad blocker for our website.
We rely on these ads to be able to run our website.
You can of course support us in other ways (see Support Us on the left).
MySQL is one of the most commonly used database engines, not just because it’s free but mostly because it’s fast, reliable and widely supported. That doesn’t mean you should not make backups …
Backups of your MySQL setup can be needed for several reason. You want a backup for safe keeping, you want to move a database to another server, just before you make some major changes, or you just want to wipe your server clean and setup everything from scratch without loosing your data.
Making a one time backup of your database(s) can be a bit unclear, so in this article a description of 3 possible methods to make a backup of one or more databases and how to import them at a later time (to the same or another MySQL server).
Whenever creating a website, I typically first play at home on a testserver. Once I’m satisfied, I transfer the content to a production server.
In the past this was rather straight forward since I had developed the website from scratch. But when I started playing with WordPress this seemed a bit more cumbersome.
In this article I’ll show you a simple guide on how to copy or move your WordPress site to another server or to another domain in 5 steps.
As you might have noticed; I really like my QNAP NAS – it has proven to be flexible and reliable.
One of the nice things is that quite a bit of functionality comes pre-installed.
For example MySQL is default installed on your QNAP (not enabled).
I’ll show you how to enable MySQL and how to install phpMyAdmin.
Ad Blocking Detected Please consider disabling your ad blocker for our website.
We rely on these ads to be able to run our website.
You can of course support us in other ways (see Support Us on the left).
