Created
March 27, 2024 14:49
-
-
Save 18520339/fe8dce2b9a97c353be0c598358d79878 to your computer and use it in GitHub Desktop.
Distributed Database - ArangoDB Cluster Setup
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
// INSERT HOADON | |
FOR hoadon in [ | |
{MAHD: "HD01", KHACHHANG: "Nguyen Duc Tri", SDT: "0937859594", DIACHI: "Ap 3,Tan Thanh, Thu Thua, Long An", MANV: "NV04"}, | |
{MAHD: "HD02", KHACHHANG: "Nguyen Hoang Nhan", SDT: "028347852", DIACHI: "Tan Mai, Bien Hoa, Dong Nai", MANV: "NV03"}, | |
{MAHD: "HD03", KHACHHANG: "Dang Hoang Quan", SDT: "036845271", DIACHI: "Phuong 15, Tan Binh, TP.HCM", MANV: "NV04"}, | |
{MAHD: "HD04", KHACHHANG: "Nguyen Duc Tri", SDT: "0937859594", DIACHI: "Ap 3,Tan Thanh, Thu Thua, Long An", MANV: "NV03"} | |
] INSERT hoadon INTO HOADON | |
// INSERT NHANVIEN | |
FOR nhanvien IN [ | |
{MANV: "NV01", TENNV: "Pham Phu Phuoc", CHUCVU: "Quan li"}, | |
{MANV: "NV02", TENNV: "Nguyen Thi B", CHUCVU: "Ke toan"}, | |
{MANV: "NV03", TENNV: "Tran Van A", CHUCVU: "Van chuyen"}, | |
{MANV: "NV04", TENNV: "Tran Van B", CHUCVU: "Van chuyen"} | |
] INSERT nhanvien INTO NHANVIEN | |
// INSERT CTHD | |
FOR cthd IN [ | |
{MAHD: "HD01", MASP: "CAT", SOLUONG: 20, THANHTIEN: 2800000}, | |
{MAHD: "HD01", MASP: "DA", SOLUONG: 10, THANHTIEN: 2300000}, | |
{MAHD: "HD02", MASP: "XM", SOLUONG: 30, THANHTIEN: 2220000}, | |
{MAHD: "HD03", MASP: "CAT", SOLUONG: 10, THANHTIEN: 1400000} | |
] INSERT cthd INTO CTHD | |
// INSERT SANPHAM | |
FOR sanpham IN [ | |
{MASP: "CAT", TENSP: "Cat", Gia: 140000, SL: 10000}, | |
{MASP: "DA", TENSP: "Da", Gia: 230000, SL: 200000}, | |
{MASP: "XM", TENSP: "Xi mang", Gia: 74000, SL: 5000} | |
] INSERT sanpham INTO SANPHAM |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
# Change IP | |
Windows 10: | |
cd /c/Program\ Files/ArangoDB3e\ 3.7.11/etc/arangodb3 | |
sed -i 's/127.0.0.1/192.168.1.3/g' * | |
cat arangosh.conf | |
Windows 7: | |
cd /c/Program\ Files/ArangoDB3e\ 3.7.12/etc/arangodb3 | |
sed -i 's/127.0.0.1/192.168.1.6/g' * | |
cat arangosh.conf | |
Ubuntu: | |
cd /etc/arangodb3 | |
sudo sed -i 's/127.0.0.1/192.168.1.14/g' * | |
cat arangosh.conf | |
# Cluster | |
arangodb \ | |
--server.storage-engine=rocksdb \ | |
--starter.data-dir=data \ | |
--starter.join 192.168.1.3,192.168.1.6,192.168.1.14 | |
FOR doc IN CTHD | |
COLLECT group = doc.MAHD | |
AGGREGATE s = SUM(doc.THANHTIEN) | |
RETURN { group, s } |
Author
18520339
commented
Mar 27, 2024
•
- Demo: https://youtu.be/v5K0ueF6Acg?si=CZEhvIh8nyKNmW6S
- Report: https://drive.google.com/file/d/17E6MVDAHyEPAcQwF9oiYVrlLYdgBC4Ot/view?usp=sharing
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment