Watch Out When Running Out of Disk Space With InnoDB Group Replication Cluster

Oracle MySQL Community Edition comes with a native, virtually synchronous, clustering solution called InnoDB Cluster. This clustering solution uses a technology under the hood called Group Replication. This technology is very similar to Galera Cluster, although where Galera relies on…

Read More >

Installing Elasticsearch Using Ansible – the Quick Way!

Editor’s Note: Because our bloggers have lots of useful tips, every now and then we bring forward a popular post from the past. We originally published today’s post on December 12, 2019. This is the first of a series of…

Read More >

Diagnosing Orchestrator Crashes Due to Time Drift Events

We were recently paged by a client because one node of their Orchestrator setup had crashed. The Orchestrator cluster was set up using the Orchestrator/raft consensus cluster and using a SQLite backend. When looking in the log files this is…

Read More >

How to Secure Your Elastic Stack (Plus Kibana, Logstash and Beats)

Editor’s Note: Because our bloggers have lots of useful tips, every now and then we bring forward a popular post from the past. We originally published today’s post on December 16, 2019. This is the second of a series of…

Read More >

Incremental Repair: Problems and a Solution

Because incremental repairs can significantly reduce the time and IO cost of performing a repair, they can seem like a great idea. However practical implementation carries a few pitfalls which can cause severe damage to a production cluster, especially when…

Read More >

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 post from the past. Today’s post was originally published on November 26, 2019. It’s not uncommon these days for…

Read More >

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 >
Page 1 of 1412345...10...Last Page »