はてなブックマーク

Password rotation is not the most exciting task in the world, and that's exactly why it's a perfect candidate for automation. Automating routine tasks like this are good for everyone - DBAs can work on something that's more exciting, companies save costs as less time is spent on changing the passwords, and there's no place for human error, either. At Pythian, we typically use Ansible for task auto

Sizing a database is one of the primary DBA functions no matter what the technology. Though Redshift is highly managed for us, we must still address this task. The first thing to note is that in sizing a cluster, we start with an estimated need of storage capacity, since the amount of storage available per node of the cluster is a fixed amount. While you get the disk space you pay for, AWS guideli

Last week, I was pleased to present at Percona Live Amsterdam 2015 regarding the importance of Performance Schema and how to begin approaching visualizing the data that is available to diagnose performance issues and fine tune your MySQL environment. You can download the slides from the Percona Live conference page. The session highlighted using the ELK ( Elasticsearch+ Logstash+ Kibana) stack to

At Pythian's internal forum, someone just asked the following question: "The team here is evaluating DB load testing tools (Hammerdb, Orion, SLOB, and Swingbench) and was wondering about our experience in using different tools and what is our opinion?" I have experience using some of the tools mentioned. Therefore, decided to answer using this public blog post, as it could be useful for you too an

Recently we quickly and efficiently resolved a major performance issue with one of our New York clients. In this blog, I will discuss about this performance issue and its solution. Problem statement The client’s central database was intermittently freezing because of high CPU usage, and their business severely affected. They had already worked with vendor support and the problem was still unresolv

Overview Pythian is a global data and analytics services company that helps organizations like yours transform by leveraging data, analytics, AI, and the cloud.

I recently reformatted my laptop with the latest Ubuntu LTS release, 10.04, aka Lucid Lynx. Since I like to have a native client installation as well as a portable sandbox server, I decided to install the latest version of Oracle EE, 11.2.0.1. Rather than re-invent the wheel, I’m going to direct you to the previous Oracle-on-Ubuntu post by my colleague Augusto Bott. Many of the directions there ho

I was very surprised that Oracle released Oracle Database for Mac OSX, especially, version 10g now that 11g has been out for almost 2 years. Well, I guess Oracle wanted to please Mac users expecting things just work and decided that good proved 10g is the way to go. On the other hand, we've been supporting 11g in production for quite a while and I must say it's much better quality compare to 10g w