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 internally and for our clients. The most noteworthy technology stack that I’ve seen get a lot of traction in the…

Read More >

How to Allow a Remote MySQL Database Connection

Here at Pythian we like to pay attention to what brings people to our site, and one of the main queries we’ve been seeing is “How can I allow a remote MySQL database connection?” Since our mission is to help…

Read More >

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 post from the past. Today’s post was originally published on May 23, 2018. In recent weeks I’ve been focusing…

Read More >

Leading Through Crisis – What Ernest Shackleton Can Teach Us About the COVID Pandemic

In January 1915, polar explorer Ernest Shackleton’s ship became trapped in ice near Antarctica. For the next two years, he kept his crew of 27 men alive on a drifting ice cap, before leading them to safety. In this article…

Read More >

ProxySQL Query Rules: Notes From Production

After spending four years working with ProxySQL in production, I’ve learned a few interesting lessons about interpreting and processing query rules. I hope to save you some time (and avoid wrong turns) with this summary of ProxySQL query rules. ProxySQL…

Read More >

Adding Your RDS Fleet to PMM2 Using the API

PMM (Percona Monitoring and Management) is a great community tool for monitoring your OSDB (MySQL, PostgreSQL, MongoDB) fleet. It’s feature rich, and it’s built and distributed as open-source based on several de-facto industry standard tools such as Grafana and Prometheus….

Read More >

Migrate Postgres Database from EC2 instance to RDS using AWS DMS (Data Migration Services)

In this post, we will explore one approach to Migrate PostgreSQL DB on EC2 instance to RDS instance using AWS Data Migration services. Amazon Relational Database Service (Amazon RDS) is quite popular because of its easy setup, operation, and auto-scalability….

Read More >

Spark + Cassandra Best Practices

Spark Overview Spark was created in 2009 as a response to difficulties with map-reduce in Hadoop, particularly in supporting machine learning and other interactive data analysis. Spark simplifies the processing and analysis of data, reducing the number of steps and…

Read More >

Using MySQL Workbench to Connect Through ProxySQL 2

So, I admit the title for this post is a bit ambiguous. Not only is it the second post I’ve written in a short period of time, but it’s also focused on ProxySQL 2.0. As promised in the previous post,…

Read More >

Using MySQL Workbench to Connect Through ProxySQL

MySQL Workbench is a popular tool for many developers working with a MySQL backend database. In a simple environment where you can connect directly to the database it works very intuitively, but in more complex environments it might be a…

Read More >
Page 1 of 1312345...10...Last Page »