Language Selection

English French German Italian Portuguese Spanish

Running MySQL queries on multiple servers

Filed under
HowTos

You may know how to use SQL to extract data from a table in a MySQL database, and how to run a query that combines data from more than one table. But what about multiple databases? Or even multiple databases on multiple servers?

Let's start by looking at the simplest example -- running a query on a single table. All you have to do is connect to the database, enter the query, and press Enter.

By the way, I'm using David Nash's HYG Databases of stellar data in the following examples. I downloaded Nash's CSV files, wrote a shell script to format them, then created the databases on three of my servers -- Acamas, Cassandra, and Hector.

Full Story.

I prefer Linux in almost every way to Mac OS X, but I have to admit a little envy over OS X's Exposé feature, which quickly tiles all open windows. Luckily for Linux users, Komposé brings the same convenience to the Linux desktop.

Komposé is a task manager for KDE that generates thumbnails of your windows grouped by your current workspace or all workspaces. The old-school way to manage windows is to use a taskbar or to move through your windows by using Alt-Tab and Alt-Shift-Tab. I usually have 10 to 20 windows open on each virtual desktop, however, so this can get tedious pretty fast.

That Story.

More in Tux Machines

GNOME Builder 3.22 Enters Beta with Many Vim Improvements, New Search & Replace

The GNOME Builder open-source IDE (Integrated Development Environment) designed for the GNOME desktop environment will soon get a major update as part of the upcoming GNOME 3.22 release. Read more

Geary 0.11.2 Email Client Improves Showing of Right-To-Left (RTL) Messages

A new version of the popular Geary open-source email client for GNU/Linux distributions has been made available for download earlier today, August 28, 2016. Read more

How To Turn On Num Lock Automatically On Startup In Linux

One of the frustrating thing in most Linux distros is that the Num Lock is not enabled on startup. Whenever I start typing my password at system login screen, the focus goes out of the password field. It happens very often with people and this little problem is very irritating. But don't worry. You can set your Linux to enable Num Lock automatically on startup. Read
more

Windows 10 vs. Linux Radeon Software Performance, Including AMDGPU-PRO & RadeonSI

As alluded to earlier and on Twitter, the past few days I have been working on a fresh Windows 10 vs. Ubuntu Linux graphics/gaming performance comparison. This time it's looking at the latest Radeon performance using an R9 Fury and RX 480. Tests on Windows were obviously done with Radeon Software Crimson Edition while under Linux were the two latest AMD/RTG Linux driver options: the hybrid AMDGPU-PRO driver and the fully open-source driver via Linux 4.8 and Mesa 12.1-dev. Read more