How do You Know if MySQL is Running on CentOS 7?

 General, How To  Comments Off on How do You Know if MySQL is Running on CentOS 7?
Sep 122018

Just this morning, someone asked me for the command to check if MySQL (or MariaDB) is running?

I quickly blurted out: Do a top or htop and you should see it.

# top | grep mysqld
26125 mysql  20   0 2618520 193692   9092 S  62.5  2.4 159:29.14 mysqld                                                   
26125 mysql  20   0 2618520 193692   9092 S   1.3  2.4 159:29.18 mysqld

While my answer was not wrong, I quickly realized there were better ways to find out if MySQL (or MariaDB) is running on a Linux box (in my case, CentOS 7).

Here are a few ways to determine if MySQL is running on a CentOS 7 or Red Hat 7 Linux box.

# service mariadb status
Redirecting to /bin/systemctl status mariadb.service
● mariadb.service - MariaDB database server
   Loaded: loaded (/usr/lib/systemd/system/mariadb.service; enabled; vendor preset: disabled)
   Active: active (running) since Thu 2018-08-30 07:59:30 EDT; 1 weeks 4 days ago
 Main PID: 25949 (mysqld_safe)
   CGroup: /system.slice/mariadb.service
           ├─25949 /bin/sh /usr/bin/mysqld_safe --basedir=/usr
           └─26125 /usr/libexec/mysqld --basedir=/usr --datadir=/var/lib/mysql --plugin-dir=/usr/lib64/mysql/plugin --log-error=/var/log/mariadb/mariadb.log --pid-file=/var/run/mariadb/mariadb.pi...

My favorite is the systemctl method since I use it often to check the status of other services like httpd.

$ systemctl status mariadb.service
● mariadb.service - MariaDB database server
   Loaded: loaded (/usr/lib/systemd/system/mariadb.service; enabled; vendor preset: disabled)
   Active: active (running) since Thu 2018-08-30 07:59:30 EDT; 1 weeks 4 days ago
 Main PID: 25949 (mysqld_safe)
   CGroup: /system.slice/mariadb.service
           ├─25949 /bin/sh /usr/bin/mysqld_safe --basedir=/usr
           └─26125 /usr/libexec/mysqld --basedir=/usr --datadir=/var/lib/mysql --plugin-dir=/usr/lib64/mysql/plugin --log-error=/var/log/mariadb/mariadb.log --pid-file=/var/run/mariadb/mariadb.pi...

Here’s another method to check the status of MySQL server:

$ mysqladmin -u root -p status
Enter password: 
Uptime: 1001300  Threads: 1  Questions: 11923946  Slow queries: 0  Opens: 701  Flush tables: 2  Open tables: 260  Queries per second avg: 11.908

You can always ping it.

# mysqladmin -umysql ping
mysqld is alive

Here’s one more way:

# mysqladmin -u root -p version
Enter password: 
mysqladmin  Ver 9.0 Distrib 5.5.60-MariaDB, for Linux on x86_64
Copyright (c) 2000, 2018, Oracle, MariaDB Corporation Ab and others.

Server version		5.5.60-MariaDB
Protocol version	10
Connection		Localhost via UNIX socket
UNIX socket		/var/lib/mysql/mysql.sock
Uptime:			11 days 14 hours 32 min 44 sec

Threads: 1  Questions: 11943278  Slow queries: 0  Opens: 701  Flush tables: 2  Open tables: 260  Queries per second avg: 11.910

On a Linux Mint or Ubuntu box, the following command should work:

$ /etc/init.d/mysql status
● mysql.service - MySQL Community Server
   Loaded: loaded (/lib/systemd/system/mysql.service; enabled; vendor preset: enabled)
   Active: active (running) since Mon 2018-09-10 02:13:20 EDT; 19h ago
 Main PID: 2250 (mysqld)
   CGroup: /system.slice/mysql.service
           └─2250 /usr/sbin/mysqld
 Posted by at 1:46 pm

Rosa Can’t Wait to get on Your Laptop or Desktop

 General, Linux  Comments Off on Rosa Can’t Wait to get on Your Laptop or Desktop
Dec 052015

