Welcome to blog.perlubantuan.com

The Journal Of A Linux Sysadmin

Disable MySQL Strict Mode

This is enabled by default, but you can disable it in one of a couple ways. First, verify which mode(s) MYSQL is running with: $ mysql -u root -p -e "SHOW VARIABLES LIKE 'sql_mode';" You'll need to replace root with whatever username has superuser permissions on your server (but, it's usually just root).…

Vim Cheat Sheet

Global :help keyword - open help for keyword:saveas file - save file as:close - close current paneK - open man page for word under the cursor Cursor movement h - move cursor leftj - move cursor downk - move cursor upl - move cursor rightH - move to top of screenM - move to middle of screenL - move to bottom of screenw - jump forwards to the start of a wordW - jump forwards to the start…

Set-Up Master-Slave Replication for PostgreSQL 9.6 on Ubuntu 16.04

What we will do: Install PostgreSQL 9.6.Configure MASTER Server.Configure SLAVE Server.Copy PostgreSQL Data from MASTER to SLAVE.Testing. Prerequisite: 1 Ubuntu 16.04 serverMASTER - Allowing Read and Write - IP: 10.0.15.101 Ubuntu 16.04 serverSLAVE - Only Read - IP: 10.0.15.11Root Privileges Step 1 - Install PostgreSQL 9.6 In this tutorial, we will install…
1 2 3 22