On 10/30/11 12:59, John Drescher wrote:
On Thu, Oct 27, 2011 at 4:07 PM, Phil Stracchino ala...@metrocast.net wrote:
I just compared what the script was doing to the existing schema and
made the necessary changes by hand. Wasn't a problem, and nothing
non-obvious showed up.
So you did
believe they're somewhat
comparing apples to oranges.
--
Phil Stracchino, CDK#2 DoD#299792458 ICBM: 43.5607, -71.355
ala...@caerllewys.net ala...@metrocast.net p...@co.ordinate.org
Renaissance Man, Unix ronin, Perl hacker, SQL wrangler, Free Stater
It's not the years
any of a number of causes.
--
Phil Stracchino, CDK#2 DoD#299792458 ICBM: 43.5607, -71.355
ala...@caerllewys.net ala...@metrocast.net p...@co.ordinate.org
Renaissance Man, Unix ronin, Perl hacker, SQL wrangler, Free Stater
It's not the years, it's the mileage
.
(To be fair, if using all-InnoDB, you can use mysqldump
--single-transaction to avoid locking any tables and still get a
consistent dump. However, that doesn't speed mysqldump up any...)
--
Phil Stracchino, CDK#2 DoD#299792458 ICBM: 43.5607, -71.355
ala...@caerllewys.net ala
-sized DBs. The
main problem with it is that for sufficiently large databases, it fails
because mysqldump just physically takes too long to complete the dump.
--
Phil Stracchino, CDK#2 DoD#299792458 ICBM: 43.5607, -71.355
ala...@caerllewys.net ala...@metrocast.net p
On 10/24/11 11:05, Alan Brown wrote:
Phil Stracchino wrote:
The NAS will be VERY much faster than the tape drive.
Are you sure about that? My LTO5s make 160Mb/s+ and I've yet to see a
non-SSD NAS which can match them.
Actually, someone else asked the same in email. So let me reword
up your client faster.
Caveat: The NAS and the tape drive MUST be controlled by the same
storage daemon for this to work.
--
Phil Stracchino, CDK#2 DoD#299792458 ICBM: 43.5607, -71.355
ala...@caerllewys.net ala...@metrocast.net p...@co.ordinate.org
Renaissance Man, Unix ronin
configs entirely. They are
worthless. They were written back when a large machine was one with
more than 32MB of RAM. If you want performance out of MySQL, learn to
tune and configure it properly yourself.
--
Phil Stracchino, CDK#2 DoD#299792458 ICBM: 43.5607, -71.355
ala
important configuration settings for obtaining optimum InnoDB
performance in MySQL 5.5.
--
Phil Stracchino, CDK#2 DoD#299792458 ICBM: 43.5607, -71.355
ala...@caerllewys.net ala...@metrocast.net p...@co.ordinate.org
Renaissance Man, Unix ronin, Perl hacker, SQL wrangler, Free Stater
MySQL 5.1 five years after MySQL 6.0 ships...
--
Phil Stracchino, CDK#2 DoD#299792458 ICBM: 43.5607, -71.355
ala...@caerllewys.net ala...@metrocast.net p...@co.ordinate.org
Renaissance Man, Unix ronin, Perl hacker, SQL wrangler, Free Stater
It's not the years
to
leave my.cnf at the default values (we don't do many restores) and use
the maximum amount of RAM for the fs buffer cache as needed?
I'd look at performance with something like mysqltuner and tune it for
best performance, just like any other MySQL use case.
--
Phil Stracchino, CDK#2
000. I'm reasonably certain this wasn't Bacula's fault.
--
Phil Stracchino, CDK#2 DoD#299792458 ICBM: 43.5607, -71.355
ala...@caerllewys.net ala...@metrocast.net p...@co.ordinate.org
Renaissance Man, Unix ronin, Perl hacker, SQL wrangler, Free Stater
It's
it is at present.
I'd hoped it would be easier using Sun Studio, but if anything it was
harder.
--
Phil Stracchino, CDK#2 DoD#299792458 ICBM: 43.5607, -71.355
ala...@caerllewys.net ala...@metrocast.net p...@co.ordinate.org
Renaissance Man, Unix ronin, Perl hacker, SQL wrangler, Free Stater
On 10/05/11 15:54, Ben Walton wrote:
What mysql are you building against? The included one? More to the
point, which compiler was it built with?
MySQL 5.5.8, Solaris 10 package from Oracle. Need to update that actually.
--
Phil Stracchino, CDK#2 DoD#299792458 ICBM: 43.5607
canceled jobs, but that's not always easy, because jobs may be
interleaved on the tape, so it doesn't try.
--
Phil Stracchino, CDK#2 DoD#299792458 ICBM: 43.5607, -71.355
ala...@caerllewys.net ala...@metrocast.net p...@co.ordinate.org
Renaissance Man, Unix ronin, Perl hacker, SQL
.
--
Phil Stracchino, CDK#2 DoD#299792458 ICBM: 43.5607, -71.355
ala...@caerllewys.net ala...@metrocast.net p...@co.ordinate.org
Renaissance Man, Unix ronin, Perl hacker, SQL wrangler, Free Stater
It's not the years, it's the mileage
of those other processes you have listed should
have one process per CPU core.
--
Phil Stracchino, CDK#2 DoD#299792458 ICBM: 43.5607, -71.355
ala...@caerllewys.net ala...@metrocast.net p...@co.ordinate.org
Renaissance Man, Unix ronin, Perl hacker, SQL wrangler, Free Stater
, with 75% of
total system RAM in the InnoDB buffer pool.
--
Phil Stracchino, CDK#2 DoD#299792458 ICBM: 43.5607, -71.355
ala...@caerllewys.net ala...@metrocast.net p...@co.ordinate.org
Renaissance Man, Unix ronin, Perl hacker, SQL wrangler, Free Stater
It's
inferring, is why it took the OP a while to realize there was
a second Director running...
--
Phil Stracchino, CDK#2 DoD#299792458 ICBM: 43.5607, -71.355
ala...@caerllewys.net ala...@metrocast.net p...@co.ordinate.org
Renaissance Man, Unix ronin, Perl hacker, SQL wrangler, Free
an admin job deletes the purged volumes once a week.
--
Phil Stracchino, CDK#2 DoD#299792458 ICBM: 43.5607, -71.355
ala...@caerllewys.net ala...@metrocast.net p...@co.ordinate.org
Renaissance Man, Unix ronin, Perl hacker, SQL wrangler, Free Stater
It's
messages.
Job completes, but fails at the end with this sequence of messages.
Using sqlite.
--
Phil Stracchino, CDK#2 DoD#299792458 ICBM: 43.5607, -71.355
ala...@caerllewys.net ala...@metrocast.net p...@co.ordinate.org
Renaissance Man, Unix ronin, Perl hacker, SQL
garages if you need more
in one or the other. You may also set up a new garage when bigger
buckets (larger tape capacity) become available and they require
different handling.
I just want to say that this analogy is made of pure win. :)
--
Phil Stracchino, CDK#2 DoD#299792458 ICBM
. If you leave the machine around with an open
console and no password, you have no expectation whatsoever of security.
--
Phil Stracchino, CDK#2 DoD#299792458 ICBM: 43.5607, -71.355
ala...@caerllewys.net ala...@metrocast.net p...@co.ordinate.org
Renaissance Man, Unix ronin, Perl
in the
man page.
--
Phil Stracchino, CDK#2 DoD#299792458 ICBM: 43.5607, -71.355
ala...@caerllewys.net ala...@metrocast.net p...@co.ordinate.org
Renaissance Man, Unix ronin, Perl hacker, SQL wrangler, Free Stater
It's not the years, it's the mileage
to use mutt as the
mailer. Example:
mailcommand = /usr/bin/mutt -F /root/.muttrc-bacula -s \Storage
alert\ %r
--
Phil Stracchino, CDK#2 DoD#299792458 ICBM: 43.5607, -71.355
ala...@caerllewys.net ala...@metrocast.net p...@co.ordinate.org
Renaissance Man, Unix ronin, Perl hacker
:
https://lists.sourceforge.net/lists/listinfo/bacula-users,
mailto:bacula-users-requ...@lists.sourceforge.net?subject=unsubscribe
--
Phil Stracchino, CDK#2 DoD#299792458 ICBM: 43.5607, -71.355
ala...@caerllewys.net ala...@metrocast.net p...@co.ordinate.org
Renaissance Man, Unix
Full.
If this is what you want, then all you should need to do is turn off
'cancel duplicate jobs' and make sure that all applicable job
concurrency settings are set high enough.
--
Phil Stracchino, CDK#2 DoD#299792458 ICBM: 43.5607, -71.355
ala...@caerllewys.net ala
to it.
--
Phil Stracchino, CDK#2 DoD#299792458 ICBM: 43.5607, -71.355
ala...@caerllewys.net ala...@metrocast.net p...@co.ordinate.org
Renaissance Man, Unix ronin, Perl hacker, SQL wrangler, Free Stater
It's not the years, it's the mileage
, and that
once this is accomplished, the entire MyISAM storage engine will
probably be deprecated.
--
Phil Stracchino, CDK#2 DoD#299792458 ICBM: 43.5607, -71.355
ala...@caerllewys.net ala...@metrocast.net p...@co.ordinate.org
Renaissance Man, Unix ronin, Perl hacker, SQL wrangler
On 07/06/11 10:41, Adrian Reyer wrote:
On Wed, Jul 06, 2011 at 10:09:56AM -0400, Phil Stracchino wrote:
should I use for my tables? is MyISAM.[1] At this point, wherever
possible, EVERYONE should be using InnoDB.
I will, if the current backup ever finishes. For a start on MySQL 5.1
though
: Assume all out-of-the-box DB engine configurations, be
it MySQL, PostgreSQL or whatever, are worthless.
--
Phil Stracchino, CDK#2 DoD#299792458 ICBM: 43.5607, -71.355
ala...@caerllewys.net ala...@metrocast.net p...@co.ordinate.org
Renaissance Man, Unix ronin, Perl hacker, SQL
symbolic dump back into any SQL DB than it took to dump it in the
first place. Just for starters, dumping the DB does not alter any
indexes, while when reloading it, all of the indexes need to get
recreated and rebuilt.
--
Phil Stracchino, CDK#2 DoD#299792458 ICBM: 43.5607, -71.355
inaccurate to say that unless you
*NEED* either merge tables or full-text indices, you should be using InnoDB.
[1] Which is to say, not NDB Cluster
--
Phil Stracchino, CDK#2 DoD#299792458 ICBM: 43.5607, -71.355
ala...@caerllewys.net ala...@metrocast.net p...@co.ordinate.org
On 06/08/11 11:44, Jérôme Blion wrote:
On Wed, 08 Jun 2011 10:50:58 -0400, Phil Stracchino ala...@metrocast.net
wrote:
The very first thing I would do would be upgrade to MySQL 5.5.[current]
(5.5.13, right now) if you're not already using 5.5, making sure it's
properly configured (hint: look
. As Jérôme
observed, if you're tied to 5.1, you should use the plugin InnoDB engine
rather than the built-in InnoDB engine if at all possible.
--
Phil Stracchino, CDK#2 DoD#299792458 ICBM: 43.5607, -71.355
ala...@caerllewys.net ala...@metrocast.net p...@co.ordinate.org
Renaissance
On 06/08/11 13:45, Jérôme Blion wrote:
I had such issues with BAT... With Webacula, I am not able to reproduce
this behaviour.
Very interesting.
Perhaps a bad query which does not use an index.
Definitely worth study.
--
Phil Stracchino, CDK#2 DoD#299792458 ICBM: 43.5607
in mind, though, that this does mean you will only
ever be able to have one job running at once to that storage device.
--
Phil Stracchino, CDK#2 DoD#299792458 ICBM: 43.5607, -71.355
ala...@caerllewys.net ala...@metrocast.net p...@co.ordinate.org
Renaissance Man, Unix ronin, Perl
On 06/07/11 12:14, Rory Campbell-Lange wrote:
On 07/06/11, Phil Stracchino (ala...@metrocast.net) wrote:
On 06/07/11 09:59, Rory Campbell-Lange wrote:
I've written job 329 after job 315 on the same tape (CLW112L4). See below
Two questions:
* can I wipe the data pertaining to job 329 off
some tapes.
Glad it came up, then. :)
--
Phil Stracchino, CDK#2 DoD#299792458 ICBM: 43.5607, -71.355
ala...@caerllewys.net ala...@metrocast.net p...@co.ordinate.org
Renaissance Man, Unix ronin, Perl hacker, SQL wrangler, Free Stater
It's not the years, it's
On 06/07/11 15:41, Rory Campbell-Lange wrote:
On 07/06/11, Rory Campbell-Lange (r...@campbell-lange.net) wrote:
On 07/06/11, Phil Stracchino (ala...@metrocast.net) wrote:
On 06/07/11 12:14, Rory Campbell-Lange wrote:
Does deleting the job remove the data (in this case the data for job
329
|
aug | sep | oct | nov | dec | january |
february | ... | december
day = 1 | 2 | ... 31
date-time-spec = month-spec day-spec time-spec
Likewise, the last day of the year is pretty much always Dec 31
--
Phil Stracchino, CDK#2 DoD#299792458
, but in practical terms you'll
never notice the difference.)
--
Phil Stracchino, CDK#2 DoD#299792458 ICBM: 43.5607, -71.355
ala...@caerllewys.net ala...@metrocast.net p...@co.ordinate.org
Renaissance Man, Unix ronin, Perl hacker, SQL wrangler, Free Stater
It's
another, simpler approach: Restore the entire damaged
filesystem, with REPLACE set to 'only if newer'.
--
Phil Stracchino, CDK#2 DoD#299792458 ICBM: 43.5607, -71.355
ala...@caerllewys.net ala...@metrocast.net p...@co.ordinate.org
Renaissance Man, Unix ronin, Perl hacker, SQL
the chance
something mucked with a timestamp in an unexpected way.
--
Phil Stracchino, CDK#2 DoD#299792458 ICBM: 43.5607, -71.355
ala...@caerllewys.net ala...@metrocast.net p...@co.ordinate.org
Renaissance Man, Unix ronin, Perl hacker, SQL wrangler, Free Stater
the good jobs on the volume to a new volume, then
purge the original volume.
--
Phil Stracchino, CDK#2 DoD#299792458 ICBM: 43.5607, -71.355
ala...@caerllewys.net ala...@metrocast.net p...@co.ordinate.org
Renaissance Man, Unix ronin, Perl hacker, SQL wrangler, Free Stater
/LabelOfTheVolume
I want to keep the label in order to reuse the volume
In Bacula 5.0.3, you can use Action On Purge = truncate, iirc.
--
Phil Stracchino, CDK#2 DoD#299792458 ICBM: 43.5607, -71.355
ala...@caerllewys.net ala...@metrocast.net p...@co.ordinate.org
Renaissance Man
as a differential (a Full is not
necessary). This will basically roll up all changes since the last
Full, thus resetting the chain of incrementals.
--
Phil Stracchino, CDK#2 DoD#299792458 ICBM: 43.5607, -71.355
ala...@caerllewys.net ala...@metrocast.net p...@co.ordinate.org
Renaissance
3 - Set option onefs=no in the filesystem
Pick one. Option 3 is not recommended, as it will cause all mountpoints
to be recursed into, which tends to be a bad thing on Windows since
Windows remounts bits of its own filesystem on mountpoints scattered all
over the place.
--
Phil Stracchino
1 - Add D:\ into the FileSet
2 - Add C:\MyNewHardDrive into the FileSet
3 - Set option onefs=no in the filesystem
er ... the *fileset*, rather, not the filesystem
--
Phil Stracchino, CDK#2 DoD#299792458 ICBM: 43.5607, -71.355
ala...@caerllewys.net ala...@metrocast.net p
. ZFS deduplication is
implemented at block level, so the size of the file is unlikely to make
a great deal of difference.
--
Phil Stracchino, CDK#2 DoD#299792458 ICBM: 43.5607, -71.355
ala...@caerllewys.net ala...@metrocast.net p...@co.ordinate.org
Renaissance Man, Unix ronin, Perl
volume in spool/bacula (yes, it's a Solaris 10 box with a
12-disk ZFS array) is 5.8GB; the largest, 201GB. I have seen disk
volumes as large as 450GB in the past. I have not run into any problems
with this scheme and with this range of volume sizes.
--
Phil Stracchino, CDK#2 DoD#299792458
- do not
back up MySQL data directories directly. I dump the DBs and back up the
dumps, or I flush and freeze the tables for a moment, snapshot the
datadir, then thaw the tables and back up the snapshot.
--
Phil Stracchino, CDK#2 DoD#299792458 ICBM: 43.5607, -71.355
ala
the Catalog.
However, if the device your Catalog is stored on is throwing block
errors, and you do this WITHOUT first replacing that device, you're
playing Russian roulette. Replace the drive first.
--
Phil Stracchino, CDK#2 DoD#299792458 ICBM: 43.5607, -71.355
ala...@caerllewys.net
.something Director.
--
Phil Stracchino, CDK#2 DoD#299792458 ICBM: 43.5607, -71.355
ala...@caerllewys.net ala...@metrocast.net p...@co.ordinate.org
Renaissance Man, Unix ronin, Perl hacker, SQL wrangler, Free Stater
It's not the years, it's the mileage
.
Rickifer Barros.
Open BAT. Click Jobs Run in the tree pane. Find the job you want.
Right-click it and select 'List JobMedia' from the context menu.
--
Phil Stracchino, CDK#2 DoD#299792458 ICBM: 43.5607, -71.355
ala...@caerllewys.net ala...@metrocast.net p...@co.ordinate.org
*.
--
Phil Stracchino, CDK#2 DoD#299792458 ICBM: 43.5607, -71.355
ala...@caerllewys.net ala...@metrocast.net p...@co.ordinate.org
Renaissance Man, Unix ronin, Perl hacker, SQL wrangler, Free Stater
It's not the years, it's the mileage
to DVD via an external process.
--
Phil Stracchino, CDK#2 DoD#299792458 ICBM: 43.5607, -71.355
ala...@caerllewys.net ala...@metrocast.net p...@co.ordinate.org
Renaissance Man, Unix ronin, Perl hacker, SQL wrangler, Free Stater
It's not the years, it's the mileage
before
running it, and should set the broadcast address as well (default
broadcast address is set to 255.255.255.255).
--
Phil Stracchino, CDK#2 DoD#299792458 ICBM: 43.5607, -71.355
ala...@caerllewys.net ala...@metrocast.net p...@co.ordinate.org
Renaissance Man, Unix ronin, Perl
On 05/12/11 14:57, Phil Stracchino wrote:
This is version 2.0 of my checkhost tool.
Except that somehow I accidentally attached the wrong version. Let's
try this again.
To make up for the error, here's a standalone lanwake tool using the
same DB backend as well.
--
Phil Stracchino, CDK#2
daemon and another.)
--
Phil Stracchino, CDK#2 DoD#299792458 ICBM: 43.5607, -71.355
ala...@caerllewys.net ala...@metrocast.net p...@co.ordinate.org
Renaissance Man, Unix ronin, Perl hacker, SQL wrangler, Free Stater
It's not the years, it's the mileage
Bacula installation layout.
--
Phil Stracchino, CDK#2 DoD#299792458 ICBM: 43.5607, -71.355
ala...@caerllewys.net ala...@metrocast.net p...@co.ordinate.org
Renaissance Man, Unix ronin, Perl hacker, SQL wrangler, Free Stater
It's not the years, it's the mileage
On 05/07/11 10:17, Phil Stracchino wrote:
On 05/07/11 07:22, Radosław Korzeniewski wrote:
Puting a whole instalation into /etc hierarchy is not a good idea. There
are /etc for config files, /bin and /sbin for binary app files and /var
for frequently changed and temporary data. Use it. If you
On 05/06/11 03:59, J. Echter wrote:
Hi,
i have a fileset containing nfs mounted shares, but these seem to not get
backed up.
Don't back up over NFS if you can avoid it. You'll get much better
performance backing up the NFS shares on the NFS server.
--
Phil Stracchino, CDK#2 DoD
are. Call me cynical if you want, but
sometimes I have a hard time believing Microsoft does not intentionally
obfuscate things like this specifically to make life difficult for third
parties.
--
Phil Stracchino, CDK#2 DoD#299792458 ICBM: 43.5607, -71.355
ala...@caerllewys.net ala
. The incrementals forever model is
pretty risky ... it can mean that a restore requires a HUGE number of
jobs restored, and can fail if any of them is missing.
--
Phil Stracchino, CDK#2 DoD#299792458 ICBM: 43.5607, -71.355
ala...@caerllewys.net ala...@metrocast.net p
so I really don't understand
this.
Your *job* may not be set to use *software* compression, but is your
*tape library* automatically using *hardware* compression?
--
Phil Stracchino, CDK#2 DoD#299792458 ICBM: 43.5607, -71.355
ala...@caerllewys.net ala...@metrocast.net p
to educate your users, or to redesign your
backup strategy in a robust way (say, use rsync to copy the data to a
buffer area off the machine that you actually back up).
--
Phil Stracchino, CDK#2 DoD#299792458 ICBM: 43.5607, -71.355
ala...@caerllewys.net ala...@metrocast.net p
it.
--
Phil Stracchino, CDK#2 DoD#299792458 ICBM: 43.5607, -71.355
ala...@caerllewys.net ala...@metrocast.net p...@co.ordinate.org
Renaissance Man, Unix ronin, Perl hacker, SQL wrangler, Free Stater
It's not the years, it's the mileage
:
\`MaxValue\` INTEGER ...
In the long term, this field should really be renamed.
--
Phil Stracchino, CDK#2 DoD#299792458 ICBM: 43.5607, -71.355
ala...@caerllewys.net ala...@metrocast.net p...@co.ordinate.org
Renaissance Man, Unix ronin, Perl hacker, SQL wrangler, Free Stater
On 03/25/11 12:26, kor...@comcast.net wrote:
It�s a pleasure to deal with this company..
http://dsblanc.mouais.ch/page.php?yqID=03ow6
Would somebody PLEASE banhammer this spammer?
--
Phil Stracchino, CDK#2 DoD#299792458 ICBM: 43.5607, -71.355
ala...@caerllewys.net ala
up the local disk pool.
--
Phil Stracchino, CDK#2 DoD#299792458 ICBM: 43.5607, -71.355
ala...@caerllewys.net ala...@metrocast.net p...@co.ordinate.org
Renaissance Man, Unix ronin, Perl hacker, SQL wrangler, Free Stater
It's not the years, it's the mileage
your
old full backup before the new one completed, and that in turn means
there is a window - however brief - during which you do not have a full
backup available to restore from.
--
Phil Stracchino, CDK#2 DoD#299792458 ICBM: 43.5607, -71.355
ala...@caerllewys.net ala
any drive enters what it considers a pre-fail state.
(Which can be simple age, increasing numbers of hard errors, increasing
variation in spindle speed, increasing slow starts, etc, etc...)
--
Phil Stracchino, CDK#2 DoD#299792458 ICBM: 43.5607, -71.355
ala...@caerllewys.net ala
by spreading purchases across several
vendors. Four drives here, four there...
--
Phil Stracchino, CDK#2 DoD#299792458 ICBM: 43.5607, -71.355
ala...@caerllewys.net ala...@metrocast.net p...@co.ordinate.org
Renaissance Man, Unix ronin, Perl hacker, SQL wrangler, Free Stater
; lose one disk from
each stripe, and you're dead in the water. The right way is to set up
five mirrored pairs, then stripe the pairs; this will survive multiple
disk failures as long as you don't lose both disks of any single pair.
--
Phil Stracchino, CDK#2 DoD#299792458 ICBM: 43.5607
(1024), M (1000*1000), Mi (1024*1024), G, Gi, T, Ti, P, Pi.
I hope others can find it useful.
Kjetil,
Thanks, this looks like a useful tool. I'm forwarding your post to the
bacula-devel list to make sure folks there see it too.
--
Phil Stracchino, CDK#2 DoD#299792458 ICBM: 43.5607
On 03/15/11 16:36, Mike Hendrie wrote:
Question:
Can I use the same File Storage and Volume for both Linux and Windows
backups?
Absolutely. No reason on earth why not. It's all just data.
--
Phil Stracchino, CDK#2 DoD#299792458 ICBM: 43.5607, -71.355
ala...@caerllewys.net ala
of the package from which Bacula was installed to properly set the
directory permissions, and that this is easier to get right if the
Bacula recommended filesystem layout for Bacula is followed.
--
Phil Stracchino, CDK#2 DoD#299792458 ICBM: 43.5607, -71.355
ala...@caerllewys.net ala
if the default was
yes, unless you explicitly turned them off) should be fairly predictable.
This is just good sense in software design: options which can
potentially result in loss of data or work if enabled, should always
default to 'off'.
--
Phil Stracchino, CDK#2 DoD#299792458 ICBM: 43.5607
the correct
catalog DB engine when building only the storage daemon, because the
storage daemon includes the storage daemon tools - btape, bscan etc -
and some of those tools (bscan in particular) need to be able to access
the catalog database directly without going through the Director.
--
Phil
MySQL
as you would if it were NOT on ZFS. Do NOT rely on the let ZFS cache
the data trick, because it won't work with Bacula.
--
Phil Stracchino, CDK#2 DoD#299792458 ICBM: 43.5607, -71.355
ala...@caerllewys.net ala...@metrocast.net p...@co.ordinate.org
Renaissance Man, Unix
throughput, I
will turn Accurate back off.
--
Phil Stracchino, CDK#2 DoD#299792458 ICBM: 43.5607, -71.355
ala...@caerllewys.net ala...@metrocast.net p...@co.ordinate.org
Renaissance Man, Unix ronin, Perl hacker, SQL wrangler, Free Stater
It's not the years, it's
On 03/08/11 22:15, Gary R. Schmidt wrote:
On Wed, March 9, 2011 12:22, Phil Stracchino wrote:
[SNIP]
Now, I said I'd get back to the MySQL issues. I was reading through
some documents about mySQL on ZFS, and came across (again) a
recommendation from one MySQL tester that reported the best
On 03/08/11 23:33, Phil Stracchino wrote:
On 03/08/11 22:15, Gary R. Schmidt wrote:
Hmm, what version of MySQL did the document you found refer to? And what
one are you using?
5.5, and 5.5, in both cases.
You know, actually, I take that back. i was confusing two different
articles
directly on the storage device,
instead of the SD writing to storage mounted over NFS?
--
Phil Stracchino, CDK#2 DoD#299792458 ICBM: 43.5607, -71.355
ala...@caerllewys.net ala...@metrocast.net p...@co.ordinate.org
Renaissance Man, Unix ronin, Perl hacker, SQL wrangler, Free Stater
user='bacula';
FLUSH PRIVILEGES;
Then update your Bacula director config file and put the exact same new
catalog password in there, then restart Bacula and see if that solves
the problem. It should.
--
Phil Stracchino, CDK#2 DoD#299792458 ICBM: 43.5607, -71.355
ala...@caerllewys.net
and restart bacula, and see if it'll connect.
--
Phil Stracchino, CDK#2 DoD#299792458 ICBM: 43.5607, -71.355
ala...@caerllewys.net ala...@metrocast.net p...@co.ordinate.org
Renaissance Man, Unix ronin, Perl hacker, SQL wrangler, Free Stater
It's not the years, it's
On 03/02/11 17:52, Maria Mckinley wrote:
On 3/2/11 2:06 PM, Maria Mckinley wrote:
Message: 20
From: Phil Stracchino ala...@metrocast.net
Connect to your Bacula DB as your administrative user (probably root)
and change the password for Bacula, as follows:
UPDATE mysql.user SET password
for Bacula to use to identify that specific
catalog database.
Your DB is present. MySQL is running. You can connect to it, yet
Bacula can't. Did Debian helpfully change your Bacula passwords in your
config files for you, or perhaps replace your Bacula config files
altogether...?
--
Phil
, then analyze'.
--
Phil Stracchino, CDK#2 DoD#299792458 ICBM: 43.5607, -71.355
ala...@caerllewys.net ala...@metrocast.net p...@co.ordinate.org
Renaissance Man, Unix ronin, Perl hacker, SQL wrangler, Free Stater
It's not the years, it's the mileage
. You'd have to use a script to generate the fileset on demand.
--
Phil Stracchino, CDK#2 DoD#299792458 ICBM: 43.5607, -71.355
ala...@caerllewys.net ala...@metrocast.net p...@co.ordinate.org
Renaissance Man, Unix ronin, Perl hacker, SQL wrangler, Free Stater
On 02/14/11 16:56, Mezgani Ali via LinkedIn wrote:
LinkedIn
Mezgani Ali requested to add you as a connection on LinkedIn:
This ... person ... is just spamming anything and everything.
--
Phil Stracchino, CDK#2 DoD#299792458 ICBM: 43.5607, -71.355
ala...@caerllewys.net ala
don't think they are even supported by MySQL any more.
They aren't. MySQL 4.1 was end-of-lifed in December 2006.
--
Phil Stracchino, CDK#2 DoD#299792458 ICBM: 43.5607, -71.355
ala...@caerllewys.net ala...@metrocast.net p...@co.ordinate.org
Renaissance Man, Unix ronin
a different way.
Dump your Catalog each day to a SQL file, as you are doing now. Each
day, BEFORE you dump the catalog, move the previous day's dump into a
subdirectory which is not backed up.
Problem solved, in five minutes of shell scripting.
--
Phil Stracchino, CDK#2 DoD#299792458 ICBM
links?
And the answer is, Bacula backs up symbolic links as symbolic links. It
can also keep track of hard links.
--
Phil Stracchino, CDK#2 DoD#299792458 ICBM: 43.5607, -71.355
ala...@caerllewys.net ala...@metrocast.net p...@co.ordinate.org
Renaissance Man, Unix ronin
}
If you want to specify different Pools for different levels, it is
better to do so using Full Pool, Differential Pool, Incremental Pool in
the Job or JobDefs.
--
Phil Stracchino, CDK#2 DoD#299792458 ICBM: 43.5607, -71.355
ala...@caerllewys.net ala...@metrocast.net p
and how long are your full backup jobs...?
--
Phil Stracchino, CDK#2 DoD#299792458 ICBM: 43.5607, -71.355
ala...@caerllewys.net ala...@metrocast.net p...@co.ordinate.org
Renaissance Man, Unix ronin, Perl hacker, Free Stater
It's not the years, it's
, and back the groups up as
separate jobs that run in parallel. This can give you a big speedup for
incrementals, which typically spend most of their time scanning for
changed files and relatively little actually backing up the changed files.
--
Phil Stracchino, CDK#2 DoD#299792458 ICBM
to put in some more good media and simply add any data from the
filesystem not in TSTbkp.2011-02-07_15.19.05_08. Is that possible?
If you're trying to ask, in effect, Can I resume a failed/interrupted
backup job, the answer is no.
--
Phil Stracchino, CDK#2 DoD#299792458 ICBM: 43.5607
Benito. It is no more. It
has ceased to be! It's expired and gone to meet its maker! It's a
stiff! Bereft of life, it rests in peace! ...
--
Phil Stracchino, CDK#2 DoD#299792458 ICBM: 43.5607, -71.355
ala...@caerllewys.net ala...@metrocast.net p...@co.ordinate.org
601 - 700 of 1318 matches
Mail list logo