dayreiner

############ REPLACE app/models/enterprise_token.rb in the source code with this file! ################
############ also be sure to RESTART OpenProject after replacing the file.             ################
############ it doesn't show that enterprise mode is enabled in the settings, but all  ################
############ enterprise mode features, such as KanBan boards, are enabled.             ################
#-- copyright
# OpenProject is an open source project management software.
# Copyright (C) 2012-2023 the OpenProject GmbH
#
# This program is free software; you can redistribute it and/or
# modify it under the terms of the GNU General Public License version 3.

dayreiner

-- 
-- @dayreiner |  https://18pct.com/ | https://sensibrands.ca | https://github.com/dayreiner 
--
-- An example database for storing product GTINs and generating the GS1 check digit and GTIN master case code. 
-- When an 11-digit GTIN is inserted, a trigger calls the function to generate the GS1 check digit and insert it into the check_digit column. 
-- A second trigger generates the master case code GTIN and inserts that value in the master_case_code column. 
-- Expanded upon from the function in this article: https://www.anycodings.com/1questions/4958850/check-for-invalid-upc-in-mysql
--
-- After creating the gtin database, you can insert a gtin to test that the check digit and case code are correctly added:
-- 

dayreiner

version: '2'
services:
  db-bootstrap:
    image: dayreiner/centos7-mariadb-10.1-galera:latest
    container_name: db1
    restart: never
    expose:
     - "3306"
     - "4567"
     - "4568"

dayreiner

Keybase proof

I hereby claim:

• I am dayreiner on github.
• I am dayreiner (https://keybase.io/dayreiner) on keybase.
• I have a public key whose fingerprint is C9B8 3E33 457A 7E82 52BA 1D32 8800 AEA0 322E A3E2

To claim this, I am signing this object:

dayreiner

Reposted from this blog entry

Associated github repository

Photo By: Håkan Dahlström

Part one of a two-part series. The second part will be posted in a couple of days...

While I manage environments across multiple cloud platforms (and even the occasional "traditional" colo) at my workplace, our primary application environment is in IBM Softlayer. I enjoy working with Softlayer -- the API is fairly robust, there's a lot of choice (even bare-metal, should that tickle your fancy) and it allows me to deploy instances in both Toronto and Montreal. Canadian data-residency is a "big deal" for many Canadian companies; which the

dayreiner

# MariaDB Tuning
vm.swappiness = 1
fs.file-max = 2097152
vm.dirty_ratio = 60
vm.dirty_background_ratio = 2

# Sets the time before the kernel considers migrating a proccess to another core
kernel.sched_migration_cost_ns = 5000000

# Group tasks by TTY

dayreiner

Monitoring MariaDB Galera Cluster Members with Citrix Netscaler

Also posted here: http://18pct.com/monitoring-mariadb-galera-cluster-members-with-citrix-netscaler/

We run several MariaDB Galera clusters for various client sites and use Citrix Netscaler Application Delivery Controllers to load-balance various services (among other features). With near-synchronous multimaster replication, Galera cluster simplifies application stacks as in many cases you can point each web server at its own corresponding database server and just worry about balancing the load between your application servers.

Citrix netscaler also supports load-balancing across MySQL systems, for instances where you want to spread out reads across systems or want to balance reads and send writes to a specific system.

But what happens when

dayreiner

Sending Bash and ZSH Commands to Syslog

Also posted here: http://18pct.com/sending-bash-and-zsh-commands-to-syslog/

Your bash/zsh history is great if its complete, but it doesn't capture commands across all users, sudo's, root commands etc. In particular with test environments, someone may perform a "one-off" procedure and then months later it needs to be repeated. It would be nice to be able to look up what the user did at the time, and searching through multiple, possibly truncated history files is a pain.

Tools like typescript are great if you're actively documenting, but not something you would use all the time in practice and capture more than just a history of your commands. There are third-party tools like rootsh and Snoopy that can accomplish this, but third-party tools can be overkill if all you want is a quick reference in a re

dayreiner

Docker 1.10.0 rc3 with Docker Compose 0.6 and Docker Machine 1.6 and Xhyve on OSX

Also posted here: http://18pct.com/docker-1.10.0rc3-with-compose,-machine-and-xhyve-on-osx/

The steps below will uninstall docker, docker-machine and docker-compose under OSX using virtualbox (via either brew or toolbox, or both), and replace them with the latest RC versions of docker, compose and machine using the Xhyve driver for better performance under OSX using Hypervisor.framework.

---

dayreiner

Docker 1.10.0 RC1 with Docker Compose 0.6 and Docker Machine 1.6 and Xhyve on OSX

Updated install instructions for RC2 are available here

The steps below will uninstall docker, docker-machine and docker-compose under OSX using virtualbox (via either brew or toolbox, or both), and replace them with the latest RC versions of docker, compose and machine using the Xhyve driver for better performance under OSX using Hypervisor.framework.