mysql

Bookmarks for 28 ago 2014 from 09:32 to 11:55

These are my links for 28 ago 2014 from 09:32 to 11:55:

  • Keepalived for Linux – Keepalived is a routing software written in C. The main goal of this project is to provide simple and robust facilities for loadbalancing and high-availability to Linux system and Linux based infrastructures. Loadbalancing framework relies on well-known and widely used Linux Virtual Server (IPVS) kernel module providing Layer4 loadbalancing. Keepalived implements a set of checkers to dynamically and adaptively maintain and manage loadbalanced server pool according their health. On the other hand high-availability is achieved by VRRP protocol. VRRP is a fundamental brick for router failover. In addition, Keepalived implements a set of hooks to the VRRP finite state machine providing low-level and high-speed protocol interactions. Keepalived frameworks can be used independently or all together to provide resilient infrastructures.
  • The BIRD Internet Routing Daemon Project – BIRD is an Internet Routing Daemon designed to avoid all of these shortcomings, to support all the routing technology used in the today's Internet or planned to be used in near future and to have a clean extensible architecture allowing new routing protocols to be incorporated easily. Among other features, BIRD supports: * both IPv4 and IPv6 protocols * multiple routing tables * the Border Gateway Protocol (BGPv4) * the Routing Information Protocol (RIPv2) * the Open Shortest Path First protocol (OSPFv2, OSPFv3) * the Router Advertisements for IPv6 hosts a virtual protocol for exchange of routes between different routing tables on a single host a command-line interface allowing on-line control and inspection of status of the daemon soft reconfiguration[…]
  • How to make MaxScale High Available with Corosync/Pacemaker | MariaDB – MaxScale, an open-source database-centric router for MySQL and MariaDB makes High Availability possible by hiding the complexity of backends and masking failures. MaxScale itself however is a single application running in a Linux box between the client application and the databases – so how do we make MaxScale High Available? This blog post shows how to quickly setup a Pacemaker/Corosync environment and configure MaxScale as a managed cluster resource.

Bookmarks for 26 ago 2014 through 27 ago 2014

These are my links for 26 ago 2014 through 27 ago 2014:

  • Regular Expressions – Regular expressions ("regexes") are supercharged Find/Replace string operations. Regular expressions are used when editing text in a text editor, to: check whether the text contains a certain pattern find those pattern matches, if there are any pull information (i.e. substrings) out of the text make modifications to the text. As well as text editors, almost every high-level programming language includes support for regular expressions. In this context "the text" is just a string variable, but the operations available are the same. Some programming languages (Perl, JavaScript) even provide dedicated syntax for regular expression operations.
  • MySQL active-passive cluster | Your IT goes Linux – We will use the iSCSI Lun defined in our iSCSI cluster as a shared storage and we will run MySQL in active-passive (fail-over) mode using Pacemaker and Corosync cluster engine. The cluster will have to connect to the iSCSI target, mount the iSCSI partition on one node and start a MySQL service which has all its data on this partition.
  • Perl – […] Perl has horrors, but it also has some great redeeming features. In this respect it is like every other programming language ever created. This document is intended to be informative, not evangelical. It is aimed at people who, like me: dislike the official Perl documentation at http://perl.org/ for being intensely technical and giving far too much space to very unusual edge cases learn new programming languages most quickly by "axiom and example" wish Larry Wall would get to the point already know how to program in general terms don't care about Perl beyond what's necessary to get the job done. This document is intended to be as short as possible, but no shorter[…]
  • Linux Performance – This page links to various Linux performance material I've created, including the tools maps on the right, which show: Linux observability tools, Linux benchmarking tools, Linux tuning tools, and Linux observability sar. For more diagrams, see my slide decks below.
  • AIXchange: Useful Storage Links – Here's an assortment of really good storage-related articles — the majority of which are found on IBM developerWorks — that are worth your time. While some of them are a few years old, they still provide relevant information.

Bookmarks for 26 ago 2014 from 11:20 to 11:53

