Replication Database Master to Master ("Toko Online") - Tugas Akhir Praktikum Distributed Database

Описание: Nama Anggota:
1. Fazel Fadhurrahman Raihan (065123191)
2. Azwariza Jandwika Putra Abdullah (065123206)

Timestamp
0:00 - 0:30 Pembukaan
0:32 - 0:47 Mematikan Firewall
0:49 - 1:03 Menyalakan WiFi, Apache, dan MySQL
1:09 - 1:19 Pengecekan IP Address
1:20 - 1:29 Test Ping ke IP Address nya Laptop 2
1:30 - 1:39 Masuk ke MariaDB
1:40 - 2:07 Pengecekan notepad my.ini
2:13 - 2:17 Proses Stop Slave
2:20 - 2:37 Membuat User untuk Laptop 2
2:40 - 3:03 Grant Replication
3:08 - 3:11 Flush Privileges
3:13 - 3:18 Flush Tables With Read Lock
3:30 - 3:34 Unlock Tables
3:35 - 3:38 Flush Logs
3:40 - 3:42 Show Master Status
3:57 - 5:06 Membuat User untuk Laptop 1
5:09 - 6:06 Grant Replication
6:18 - 6:28 Flush Privileges
6:31 - 6:57 Flush Table With Read Lock
7:02 - 7:10 Unlock Tables
7:12 - 7:22 Show Master Status
7:31 - 9:37 Change Master To (Laptop 2 ke Laptop 1)
9:42 - 9:49 Start Slave
9:53 - 10:31 Show Slave Status
10:33 - 10:44 Show Databases
10:47 - 12:10 Change Master To (Laptop 1 ke Laptop 2)
12:11 - 12:13 Start Slave
12:16 - 12:38 Show Slave Status
12:45 - 12:52 Show Databases
12:54 - 13:19 Masuk ke phpMyAdmin
13:23 - 13:36 Masuk ke Database
13:38 - 14:01 Pengecekan antar Tabel
14:04 - 17:15 Buat Query Trigger
17:24 - 17:31 Output Tabel dari Trigger
17:42 - 19:36 Buat Query Group By
19:38 - 19:55 Output Tabel dari Group By
20:51 - 20:56 Buat Query Inner Join
20:57 - 21:08 Output Tabel Inner Join
21:34 - 21:46 Buat Query Cross Join
21:49 - 21:52 Output Tabel Cross Join
22:05 - 22:11 Buat Query Full Join
22:13 - 22:42 Output Tabel Full Join
22:43 - 22:45 Penutup