Pythian Marketing

SQL - Managing Jobs in Availability Groups

This blog post will show how to dynamically add logic at the beginning of jobs in Availability Groups in order to avoid ...

ProxySQL Query Rules: Notes From Production

Step-by-bstep monitoring Cassandra with with Prometheus and Grafana

In this blog, I’m going to give a detailed guide on how to monitor a Cassandra cluster with Prometheus and Grafana. For ...

Scaling ProxySQL Rapidly in Kubernetes

Editor’s Note: Because our bloggers have lots of useful tips, every now and then we update and bring forward a popular ...

Setting up MySQL encrypted replication on MySQL 5.7 with GTID

In this blog post, I'll walk you through setting up encrypted replication on MySQL 5.7 with GTID enabled. I will walk ...

Obtaining an active-passive ProxySQL on FreeBSD

When designing a highly-available MySQL architecture, having a proxy to route the traffic to the appropriate instances ...

Join, Group By, and Aggregate in Cloud Data Fusion

Good news! Cloud Data Fusion is now GA. Announced at Google Next ‘19 UK on November 21, 2019, Cloud Data Fusion is a ...

How Cloud Computing Has Transformed Over the Last Decade

As we look back on the past ten years, cloud computing may be considered one of the largest transformations in ...

Configuring MySQL in a Docker Container

Editor's Note: Because our bloggers have lots of useful tips, every now and then we update and bring forward a popular ...

Managing SQL Jobs in Availability Groups - Method Job Category

Method - Job Category This blog post will show how to setup SQL Jobs in multiple availability groups. This method will ...

Ansible Inventory Automation Using Consul and Orchestrator

Here at Pythian we get a lot of exposure to new technologies and implementation strategies via the work we do ...

An overview of best practices for implementing ML systems - Part 1

In this series of blog posts, we will recommend some best practices identified from our own failures and successes ...

Exposing MyRocks internals via system variables: Part 5, Data Reads

(In the previous post, Part 4, we covered Compression and Bloom Filters) In this blog post, we continue on our series ...

Minimal Networking Knowledge Recommended for DBAs

In a recent post, I summarized what I consider to be the minimal topics one should be familiar with in order to do ...

Exposing MyRocks Internals Via System Variables: Part 3, Compaction

(In the previous post, Part 2, we covered Initial Data Flushing.) In this blog post, we continue our series of ...

Live Kernel Updates Without Downtime in New RHEL 8.1, 7.7 and 7.6 Release

Most often companies scheduling downtime for patching of the Linux kernel in a production environment follow strict ...

MariaDB Temporal Tables: Uncut & Uncensored (Part III)

(This is the third of a series of blog posts covering MariaDB Temporal Tables. The first and second in the series ...

Cluster Level Consistency in InnoDB Group Replication

When you have multiple database servers working together as nodes in a cluster, it’s beneficial to understand how data ...

Cloning a PDB with encrypted data in united mode - avoid ORA-00283

The purpose of this blog post is to give you some guidelines on how to avoid " ORA-00283: recovery session canceled due ...

Is slave_exec_mode idempotent actually idempotent?

Background Co-Author: Rafael Alvarez When you look up the word idempotence in wikipedia you get the following ...

GCP features wish list for Google Next 2018

As I've just posted about Pythian at Google Next, I thought it would be cool to share the new GCP features I'd love to ...

DBAs and the Cloud: Evolving Roles and New Challenges

The adoption of cloud services is soaring and causing an enormous shift in the role of DBAs. Depending on whether an ...