Sysadmin tips
1.9K views | +0 today
Follow
Sysadmin tips
Tips and Tricks that we have to know and abuse every day. sysadmin, sysops and network.
Curated by stephane gault
Your new post is loading...
Scooped by stephane gault
September 29, 2014 5:20 AM
Scoop.it!

Logical MySQL backup tool mydumper 0.6.2

Logical MySQL backup tool mydumper 0.6.2 | Sysadmin tips | Scoop.it
We are pleased to announce the third release in the 0.6 series of mydumper, a tool for performing logical MySQL backups. In this release, we focused on simplifying compiling the code and added new features for making logical backups.
stephane gault's insight:

Very useful tool

No comment yet.
Scooped by stephane gault
September 22, 2014 9:21 AM
Scoop.it!

Upgrading ElasticSearch.

Upgrading ElasticSearch. | Sysadmin tips | Scoop.it

Elasticsearch can usually be upgraded using a rolling upgrade process, resulting in no interruption of service. This section details how to perform both rolling and restart upgrades.

stephane gault's insight:

From 0.90.5 to 1.3.2 without breaking it :) Be patient for the index to rebuild, and don't be scared by the lack of logs !

No comment yet.
Scooped by stephane gault
September 10, 2014 9:31 AM
Scoop.it!

How Twitter Uses Redis to Scale - 105TB RAM, 39MM QPS, 10,000+ Instances

How Twitter Uses Redis to Scale - 105TB RAM, 39MM QPS, 10,000+ Instances | Sysadmin tips | Scoop.it
Yao Yu has worked on Twitter’s Cache team since 2010. She recently gave a really great talk: Scaling Redis at Twitter. It’s about Redis of course, but it's not just about Redis.
Yao has worked at Twitter for a few years.
stephane gault's insight:

Always incredible value on admin experience on how they face and resolve scalability issues ! Redis at it's finest :)

No comment yet.
Scooped by stephane gault
September 9, 2014 10:26 AM
Scoop.it!

How to view bad blocks on mounted ext3 filesystem?

dumpe2fs -b /dev/<WHATEVER>
stephane gault's insight:

this command print the blocks which are reserved as bad in the filesystem. Handy when used on mounted prod FS !

No comment yet.
Scooped by stephane gault
September 4, 2014 12:43 PM
Scoop.it!

The nodetool utility | DataStax Cassandra 2.0 Documentation

The nodetool utility | DataStax Cassandra 2.0 Documentation | Sysadmin tips | Scoop.it

The nodetool utility of cassandra : A command line interface for Cassandra for managing a cluster.

stephane gault's insight:

Here is the basic tool you need to know to operate a cassandra cluster. From Datastax doc.

No comment yet.
Scooped by stephane gault
September 4, 2014 4:17 AM
Scoop.it!

MySQL 101: Monitor Disk I/O with pt-diskstats

MySQL 101: Monitor Disk I/O with pt-diskstats | Sysadmin tips | Scoop.it
Here on the Percona Support team we often ask customers to retrieve disk stats to monitor disk IO and to measure block devices iops and latency. There are a number of tools available to monitor IO on Linux.
stephane gault's insight:

Very accurate way to find if your disks are the bottleneck (often the case).

Scoopit Love the percona toolkit, very powerfull to monitor and debug !

No comment yet.
Scooped by stephane gault
September 3, 2014 4:24 PM
Scoop.it!

The Easy Way of Building a Growing Startup Architecture Using HAProxy, PHP, Redis and MySQL to Handle 1 Billion Requests a Week - High Scalability -

The Easy Way of Building a Growing Startup Architecture Using HAProxy, PHP, Redis and MySQL to Handle 1 Billion Requests a Week - High Scalability - | Sysadmin tips | Scoop.it
This Case Study is a guest post written by Antoni Orfin , Co-Founder and Software Architect at ...
stephane gault's insight:

case study are priceless for sysops. loadbalanced php infra.

No comment yet.
Scooped by stephane gault
September 3, 2014 7:41 AM
Scoop.it!

Installing OpenDKIM with Postfix or Sendmail (for RHEL / CentOS / Fedora)

Installing OpenDKIM with Postfix or Sendmail (for RHEL / CentOS / Fedora) | Sysadmin tips | Scoop.it
For those who want or need to compile and install OpenDKIM from the source code, you can follow the instructions I wrote in this article. If you're looking for the fastest and easiest way to get Op...
stephane gault's insight:

Good howto to get your outgoing mails signed with opendkim, with all the spf reminder.

No comment yet.
Scooped by stephane gault
September 3, 2014 7:37 AM
Scoop.it!

Home of Sysadmin & Sysops tips and tricks

