dba

Bookmarks for 4 set 2014 through 5 set 2014

These are my links for 4 set 2014 through 5 set 2014:

  • tmux-plugins/tmux-resurrect – Restore tmux environment after a system restart. Tmux is great, except when you have to restart the computer. You lose all the running programs, working directories, pane layouts etc. There are helpful management tools out there, but they require initial configuration and continuous updates as your workflow evolves or you start new projects. tmux-resurrect saves all the little details from your tmux environment so it can be completely restored after a system restart (or when you feel like it). No configuration is required. You should feel like you never quit tmux. http://undeadly.org/cgi?action=article&sid=20140904174329
  • box/Anemometer – This is the Box Anemometer, the MySQL Slow Query Monitor. This tool is used to analyze slow query logs collected from MySQL instances to identify problematic queries.
  • SpamExperts/pyzor – Pyzor is a Python implementation of a spam-blocking networked system that use spam signatures to identify them.

Bookmarks for 16 apr 2013 through 19 apr 2013

These are my links for 16 apr 2013 through 19 apr 2013:

  • Sequel Pro – Sequel Pro is a fast, easy-to-use Mac database management application for working with MySQL databases.
  • Squidblacklist.org’s Blacklists For Squid Proxy. – Squidblacklist.org is the worlds leading publisher of blacklists tailored for squid proxy. The data that we use to generate the blacklists that we offer is compiled from various sources including some of the top security researchers and threat mitigation organizations. We incorporate all of the best publicly available data, as well as aggregate from our own research. Then, the data is combined, parsed for dupes & errors, formatted for squid, ultimately the lists are tested and reviewed in a production environment before being published.
  • RDO – RDO is a community of people using and deploying OpenStack on Red Hat and Red Hat-based platforms. We have documentation to help get started, forums where you can connect with other users, and community-supported packages of the most up-to-date OpenStack releases available for download.

Bookmarks for 12 apr 2013 from 14:46 to 21:36

These are my links for 12 apr 2013 from 14:46 to 21:36:

  • carloslima/dhsnapshot · GitHub – This script was created out of the need to have snapshots-like backups using the DreamHost Backup service, which provides 50GB of space for personal backups but gives very limited access to it's servers. Basically, you have no SSH access, only RSync and SFTP. It can be used to backup any machine: your computer, a server or even a Dreamhost-hosted website. You just need to configure it with the path to backup, your dreamhost backup account and the private key used for authentication and it will create daily backups and keep the last 7 days, 4 weeks and 6 months.
  • palexander/dreamback · GitHub – Dreamback is the easiest way to automate your backups on dreamhost. Dreamhost does not guarantee their backups of your users (though they've saved me with backups before), so it's best to run backups yourself. This is beta quality software. Please report issues if you have them. Using Dreamback is easy: 1) Create a user on dreamhost to manage your backups 2) Log in with your new user 3) gem install dreamback 4) dreamback 5) Answer the questions to setup your automated backup
  • View all MySQL Variables for Pasting into my.cnf – This is really useful for me because I work with dozens of different database servers. The first thing I do is run this command and paste it into the servers /etc/my.cnf file. That way I will always know the original value and it just makes life much easier.
  • How Permissions Work – Permissions are a key component of the Windows Server 2003 security architecture that you can use to manage the process of authorizing users, groups, and computers to access objects on a network.

Bookmarks for 27 dic 2012 through 28 dic 2012

These are my links for 27 dic 2012 through 28 dic 2012:

  • SyBooks Online: Back Up Data to a New Table (on sybase 12.x) – Copy the data from the corrupted table into a new table by creating a dummy table, and copying the old data into the dummy table.
  • Netl33ts: Cisco VPN Troubleshooting Guide – It is important to understand how IPSEC works in order to understand how to troubleshoot a VPN connection. This is a quick overview of IPSEC and is by no means a complete detailed guide.
  • TunnelsUP: Home – Welcome to tunnelsup.com! This site aims to document how to set up, troubleshoot and understand everything to do with Cisco VPN concepts. Here you will find scripts for putting together a tunnel, troubleshooting tips and videos that will teach concepts and demonstrate various VPN technologies.

Bookmarks for 2 nov 2012 from 15:23 to 18:09

