Enable MySQL over SSL in PHP (PDO)

If you are using a MySQL server that does not live on the same server as your website or application you should strongly consider accessing your database over SSL to prevent any snooping of not only your data but also your database credentials. Of course, doing so is highly dependent on the developers of applications…

Read More

How Do I See Outbound Connections From My Server?

Netstat to the rescue! First off, I’m going to assume you are using a Linux-based operating system on your server. While Windows servers also have a netstat tool, the arguments/options are all different (look for the link below for documentation). netstat The netstat tool will print network connection information and the output is highly customizable.…

Read More

Using Sysbench to Benchmark MySQL 5.7

So, you want to see how many connections your database can take before it gives up? It’s better to know ahead of time when you might expect performance issues than to wait until your service goes down. One of the most common tools around for performance testing is sysbench. I’ve used sysbench with MySQL 5.5…

Read More

Screen 202: Making Screen a Little More User Friendly

By now you’ve learned the basics of using screen from my previous posts. You may be wondering how to keep track of what you have running in each of your screen sessions. With this post we’ll show you how to add a little more context to screen that will allow you to more easily see what…

Read More

Screen 201: 7 Ways to Change Your View When Using Screen

In a previous post I detailed the basic usage of GNU Screen. Below I will cover how to customize screen to make it easier to use and more convenient for you. If you’ve used screen at all you know out-of-the-box it can be a bit plain and quirky. In fact, it’s virtually impossible to distinguish a…

Read More

Screen 101: Use Screen to Manage SSH Sessions

If you’re not a Linux power-user then you probably have never heard of Screen, in fact, I would hazard to say most Linux users probably have never heard of this utility. You don’t need to be a Linux desktop user (I’m not) to find Screen useful. I typically use it when running a script that…

Read More

Sysbench 1.x Fundamentals

Sysbench is the hammer frequently used to benchmark servers and services. Within the past year sysbench version 1 was released and with it came some syntax and usage changes. Unfortunately, there’s not a lot of documentation out there for using Sysbench so I had to learn the hard way. The best way to learn more…

Read More

Using Cloud-Based AI Keyword Analysis for Text Optimization

Recently I’ve seen a lot of discussion and debate about the use of Applicant Tracking Systems and how they parse resumes for keywords to try to determine if a candidate is a good fit for a job posting. Regardless of one’s thoughts on the systems, for better or for worse, the reality is they are…

Read More

Detecting Sentiment and Emotion in Text

Recently I was thinking about how sentiment and emotion are reflected in written communication. Be that in copy for an e-commerce product page, a press release, a blog post, or the bio on your LinkedIn profile. Effective communication requires the receiver to accept your message with the same tone and sentiment you intended. Word choice…

Read More