Distributed Database - ArangoDB Cluster Setup

data.aql

// 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

script.sh

# 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 }

• Demo: https://youtu.be/v5K0ueF6Acg?si=CZEhvIh8nyKNmW6S
• Report: https://drive.google.com/file/d/17E6MVDAHyEPAcQwF9oiYVrlLYdgBC4Ot/view?usp=sharing