×××Ö·× × ×Öž××¢× ××× ××¢× ×ס ך×Öž×שק×Öž××, ××× ××× ×עך ××××€ÖŒ× ×€×× ×××××××××š× ×Ö·× ××××ק××× × ××× ×× ××Ö·××× ×€×֞ך×סעך×××סע ×€×ך××¢ ××× ×× ×€ÖŒ×š×Öž×××§× ××Ö·× ×©×Ö·×€Ö¿×
×עך ×ַך×××§× ××× ××¢×××¢× ×Š×××¢×ך××× ×××××š× ××××£ ×Ö· ךע××¢ ×××Ö·
×עך ×ַך×××§× ×××¢× ××Öž×× ×ך×× ×××××:
- ××× ×Š× ××Ö·×××Öž×š×¢× ×¢× ×§×Ö·× ×¢×§×©×Ö·× ×.
- ×××֞ס ××× ×Ö· ק×Öž× ×ך×Öž×××š× ×€×× ×ַקש×Ö·× × ××× ××× ×Š× ×š×¢×§×֞ך×××š× ×××֞ס ××× ××¢×©×¢×¢× ×ש ××××£ ×× ××Ö·××Ö·×××ס ×××Ö·× ××× ×§×Ö·× ×¢×§××× × ×Š× ×¢×¡.
- ××× ×Š× ××ַש××Š× ××Ö·×× ××× ×× ××Ö·××Ö·×××ס ××× ××× ×××֞ס ××¢×§× ×Ö·××Ö·××ש×× ××¢× ×¢× ×× ×××Š× ×€Ö¿×ַך ××¢×.
×ך×× ×§×Ö·××€ÖŒ×Öž×× ×Ö·× ×¥ ×€×× DBMS ×××עך××××: קשך ש××¥, ××¢××ק××× ×Ö·××Ö·××× × ××× ××Ö·×× ×©××¥
ס×ק××ך×× × ×××× ×§×Ö·× ×¢×§×©×Ö·× ×
××ך ×§×¢× ×¢× ×€×ַך××× ×× ×Š× ×× ××Ö·××Ö·×××ס ×Öž×עך ××××Ö·× ×Öž×עך ××× ×ַ׊×Ö·× ×××š× ×××¢× ×Ö·×€ÖŒ××ַק××ש×Ö·× ×. ××× ×Ö· ×עךש×, ×עך ××¢×©×¢×€× ××Ö·× ×׊עך, ××֞ס ××× ×עך ××¢× ×ש ×××֞ס ×ַך××¢× ××× ×× DBMS, ×× ×עך×ַקץ ××× ××× ××× ×ַ׊×Ö·×.
××××עך ××ך ךע×× ×××¢×× ×€ÖŒ×š×Ö·×עק××× × ×§×Ö·× ×¢×§×©×Ö·× ×, ××ך ××Ö·×š×€Ö¿× ×Š× ×¢× ××€Ö¿×¢×š× ××××××ק ׀ֿך××× ×××֞ס ××ַש×××¡× ××× ×××עך×××× ×××××¢× ×××¢× ×××× ×¡×ך×ַק×שעך×:
- ××× ×××× ××¢×©×¢×€× ××Ö·× ×׊עך עק××××××Ö·××¢× × ×Š× ×××× DBMS ××Ö·× ×׊עך?
- ×Š× ×ַקסעס ×Š× DBMS ××Ö·×× ××× ×Š××עש××¢×× ××××× ×××š× ×Ö·× ×Ö·×€ÖŒ× ×Ö·× ××ך ק×Öž× ×ך×Öž×, ×Öž×עך ×Š× ×××©× ××¢× ×¢× ×Ö·×§×¡×¢×¡× ××××Ö·×;
- ×Š× ×× DBMS ××× ×Ö·××ַק××××× ×Š× ×Ö· ××Ö·××× ×עך ׀֌ך×Öž×עק××¢× ×¡×¢×××¢× ×, ××עך ×× ×עך×ַקץ ××× ××× ××× ×××;
- ×Š× ×€ÖŒ×Öž×Öž××× × / ׀֌ך×Ö·×§×¡× ××× ×× ×עך×××××× ×××ַעךס ××¢× ×¢× ××¢× ×׊×, ×××֞ס ×§×¢× ×¢× ××××©× ××× ×€Ö¿×֞ך××ַ׊××¢ ×××¢×× ××× ×× ×§×©×š ××× ××¢×××× ××× ××עך ××× × ××Š× ×× ××Ö·××Ö·×××ס.
×××Š× ××Öž×× ××× ×× ××¢× ×××֞ס ××ש×ך×× ×§×¢× ×¢× ×××× ××¢××××× × ×Š× ××Ö·×××Öž×š×¢× ×¢× ×§×Ö·× ×¢×§×©×Ö·× ×:
- × ××Š× ×××××Ö·×××ס ×€××ך×××Ö·× ×§××ַס ס×Ö·××ש×Ö·× ×. ×Ö·× × ×Öž× ×©××××¢ ×€×× ââש××¥ ×××¢×, ×××Ö· ×Ö· ××× ××××, ×€×ַך××š×¢×¡×¢×š× ×× ××ך×××¢×ק××Ö·× ×€×× ×××֞ס ××× ××¢×©×¢×¢× ×ש ××× ×× DBMS, ××× ××× ××ַקס××××, ××ך ×××¢× ×§×¢× ×¢× ×Š× ×Š×ש××¢×× × ×Öž× ××Ö·×× ×©××¥.
- × ××Š× ×€ÖŒ×ַך×Öž× ×€ÖŒ×Ö·××ַס××. ×××עך × ××Š× ××¢×€ÖŒ×¢× ×ס ××××£ ××× ×××× ×ַךק×Ö·×עק×שעך ××× ××¢××××. ××× ×§××× ×€×Ö·×, ×××× ×€ÖŒ×ַך×Öž× ××× ×× ×§×Ö·× ×€×××עך××ש×Ö·× ×עקע ×€×× ââ×Ö· ×××¢× ×Ö·×€ÖŒ××ַק××ש×Ö·× ×××֞ס ק×Ö·× ×¢×§×¥ ×Š× ×× DBMS ××× × ××©× ××¢× ×× ×€Ö¿×ַך ש××¥. עס ××¢× ×¢× ×Ö· × ××עך ×€×× DBMS ××ש×ך×× ×××֞ס ××Öž×× ××ך ×Š× ×§×Öž× ×ך×Öž×××š× ×Ö·× ×עך ××Ö·× ×׊עך ××× ×€ÖŒ×ַך×Öž× ××Ö·×š×€× ×Ö·×€ÖŒ×××××× ×.
××ך ×§×¢× ×¢× ××××¢× ×¢× ×עך ×××¢×× ××Ö·× ×׊עך ש×Ö·×¥ ×€×Ö·× ×קש×Ö·× ×
××Öž ××ך ×§×¢× × ×××× ××¢×€Ö¿×× ×¢× ××× ×××¢×× MS SQL ×××Ö·×× ×¢×š×Ö·×××××× ×ַססעסס××¢×××Öž . - ××ַך××Ö·××¢×š× ××¢× ×§×Öž× ××¢×§×¡× ×€×× ×× ×¡×¢×¡××¢ ××× ×× × ××××ק ××× ×€Ö¿×֞ך××ַ׊××¢. ×××× ×× ×¡×¢×¡××¢ ××× ×Öž××€ÖŒ××ק, ××ך ××Öž× × ×× ×€Ö¿×ַךש×××× ××עך עס ×ַך××¢× ××× ×× DBMS ××× ×××× ×€×š×××××עךק, ××ך ×§×¢× ×¢×, ××× ×× ×€×š×××××עךק ×€×× ×× ×֞׀֌עך×ַ׊××¢ ×××֞ס ××× ××ך××עק×Öž××, ××××× ××× ×€Ö¿×֞ך××ַ׊××¢ ×××¢×× ×××֞ס ××× ×××֞ס ××× ×××֞ס. ×× ××× ×€Ö¿×֞ך××ַ׊××¢ ×§×¢× ×¢× ×××× ××¢××¢× ××× ×× ×§×Öž× ×ך×Öž××ך×.
- ק×Ö·× ×€×××עך ×¡×¡× ×××× ××ך ××Öž× × ×× ××Öž×× ×Ö· × ×¢×¥ ׊עש××××× × ×Š××××©× ×× DBMS ××× ×¡××£ × ×׊עךס; עס ××× × ××©× ××× ×Ö· ××Ö·××× ×עך ××××Ö·×. ××× ×Ö·××Ö· ק×ַסעס, עס ××× ××׀֌עך×Ö·×××× ×Š× ××ַש××Š× ×× ×§×Ö·× ×Ö·× ×Š××××©× ×× ×§×Ö·× ×¡××עך ××× ×× DBMS ×××. ×××עך×××× ××ש×ך×× ××¢× ×¢× ×××× ×× ×××Š× ××× ×Öž×€Ö¿× ×ק×ך.
××× ×××¢× ××֞ס ××××š×§× ×× ×€×֞ךש××¢××× × ×€×× ×× DBMS?
××Öž××ך ק××§× ××× ××¢× ×××ש׀֌×× ×€×× PostgreSQL ×Š× ××¢× ××× SSL ×ַ׀עקץ ×× ×§×€ÖŒ× ××ַסע, ×× ×§×š×ס×× ×××××× ×× ××× ××קך×ס×Ö·× ×׀֌ס, ××× ×Š× ×¢×¡ ×××¢× ×€×Ö·×š× ××Š× ×Š× ×€×××¢ ךעס××š×¡× ×××× ××ך ××¢×× ×¢×¡.
××Öž×××× × PostgreSQL × ××Š× pgbench ××× ×Ö· ׀֌ש×× ×€ÖŒ×š×Öž×ך×Ö·× ×€Ö¿×ַך ×€×××¡× ××ק ×€×֞ךש××¢××× × ×עסץ. עס עקס×ַק×××¥ ך××€ÖŒ×××××× ×Ö· ×××× ×¡×ק×××Ö·× ×¡ ×€×× ×§×Ö·××Ö·× ××, ע׀שעך ××× ×€ÖŒ×ַך×Ö·××¢× ××Ö·××Ö·×××ס סעש×Ö·× ×, ××× ××¢××Öž×× ×§×Ö·×ק××Ö·××××¥ ×× ××ך××©× ××××¢× ×ך×Ö·× ×¡×ַק×××Öž× ×§×ךס.
××¢×¡× 1 ×Öž× ×¡×¡× ××× × ××Š× ×¡×¡× - ×× ×§×©×š ××× ××¢×ך×× ××¢× ×€Ö¿×ַך ××¢×עך ×ך×Ö·× ×¡×ַק×××Öž×:
pgbench.exe --connect -c 10 -t 5000 "host=192.168.220.129 dbname=taskdb user=postgres sslmode=require
sslrootcert=rootCA.crt sslcert=client.crt sslkey=client.key"
vs
pgbench.exe --connect -c 10 -t 5000 "host=192.168.220.129 dbname=taskdb user=postgres"
××¢×¡× 2 ×Öž× ×¡×¡× ××× × ××Š× ×¡×¡× - ×Ö·××¢ ×ך×Ö·× ××ַקש×Ö·× × ××¢× ×¢× ××ך××עק×Öž×× ××× ×××× ×§×©×š:
pgbench.exe -c 10 -t 5000 "host=192.168.220.129 dbname=taskdb user=postgres sslmode=require
sslrootcert=rootCA.crt sslcert=client.crt sslkey=client.key"
vs
pgbench.exe -c 10 -t 5000 "host=192.168.220.129 dbname=taskdb user=postgres"
×× ×עךע סע×××× ×ס:
scaling factor: 1
query mode: simple
number of clients: 10
number of threads: 1
number of transactions per client: 5000
number of transactions actually processed: 50000/50000
××¢×¡× ×š×¢×××××××:
ק××× SSL
סס×
× ×§×©×š ××× ××¢×ך×× ××¢× ×€Ö¿×ַך ××¢×עך ×ך×Ö·× ×¡×ַק×××Öž×
×××××Ö·× ×¡× ××ך××©× ××××¢×
×§×¡× ××קס ×ס
×§×¡× ××קס ×ס
×׀֌ס ×ַך××Ö·× ×עךע×× × ×§×Ö·× ×¢×§×©×Ö·× × ×ך×× ××
58.168112
53.278062
×׀֌ס עקסק××××× × ×§×Ö·× ×¢×§×©×Ö·× × ×ך×× ××
64.084546
58.725846
ק׀֌×
×§×¡× ××קס%
×§×¡× ××קס%
×× ×ך×Ö·× ××ַקש×Ö·× × ××¢× ×¢× ××ך××עק×Öž×× ××× ×××× ×§×©×š
×××××Ö·× ×¡× ××ך××©× ××××¢×
×§×¡× ××קס ×ס
×§×¡× ××קס ×ס
×׀֌ס ×ַך××Ö·× ×עךע×× × ×§×Ö·× ×¢×§×©×Ö·× × ×ך×× ××
1587.657278
1576.792883
×׀֌ס עקסק××××× × ×§×Ö·× ×¢×§×©×Ö·× × ×ך×× ××
1588.380574
1577.694766
ק׀֌×
×§×¡× ××קס%
×§×¡× ××קס%
××× ×××× ××Öž×××, ×× ××©×€ÖŒ×¢× ×€×× SSL ××× ×€×ַך××××Ö·×××¢× ××× ×× ××¢×שעך××Ö·× × ××¢×ת. ×××× ×× ×¡×××¢ ×€×× ââ×ך×Ö·× ×¡×€×¢×š× ××Ö·×× ××× ×××עך ×ך××ס, ×× ×¡××××ַ׊××¢ ×§×¢× ×××× ×Ö·× ×עךש. ×××× ××ך ×€×ַך××××× ×××× ×§×©×š ׀֌עך ×ך×Ö·× ×¡×ַק×××Öž× (××֞ס ××× ××¢×××, ×××ש×Ö·×××Ö·×× ×× ×§×©×š ××× ×©×¢×š× ×Š××××©× ×××עך×), ××ך ××Öž×× ×Ö· ×ך××ס × ××עך ×€×× ×§×Ö·× ×¢×§×©×Ö·× × / ××סק×Ö·× ×¢×§×©×Ö·× ×, ×× ×€ÖŒ×š×Ö·× ×§×¢× ×××× ×Ö· ×××¡× ×ךעסעךע. ×Ö·× ×××, עס ×§×¢× ×××× ×š×סקס ×€×× ××קך××¡× ×€×֞ךש××¢××× ×, ×Öž×עך, ×× ××××ק ××× × ××©× ×Ö·××× ×ך××ס ××× × ××©× ×Š× × ××Š× ×©××¥.
××××¢ ××Öž× ×Ö·× ×¢×¡ ××× ×Ö· ש××ַךק ××××ק ×××× ××ך ×€×ַך××××Ö·×× ×× ×֞׀֌עך××××× × ××Öž×עס: ××ך ×ַך××¢× ××× ×עך ××¢×××קעך סעס××¢ ×Öž×עך ××× ×€×ַךש×××¢× ×¢ ×Öž× ×¢×¡. ××֞ס ××× ×€×ַךש××××ק: ךעס××š×¡× ××¢× ×¢× ×€×ך×ך××× ×Š× ×©×Ö·×€Ö¿× ××¢×עך קשך.
××ך ××Öž×× ×Ö· ×€×Ö·× ×××¢× ××ך ק×Öž× × ×¢×§××¢× Zabbix ××× ×Š××ך×× ××Öž××¢, ××֞ס ×××, md5 ××× × ××©× ×Öž×€ÖŒ×עש××¢××, עס ××× × ×× ××Ö·×š×€Ö¿× ×€Ö¿×ַך ×Öž××¢× ××ַק××ש×Ö·×. ××¢×š× ×Öž× ×עך ק×× × ××¢××¢×× ×Š× ××¢×× md5 ×Öž××¢× ××ַק××ש×Ö·× ××Öž××¢. ××֞ס ××Öž× ×עש××¢×× ×Ö· ש××עך ××ַסע ××××£ ×× ×§×€ÖŒ×, ××× ×€×֞ךש××¢××× × ×ך×Ö·×€ÖŒ×. ××ך ×× ××¢××××× ×Š× ×§××§× ×€Ö¿×ַך ×××¢×× ×Š× ×Ö·×€ÖŒ××Ö·××××. ×××× ×¢×š ×€×× ×× ××¢×××¢× ×¡×Ö·××ש×Ö·× × ×Š× ××¢× ×€ÖŒ×š×Öž×××¢× ××× ×Š× ×× ×¡×ך×××¢× × × ×¢×¥ ך×ס×ך×קש×Ö·× ×, ××Ö·×× ××Ö·××× ×עך ××××Ö·× × ×€Ö¿×ַך ×× DBMS, ××××× ×¡×¢×××× ×ס ×Š× ××Ö·×× ×¢×¡ ק××֞ך ××עך ××× ×§×Ö·× ×¢×§××× × ×€×× ××× ××× ××Ö·×××Ö·×××§× ×Öž××¢× ××ַק××ש×Ö·×. ××× ×Ö·×××¢×××× ×× × ××Š× ×€×× ×€×ַךש×××¢× ×¢ ××¢×××Öž×ס ×Öž××¢× ××ַק××ש×Ö·× ×ַ׀עקץ ×€×֞ךש××¢××× × ××× ×š×ק×××××¢×š× ××¢× ×××¢× ×× ×¡×××ת ××× ×ש××× ×××¢× ×××××× ×× × ×× ×§×Ö·××€ÖŒ××××× × ××Ö·×× ×€×× ×¡×¢×š××עךס (××ַך××××ַךע) ×€Ö¿×ַך ×× DBMS.
××¡×§× ×: ××× ×Ö· × ××עך ×€×× ×¡×Ö·××ש×Ö·× ×, ××€××× ×§×××× × ××Ö·× ×¡×× ××× ×Öž××¢× ××ַק××ש×Ö·× ×§×¢× ×¢× ×××עך ××××š×§× ×× ×€ÖŒ×š×××¢×§× ××× ×¢×¡ ××× ×©××¢×× ×××¢× ××֞ס ××× ×§××֞ך ××××× ×××¢× ×××€ÖŒ××Ö·××¢× ×Ö·× ××× ×€ÖŒ×š×Öž××ק׊××¢.
ק×Ö·××£ ק×Öž× ×ך×Öž××ך×
ק×Öž× ×ך×Öž×××š× ×§×¢× ×¢× ×××× × ×× ××××× DBMS. ×Ö· ק×Öž× ×ך×Öž×××š× ××× ×××¢×× ×§×š××× ××× ×€Ö¿×֞ך××ַ׊××¢ ×××¢×× ×××֞ס ××× ××¢×©×¢×¢× ×ש ××× ×€×ַךש×××¢× ×¢ סע×××Ö·× ×¥. ××֞ס ×§×¢× ×××× ×Ö· ××Ö·××Ö·×××ס ×€××ך×××Ö·× ×Öž×עך ×× ×֞׀֌עך××××× × ×¡×ס××¢× ××××£ ×××֞ס ×× DBMS ××× ××¢××××.
××× ××¢×©×¢×€× ×¢× ×עך׀֌ך××× ××ך×× DBMSs ×Ö·××¥ ××× ××× ××× ×Ö·××Ö·××× ×, ×Öž×עך ××× ×Öž×€Ö¿× ×ק×ך - × ×× ×©××¢× ××ק. ××Öž ס ×××֞ס PostgreSQL ×××:
- ×€×¢××ק××Ö·× ×§××Öž×¥ - ××¢××××-××× ××Öž××× ×;
- ×קס××¢× ×©×Ö·× ×: pgaudit - ×××× ×€×¢××ק××Ö·× ××Öž××× × ××× × ××©× ××¢× ×× ×€Ö¿×ַך ××ך, ××ך ×§×¢× ×¢× × ××Š× ××Ö·××× ×עך סע×××× ×ס ×××֞ס ס×Öž××××¢ ×¢×××¢××¢ ׀֌ך×Öž×××¢×ס.
×Ö·××ש×Ö·× ×Š× ×× ××ַך××× ××× ×× ×××××¢×:
"××ַס×ק ס××Ö·××¢××¢× × ××Öž××× × ×§×¢× ×¢× ×××× ×Š××עש××¢×× ×××š× ×Ö· × ×֞ך××Ö·× ××Öž××× × ××¢××ךעס ××× log_statement = all.
××֞ס ××× ×€ÖŒ×ַס×ק ×€Ö¿×ַך ××Öž× ×××֞ך×× × ××× ×× ×עךע × ×׊×, ×Öž×עך ××× × ××©× ×Š×ש××¢×× ×× ××ך×× ×€×× ××¢××Ö·× ×××€ÖŒ×ק×× ×€×ך××× ×× ×€Ö¿×ַך ×Ö·××Ö·××× ×.
עס ××× × ××©× ××¢× ×× ×Š× ××Öž×× ×Ö· ךש××× ×€×× ×Ö·××¢ ×× ×ַ׀֌עך××ש×Ö·× × ××¢××× ××××£ ×× ××Ö·××Ö·×××ס.
עס ××Öž× ×××× ×××× ××¢×××¢× ×Š× ××¢×€Ö¿×× ×¢× ×¡×€ÖŒ×¢×Š××€×ש ס××××××Ö·× ×¥ ×××֞ס ××¢× ×¢× ×€×× ××× ×עךעס ×Š× ×× ×Ö·××Ö·×עך.
× ×֞ך××Ö·× ××Öž××× × ×××××× ×××֞ס ×עך ××Ö·× ×׊עך ××¢××¢××, ×שעת pgAudit ×€×Öž×ק×ס×× ××××£ ×× ××¢××Ö·××ס ×€×× ×××֞ס ××¢×ך××€× ×××¢× ×× ××Ö·××Ö·×××ס עקס×ַק××××Ö·× ×× ×Öž× ×€Ö¿×š×¢×.
×€Ö¿×ַך ×××ַש׀֌××, ×עך ×Öž××××֞ך ××× ×××¢×× ×Š× ××ַש××¢×××§× ×Ö·× ×Ö· ××Ö·××× ×עך ××ש ××× ××ש××€× ××× ×Ö· ××ַק××××¢× ××Ö·× ××ש×Ö·×× ×€Ö¿×¢× ×Š×עך.
××֞ס ×§×¢× ××סק×××¢× ××× ×Ö· ׀֌ש×× ×ַך××¢× ××× ×קעך××ק ×Ö·××Ö·××× × ××× ×ךע׀֌, ×Öž×עך ×××֞ס ×××× ××ך ××Öž× ×עך××× ×× ×¢×€ÖŒ×¢×¡ ××× ××¢× (×עק×××× ×§×Ö·× ×€××××× ×) ×××ַש׀֌××:
DO$$
BEGIN
EXECUTE 'CREATE TABLE ×××€ÖŒ×֞ך×' || '×Ö·× ×_××Ö·×××¢ (ש××Ö·× ×× ×)';
END$$;
× ×֞ך××Ö·× ××Öž××× × ×××¢× ××¢×× ××ך ××¢×:
××Öž×: ×עךק×עך×× ×: ××Öž× $$
BEGIN
EXECUTE 'CREATE TABLE ×××€ÖŒ×֞ך×' || '×Ö·× ×_××Ö·×××¢ (ש××Ö·× ×× ×)';
END$$;
עס ×××ס ×Ö·× ×עך××××× × ×× ××ש ×€×× ××× ×עךעס ×§×¢× ××Ö·×š×€× ×¢×××¢××¢ ק×Öž× ××××¡× ××× ×§×ַסעס ××× ×××©× ××¢× ×¢× ××ש××€× ××× ×Ö·××ק×Ö·×××.
××֞ס ××× × ××©× ×××¢×Ö·×, ××××Ö·× ×¢×¡ ×××Öž×× ×××× ××××עך ×Š× × ×֞ך ×××× ×××š× ××ש × ×Öž××¢×.
××֞ס ××× ××× pgAudit ק××× ××× ××Ö·× ××ק.
×€Ö¿×ַך ×עך ××¢×××קעך ×ַך××Ö·× ×©×š××Ö·×, עס ×××¢× ×€ÖŒ×š×Öž××׊××š× ××¢× ×š×¢×××××Ö·× ××× ×× ×§××Öž×¥:
ק×Öž× ×ך×Öž××ך×: סעס××¢,33,1,×€×× ×§×Š××¢,××Öž×,,,"××Öž× $$
BEGIN
EXECUTE 'CREATE TABLE ×××€ÖŒ×֞ך×' || '×Ö·× ×_××Ö·×××¢ (ש××Ö·× ×× ×)';
END$$;"
ק×Öž× ×ך×Öž××ך×: SESSION,33,2,DDL,CREATE TABLE,TABLE,public.important_table,CREATE TABLE important_table (ID INT)
× ×× ××××× ×× DO ×××֞ק ××× ××Öž××, ×Öž×עך ×××× ×× ×€×× ××¢×§×¡× ×€×× ×× CREATE TABLE ××× ××ס××Öž××× × ×××€ÖŒ, ××××€×¢×¥ ×××€ÖŒ ××× ×€×× × ×Öž××¢×, ×××× ×××× ×ך×× ×עך.
×××¢× ××Öž××× × SELECT ××× DML ס××××××Ö·× ×¥, pgAudit ×§×¢× ×¢× ×××× ×§×Ö·× ×€××××¢×š× ×Š× ×§××Öž×¥ ×Ö· ××Ö·××× ×עך ×€ÖŒ×Öž××׊××¢ ×€Ö¿×ַך ××¢×עך ש××××ת ×š×¢×€×¢×š×¢× ×¡× ××× ×× ×עךק×עך×× ×.
ק××× ×€ÖŒ×ַךס×× × ××× ×€×ך××× ×× ×Š× ××¢×€Ö¿×× ×¢× ×Ö·××¢ ס××××××Ö·× ×¥ ×××֞ס ×€×ַך××× ×× ×Ö· ××Ö·××× ×עך ××ש (
××× ×××¢× ××֞ס ××××š×§× ×× ×€×֞ךש××¢××× × ×€×× ×× DBMS?
××Öž××ך ××××€× ×עסץ ××× ×€×× ×Ö·××Ö·××× × ×¢× ××××Ö·×× ××× ××¢× ×××֞ס ××Ö·×€ÖŒ×Ö·× × ××× PostgreSQL ×€×֞ךש××¢××× ×. ××× ×¡ ××¢×× ××ַקס×××× ××Ö·××Ö·×××ס ××Öž××× × ×€Ö¿×ַך ×Ö·××¢ ×€ÖŒ×ַך×Ö·××¢×עךס.
××ך ××××©× ×ÖŒ××¢× ××Öž×š× ××©× ××× ×× ×§×Ö·× ×€×××עך××ש×Ö·× ×עקע, ×× ××¢×š×¡× ××××××ק ××Ö·× ××× ×Š× ×§×¢×š ××××£ ×× ××¢××× 5 ××Öž××¢ ×Š× ××ַק×××¢× ××ַקס×××× ××× ×€Ö¿×֞ך××ַ׊××¢.
postgresql.conf
log_destination = 'ס××עךך'
logging_collector = ××××£
log_truncate_on_rotation = ××××£
××Öž×_ך×Öž××Ö·×××Öž×_×Ö·××¢ = 1×
log_rotation_size = 10MB
log_min_messages = debug5
log_min_error_statement = debug5
log_min_duration_statement = 0
debug_print_parse = ××××£
debug_print_rewritten = ××××£
debug_print_plan = ××××£
debug_pretty_print = ××××£
log_checkpoints = ××××£
log_connections = ××××£
log_disconnections = ××××£
log_duration = ××××£
××Öž×_××֞ס×× ×Ö·××¢ = ××××£
log_lock_wait = ××××£
log_replication_commands = ××××£
log_temp_files = 0
log_timezone = '×××ך×֞׀֌ע/××֞סק×××¢'
××××£ ×Ö· PostgreSQL DBMS ××× ×€ÖŒ×ַך×Ö·××¢×עךס ×€×× 1 ק׀֌×, 2,8 ×××, 2 ×××××××× ××ַך×Ö·×, 40 ×××××××× ×××, ××ך ××ך××€××š× ×ך×× ××ַסע ×עסץ ××× ×× ×§×Ö·××Ö·× ××:
$ pgbench -p 3389 -U postgres -i -s 150 benchmark
$ pgbench -p 3389 -U postgres -c 50 -j 2 -P 60 -T 600 benchmark
$ pgbench -p 3389 -U postgres -c 150 -j 2 -P 60 -T 600 benchmark
××¢×¡× ×š×¢×××××××:
ק××× ××Öž××× ×
××× ××Öž××× ×
××Ö·× ×¥ ×××××Ö·×××ס ×€×××× × ×Š××Ö·×
43,74 sec
53,23 sec
××ַך×Ö·×
×§×¡× ××קס%
×§×¡× ××קס%
ק׀֌×
×§×¡× ××קס%
×§×¡× ××קס%
××¢×¡× 1 (50 ק×Ö·× ×¢×§×©×Ö·× ×)
× ××עך ×€×× ×ך×Ö·× ××ַקש×Ö·× × ××× 10 ××× ××
74169
32445
×ך×Ö·× ××ַקש×Ö·× × / סעק
123
54
××ך××©× ××××¢× ×××××Ö·× ×¡
405 ms
925 ms
××¢×¡× 2 (150 ק×Ö·× ×¢×§×©×Ö·× × ××× 100 ××¢×××¢×)
× ××עך ×€×× ×ך×Ö·× ××ַקש×Ö·× × ××× 10 ××× ××
81727
31429
×ך×Ö·× ××ַקש×Ö·× × / סעק
136
52
××ך××©× ××××¢× ×××××Ö·× ×¡
550 ms
1432 ms
×××¢×× ×¡××עס
DB ×ך××ס
2251 ××¢×××××××
2262 ××¢×××××××
××Ö·××Ö·××ַסע ק××Öž×¥ ×ך××ס
0 MB
4587 MB
×× ×Öž ש×ך×: ×Ö· ×€×× ×§×Öž× ×ך×Öž×××š× ××× × ××©× ×××עך ×××. ×× ××Ö·×× ×€×× ×× ×§×Öž× ×ך×Öž×××š× ×××¢× ×××× ××× ×ך××ס ××× ×× ××Ö·×× ××× ×× ××Ö·××Ö·×××ס ×××, ×Öž×עך ××€××× ×עך. ×× ×¡×××¢ ×€×× ââââ××Öž××× × ×××֞ס ××× ×××©×¢× ×¢×š××××Ö·× ×××¢× ×ך××¢×× ××× ×Ö· DBMS ××× ×Ö· ׀֌ך×Öž×¡× ×€ÖŒ×š×Öž×××¢× ××× ×€ÖŒ×š×Öž××ק׊××¢.
××× ×¡ ק×ק ××× ×× ×עךע ×€ÖŒ×ַך×Ö·××¢×עךס:
- ×× ×××ק××Ö·× ××× × ××©× ××××©× ×€××: ×Öž× ××Öž××× × - 43,74 סעק×× ×עס, ××× ××Öž××× × - 53,23 סעק×× ×עס.
- ××ַך×Ö·× ××× ×§×€ÖŒ× ×€×֞ךש××¢××× × ×××¢× ×××Ö·××, ××× ××ך ××Ö·×š×€Ö¿× ×Š× ×××©×¢× ×¢×š××× ×Ö· ק×Öž× ×ך×Öž×××š× ×עקע. ××֞ס ××× ×××× ××××¢×š×§× ××× ×€ÖŒ×š×Öž×××ַק×××××××.
××× ×× × ××עך ×€×× ×§×Ö·× ×¢×§×©×Ö·× × ×× ×§×š×ס××, ××¢××××× ×××¢×, ×× ×€×֞ךש××¢××× × ×××¢× ×€×ַךעך××¢×š× ×Ö· ××ס×.
××× ×§×֞ך׀֌עך××ש×Ö·× × ××× ×§×Öž× ×ך×Öž×××š× ×¢×¡ ××× ××€××× ×עך ש××עך:
- עס ××× ×Ö· ×€ÖŒ××Ö·×¥ ×€×× ××Ö·××;
- ×Ö·××Ö·××× × ××× ××ךף × ×× ××××× ×××š× ×¡×ס××Öž× ××× SIEM, ×Öž×עך ×××× ××× ×עקעס: ×××× ×¢×€ÖŒ×¢×¡ ××Ö·×€ÖŒ×Ö·× × ×Š× ×¡×ס××Öž×, עס ×××× ×××× ×Ö· ×עקע × ×Öž×¢× × ×Š× ×× ××Ö·××Ö·×××ס ××× ×××֞ס ×× ××Ö·×× ××¢× ×¢× ×עך×××¢×××¢×;
- ×Ö· ××Ö·××× ×עך ×€ÖŒ×Öž××׊ע ××× ××ךף ×€Ö¿×ַך ×Ö·××Ö·××× × ×Ö·××× × ××©× ×Š× ××××¡× × / ×Öž ××סקס, ××××Ö·× ×¢×¡ × ×¢×× ×Ö· ×€ÖŒ××Ö·×¥ ×€×× ×€ÖŒ××Ö·×¥;
- עס ××Ö·×€ÖŒ×Ö·× × ×Ö·× ××× ×€Ö¿×֞ך××ַ׊××¢ ×××עך×××× ×¢××€ÖŒ××××× ××Ö·×š×€Ö¿× GOST ס××Ö·× ××ַך×ס ××××¢×××, ××× ××Ö·×š×€× ×©××Ö·× ××¢××××××ַ׊××¢.
ך×ס×ך×ק××× × ×ַקסעס ×Š× ××Ö·××
××Öž××ך ק××§× ××× ×× ××¢×§× ×Ö·××Ö·××ש×× ×××֞ס ××¢× ×¢× ××¢× ××Š× ×Š× ××ַש××Š× ××Ö·×× ××× ×ַקסעס עס ××× ××¢×©×¢×€× DBMSs ××× ×Öž×€Ö¿× ×ק×ך.
×××֞ס ×§×¢× ×¢× ××ך ×××× × ×׊×:
- ×¢× ×§×š×׀֌ש×Ö·× ××× ×Ö·××€×ַסק××ש×Ö·× ×€×× ×€ÖŒ×š×Öž×ס××××©×¢×š× ××× ×€×Ö·× ×קש×Ö·× × (ך×Ö·×€ÖŒ×× ×) - ××֞ס ×××, ××Ö·××× ×עך ××ש×ך×× ××× ××××××Ö·××× ×××֞ס ××Ö·×× ×××× ×¢××××ק ק×Öž× ×Ö·× ×š×××Ö·××Ö·×. ××ת, ××¢××Öž×× ×¢×¡ ×§×¢× ×¢× × ×× ×××× ×ש××× ×××©× ××× × ×× ×š××€×ַק××¢×š× ×Š×ך×ק. ××¢× ×Š×××Ö·× × ××× ××× ×€×ך××× ×× ×××Ö· ××× ×ס×עך ××××£ ×× DBMS ×××Ö·× - ×× ××Öž××ק ×€×× ×עך×××××¢× ×ש ך×ס×ך×קש×Ö·× × ×Öž×עך ×עך×××××¢× ×ש ××Öž××ק ××× ×× ×§×š××€ÖŒ××× ×€ÖŒ×× ×§× ××× ×× ×€ÖŒ×š×֞׊ע××ך ××× ×€×× ×§×Š××¢ ××ך××.
- ××××××× × ×× ×××××Ö·×××××× ×€×× ××Ö·×× ×××š× ×š×Öž×× (RLS) ××× ×××¢× ×€×ַךש×××¢× ×¢ × ×׊עךס ××¢× ×××× ××ש, ×Öž×עך ×Ö· ×Ö·× ×עךש ××Ö·×¥ ×€×× ×š×Öž×× ××× ×¢×¡, ××֞ס ×××, ע׀֌עס ×§×¢× ×¢× × ×× ×××× ××¢××××× ×Š× ×¢×ע׊עך ××× ×× ×š×××¢×š× ××ך××.
- ×¢××××× × ×× ××¢××××× ××Ö·×× (××ַסק×× ×) ××× ×××¢× × ×׊עךס ××× ×××× ×××Ö·× ×€×× ×× ××ש ××¢× ×Öž×עך ××Ö·×× ×Öž×עך ××××× ×ַס×עך×סקס, ××֞ס ×××, ×€Ö¿×ַך ×¢×××¢××¢ ××××¢×š× ×× ××× ×€Ö¿×֞ך××ַ׊××¢ ×××¢× ×××× ×€×ך××××. ×× ××¢×× ×Öž××Öž×××¢ ×××עך××Ö·× × ×××֞ס ××Ö·× ×׊עך ××× ××¢××××× ×××֞ס ×××××š× ××××£ ×××עך ×ַקסעס ××ך××.
- ×××עך×××× ×××Ö· / ×ַ׀֌׀֌××ק×Ö·×××Öž× ×××Ö· / ×××Ö· ×ַקסעס ק×Öž× ×ך×Öž× ×××, ×××, ×××¢×× ×š×ס×ך×ק××× × ×ַקסעס ×Š× ×× DBMS ×××, ××֞ס ×××, ××× ×€Ö¿×֞ך××ַ׊××¢ ×××עך×××× ×¢××€ÖŒ××××× ×§×¢× ×¢× ×××× ××€×עש×××× ×€×× ××Ö·××Ö·×××ס ×Ö·×××× ×ס×ך×Ö·××֞ךס ××× ×Ö·×€ÖŒ××ַק××ש×Ö·× ×Ö·×××× ×ס×ך×Ö·××֞ךס. עס ××¢× ×¢× ××××× ×ק ×Ö·××Ö· ××¢×§× ×Ö·××Ö·××ש×× ××× ×Öž×€Ö¿× ×ק×ך, ×Öž×עך עס ××¢× ×¢× ×€×××¢ ×€×× ââ××× ××× ××¢×©×¢×€× DBMSs. ××× ××¢× ×¢× ××ךף ×××¢× ×¢×¡ ××¢× ×¢× ×€×××¢ × ×׊עךס ××× ×ַקסעס ×Š× ×× ×¡×¢×š××עךס ×××.
- ך×ס×ך×ק××× × ×ַקסעס ×Š× ×עקעס ××××£ ×× ×עקע ס×ס××¢× ××ך××. ××ך ×§×¢× ×¢× ××¢×× ×š×¢×× ××× ×ַקסעס ׀֌ך××××××Ö·××ש×Ö·× ×Š× ×××ךעק×עך×× ×Ö·××× ×Ö·× ××¢×עך ×Ö·×××× ×ס×ך×Ö·××֞ך ××× ×ַקסעס ××××× ×Š× ×× × ××××ק ××Ö·××.
- ××Ö·× ××Ö·××Öž×š× ×ַקסעס ××× ××ק×Öž×š× ×€ÖŒ×Öž×××Ö·× ×¢ - ×× ××¢×§× ×Ö·××Ö·××ש×× ××¢× ×¢× ×š×ַךע×× ××¢× ×׊×.
- ס××£-׊×-ס××£ ×¢× ×§×š×׀֌ש×Ö·× ××××Ö·× ×€Ö¿×× ×× DBMS ××× ×¢× ×§×š×׀֌ש×Ö·× ×€×× ×§×××¢× × ×××Ö·× ××× ×©×××¡× ×€×ַך×××Ö·×××× × ××××£ ×× ×¡×¢×š××עך ×××Ö·×.
- ××Ö·××Ö· ×¢× ×§×š×׀֌ש×Ö·×. ×€Ö¿×ַך ×××ַש׀֌××, ק×Öž×××× ×¢×š ×¢× ×§×š×׀֌ש×Ö·× ××× ×××¢× ××ך × ××Š× ×Ö· ×עק×Ö·× ×××Ö·× ×××֞ס ×× ×§×š××€ÖŒ× ×Ö· ×××× ×××Ö·× ×€×× ×× ××Ö·××Ö·×××ס.
××× ×§×¢× ××֞ס ××××š×§× ×× ×€×֞ךש××¢××× × ×€×× ×× DBMS?
××Öž××ך ××¢× ××¢× ×××ש׀֌×× ×€×× ×§×Öž×××× ×¢×š ×¢× ×§×š×׀֌ש×Ö·× ××× PostgreSQL. עס ××× ×Ö· ×€ÖŒ×קך××€ÖŒ××Öž ××Öž××××¢, עס ×Ö·××Ö·×× ××ך ×Š× ×§×š×Öž× ×××ס×עק×××× ×€×¢××עך ××× ×× ×§×š××€ÖŒ××× ×€×֞ךע×. ××֞ס ××× × ×׊×ק ×××¢× ××××× ×¢×××¢××¢ ××Ö·×× ××¢× ×¢× ××עך××€××. ×Š× ××××¢× ×¢× ×× ×× ×§×š××€ÖŒ××× ×€×¢××עך, ×עך ק×××¢× × ×ך×Ö·× ××××¥ ×Ö· ×עקך××€ÖŒ×××Öž× ×©××ס×, ×עך סעך××עך ×עקך××€ÖŒ× ×× ××Ö·×× ××× ×§×¢×š× ×¢×¡ ×Š× ××¢× ×§×××¢× ×. ×Öž× ××¢× ×©××ס×, ק××× ×××× ×¢×š ×§×¢× ×¢× ××Öž× ×¢×€ÖŒ×¢×¡ ××× ×××× ××Ö·××.
××× ×¡ ׀֌ך××××š× ××× pgcrypto. ××× ×¡ ××Ö·×× ×Ö· ××ש ××× ×× ×§×š××€ÖŒ××× ××Ö·×× ××× ×š×¢×××עך ××Ö·××. ×× ×עך ××¢× ×¢× ×× ×§×Ö·××Ö·× ×× ×€Ö¿×ַך קך×××××× × ××ש×, ××× ×עך עךש×עך ש××š× ×¢×¡ ××× ×Ö· × ×׊×ק ××Ö·×€Ö¿×¢× - קך×××××× × ×× ×€×ַך××¢× ×עך×× × ××× ××× DBMS ךע××ס×ך×ַ׊××¢:
CREATE EXTENSION pgcrypto;
CREATE TABLE t1 (id integer, text1 text, text2 text);
CREATE TABLE t2 (id integer, text1 bytea, text2 bytea);
INSERT INTO t1 (id, text1, text2)
VALUES (generate_series(1,10000000), generate_series(1,10000000)::text, generate_series(1,10000000)::text);
INSERT INTO t2 (id, text1, text2) VALUES (
generate_series(1,10000000),
encrypt(cast(generate_series(1,10000000) AS text)::bytea, 'key'::bytea, 'bf'),
encrypt(cast(generate_series(1,10000000) AS text)::bytea, 'key'::bytea, 'bf'));
××¢×š× ×Öž×, ××Öž××ך ׀֌ך××××š× ×Š× ××Ö·×× ×Ö· ××Ö·×× ××ס×עך ×€×× ××¢×עך ××ש ××× ×§×ק ××× ×× ××ך××€×ך×× × ××××× ×ס.
ס×Ö·×עק××× × ×€×× ×Ö· ××ש ×Öž× ×¢× ×§×š×׀֌ש×Ö·× ×€Ö¿×× ×§×Š××¢:
psql -c "timing" -c "select * from t1 limit 1000;" "host=192.168.220.129 dbname=taskdb
user=postgres sslmode=disable" > 1.txt
×× ×¡××Ö·×€ÖŒ×××Ö·×ש ××× ××××£.
id | text1 | ×עקס×2
ââ+ââ-+ââ-
1 | 1 | 1
2 | 2 | 2
3 | 3 | 3
...
997 | 997 | 997
998 | 998 | 998
999 | 999 | 999
1000 | 1000 | 1000
(1000 ש×ך×ת)
׊×××: 1,386 ×××
סע×עק׊××¢ ×€×× ââââ×Ö· ××ש ××× ×¢× ×§×š×׀֌ש×Ö·× ×€×× ×§×Š××¢:
psql -c "timing" -c "select id, decrypt(text1, 'key'::bytea, 'bf'),
decrypt(text2, 'key'::bytea, 'bf') from t2 limit 1000;"
"host=192.168.220.129 dbname=taskdb user=postgres sslmode=disable" > 2.txt
×× ×¡××Ö·×€ÖŒ×××Ö·×ש ××× ××××£.
id | ×עקך××€ÖŒ× | ×עקך××€ÖŒ×
ââ+âââââ+ââââ
1 | x31 | x31
2 | x32 | x32
3 | x33 | x33
...
999 | x393939 | x393939
1000 | x31303030 | x31303030
(1000 ש×ך×ת)
׊×××: 50,203 ×××
××¢×¡× ×š×¢×××××××:
×Öž× ×¢× ×§×š×׀֌ש×Ö·×
×€ÖŒ×קך××€ÖŒ××Öž (×עקך××€ÖŒ×)
××ס×עך 1000 ך×Öž××
1,386 ms
50,203 ms
ק׀֌×
×§×¡× ××קס%
×§×¡× ××קס%
××ַך×Ö·×
+ ×§×¡× ××קס%
×¢× ×§×š×׀֌ש×Ö·× ××× ×Ö· ×ך××ס ׀֌ך×Ö·× ××××£ ×€×֞ךש××¢××× ×. עס ×§×¢× ×¢× ×××× ××¢××¢× ×Ö·× ×× ×××××× × ××× ××¢×××קס×, ××× × ×עקך××€ÖŒ×××Öž× ×ַ׀֌עך××ש×Ö·× × ×€×× ×¢× ×§×š××€ÖŒ××× ××Ö·×× (××× ×עקך××€ÖŒ×××Öž× ××× ×××ש×Ö·×××Ö·×× × ×Öž× ××× ××¢×××ק×× ××× ×××× ××Öž××ק) ××Ö·×š×€× ××Ö·×××Ö·××ק ךעס×ךס×. ××֞ס ×××, ×עך ××¢××Ö·× ×§ ×€×× ×¢× ×§×š××€ÖŒ××× × ×Ö·××¢ ש׀×××× ××× ×¢×××¢××¢ ××Ö·×× ××× ×€×š×Öž× ××× ×Ö· ×€×ַךק××¢× ×¢×š× ××× ×€×֞ךש××¢××× ×.
×Öž×עך, ×¢× ×§×š×׀֌ש×Ö·× ××× × ××©× ×Ö· ××××עך ק××× ×××֞ס ס×Ö·×××× ×Ö·××¢ ׀֌ך×Öž×××¢×ס. ×× ×עקך××€ÖŒ××¢× ××Ö·×× ××× ×× ×עקך××€ÖŒ×××Öž× ×©×××¡× ×עש×ַס ××¢× ×€ÖŒ×š×֞׊עס ×€×× ×עקך××€ÖŒ××× × ××× ×ך×Ö·× ×¡××××× × ×× ××Ö·×× ××¢× ×¢× ×××× ××××£ ×× ×¡×¢×š××עך. ×עך××עך, ×× ×©××ס××¢× ×§×¢× ×¢× ×××× ×× ×עךסע׀֌××Ö·× ×××š× ×¢×ע׊עך ×××ס ××× ×€×× ×ַקסעס ×Š× ×× ××Ö·××Ö·×××ס סעך××עך, ×Ö·××Ö· ××× ×Ö· ס×ס××¢× ×Ö·×××× ×ס×ך×Ö·××֞ך.
×××¢× ×¢×¡ ××× ×××× ×©×××¡× ×€Ö¿×ַך ×× ××× ×Š×¢ ×××Ö·× ×€Ö¿×ַך ×Ö·××¢ × ×׊עךס (×Ö·×€Ö¿××× ×××× × ××©× ×€Ö¿×ַך ×Ö·××¢, ×Öž×עך ×€Ö¿×ַך ק××××Ö·× ×¥ ×€×× ×Ö· ××××××¢× ××Ö·× ×), ××֞ס ××× × ××©× ×©××¢× ××ק ××× ××× ×š××××ק. ×עך׀ֿ×ַך ××Öž×× ××× ×Öž× ××¢××××× ××ך××€××š× ×¢× ×-׊×-ס××£ ×¢× ×§×š×׀֌ש×Ö·×, ××× ×× DBMS ××× ×× ××¢××××× ×Š× ××Ö·×ך×Ö·××× ×֞׀֌׊×עס ×€Ö¿×ַך ×¢× ×§×š××€ÖŒ××× × ××Ö·×× ××××£ ×× ×§×××¢× × ××× ×¡×¢×š××עך ×××Ö·×, ××× ×× ××¢×××¢ ש××ס×-×××Öž×× ×¡××֞ך×××ש ××× ×ך××ס - ××Ö·××× ×עך ׀֌ך×Öž××ק×× ×××֞ס ׊×ש××¢×× ×©×××¡× ×€×ַך×××Ö·×××× × ××××£ ×× DBMS ×××Ö·×.
×××עך×××× ×€Ö¿×¢×֎ק×××× ××× ××¢×©×¢×€× ××× ×Öž×€Ö¿× ×ק×ך ×××ס
×€×Ö·× ×קש×Ö·× ×
×××€ÖŒ
ש׀֌ך×××××Öž×š× ×€ÖŒ×Öž××××ק
ק×Öž× ×ך×Öž××ך×
׀֌ך×Ö·×עק××× × ×× ×ק×ך ק×Öž× ×€×× ×€ÖŒ×š×Öž×ס××××©×¢×š× ××× ×€×Ö·× ×קש×Ö·× ×
ך×ס
×¢× ×§×š×׀֌ש×Ö·×
×֞ך×ַק×
×עשע׀×
+
+
+
+
+
MsSql
×עשע׀×
+
+
+
+
+
×עשע׀×
+
+
+
+
×קס××¢× ×©×Ö·× ×
×€ÖŒ×֞ס××ךעסק×
׀ך××Ö·
×קס××¢× ×©×Ö·× ×
×קס××¢× ×©×Ö·× ×
-
+
×קס××¢× ×©×Ö·× ×
MongoDb
׀ך××Ö·
-
+
-
-
××××× ×× ×××Š× ××× MongoDB Enterprise
×עך ××ש ××× ××××× ×€×× ××Ö·× ×¥, ×Öž×עך ×× ×¡××××ַ׊××¢ ××× ×Ö·×××: ××× ××¢×©×¢×€× ×€ÖŒ×š×Öž××ק××, ×××עך×××× ×€ÖŒ×š×Öž×××¢×ס ××Öž×× ×©××× ×¡×Ö·×××× ×€Ö¿×ַך ×Ö· ××Ö·× × ×Š××Ö·×, ××× ×Öž×€Ö¿× ×ק×ך, ××× ×Ö· ×עךש×, ×¢×××¢××¢ ×Ö·×-×Öž× ×¡ ××¢× ×¢× ××¢× ××Š× ×€Ö¿×ַך ×××עך××××, ×€×××¢ ×€×Ö·× ×קש×Ö·× × ××¢× ×¢× ×€×¢×× ××ק. , ××× ××ך ××Öž×× ×Š× ××××× ×¢×€ÖŒ×¢×¡. ×€Ö¿×ַך ×××ַש׀֌××, ×€ÖŒ×ַך×Öž× ×€ÖŒ×Ö·××ַס×× - PostgreSQL ××× ×€×××¢ ×€×ַךש×××¢× ×¢ ×קס××¢× ×©×Ö·× × (
×××֞ס ×Š× ××Öž× ×××× ××ך ××Öž× × ×× ××Öž×× ×××֞ס ××ך ××Ö·×š×€Ö¿× ×¢×š××¢×¥? ×€Ö¿×ַך ×××ַש׀֌××, ××ך ××××× ×Š× × ××Š× ×Ö· ס׀֌ע׊××€×ש ×××ס ×××֞ס ××× × ××©× ××Öž×× ×× ×€×Ö·× ×קש×Ö·× × ×Ö·× ×עך ק×× × ×š×ק××××עך×.
××¢×š× ×Öž× ××ך ×§×¢× ×¢× × ××Š× ×ך××-×€ÖŒ×ַך××× ×¡×Ö·××ש×Ö·× × ×××֞ס ×ַך××¢× ××× ×€×ַךש×××¢× ×¢ ×××ס, ××ש×, Crypto DB ×Öž×עך Garda DB. ×××× ××ך ××¢× ×¢× ×עךע×× ×××¢×× ×¡×Ö·××ש×Ö·× × ×€×× ×× ××× ×¢×š ×Öž×€ÖŒ×©× ××, ××× ××××¡× ×××¢×× GOSTs ×עסעך ××× ××× ×Öž×€Ö¿× ×ק×ך.
×× ×š××¢ ×֞׀֌׊××¢ ××× ×Š× ×©×š××Ö·×× ×××֞ס ××ך ××Ö·×š×€Ö¿× ×××, ×× ×¡×ך×××¢× × ××Ö·×× ×ַקסעס ××× ×¢× ×§×š×׀֌ש×Ö·× ××× ×× ×Ö·×€ÖŒ××ַק××ש×Ö·× ××× ×× ×€ÖŒ×š×֞׊ע××ך ××ך××. ××ת, עס ×××¢× ×××× ×עך ש××עך ××× GOST. ×Öž×עך ××× ×Ö·×××¢××××, ××ך ×§×¢× ×¢× ××Ö·××Ö·××× ×× ××Ö·×× ××× ××ךף, ש××¢×× ×¢×¡ ××× ×Ö· DBMS, ××× ×Š×ך×קקך××× ×¢×¡ ××× ×עקך××€ÖŒ× ×¢×¡ ××× ××ךף, ךע×× ××××£ ×× ×Ö·×€ÖŒ××ַק××ש×Ö·× ××ך××. ××× ×עך ××¢×××קעך ׊×××, ××××× ×ך×Ö·××× ×××¢×× ××× ××ך ×××¢× ××ַש××Š× ×× ×Ö·××עך×××Ö·×× ××× ×× ×Ö·×€ÖŒ××ַק××ש×Ö·×. ××× ××× ××עך ×××× ×× ×, ××֞ס ××Öž× ×××× ××¢××× ××××£ ×× DBMS ××ך××, ××××Ö·× ×¢×¡ ×××¢× ×ַך××¢×× ×€×ַס×עך.
××¢× ××ַך××× ××× ××¢×××¢× ×¢×š×©×עך ×עך××× ×× ×××
×××֞ס ×Ö·× ×עךש ×Š× ××××¢× ×¢× ××××£ ×עך ××¢××¢:
×עך ××× Ceph: MCS ×××Öž××§× ×××֞ק ס××֞ך×××ש .××× ×Š× ×§×××Ö·×× ×Ö· ××Ö·××Ö·×××ס ×€Ö¿×ַך ×Ö· ׀֌ך×××¢×§× ×Ö·××× ××ך ××Öž× × ×× ××Öž×× ×Š× ×§×××Ö·×× ××××עך .
×ק×ך: www.habr.com