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

Remembering Thomas Wood

It is with great sadness that we announce the passing of our friend, Thomas Wood. Commonly known as ‘thos’ on irc, Thomas was a long time contributor to the GNOME Art project, where he curated GTK+ Themes, backgrounds, login screens, and icons. In later years, he also worked on the control center and maintained the GNOME Backgrounds module. Outside of GNOME, he worked on the Moblin platform, which enabled various technologies key to GNOME 3, like GNOME Shell and Clutter. Read more

The Review of Wayland Progress In 2016: Weston, GNOME, KDE, Enlightenment

We live in time of Linux graphic revolution and it’s not a scenario of popular blockbuster. X Window System from the 1980’s with old architecture isn’t good as 10 or 20 years ago. Wayland provides the modern speedy protocol without tons of legacy code and make the Linux desktop better and faster. Time to testing the most popular Linux desktop environment on Wayland. If you have interested working experience with Wayland – I’m will happy to read it in the comments. Read more

How to run Windows programs on Linux with CrossOver

Will your program run on Linux, or for that matter CrossOver Mac? CrossOver keeps a complete listing of what runs, and what doesn't. You can also try CrossOver with a 15-day free trial to make sure the software you need works well on a Linux system. CrossOver is based on the open-source project Wine, an implementation of the Windows application programming interface (API) on top of the Unix/Linux operating system family. Wine is a mature project with 20 plus years of work behind it. Read more

Firefox 44.0.2 Arrives for Linux, Windows, and Mac OS X

Mozilla launched a second update for the Firefox 44.0 branch, but this is a smaller release with just a couple of smaller fixes, albeit the security issue is quite important. Read more