Home of Sysadmin & Sysops tips and tricks | Sysadmin tips | Scoop.it

Commands, tips, network config, bigdata, performance tweaking, all you need to know.

stephane gault's insight:

MySQL, Percona, HAproxy, Nginx, Zsh, Cassandra, Hadoop, Memcached, Redis, ElasticSearch, Postfix, OpenDKIM, etc ...

No comment yet.
Scooped by stephane gault
September 3, 2014 4:53 AM
Scoop.it!

4 unix commands I abuse every day - Everything Sysadmin

4 unix commands I abuse every day - Everything Sysadmin | Sysadmin tips | Scoop.it

4 unix commands  I abuse every day By Everything Sysadmin

stephane gault's insight:

usefull use of piping

No comment yet.
Scooped by stephane gault
September 23, 2014 3:20 AM
Scoop.it!

Migrating to Percona XtraDB Cluster

Many organizations are interested in Percona XtraDB Cluster (PXC) as a replacement for conventional MySQL® master/slave architectures to eliminate replicatio...
stephane gault's insight:

Detailed key points to figure out if you want to go that path.

No comment yet.
Scooped by stephane gault
September 20, 2014 6:46 AM
Scoop.it!

MySQL upgrade best practices

MySQL upgrade best practices | Sysadmin tips | Scoop.it
MySQL upgrades are necessary tasks and we field a variety of questions here at Percona Support regarding MySQL upgrade best practices. This post highlights recommended ways to upgrade MySQL in different scenarios.
stephane gault's insight:

dump, with xtrabackup is mandatory before any upgrade ! Logical AND FS backup, one for the consitency one for fast operations.

No comment yet.
Scooped by stephane gault
September 9, 2014 11:59 AM
Scoop.it!

Remove mail from Mailq from a specific user

Remove mail from Mailq from a specific user | Sysadmin tips | Scoop.it

mailq | awk '$7 ~/^username@domain.tld$/ { print $1 }' | tr -d '*!' | postsuper -d -

stephane gault's insight:

Very intresting way of getting rid of some useless or bugged mail in a long postfix queue.

No comment yet.
Scooped by stephane gault
September 5, 2014 7:04 AM
Scoop.it!

Configure Postfix for Multiple ISP Client SMTP Authentication

Configure Postfix for Multiple ISP Client SMTP Authentication | Sysadmin tips | Scoop.it

This article outlines the steps required to configure Postfix to relay email through multiple ISP or mail providers depending on the source address.

stephane gault's insight:

Relaying mails to different relay SMTP with postfix, based on sender or domain, using sender_dependent_relayhost_maps.

No comment yet.
Scooped by stephane gault
September 4, 2014 5:26 AM
Scoop.it!

How to recover a PXC cluster

How to recover a PXC cluster | Sysadmin tips | Scoop.it
Galera replication for MySQL brings not only the new, great features to our ecosystem, but also introduces completely new maintenance techniques. Are you concerned about adding such new complexity to your MySQL environment?
stephane gault's insight:

Operations with a Percona Xtradb Cluster outage, how to recover and restart nodes. You'll always have a backup anyway (XtraBackup fast & secure).

No comment yet.
Scooped by stephane gault
September 4, 2014 3:34 AM
Scoop.it!

Installing and running Postfix within a docker container from the com…

Installing and running Postfix within a docker container from the command line
stephane gault's insight:

Intresting start to docker postfix (fine if you want to have different postfix on the same host).

No comment yet.
Scooped by stephane gault
September 3, 2014 12:11 PM
Scoop.it!

Simple MySQL Master HA with mysqlnd_ms

Simple MySQL Master HA with mysqlnd_ms | Sysadmin tips | Scoop.it
Jervin Real shares two ways of achieving high availability with the mysqlnd_ms extension using the mysqlnd plugin, MySQL Master Slave.
stephane gault's insight:

Good way to achieve HA in an Master Slave setup.

No comment yet.
Scooped by stephane gault
September 3, 2014 7:45 AM
Scoop.it!

Simple bucket-ized stats in awk

Simple bucket-ized stats in awk | Sysadmin tips | Scoop.it
Someone recently asked how to take a bunch of numbers from STDIN and then break them down into distribution buckets. This is simple enough that it should be do-able in awk.
Here's a simple script that will generate 100 random numbers.
stephane gault's insight:

awk the lost art :)

No comment yet.
Scooped by stephane gault
September 3, 2014 4:59 AM
Scoop.it!

Ansible Galaxy HAproxy

Ansible Galaxy HAproxy | Sysadmin tips | Scoop.it

Installs and configure haproxy from ansible galaxy content.

stephane gault's insight:

Good playbooks and configs for a first HAproxy setup

No comment yet.