一、准备环境1、下载最新版mongodb_64位安装包:http://www.mongodb.org/downloads2、解压安装配置:#tarzxvfmongodb-linux-x86_64-2.2.3.tgz-C/usr/local/#mvmo
一、准备环境
1、下载最新版mongodb_64位安装包:
2、解压安装配置:
# tar zxvf mongodb-linux-x86_64-2.2.3.tgz -C /usr/local/
# mv mongodb-linux-x86_64-2.2.3/ mongodb
# mkdir data_mongo
# cd data_mongo
# mkdir config
# mkdir ku1-zu
# mkdir ku2-bei
# mkdir ku3-abr
# mkdir logs
# cd ../mongodb/
# mkdir conf
# cd conf/
# touch ku1-zu.conf
# touch ku2-bei.conf
# touch ku3-abr.conf
# touch config.conf
# touch mongos.conf
【192.168.10.20上的配置文件】
# vi ku1-zu.conf
logpath = /usr/local/data_mongo/logs/ku1.log
logappend = true
dbpath = /usr/local/data_mongo/ku1_zu
shardsvr = true
replSet = rs1
bind_ip = 127.0.0.1,192.168.10.20
maxConns = 5000
fork = true
port = 27011
oplogSize = 1000
profile = 1
slowms = 500
rest = true
directoryperdb = true
journal = true
# vi ku2-bei.conf
logpath = /usr/local/data_mongo/logs/ku2.log
logappend = true
dbpath = /usr/local/data_mongo/ku2_bei
shardsvr = true
replSet = rs2
bind_ip = 127.0.0.1,192.168.10.20
maxConns = 5000
fork = true
port = 27013
oplogSize = 1000
profile = 1
slowms = 500
rest = true
directoryperdb = true
journal = true
vi ku3-abr.conf
logpath = /usr/local/data_mongo/logs/ku3.log
logappend = true
dbpath = /usr/local/data_mongo/ku3_abr
shardsvr = true
replSet = rs3
bind_ip = 127.0.0.1,192.168.10.20
maxConns = 5000
fork = true
port = 27015
vi config.conf
logpath = /usr/local/data_mongo/logs/config.log
logappend = true
dbpath = /usr/local/data_mongo/config
configsvr = true
bind_ip = 127.0.0.1,192.168.10.20
fork = true
port = 20000
vi mongos.conf
configdb = 192.168.10.20:20000,192.168.10.21:20000,192.168.10.22:20000
logpath = /usr/local/data_mongo/logs/mongos.log
logappend = true
chunkSize = 10
fork = true
maxConns = 6000
port = 30000
【192.168.10.21上的配置文件】[config.conf、mongos.conf 与10.20几乎一致略]
vi ku1-abr.conf
logpath = /usr/local/data_mongo/logs/ku1.log
logappend = true
dbpath = /usr/local/data_mongo/ku1_abr
shardsvr = true
replSet = rs1
bind_ip = 127.0.0.1,192.168.10.21
maxConns = 5000
fork = true
port = 27011
vi ku2-zu.conf
logpath = /usr/local/data_mongo/logs/ku2.log
logappend = true
dbpath = /usr/local/data_mongo/ku2_zu
shardsvr = true
replSet = rs2
bind_ip = 127.0.0.1,192.168.10.21
maxConns = 5000
fork = true
port = 27013
oplogSize = 1000
profile = 1
slowms = 500
rest = true
directoryperdb = true
journal = true
vi ku3-bei.conf
logpath = /usr/local/data_mongo/logs/ku3.log
logappend = true
dbpath = /usr/local/data_mongo/ku3_bei
shardsvr = true
replSet = rs3
bind_ip = 127.0.0.1,192.168.10.21
maxConns = 5000
fork = true
port = 27015
oplogSize = 1000
profile = 1
slowms = 500
rest = true
directoryperdb = true
journal = true
【192.168.10.22上的配置文件】[config.conf、mongos.conf 与10.20几乎一致略]
vi ku1-bei.conf
logpath = /usr/local/data_mongo/logs/ku1.log
logappend = true
dbpath = /usr/local/data_mongo/ku1_bei
shardsvr = true
replSet = rs1
bind_ip = 127.0.0.1,192.168.10.22
maxConns = 5000
fork = true
port = 27011
oplogSize = 1000
profile = 1
slowms = 500
rest = true
directoryperdb = true
journal = true
vi ku2-abr.conf
ogpath = /usr/local/data_mongo/logs/ku2.log
logappend = true
dbpath = /usr/local/data_mongo/ku2_abr
shardsvr = true
replSet = rs2
bind_ip = 127.0.0.1,192.168.10.22
maxConns = 5000
fork = true
port = 27013
vi ku3-zu.conf
logpath = /usr/local/data_mongo/logs/ku3.log
logappend = true
dbpath = /usr/local/data_mongo/ku3-zu
shardsvr = true
replSet = rs3
bind_ip = 127.0.0.1,192.168.10.22
maxConns = 5000
fork = true
port = 27015
oplogSize = 1000
profile = 1
slowms = 500
rest = true
directoryperdb = true
journal = true
3、启动:【这是192.168.10.20、其他两台都一样启动、但都必须先启动shard 也就是自定义的 ku1 ku2 ku3;再启动config 和 mongos 略】
/usr/local/mongodb/bin/mongod -f /usr/local/mongodb/conf/ku1-zu.conf
/usr/local/mongodb/bin/mongod -f /usr/local/mongodb/conf/ku2-bei.conf
/usr/local/mongodb/bin/mongod -f /usr/local/mongodb/conf/ku3-abr.conf
/usr/local/mongodb/bin/mongod -f /usr/local/mongodb/conf/config.conf
/usr/local/mongodb/bin/mongos -f /usr/local/mongodb/conf/mongos.conf
4、4-1 配置congif和路由:【ku1 ku2 ku3 每个库群 随便找一台进去对应的端口进行配置】
例如:ku1 我在192.168.10.20 上进行初始化副本集
# /usr/local/mongodb/bin/mongo --port 27011

