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

Linux Foundation and Linux

openSUSE Tumbleweed Users Get Git 2.11, Xfce 4.12.3, FFmpeg 3.2.1 & Mesa 13.0.2

openSUSE's Douglas DeMaio reports on the latest Open Source and GNU/Linux technologies that landed in the repositories of the openSUSE Tumbleweed rolling operating system. Read more

What Is A VPN Connection? Why To Use VPN?

We all have heard about VPN sometime. Most of us normal users of internet use it. To bypass the region based restrictions of services like Netflix or Youtube ( Yes, youtube has geo- restrictions too). In fact, VPN is actually mostly used for this purpose only. ​ Read
more

The Libreboot C201 from Minifree is really really really ridiculously open source

Open source laptops – ones not running any commercial software whatsoever – have been the holy grail for free software fans for years. Now, with the introduction of libreboot, a truly open source boot firmware, the dream is close to fruition. The $730 laptop is a bog standard piece of hardware but it contains only open source software. The OS, Debian, is completely open source and to avoid closed software the company has added an Atheros Wi-Fi dongle with open source drivers rather than use the built-in Wi-Fi chip. Read more