These are my links for 2 nov 2012 from 15:23 to 18:09:

  • USEFUL ONE-LINE SCRIPTS FOR SED – (Unix stream editor) Dec. 29, 2005
    Compiled by Eric Pement – pemente[at]northpark[dot]edu version 5.5
  • IBM devscan tool – United States – The devscan tool is a supplemental tool used by AIX support personnel to gather debugging data for Storage Area Networks. The package download includes a manual page that is also available on this site at the Usage tab.
  • mysqlreport :: Make easy-to-read MySQL status reports – mysqlreport makes a friendly report of important MySQL status values. mysqlreport transforms the values from SHOW STATUS into an easy-to-read report that provides an in-depth understanding of how well MySQL is running. mysqlreport is a better alternative (and practically the only alternative) to manually interpreting SHOW STATUS.
  • Percona Online Tools – Welcome to Percona's suite of productivity tools for MySQL database administrators and developers. One free account lets you access all of the tools below, and keeps you updated when new tools or enhancements are available. Registration is required.

    Optimize your MySQL Server:
    Leverage our expertise to create a good starting configuration for a MySQL server.
    This tool will walk you through all of the steps necessary to create a ready to use MySQL configuration file in about 5 minutes.

    Analyze an SQL Query:
    Find out when your SQL is potentially buggy, hard for MySQL to optimize, or confusing.
    This tool will analyze your SQL code and warn you when it detects problems that we've encountered while optimizing thousands of queries in real applications.

Bookmarks for 2 nov 2012 from 11:31 to 12:17

These are my links for 2 nov 2012 from 11:31 to 12:17:

Bookmarks for 9 ott 2012 from 10:37 to 20:19

These are my links for 9 ott 2012 from 10:37 to 20:19:

  • notepadqq/notepadqq · GitHub – Linux clone of notepad++
  • Top 10 things you must read about vSphere 5.1 – Welcome to vSphere-land! – There has been so many documents, white papers, videos and blog posts posted about the vSphere 5.1 release that it’s hard to keep up with them all. I have at least 250 links gathered in my vSphere 5.1 Link-o-rama and it is still growing. With so many links it’s easy to miss some of the really good ones so I thought I would put together a top 10 list that highlights the ones that you don’t want to miss.
  • Three things you should never put in your database | Revolution Systems – As I've said in a few talks, the best way to improve your systems is by first not doing "dumb things". I don't mean you or your development staff is "dumb", it's easy to overlook the implications of these types of decisions and not realize how bad they are for maintainability let alone scaling. As a consultant I see this stuff all of the time and I have yet to ever see it work out well for anyone.

Bookmarks for 26 set 2012 from 17:24 to 17:48

These are my links for 26 set 2012 from 17:24 to 17:48:

  • Optimizing Magento Performance – Tutorials – Magebase – Performance optimization is a good way out in such situation. Optimizing a website, you should consider providing two factors:

    acceptable pages loading speed;
    acceptable pages loading speed when N people use the same application simultaneously.

  • Magento and Nginx Performance Tuning Services – Magento and Nginx Performance Tuning Services
  • Optimize MySQL settings for Magento database – The Tuning Primer is a shell script that allows you to review the MySQL settings and make adjustments to increase Magento database performance and stability. The script will analyze MySQL statistics and provide you with recommendations on how to fine-tune your MySQL server.

    The uptime of your MySQL should be more than 48 hours for correct script work. Only in this case there will be enough information for analysis. Tuning Primer script is compatible with all versions of MySQL starting from 3.23.

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 18 lug 2012 through 19 lug 2012

These are my links for 18 lug 2012 through 19 lug 2012:

  • Generate large amount of test data « my two cents – I’m using the dictionary on linux systems to generate test data. The shell script below generates test data for MySQL, but similar concepts can be used for other database systems as well.
  • JQueryin | Switching Apache from Prefork to Worker MPM in RHEL / CentOS 5.x / Fedora 13 – I’m going to outline the process of switching from Apache’s default installation of MPM Prefork to that of MPM Worker. I will also be covering the proper installation of FastCGI (mod_fcgid) to further improve your server performance. This guide is ideally intended for individuals running on low-memory VPS servers as memory consumption will likely be far lower with the Worker MPM because it spawns threads as opposed to forking child processes. If you’re intentionally reading this article, you’re probably aware of the performance benefits gained.
  • Free PDF Reader – Sumatra PDF – Sumatra PDF is a free PDF, eBook (ePub, Mobi), XPS, DjVu, CHM, Comic Book (CBZ and CBR) reader for Windows.

    Sumatra PDF is small, portable and starts up very fast.

    Simplicity of the user interface has a high priority.