SMB Nation Blog

SMB Nation has been serving the Bainbridge Island area since 2001, providing IT Support such as technical helpdesk support, computer support, and consulting to small and medium-sized businesses.

Top 5 open source tools for MySQL administrators

Look to these excellent tools to improve CLI and web admin, SQL queries, schema migration, and replication and recovery in your MySQL environment

free neon sign 100719704 large

                     ThinkStock

For database administrators (DBAs), keeping databases running at peak performance can be a little like spinning plates: It takes agility, concentration, quick reactions, a cool head, and an occasional call out from a helpful onlooker. Databases are central to the successful operation of almost every application. As DBAs are responsible for an organization’s data, finding dependable tools that help them to streamline the database management process and ease day-to-day maintenance tasks is essential. DBAs need good tools to keep their systems spinning smoothly.

So what are the tried and trusted tools for MySQL administrators? Here I share my top five open source tools for MySQL administrators and discuss their value in the support of day-to-day MySQL administration tasks. For each of them, I’ve provided a link to the GitHub repository and listed the number of GitHub stars at the time of writing.

Mycli

The Mycli project provides MySQL command line auto-completion and syntax highlighting. It is one of the most popular MySQL tools for administrators.

Security restrictions such as jump hosts and two-factor authentication leave many MySQL DBAs with command-line only access to their systems. In such circumstances, beloved GUI tools such as MySQL Workbench, Monyog, and others are not an option.

At the command line, much of the time is spent in a light-on-black terminal world. So one of the best things about Mycli is the richness of its syntax highlighting. This allows you, for example, to visually separate functions and operators from query strings in WHERE clauses. For a short, single-line query this may not be such a big deal, but it becomes a game changer when you work with queries that perform JOIN operations over more than a couple of tables. Am I doing the JOIN using indexed columns? Am I filtering using leading wildcards in my WHERE clauses? Mycli supports multi-line queries and syntax highlighting, which means you can home in on the sections that matter most when reviewing or optimizing queries. You can choose from a number of syntax highlighting color schemes or create your own.

The other killer feature of Mycli is smart completion. This allows to you pick out table and column names from a context sensitive list by entering just their first few characters. No more abandoning your current input to run SHOW CREATE TABLE because you forgot the name of the column you want in your WHERE clause!

Read More

 

February is Channel Education Month!
D&H DISTRIBUTING OFFERS SMB “MESH” WIFI SOLUTIONS ...

Recent Comments

Norberto Harrison How To Sell A HIPAA Risk Analysis
21 May 2018
Thanks for ones marvelous posting! I genuinely enjoyed reading it, you are a great author. I will be...
Mili AT&T Stores Breeding “Mini-Sales Agents”
21 May 2018
Agents are very important employees because they are the ones who advertise a company's products or ...
Norberto Harrison New Panasonic Toughpad Features Windows 8 Pro
20 May 2018
I ‘d mention that most of us visitors are really endowed to exist in a fabulous place with very many...