Stuff I'm Up To

Technical Ramblings

Bye, bye, Percona — May 25, 2017

Bye, bye, Percona

For quite a few years we’d been running Percona on our Nagios server with no issues. So no reason to change, until sometime over the past few days the repository’s public key expired and automated updates were failing.

I tried to update the key, searching key servers and eventually gave up. I resorted to removing the repo’s from my apt sources.list. Then I just installed the MySQL apt repo and installed MySQL. As it installs it warns you about having a backup as data already exists and may be lost after the install. However, for me it simply removed Percona for me, installed MySQL and was up and running without any issue.

So it maintained all my users, schemas and tables and performed as expected.

Not that there’s anything wrong with Percona, just that I took the easy option of going with what the majority of our install base uses.

 

Advertisements
MySQL Enterprise — February 22, 2017
MySQL Apt-Get Update Fails —

MySQL Apt-Get Update Fails

Apt-get update fails because the PGP keys for the repository have expired.

$ sudo apt-get update

W: An error occurred during the signature verification. The repository is not updated and the previous index files will be used. GPG error: http://repo.mysql.com jessie InRelease: The following signatures were invalid: KEYEXPIRED 1487236823 KEYEXPIRED 1487236823 KEYEXPIRED 1487236823

W: Failed to fetch http://repo.mysql.com/apt/debian/dists/jessie/InRelease

W: Some index files failed to download. They have been ignored, or old ones used instead.

Update the necessary key by adding it to your keystore

$ sudo apt-key adv --keyserver pgp.mit.edu --recv-keys A4A9406876FCBD3C456770C88C718D3B5072E1F5

References: https://bugs.mysql.com/bug.php?id=85029

Sphinx Search — September 29, 2016

Sphinx Search

http://sphinxsearch.com/

https://www.digitalocean.com/community/tutorials/how-to-install-and-configure-sphinx-on-ubuntu-16-04?utm_medium=social&utm_source=twitter&utm_campaign=sphinx_ubuntu_tut&utm_content=image

Sphinx is an open source full text search server, designed from the ground up with performance, relevance (aka search quality), and integration simplicity in mind. It’s written in C++ and works on Linux (RedHat, Ubuntu, etc), Windows, MacOS, Solaris, FreeBSD, and a few other systems.

MySQL 5.7 — September 20, 2016

MySQL 5.7

With a Debian Jessie install right now you’ll be getting MySQL 5.5. If you want something newer you’ll need to use MySQL’s own repositories by adding them to your apt sources.

The install works pretty seamlessly. Just make sure you follow the guide. Step 1 a) download the repository setup: http://dev.mysql.com/downloads/repo/apt/

Once done it’s a simple case of dpkg install it and then update the repos and install/upgrade your MySQL server.

Source: http://dev.mysql.com/doc/mysql-apt-repo-quick-guide/en/