Backup help

[Bram Mertens]

Colin,

You've got that correct. Replication, just like e.g. RAID protects against
some forms of data loss but it is not a full backup solution.

It could be part of it though, e.g. if running a more permanent backup from
the slave is easier than running it on the master.

MySQL/MariaDB have specific commands to create backups, look at mysqldump
for details.
As with all backups: it is important to test not only the backup part but
also the part of restoring it.  Depending on the options you set with
mysqldump the recovery part differs.
E.g. You may need to make sure you have a backup of the mysql user's
passwords, which is a separate task.

Regards

Bram

On Wed, Sep 20, 2017 at 9:59 AM Colin Law <clanlaw at gmail.com> wrote:

> Just to point out that database replication might not be considered a
> good form of backup. It copes with something like a disc crash but if,
> for example, a user or bug were accidentally to delete large sections
> of the db then that deletion would be copied to the slave database.
> Unless I misunderstand how replication works.
>
> Colin
>
> On 20 September 2017 at 04:27, DaveC49 <davidcousens at bigpond.com> wrote:
> > Hi Art, Roger
> >
> > Just a quick comment. If you are using the MYSQL backend you can sync
> > databases on different machines reasonably easily using MYSQL
> master-slave
> > replication (https://dev.mysql.com/doc/refman/5.7/en/replication.html)
> as an
> > alternative to maintaining a mobile copy.
> >
> > There is a bit of a learning curve in setting it up and some maintenance
> if
> > the databases do get out of sync. I use it on a Linux desktop and my
> Linux
> > laptop to keep a number of application databases synced using SSL over my
> > LAN.  It syncs automatically whenever the laptop is connected to the
> LAN. I
> > haven't tried syncing from a Linux box to a Windows box but it shouldn't
> be
> > too much of a problem as it is all done in MYSQL configuration as long as
> > the basic underlying network connectivity is there. There can be timing
> > issues if the databases on different machines are updated at the same
> time
> > which are not generally a problem for a single user.
> >
> > You can use the TinyCA (https://tinyca.alioth.debian.org/) to generate
> the
> > necessary SSL certificates. I set MySQL  both machines up as
> master-master
> > servers so that no matter which machine I make changes to the database
> they
> > are  duplicated to the other machine.
> >
> > David Cousens
> >
> >
> >
> > -----
> > David Cousens
> > --
> > Sent from:
> http://gnucash.1415818.n4.nabble.com/GnuCash-User-f1415819.html
> > _______________________________________________
> > gnucash-user mailing list
> > gnucash-user at gnucash.org
> > https://lists.gnucash.org/mailman/listinfo/gnucash-user
> > -----
> > Please remember to CC this list on all your replies.
> > You can do this by using Reply-To-List or Reply-All.
> _______________________________________________
> gnucash-user mailing list
> gnucash-user at gnucash.org
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> -----
> Please remember to CC this list on all your replies.
> You can do this by using Reply-To-List or Reply-All.
>