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

LibreOffice 5, a foundation for the future

The release of the next major version of LibreOffice, the 5.0, is approaching fast. In several ways this is an unique release and I’d like to explain a bit why. Read more

Samsung Continues to Lessen Android Dependence

Samsung's partnership with members of the Linux Foundation appears to be bearing fruit. The partnership's mobile operating system -- dubbed Tizen -- is Linux-based. Samsung's initial Tizen phone rollout was rocky: The company's highly anticipated Samsung Z launch in Russia was quickly canceled last year, and the company blamed concerns about the ecosystem for the delay. Unfortunately, in many cases, ecosystem development presents a "chicken and egg" problem: Developers won't build apps until you have users, and users won't select your product until you have apps. Read more

Linux 4.2 Offers Performance Improvements For Non-Transparent Bridging

The Non-Transparent Bridge code is undergoing a big rework that has "already produced some significant performance improvements", according to its code maintainer Jon Mason. For those unfamiliar with NTB, it's described by the in-kernel documentation, "NTB (Non-Transparent Bridge) is a type of PCI-Express bridge chip that connects the separate memory systems of two computers to the same PCI-Express fabric. Existing NTB hardware supports a common feature set, including scratchpad registers, doorbell registers, and memory translation windows." Or explained simply by the Intel Xeon documentation that received the NTB support, "Non-Transparent Bridge (NTB) enables high speed connectivity between one Intel Xeon Processor-based platform to another (or other IA or non-IA platform via the PCIe interface)." Read more

Benchmarks Of 54 Different Intel/AMD Linux Systems

This week in celebrating 200,000 benchmark results in our LinuxBenchmarking.com test lab, I ran another large comparison against the latest spectrum of hardware/software in the automated performance test lab. Read more