Bacula

[John Fields]

http://bacula.org

Can backup/restore Linux, Mac and Windows...

I expect MariaDB will be a common service available to more than one container.  

Remember, always do a search and replace with MariaDB for MySQL.

Supported in the Arm repos as...

# Completed on Tue Sep 22 00:58:12 2015

root@bananapi ~ # apt-cache search bacula

bacula - network backup service - metapackage

bacula-client - network backup service - client metapackage

bacula-common - network backup service - common support files

bacula-common-dbg - network backup service - common support files (debugging)

bacula-common-mysql - network backup service - MySQL common files

bacula-common-mysql-dbg - network backup service - MySQL common files (debugging)

bacula-common-pgsql - network backup service - PostgreSQL common files

bacula-common-pgsql-dbg - network backup service - PostgreSQL common files (debugging)

bacula-common-sqlite3 - network backup service - SQLite v3 common files

bacula-common-sqlite3-dbg - network backup service - SQLite v3 common files (debugging)

bacula-console - network backup service - text console

bacula-console-dbg - network backup service - text console (debugging)

bacula-console-qt - network backup service - Bacula Administration Tool

bacula-console-qt-dbg - network backup service - Bacula Administration Tool (debugging)

bacula-director-common - network backup service - Director common files

bacula-director-common-dbg - network backup service - Director common files (debugging)

bacula-director-mysql - network backup service - MySQL storage for Director

bacula-director-mysql-dbg - network backup service - MySQL storage for Director (debugging)

bacula-director-pgsql - network backup service - PostgreSQL storage for Director

bacula-director-pgsql-dbg - network backup service - PostgreSQL storage for Director (debugging)

bacula-director-sqlite3 - network backup service - SQLite 3 storage for Director

bacula-director-sqlite3-dbg - network backup service - SQLite 3 storage for Director (debugging)

bacula-fd - network backup service - file daemon

bacula-fd-dbg - network backup service - file daemon (debugging)

bacula-sd - network backup service - storage daemon

bacula-sd-dbg - network backup service - storage daemon (debugging)

bacula-sd-mysql - network backup service - MySQL SD tools

bacula-sd-mysql-dbg - network backup service - MySQL SD tools (debugging)

bacula-sd-pgsql - network backup service - PostgreSQL SD tools

bacula-sd-pgsql-dbg - network backup service - PostgreSQL SD tools (debugging)

bacula-sd-sqlite3 - network backup service - SQLite 3 SD tools

bacula-sd-sqlite3-dbg - network backup service - SQLite 3 SD tools (debugging)

bacula-server - network backup service - server metapackage

bacula-traymonitor - network backup service - tray monitor

bacula-traymonitor-dbg - network backup service - tray monitor (debugging)

[Hanz Da Silva]

Well I'm reading up on Bacula now...or at least have been as time permits. MySQL support is explictly stated, but MairiaDB is not. I realize that MariaDB is a fork of MySQL, at least that's how it started - I believe, but I would think that we all agree that we want whatever we choose to be supported.

That being said, I'm sure with a little bit of elbow grease, we can get it work.

[John Fields]

I shall repeat....  Search and replace with Maria dB. 😁

When oracle bought the commercial half of mysql,  90% of the employees went to work for a new company that is the commercial half of Maria.

When you install Maria it creates a symlink for mysql and it is 100% backwards with ALL releases of mysql.  In addition to supporting whatever Oracle manages to push out the door they push forward and add really cool features like multi-master clustering that oracle has zero interest in.  They sell another database with new licensing if you want a feature like that.

So yeah,  I really really mean it. Mysql is now pronounced MariaDB. 😁

Also I looked a little at it and I think a single bacula *director* node running on HFS and a *storage* daemon running on each HFR with either a SATA disk or a USB drive as the media would allow local backups and can enable off site replication,  timeshares and/or at a throttled speed.

Didn't see an easy restore checklist though.  Maybe also consider FOG or CloneZilla with PXE?

Bacula needs a client of course.  Wondering if we need Chef to tie this all together....

On Sep 23, 2015 11:10 PM, "Hanz Da Silva" <mitte...@gmail.com> wrote:

Well I'm reading up on Bacula now...or at least have been as time permits. MySQL support is explictly stated, but MairiaDB is not. I realize that MariaDB is a fork of MySQL, at least that's how it started - I believe, but I would think that we all agree that we want whatever we choose to be supported.

That being said, I'm sure with a little bit of elbow grease, we can get it work.

--
You received this message because you are subscribed to the Google Groups "The HomeFrontRouter Project" group.
To unsubscribe from this group and stop receiving emails from it, send an email to homefrontrout...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/homefrontrouter/dbe9f317-ca84-4509-9008-21c9c1a69b67%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

[Jeff Burns]

Upthumbing everything John said.   Heres the boots on the ground situation -  All the Linux Distros (even Oracle Linux 7.x ironically) switched to MariaDB.  MySQL is effectively legacy now and is persona non-grata.  No new projects are using it, and given its status - the existing projects will switch over when the distro they're developed on gets upgraded which was probably 6 months ago or more.   The new 10.x version is pretty awesome, has integrated Galera clustering, has some better tools in general at most every step of the way.

2)  On the backup syncs - Rsync allows to to throttle bandwidth if trying to replicate offsite.  Did that with large OracleDB backups going across the WAN before.

[Hanz Da Silva]

Well I'm certainly not advocating the use of MySQL over Maria DB. I'm no fan of Oracle's attitude toward the Community.

As I said before, I am in the process of reading the documentation for Bacula starting with webpage info. Although I have heard the name Bacula and seen adverts in various publications, I have never looked at the project or the software before now. I am going over some basic information on the website before I get into technical documentation so that I can be familiar with the concepts and terminology that is used when describing the project (the About - What is Bacula has been an excellent resource). So far the only databases listed are MySQL Postgres, and SQLlite. When I get further along I'm sure it will mention MariaDB and probably many others.

I only say this because I have tried to implement other projects that mention support for multiple database, but the reality was that trying to get the application to work with one of the other supported databases ended up being a nightmare. I got it done, but it was a lot of work massaging many parts of the database and the application to get things running smoothly.

I'm not looking to have a religious war on which DB is best or best to use in this case. I am relatively DB agnostic and feel that whatever DB works for the given task is the right one to use; I'm sure some DBAs will be waiting for me at the next meeting with a rope. ;-)

Anyway. Our fearless leader has decreed MariaDB be used and "so let it written, so let it be done" to quote a phrase. Hence, I am all for MariaDB regardless of whether or not it requires extra grunt work to get it working.

Time to go back to work so I can make some paper.

Hanz

[John Fields]

No worries. It's open source. Holy wars are what we do.  =)

The whole point is to make backups easy  past so I would request extra diligence around the restore mechanism s.

That is why I was also thinking FOG to do whole disk imaging.. Possibly instead.

--
You received this message because you are subscribed to the Google Groups "The HomeFrontRouter Project" group.
To unsubscribe from this group and stop receiving emails from it, send an email to homefrontrout...@googlegroups.com.

To view this discussion on the web visit https://groups.google.com/d/msgid/homefrontrouter/4ca831cf-149a-43e2-9d82-d6016a445b07%40googlegroups.com.