1,306 reputation
813
bio website amd.co.at
location Vienna, Austria
age 31
visits member for 5 years, 10 months
seen 14 hours ago

  • Sysadmin gone architecture/team lead
  • kink for running large Web Projects
  • PostgreSQL evangelist
  • Scrum Master
  • also interested in Product development
  • Likes kitties.


    Working on pganalyze these days - a great PostgreSQL performance monitoring tool!


  • May
    31
    comment What's the most efficient way of taking backup snapshots of a mysql database over the internet?
    The more I think of it the more I'm convinced that your best bet is plain rsync with --compress. Both gzip and rsync can produce completely different output when the input is shifted (far enough into their respective blocksize).<br>I don't know how the pattern search algorithms in rsync exactly work, if you find anything on this, please do tell ;).
    May
    31
    asked Which identity management products are suitable for small to medium business?
    May
    31
    answered What's the most efficient way of taking backup snapshots of a mysql database over the internet?
    May
    31
    awarded  Student
    May
    31
    comment Does orientation affect hard drive lifespan?
    There are reference server designs (mostly 4U+, but with 2.5" disks also 2U) which mount disk drives sideways, so this should be a non-issue. But as you already said, to get meaningful results you'd have to monitor failures in large environments like Amazon S3/EC2, Google or CERN.
    May
    31
    asked What backup software offerings are fit for “enterprise” use?
    May
    31
    answered VMware - Create VM out of a current desktop
    May
    30
    revised What Good PostgreSQL Administration Tools Exist?
    added an additional link
    May
    30
    awarded  Supporter
    May
    30
    answered gzip to bmp images on the fly?
    May
    30
    answered Hard drive throttling?
    May
    30
    answered The use of external journals on SSDs
    May
    30
    revised PostgreSQL Replication
    fixing one link
    May
    30
    answered Postgresql 'invalid page header' recovery
    May
    29
    awarded  Editor
    May
    29
    revised What Good PostgreSQL Administration Tools Exist?
    removed links postscript
    May
    29
    revised PostgreSQL Replication
    fixed links
    May
    29
    awarded  Teacher
    May
    29
    answered What Good PostgreSQL Administration Tools Exist?
    May
    29
    answered PostgreSQL Replication