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

Red Hat Financial News

Leftovers: Gaming

  • Unreal Engine 4.16 Enters Public Preview State
    Epic Games on Friday released the first public preview of the upcoming Unreal Engine 4.16. There are many changes to find with Unreal Engine 4.16 while some of the highlights include volumetric fog support, a new clothing solver, optimized distance field lighting, garbage collection improvements, and more.
  • Unreal Engine 4.16 Preview
    A Preview of the upcoming 4.16 release is available now on the Launcher and Github. We have made this Preview available so that our developer-community can help us catch issues before the final release. As fixes are implemented, we will release updated previews throughout the development cycle. Please be aware that the preview releases are not fully quality tested, that they are still under heavy active development, and that they should be considered as unstable until the final release. Developers should not convert their projects for active development on preview releases. Please test on copies of your project instead.
  • Watch this highlight reel of iAlwaysSin's Alien Isolation livestreams!
    Last Thursday the newest member of the GOL Livestream Team, iAlwaysSin, completed her live playthrough of the extremely scary Alien Isolation. And, to commemorate this achievement (and all the deaths that occurred in the process) I decided to download and edit all the VODs together into a nice highlight reel. With my sarcastic remarks, of course.

Kernel and Graphics in Linux

Manjaro Linux: Reliable and Up to Date, Geekdom Optional

Regular readers can pretty much ignore this one. We’ll be back to cartoons, O’s baseball and the usual inanity soon, tomorrow in fact. I just wanted to revisit my dedication to Linux, prompted by a recent mixed bag of experiences that left me feeling even more positive about a relative newcomer to the distro scene: Manjaro. It all started a few days ago, when I decided to finally try to update the eight remaining Linux installs on my main desktop PC. I’ve been using Linux Mint (18.1 Cinnamon) as my daily driver for several months, originally in an attempt to keep my bandwidth usage to a reasonable level, and then due to inertia/lack of issues. I could have gone with my trusty Debian stable install, my go-to for years up till then, but I guess I was just getting bored. Read more