These are my links for 26 ago 2014 from 11:20 to 11:53:

  • claudioc/jingo – A git based wiki engine written for node.js, with a decent design, a search capability and a good typography.
  • fastmonkeys/stellar – Stellar allows you to quickly restore database when you are e.g. writing database migrations, switching branches or messing with SQL. PostgreSQL and MySQL are supported.
  • Sandstorm Apps – This page is for people who already have a Sandstorm instance set up. Use the buttons below to install apps.
  • Sandstorm – Sandstorm's server-side sandboxing is based on the same underlying Linux kernel features as LXC and Docker. We use the system calls directly for finer-grained control.
  • apenwarr/sshuttle – Transparent proxy server that works as a poor man's VPN. Forwards over ssh. Doesn't require admin. Works with Linux and MacOS. Supports DNS tunneling.

Bookmarks for 30 lug 2014 through 5 ago 2014

These are my links for 30 lug 2014 through 5 ago 2014:

Bookmarks for 29 lug 2014 from 19:48 to 20:16

These are my links for 29 lug 2014 from 19:48 to 20:16:

  • FhGFS Wiki: Tips and Recommendations for Storage Server Tuning – Here are some tips and recommendations on how to improve the performance of your storage servers. As usual, the optimal settings depend on your particular hardware and usage scenarios, so you should use these settings only as a starting point for your tuning efforts.
  • Linux NAS optimizations ← BAFM – […] Well, I recently had to flatten my archive NAS (well only the OS part … *wheeeh*). Since I didn’t have the chance to backup the old settings I had to do everything from scratch … And this time I decided, I wasn’t doing a script but rather the proper way. I spent a while reading through the Internetz about the various settings until I stumbled upon a Frauenhofer Wiki entry. From there I ended up writing those udev-rules and the sysctl configs…[…]
  • Some MySQL security tips | code.openark.org – This is a brief list of security tips for MySQL. It is by no means complete.
  • openarkkit – Common utilities for MySQL – Google Project Hosting – The openark kit provides common utilities to administer, diagnose and audit MySQL databases.
  • outbrain/orchestrator – MySQL replication topology manager/visualizer

Bookmarks for 20 ago 2013 through 7 set 2013

These are my links for 20 ago 2013 through 7 set 2013:

  • Gmvault: gmail backup – Gmvault is a tool for backing up your gmail account and never lose email correspondence. Gmvault is open source and under GNU-AGPL-3.0. [ via http://www.lffl.org/2013/09/gmvault-effettuare-il-backup-e.html ]
  • SSL Checker – SSL Certificate Verify – SSL Checker This SSL Checker will help you diagnose problems with your SSL certificate installation. You can verify the SSL certificate on your web server to make sure it  is correctly installed, valid, trusted and doesn't give any errors to any of your users. To use the SSL Checker, simply enter your server's hostname (must be public) in the box below and click the Check SSL button. If you need an SSL certificate, check out the SSL Wizard.
  • A Gentoo Linux Advanced Reference Architecture – The book "A Gentoo Linux Advanced Reference Architecture" is meant as a resource displaying the powerful features of many free software solutions that are supported on top of Gentoo Linux. It is a deep-dive approach in many aspects related to processes, supportability, maintainability based on Gentoo Linux system deployments. Unlike the existing, per-application documents that exist on the Internet (and which are a valuable resource to get into the gory details of many applications) and the per-distribution guides that provide information on using that particular distribution, this book will focus more on architecturing IT infrastructure for medium-sized enterprises. Smaller enterprises might find the reference architecture here too expensive or large – however, many services described in the book can be slimmed down into a smaller deployment as well.

Bookmarks for 20 ago 2013 from 02:47 to 02:50

These are my links for 20 ago 2013 from 02:47 to 02:50:

  • WordPress › HyperDB « WordPress Plugins – HyperDB is a very advanced database class that replaces a few of the WordPress built-in database functions. The main differences are: * HyperDB can be connect to an arbitrary number of database servers, * HyperDB inspects each query to determine the appropriate database.
  • ClusterFoundry Blog Highly-Available and Load-Balanced WordPress Cluster – Part 1 – This article explains on how to setup a load-balanced WordPress cluster in a master-slave configuration. The load balancer(HAProxy) sits in front of 2 or more web server nodes (1 Master and 1 Slave) which has the same contents. HAProxy does not only distribute requests, but also checks the health of the services running on the node. If one of the nodes are down, all requests will be redirected to the remaining nodes.
  • Deploying Scalable WordPress – The Official Rackspace Blog – […] The end result is a WordPress site that uses Cloud Load Balancers, Cloud Servers, and Cloud Files to deliver an easily scalable, modular configuration.[…]

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.