Bookmarks for 25 lug 2012 from 14:52 to 15:47

These are my links for 25 lug 2012 from 14:52 to 15:47:

  • Disaster: LVM Performance in Snapshot Mode – MySQL Performance Blog – In many cases I speculate how things should work based on what they do and in number of cases this lead me forming too good impression about technology and when running in completely unanticipated bug or performance bottleneck. This is exactly the case with LVM
    Number of customers have reported the LVM gives very high penalty when snapshots are enabled (leave along if you try to run backup at this time) and so I decided to look into it.
  • Netexpertise » Mysql Ultra-Fast Backup with LVM – It is generally good practice to respect the two following points when backing up databases. The backup has to be:
    consistent
    fast
    Consistency is easily achieved putting a read lock on all tables beforehands. However, this isn’t always applied, and WILL definately lead to a database integrity problem at some stage.
    Once a lock has been set on the database, the backup has to be as quick as possible, all write instructions being held in the queue.
  • MIME and HTML in Email – How to encapsulate HTML in an email message and send via sendmail

Bookmarks for 10 giu 2012 through 15 giu 2012

These are my links for 10 giu 2012 through 15 giu 2012:

  • Backup automatizzato dei database su SQL Express – SQL Server Express viene distribuito senza SQL Agent, quindi non è possibile schedulare internamente a SQL Server processi automatizzati, come ad esempio il backup. E’ però possibile aggirare questo ostacolo creando uno script ad-hoc, che si occupi dei vari job che vogliamo eseguire.
  • PacketFence: Open Source NAC (Network Access Control) – PacketFence is a fully supported, trusted, Free and Open Source network access control (NAC) solution. Boasting an impressive feature set including a captive-portal for registration and remediation, centralized wired and wireless management, powerful guest management options, 802.1X support, layer-2 isolation of problematic devices; PacketFence can be used to effectively secure networks small to very large heterogeneous networks.
  • teambox/teambox · GitHub – Open-source project collaboration software, available online for free. Inspired by Basecamp, Yammer, Twitter.

Bookmarks for 5 gen 2012 through 25 gen 2012

These are my links for 5 gen 2012 through 25 gen 2012:

  • MySQL permissions for backup | OpenConcept Mobile Site – It's a really good idea to use a least-privilege approach to most system administration tasks, and especially automated ones. This post describes using a "read only" MySQL user to handle backing up MySQL databases.

    We use mysqldump to backup our databases on a regular basis, using scripts like this one

  • MuckNet » Blog Archive » MySQL Permissions for backup using mysqldump and/or ec2-consistent-snapshot – Using root for your MySQL backups is a bad idea boys and girls. You should dedicate a user to doing your backups. Below are a few options for setting up minimum permissions for your dedicated mysql backup user

    [memento mori]

  • Tiki Wiki CMS Groupware | Tiki Wiki CMS Groupware – Software made the wiki way. – What is Tiki Wiki CMS Groupware? Tiki is a powerful, web-based application, created by a large team of contributors. Tiki is the ideal tool for you to build and maintain your Website/Wiki/Groupware/CMS/Forum/Blog/Bug Tracker or any other project you can imagine running in your browser window.

    Tiki is free, both Free Software (as in "Free Speech") and Free of Charge (as in "Free Beer"), and for everyone! It has all the features you need "out-of-the-box":
    Wikis (like Wikipedia)
    Forums (like phpBB)
    Blogs (like WordPress)
    Articles (like Yahoo News)
    Image Gallery (like Flickr)
    Map Server (like Google Maps)
    Link Directory (like DMOZ)
    Multilingual (like Babel Fish)
    Bug Tracker (like Bugzilla)
    RSS Feeds (like Digg)
    Free Open Source software (LGPL)

    [ via http://www.gpaterno.com/2011/12/23/create-a-secure-intranetextranet-with-tikiwiki-and-securepass/ ]

  • Create a secure intranet/extranet with TikiWiki and SecurePass – Giuseppe Paternò – [...]
    In this market segment, there’s still a need for a secure corporate intranet with the need to exchange private information and files. Collaborative places, such as wikis, are perfect solutions to quickly achieve this goal without spending a fortune. I found TikiWiki (http://www.tiki.org/) to suit best in these environments: while extremely easy to use for an end-user through WYSYWIG editor, the complex permission system allow you to set each page access or even show/hide part of the page to a given group of users, which is unique if compared to other solutions
    [...]

Bookmarks for 9 dic 2011 through 13 dic 2011

These are my links for 9 dic 2011 through 13 dic 2011:

  • BAT file tips | Alex @ Net – Let's play with BAT files a little. As you may know, BAT files are intended to be run and processed by the MS command processor, named cmd.exe, and the programming language they are created with is very close to BASIC. The early versions of the BAT-files language (which comes from famous Windows ancestor, MS-DOS) were very limited. Nowadays it has more features and a few days ago I created a small collection of interesting tricks, related to BAT file programming. You can check the following examples that demonstrate which execution flow controlling statements BAT-file language has and show their analogs in PHP.
  • 10 Tools To Add Some Spice To Your UNIX Shell Scripts – here are some misconceptions that shell scripts are only for a CLI environment. You can easily use various tools to write GUI and/or network (socket) scripts under KDE or Gnome desktops. Shell scripts can make use of some of the GUI widget (menus, warning boxs, progress bars etc). You can always control the final output, cursor position on screen, various output effects, and so on. With the following tools you can build powerful, interactive, user friendly UNIX / Linux bash shell scripts.
  • Nagios plugin for ASE – SybaseWiki – When you are using Nagios (http://www.nagios.org) as a monitoring tool, it's real easy to implement your own checks for Sybase servers. Here's a sample check to see if your ASE server is up and connectable.