Enable http/2 in Apache
Directadmin update httpd to support http/2 su - # yum update # cd /usr/local/directadmin/custombuild # ./build update # ./build update_versions # ./build set php1_mode php-fpm # ./build php n #…
Read More MySQL Shell 8.x
MySQL Shell – Create and Restore a MySQL backup MySQL Shell is an advanced client and code editor for MySQL. In addition to the SQL functionality, similar to mysql client,…
Read More vi/vim tricks
vi or vim is a powerful text editor that comes installed by default in most Linux and Unix systems. You’ll find many tutorials online that’s get you started quickly. There’s also the command vimtutor that…
Read More SELinux on CentOS
What is SELinux Security Enhanced Linux (SELinux) is a Linux Security Module (LSM) that is built into the Linux kernel. SELinux provides an additional layer of system security. The standard…
Read More ssh-copy-id (password less ssh login)
If your OS does not support “ssh-copy-id” command, you can use the following instead. cat ~/.ssh/id_rsa.pub | ssh <REMOTE_MACHINE_IP> [-p SSH_PORT] [-l USERNAME] 'mkdir .ssh; chmod 0700 .ssh; cat >>…
Read More MySQL auto_increment capacity calculation
Have you ever wondered if your tables in a MySQL database may be nearing capacity on INT AUTO_INCREMENT columns?First things first: If your application design allows, set the AUTO_INCREMENT column…
Read More Using UUID as a Primary Key
MySQL UUIDs A UUID is a 128-bit number represented by a utf8 string of five hexadecimal numbers separated by dashes. A UUID value looks like: aaaaaaaa-bbbb-cccc-dddd-eeeeeeeeeeee There are 5 different versions. MySQL uses UUID version 1. mysql> SELECT…
Read More Keycloak and InnoDB Cluster
It seems many people have had issues setting up Keycloak with InnoDB Cluster (Group Replication). Unfortunately the error messages thrown by the set process (Java) haven’t been very helpful in…
Read More How to create Column in MySQL only if one does not exist?
You can do the following through using a stored proc or a programming language if this is something that you’ll need to do on a regular basis.
Inject empty transactions in MySQL 5.6 GTID based Replication
As you probably already know, SET GLOBAL SQL_SLAVE_SKIP_COUNTER = n doesn’t work anymore if you use GTID based replication. Is there a way to skip a single transaction in such…
Read More Recent Posts
- Enable http/2 in Apache 16th Jan 2021
- MySQL Shell 8.x 16th Jan 2021
- vi/vim tricks 30th Dec 2020
- SELinux on CentOS 29th Dec 2020
- ssh-copy-id (password less ssh login) 26th Dec 2020
- MySQL auto_increment capacity calculation 26th Dec 2020
- Using UUID as a Primary Key 24th Dec 2020
- Keycloak and InnoDB Cluster 29th Nov 2020
- How to create Column in MySQL only if one does not exist? 19th Mar 2019
- Inject empty transactions in MySQL 5.6 GTID based Replication 25th Dec 2018
- Adding a new disk to CentOS 26th Aug 2018
- mysqldump extended inserts 26th Jun 2018
- CentOS Logical Volume Manager (LVM) 26th Oct 2017
- How to prepare SD Card for Raspberry Pi on a MAC 26th Jun 2017
- Convert .dmg file on a MAC to .iso 26th Apr 2017
Categories
- CentOS (4)
- CentOS 8 (2)
- InnoDB cluster (1)
- mysql (7)
- Raspberry Pi (1)
- ssh (1)
- Technical (3)
Tag cloud
Archives
- January 2021 (2)
- December 2020 (5)
- November 2020 (1)
- March 2019 (1)
- December 2018 (1)
- August 2018 (1)
- June 2018 (1)
- October 2017 (1)
- June 2017 (1)
- April 2017 (1)
- February 2016 (1)