Skip to content

Instantly share code, notes, and snippets.

🏠
Working from home

Otienoh Otienoh

🏠
Working from home
Block or report user

Report or block Otienoh

Hide content and notifications from this user.

Learn more about blocking users

Contact Support about this user’s behavior.

Learn more about reporting abuse

Report abuse
View GitHub Profile
View mysql5_7_replication.md

How To Set Up Database Replication In MySQL

About MySQL replication

This tutorial describes how to set up database replication in MySQL. MySQL replication allows you to have an exact copy of a database from a master server on another server (slave), and all updates to the database on the master server are immediately replicated to the database on the slave server so that both databases are in sync. This is not a backup policy because an accidentally issued DELETE command will also be carried out on the slave; but replication can help in othe situations

  1. protect against hardware failures as part of your database failover strategy.
  2. Reducing load on production master server by running expensive report queries on the slave server. In these setup, you should only allow accept write queries on the master server, other wise those changes made on a specific slave server won't be replicated across all instances of replication servers.

MySQL Server setup

Consider a very simple example of mysql replicatio

@Otienoh
Otienoh / PhpStorm Keyboard Shortcuts.md
Created Apr 23, 2017 — forked from koomai/PhpStorm Keyboard Shortcuts.md
Frequently Used PhpStorm Keyboard Shortcuts
View PhpStorm Keyboard Shortcuts.md

Note: Some of these shortcuts have been remapped for my own convenience (Preferences->Keymap). These are Mac shortcuts, just use the Windows/Linux equivalent of the Cmd/Option/Ctrl/Del keys.

####Search, Go to, Navigation ####

Cmd + P - Search file

Cmd + Shift + O - Search everywhere

(I swapped the above two recently because I use Cmd + P to search for files most of the time).

@Otienoh
Otienoh / ubuntu-server-setup-16.04-LAMP.md
Last active Oct 5, 2019
LAMP Server setup for Ubuntu 16.04 on Digital Ocean
View ubuntu-server-setup-16.04-LAMP.md

Server setup for Ubuntu 16.04 on Digital Ocean

The setup installs the following software:

The setup installs the following software:

  • Apache
  • MySQL
  • PHP
  • Node
@Otienoh
Otienoh / README.md
Created Nov 23, 2015 — forked from hofmannsven/README.md
My simply MySQL Command Line Cheatsheet
You can’t perform that action at this time.