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

GNU/Linux: the desktop that never was

About 6 years ago, I wrote an article about why I felt that installing software in GNU/Linux was broken. It pains me to say that the situation is, sadly, exactly the same:GNU/Linux never made it to personal computers, really, and at this point it looks like it never will. http://www.freesoftwaremagazine.com/articles/gnulinux_desktop_never_was

GNU/Linux: the desktop that never was

About 6 years ago, I wrote an article about why I felt that installing software in GNU/Linux was broken. It pains me to say that the situation is, sadly, exactly the same:GNU/Linux never made it to personal computers, really, and at this point it looks like it never will. http://www.freesoftwaremagazine.com/articles/gnulinux_desktop_never_was

UK Government Analyzes Ubuntu 14.04 LTS Security

The UK government releases every year a security guidance that details various problems and security problems that are identified in systems used by the authorities. They also revealed some issues with Ubuntu 14.04 LTS, although it's not something major. Read more

AndEX Now Lets You Run Android Lollipop 5.0.2 on Your PC with Linux Kernel 4.0

The AndEX Live DVD that we introduced to you a few weeks ago has been updated today with new features, such as the latest Linux 4.0 kernel. Read more