Folks, there’s a new, pretty hooker Rosa in town and the lady can’t wait to establish herself on your lap-top or desk-top. 🙂

Sound the bugle, uncork the champagne and lay out the red carpet for the newly arrived Rosa a.k.a. Linux Mint 17.3.

Linux Mint 17.3 Available

Not content with offering an excellent, rock-solid distribution in Linux Mint 17.2 a.k.a Rafaela for free, Linux Mint developers have now put out an upgrade with a Christmas bag full of goodies.

Something is seriously wrong with Linux Mint’s Project Manager Clement Lefebvre and his team! I can’t handle so much goodness!

The new release, Linux Mint 17.3 a.k.a Rosa, is available in both Cinnamon and Mate editions.

Linux Mint 17.3 Rosa Released

Linux Mint 17.3 is a long term support release, which means we freeloaders will be supported and receive security updates until 2019.

Built on the Ubuntu 14.04 package base, Linux Mint ‘Rosa’ Cinnamon edition features Linux kernel 3.19, Cinnamon 2.8 and MDM 2.0 display manager.

Both 32-bit and 64-bit versions of Linux Mint 17.3 are available.

Several Enhancements

Here are the key enhancements in Linux Mint 17.3 Cinnamon edition:

* Improved Update Manager that performs more checks about the mirrors than before
* More robust Driver Manager that refreshes the cache before looking for drivers, loads faster and detects drivers in the background
* Improvements to the Software Sources tool to make it faster and more reliable
* Cinnamon 2.8 featuring several usability improvements
* Better applets
* Upgrades to Xorg, Mesa and Linux kernel
* LibreOffice upgraded to version 5
* OpenVPN support, Orca screen reader and Nemo preview installed by default

You can download Linux Mint 17.3 (Cinnamon or Mate editions) at the Linux Mint web site.

Go ahead, get Rosa on your laptop or desktop and take her for a spin.

I bet you’ll be more than pleased.

Upgrade to Rosa

Linux Mint 17, 17.1 or 17.2 users wanting to upgrade to Linux Mint 17.3 should wait for a few days until a new version of Update Manager is released.

A big Thank You to Clem and the Linux Mint team!

How Many Webs are There?

 General  Comments Off on How Many Webs are There?
Oct 012015

When most of us think of the Internet, our thoughts turn to search engines like Google, news sites like New York Times, social networks like Facebook or Twitter, tech blogs like Techcrunch, shopping sites like Amazon, free e-mail like gmail and our employers’ web sites.

But those’re just the most visible parts of the Internet, the proverbial tip of the Web iceberg.

Like a lot of things man made, the Internet too is multi-layered.

When you start peeling the surface layer of the Internet, there’s stuff you would be amazed to know exists.

Broadly speaking, the Web comprises of three layers or in other words the Internet has three Webs:

1. Surface Web – Who amongst us is not familiar with the Surface Web? This visible layer constitutes stuff like news, shopping, social networks, e-mail, business, and government web sites. Although for the most part in the legal domain, the Surface Web also occasionally hosts criminal enterprises or ones that sit on the edge between legal and illegal. The overwhelming majority of users of the Surface Web rely on regular browsers like Firefox, Safari or Chrome and simple mail clients like Outlook, Evolution and Thunderbird.

2. Deep Web – This section of the Internet consists of stuff not easily accessibly by the lay public. Stuff like governmental databases of federal and state tax filings, SSN benefits, pension records accessible only by a few select people, online banking, medical records, and paywall content. What distinguishes Deep Web from the Surface Web is access restriction via strict policies. While some analysts include the third layer, Dark Web, as a subset of the Deep Web, I set it apart. In my view, the Deep Web operates for the most part in the legal domain circumscribed by laws and regulations but the Dark Web is a free for all.

