Pythian Blog: Technical Track | Open Source (3)

Site Reliability Engineering

The value of Pythian’s internship program

MySQL

Data encryption at rest

Amazon RDS

How to migrate from on-premises to Azure SQL database

MySQL

High "cursor: pin S wait on X" waits?

MySQL

Amazon S3 to Glacier - Cloud ILM

MongoDB

Mongostat - A nifty tool for Mongo DBAs

Open Source

fsfreeze in Linux

Open Source

Using strace to debug application errors in linux

Monitoring

Monitoring Cassandra with Grafana and Influx DB

Open Source

Troubleshooting a Multipath Issue

Open Source

Debugging high CPU usage using Perf Tool and Vmcore Analysis

Open Source

Auditing files in Linux

MySQL

Availability Group - Delay with Listener Connectivity After Failover

MySQL

Guide to Cassandra Thread Pools

MySQL

In-Place Upgrade failure from SQL Server 2008 SP1 to SQL Server 2008 R2

MySQL

Duplication: divide et impera

MySQL

Configuring OID 11.1.1.6 Connector in OIM 11.1.2

MySQL

Hard Drive: Inner or Outer?

Apache Cassandra

Basho Technologies and PalominoDB Partner to Offer Enhanced Support and Monitoring Services for Riak Installation and Management

Site Reliability Engineering

Hashing Algorithm in MySQL PASSWORD()

Site Reliability Engineering

Exporting the mysql.slow_log table into slow query log format

Technical Track

Indexing text columns with GIST or GIN to optimize LIKE, ILIKE using pg_trgm in Postgres 9.1 (Part 1)

MySQL

Audit a MySQL Instance with MySQLTuner

MySQL

MySQL Can't Use Index With Uncorrelated IN Subquery