Ralph Ralph-Lee

Change a MySQL Data Directory to a New Location on CentOS 7

mysql -u root -p

# Check current data directory
mysql> select @@datadir;
+-----------------+
| @@datadir       |
+-----------------+
| /var/lib/mysql/ |

Installing MySQL 8.0 via Docker

TLDR: just looking for the code? Skip to the end.

📖 Summary

This document guides you through the setup of Docker and MySQL.

Why would you want to do it this way?

Isolated environment. Need to upgrade from version 5.7 to 8.0 and are just developing locally? Previous configurations breaking your installation? Toss your old image and get a new one.
Preparation for real world development. Local databases are typically for coding and testing. Developers don't normally run a live production database from their own machine. We just need a database we can quickly test and develop on. Docker is perfect for that.

MySQL 5.7 installation in CentOS 7

sudo su

# Remove MariaDB packages
yum list installed | grep -i maria
yum remove mariadb.x86_64
yum remove mariadb-libs.x86_64

# Download MySQL 5.7 RPM tar

openssh latest

Build, install, and run the latest OpenSSH Server as a systemd service.

openssh latest
- About
- Prepare /opt
apt install

Building GCC 9.2.0 on CentOS 7

Introduction

CentOS 7 distribution (as well as RHEL 7) ships with a somewhat outdated version of the GCC compiler (4.8.5 on CentOS 7.5), which may not be suitable to your compilation requirements. For example, C11 - which supersedes C99 - is fully supported only starting from GCC 4.9).

Additionally, recent versions of GCC (GCC6, GCC7, GCC8, GCC9) come with improvements which help detect issues at build time and offer suggestions on how to fix them. Sometimes, these are even actually helpful!

This note describes how to build the latest GCC (9.2.0 as of October 2019) from sources on CentOS 7. This should be applicable as is on RHEL 7. For other Linux distributions, adapt as needed.

Mac OSX Bootstrap

Upgrade to Mavericks

Install Mavericks via the App Store.

Secure The Machine

Raspberry Pi VPN Router

This is a quick-and-dirty guide to setting up a Raspberry Pi as a "router on a stick" to PrivateInternetAccess VPN.

Requirements

Install Raspbian Jessie (2016-05-27-raspbian-jessie.img) to your Pi's sdcard.

Use the Raspberry Pi Configuration tool or sudo raspi-config to:

	Weblogic 11c
	Add the <enforce-valid-basic-auth-credentials> element to config.xml within the <security-configuration> element.
	:
	<enforce-valid-basic-auth-credentials>false</enforce-valid-basic-auth-credentials>
	</security-configuration>
	Start or restart all of the servers in the domain.

	http://blog.avanttic.com/2011/02/16/problema-drivers-jdbc-al-migrar-una-aplicacion-java-1-4-a-1-6-weblogic-11g/

	Weblogic 12C

	# See https://docs.oracle.com/javase/8/docs/technotes/tools/windows/java.html
	# See https://docs.oracle.com/javase/8/docs/technotes/guides/vm/performance-enhancements-7.html
	# See https://docs.oracle.com/javase/8/embedded/develop-apps-platforms/codecache.htm
	# See http://normanmaurer.me/blog_in_progress/2013/11/07/Inline-all-the-Things/
	# See http://stas-blogspot.blogspot.com.br/2011/07/most-complete-list-of-xx-options-for.html

	# -XX:+LogCompilation
	# -XX:+PrintInlining

	-Dfile.encoding=UTF-8

	<?xml version="1.0" encoding="UTF-8"?>
	<!DOCTYPE plist PUBLIC "-//Apple//DTD PLIST 1.0//EN" "http://www.apple.com/DTDs/PropertyList-1.0.dtd">
	<plist version="1.0">
	<dict>
	<key>KeepAlive</key>
	<true/>
	<key>Label</key>
	<string>autossh.lenciel</string>
	<key>ProgramArguments</key>
	<array>