3. Dark Web – Think of Dark Web aka Dark Net as the Mariana Trench of the Internet, the deep, murky parts. Players in this Wild West section of the web include drug peddlers, Mafia, terrorists, government intelligence agencies, pedophiles, gun peddlers, hackers for hire, smugglers, counterfeiters, illegal marketplaces and a grab bag of criminals. A key aspect of the Dark Web is its secretive, hidden and anonymous nature. Dark Web is the shadowy, dark alley equivalents of the Web. Dark Web sites are not indexed by conventional search engines, have esoteric URLs or accessible only by IPs and frequently change their web site address. Except for the hopeless oligophrenic idiots, users of the Dark Web rely on multiple layers of cloaking like Tor and VPNs to navigate the Dark Web.

 Posted by at 10:34 pm

How to Restore from a QuiteRSS Backup

 General  Comments Off on How to Restore from a QuiteRSS Backup
Aug 042015

QuiteRSS BackupQuiteRSS is an excellent open source cross-platform RSS news feed reader that I have been using for about a year now with mucho satisfaction.

I’ve installed it on Linux Mint and CentOS. The reader works fine on Linux and I can’t recollect it ever crashing on me.

The free reader works on Windows and Mac OS X too but I have yet to try them on those platforms.

Like any good IT user, every month or so I make a backup of QuiteRSS (Via File –> Create Backup on the menu bar) from inside the program just in case I need it later.

Restoring from QuiteRSS Backup

Recently I wanted a copy of my carefully picked QuiteRSS feeds on a CentOS 7 system. Continue reading »

 Posted by at 2:28 pm

VirtualBox Matures into 5.0 with Improved Security

 General  Comments Off on VirtualBox Matures into 5.0 with Improved Security
Jul 102015

Where to Download VirtualBox 5.0

Oracle’s cross-platform virtualization software VirtualBox has hit release 5 with enhanced security and usability features.

Designed to run on standard x86 desktop and laptop computers, VirtualBox lets developers and other users run multiple operating systems in secure containers without the overhead of using a full server environment.

For instance, if you have VirtualBox on a Windows 7 laptop then you can install Fedora or any other supported guest OS in a secure container.

Enhancements in Virtualbox 5.0

* Disk Image Encryption – Data can be encrypted on virtual hard disk images during runtime using AES algorithm with up to 256 bit data encryption keys (DEK). This feature enables data to remain secure and encrypted at all times, whether the virtual machine is sitting unused on a developer’s machine or server, or actively in use.

* Bi-Directional Drag and Drop Support for Windows – On all host platforms, Windows, Linux and Oracle Solaris guests now support “drag and drop” of content between the host and the guest. An extremely handy feature, the drag and drop feature allows copying or opening of files and directories between the host and the guest.

* Support for USB 3.0 Devices – Guest operating systems can now directly recognize USB 3.0 devices and operate at full 3.0 speeds. Guest OS can be configured to support USB 1.1, 2.0, and 3.0.

* Improved CPU Utilization: Performance boost is obtained by exposing a broader set of CPU instructions to the guest OS, enabling applications to make use of latest hardware instruction sets.

* Paravirtualization Support for Windows and Linux Guests – Improves guest OS performance by leveraging built-in virtualization support on operating systems like Oracle Linux 7 and Windows 7.

* GUI improvements – Allow hotplugging support for SATA disks, direct access to storage media in the virtual machine selector and VM guest-content scaling support (including 3D acceleration).

* New Guest OS – Support for additional guest OS such as Windows 10, Windows Server 2012 R2 and new Linux platforms like Fedora 22.

Download Virtualbox 5.0 here.

 Posted by at 9:30 am

Firefox Reader View – Another Nail in Content Producers Coffin

 General  Comments Off on Firefox Reader View – Another Nail in Content Producers Coffin
Jun 072015

Firefox Reader ViewContent producers are in the throes of death.

Be it the New York Times, Washington Post, L.A.Times or any major news publication, they’re all in dire straits.

Today it’s mostly middlemen (platforms) like Facebook, Trip Advisor, Yelp, Yahoo, Bing (Microsoft) and Google who leech on others’ content and make money.

Endless Woes

There’s just no end to the train of woes besetting content producers, big or small, these days.

A few days back, Firefox browser delivered a devastating punch to content producers.

The latest update to Firefox (version 38.0.5) has introduced a Reader View feature that lets readers strip all ads from the news story they’re reading and consume the news in a so-called “distraction-free mode.” Continue reading »

 Posted by at 3:34 am