mysqlviewshavelimitations:1)他們不使用Supportallsqloperations,限制DatamanipulationThroughViewSwithJoinsOrsubqueries.2)他們canimpactperformance,尤其是withcomplexcomplexclexeriesorlargedatasets.3)

porthusermanagementinmysqliscialforenhancingsEcurityAndsingsmenting效率databaseoperation.1)usecReateusertoAddusers,指定connectionsourcewith@'localhost'or@'%'。

mysqldoes notimposeahardlimitontriggers,butacticalfactorsdeterminetheireffactective:1)serverConfiguration impactactStriggerGermanagement; 2)複雜的TriggerSincreaseSySystemsystem load; 3)largertablesslowtriggerperfermance; 4)highConconcConcrencerCancancancancanceTigrignecentign; 5); 5)

Yes,it'ssafetostoreBLOBdatainMySQL,butconsiderthesefactors:1)StorageSpace:BLOBscanconsumesignificantspace,potentiallyincreasingcostsandslowingperformance.2)Performance:LargerrowsizesduetoBLOBsmayslowdownqueries.3)BackupandRecovery:Theseprocessescanbe

通過PHP網頁界面添加MySQL用戶可以使用MySQLi擴展。步驟如下:1.連接MySQL數據庫,使用MySQLi擴展。 2.創建用戶,使用CREATEUSER語句,並使用PASSWORD()函數加密密碼。 3.防止SQL注入,使用mysqli_real_escape_string()函數處理用戶輸入。 4.為新用戶分配權限,使用GRANT語句。

mysql'sblobissuitableForStoringBinaryDataWithInareLationalDatabase,而ilenosqloptionslikemongodb,redis和calablesolutionsolutionsolutionsoluntionsoluntionsolundortionsolunsonstructureddata.blobobobissimplobisslowdeperformberbutslowderformandperformancewithlararengedata;

toaddauserinmysql,使用:createUser'username'@'host'Indessify'password'; there'showtodoitsecurely:1)choosethehostcarecarefullytocon trolaccess.2)setResourcelimitswithoptionslikemax_queries_per_hour.3)usestrong,iniquepasswords.4)Enforcessl/tlsconnectionswith

toAvoidCommonMistakeswithStringDatatatPesInMysQl,CloseStringTypenuances,chosethirtightType,andManageEngencodingAndCollationsEttingSefectery.1)usecharforfixed lengengtrings,varchar forvariable-varchar forbariaible length,andtext/blobforlargerdataa.2 seterters seterters seterters


熱AI工具

Undresser.AI Undress
人工智慧驅動的應用程序,用於創建逼真的裸體照片

AI Clothes Remover
用於從照片中去除衣服的線上人工智慧工具。

Undress AI Tool
免費脫衣圖片

Clothoff.io
AI脫衣器

Video Face Swap
使用我們完全免費的人工智慧換臉工具,輕鬆在任何影片中換臉!

熱門文章

熱工具

Safe Exam Browser
Safe Exam Browser是一個安全的瀏覽器環境,安全地進行線上考試。該軟體將任何電腦變成一個安全的工作站。它控制對任何實用工具的訪問,並防止學生使用未經授權的資源。

ZendStudio 13.5.1 Mac
強大的PHP整合開發環境

禪工作室 13.0.1
強大的PHP整合開發環境

SublimeText3漢化版
中文版,非常好用

DVWA
Damn Vulnerable Web App (DVWA) 是一個PHP/MySQL的Web應用程序,非常容易受到攻擊。它的主要目標是成為安全專業人員在合法環境中測試自己的技能和工具的輔助工具,幫助Web開發人員更好地理解保護網路應用程式的過程,並幫助教師/學生在課堂環境中教授/學習Web應用程式安全性。 DVWA的目標是透過簡單直接的介面練習一些最常見的Web漏洞,難度各不相同。請注意,該軟體中