| 123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221 |
- 打包命令----.\gradlew.bat clean build jar
- mongo数据库:docker exec -it 0cbb78421194 mongo mongodb://admin:rimZBP82Ia@127.0.0.1:27017/x5_tk_login?authSource=admin
- nohup java -jar jenkins.war --httpPort=12567 > jenkins.log 2>&1 &
- tar -czvf archive.tar.gz directory/ # 压缩
- tar -xzvf archive.tar.gz # 解压
- mongo "mongodb://admin:123456@127.0.0.1:27017/admin?authSource=admin"
- 启动svn
- svnserve -d -r /www/svn/ro
- mysql -u 用户名 -p -e "SELECT * FROM 数据库名.表名" -B | sed 's/\t/","/g;s/^/"/;s/$/"/;s/\n//g' > 输出文件.csv
- db.user.find(
- { _id: 10001587 }
- )
- db.user.updateOne(
- { _id: 10001587 },
- {
- $set: {
- "medalManager.medalMap": {},
- }
- }
- );
- test2插入到test集合中
- db.getSiblingDB('test').集合.insertMany(
- db.getSiblingDB('test2').集合.find().toArray(),
- { ordered: false }
- );
- //设置hset全部key为指定value10001
- EVAL "local keys = redis.call('HKEYS', KEYS[1]); for i,key in ipairs(keys) do redis.call('HSET', KEYS[1], key, ARGV[1]) end; return #keys" 1 CUser_ServerId: 10001
- //将10005的值改成10001
- EVAL "local keys = redis.call('HKEYS', KEYS[1]); local count = 0; for i,key in ipairs(keys) do local value = redis.call('HGET', KEYS[1], key); if value == ARGV[2] then redis.call('HSET', KEYS[1], key, ARGV[1]); count = count + 1; end; end; return count" 2 CUser_ServerId: 10001 10005
- redis-cli -a "lVzYFQ2i6v" EVAL "local keys = redis.call('HKEYS', 'CUser_ServerId:'); local count = 0; for i,key in ipairs(keys) do if redis.call('HGET', 'CUser_ServerId:', key) == '10004' then redis.call('HSET', 'CUser_ServerId:', key, '10005'); count = count + 1; end; end; return count" 0
- lVzYFQ2i6v
- db.your_collection.updateMany(
- {}, // 空对象表示匹配所有文档
- {
- $set: {
- "your_field": 10001
- }
- }
- );
- db.user_info.updateMany(
- {
- "serverId": "10004" // 只匹配serverId为10003的文档
- },
- {
- $set: {
- "serverId": "10005"
- }
- }
- );
- 时空合服工具,新增level字段在user_info集合里
- // 检查当前数据库
- db.getName();
- // 切换到login数据库
- use m5_tk_login;
- // 检查players集合结构
- db.user_info.findOne();
- // 1. 先添加level字段(如果不存在)
- db.user_info.updateMany(
- { level: { $exists: false } },
- { $set: { level: 0 } }
- );
- print("已初始化level字段");
- // 2. 假设有两个服务器:s1和s2
- // 更新服务器s1的玩家等级
- var server1Db = db.getSiblingDB("m5_x1_game_10001");
- var loginDb = db.getSiblingDB("x5_tk_login");
- var count1 = 0;
- server1Db.user.find().forEach(function(doc) {
- var result = loginDb.user_info.updateOne(
- {
- _id: doc._id
- },
- {
- $set: {
- level: doc.playerManager.level,
- update_time: new Date()
- }
- }
- );
-
- if (result.modifiedCount > 0) {
- count1++;
- }
- });
- print("服务器s1更新完成,更新了 " + count1 + " 条记录");
- //备份mongo所有数据库
- mongo "mongodb://admin:rimZBP82Ia@localhost:27017/admin"
- db.createUser({
- user: "mongobackup",
- pwd: "Backup562221715", // 使用强密码
- roles: [
- { role: "backup", db: "admin" },
- { role: "clusterMonitor", db: "admin" },
- { role: "readAnyDatabase", db: "admin" }
- ]
- })
- mongodump --uri='mongodb://mongobackup:Backup562221715@localhost:27017' \
- --authenticationDatabase=admin \
- --out /backup/mongodb/
- # 启动 MongoDB 服务
- sudo systemctl start mongodb
- //全服务端口查看
- netstat -lntp
- /etc/systemd/system/mongodb.service
- [Unit]
- Description=MongoDB Database Server
- After=network.target
- [Service]
- Type=forking
- ExecStart=/usr/bin/mongod --config /www/server/mongodb/config.conf
- ExecStop=/usr/bin/mongod --shutdown --config /www/server/mongodb/config.conf
- Restart=always
- RestartSec=5
- LimitNOFILE=64000
- [Install]
- WantedBy=multi-user.target
- mongo安装
- # 创建安装目录
- mkdir -p ~/mongodb-install
- cd ~/mongodb-install
- # 下载 MongoDB 4.0 的 RPM 包(以下为示例,可能需要更新下载链接)
- wget https://repo.mongodb.org/yum/redhat/7/mongodb-org/4.0/x86_64/RPMS/mongodb-org-server-4.0.28-1.el7.x86_64.rpm
- wget https://repo.mongodb.org/yum/redhat/7/mongodb-org/4.0/x86_64/RPMS/mongodb-org-shell-4.0.28-1.el7.x86_64.rpm
- wget https://repo.mongodb.org/yum/redhat/7/mongodb-org/4.0/x86_64/RPMS/mongodb-org-tools-4.0.28-1.el7.x86_64.rpm
- wget https://repo.mongodb.org/yum/redhat/7/mongodb-org/4.0/x86_64/RPMS/mongodb-org-mongos-4.0.28-1.el7.x86_64.rpm
- # 安装依赖
- sudo yum install -y cyrus-sasl cyrus-sasl-gssapi cyrus-sasl-plain libcurl net-snmp openldap openssl
- # 安装 RPM 包
- sudo rpm -ivh mongodb-org-server-4.0.28-1.el7.x86_64.rpm
- sudo rpm -ivh mongodb-org-shell-4.0.28-1.el7.x86_64.rpm
- sudo rpm -ivh mongodb-org-tools-4.0.28-1.el7.x86_64.rpm
- sudo rpm -ivh mongodb-org-mongos-4.0.28-1.el7.x86_64.rpm
- # 创建数据目录
- sudo mkdir -p /var/lib/mongo
- sudo chown -R mongod:mongod /var/lib/mongo
- # 创建日志目录
- sudo mkdir -p /var/log/mongodb
- sudo chown -R mongod:mongod /var/log/mongodb
- # 备份原配置文件
- sudo cp /etc/mongod.conf /etc/mongod.conf.bak
- # 编辑配置文件
- sudo vi /etc/mongod.conf
- # 网络绑定(默认只允许本地访问)
- net:
- port: 27017
- bindIp: 127.0.0.1 # 如果需要远程访问,改为 0.0.0.0
- # 存储配置
- storage:
- dbPath: /var/lib/mongo
- journal:
- enabled: true
- # 日志配置
- systemLog:
- destination: file
- logAppend: true
- path: /var/log/mongodb/mongod.log
- # 进程管理
- processManagement:
- fork: true # 后台运行
- pidFilePath: /var/run/mongodb/mongod.pid
- # 安全配置(建议设置)
- security:
- authorization: enabled # 启用认证
- # 启动服务
- sudo systemctl start mongod
- # 设置开机自启
- sudo systemctl enable mongod
- # 查看服务状态
- sudo systemctl status mongod
- # 查看日志
- sudo tail -f /var/log/mongodb/mongod.log
- 春之歌redis:/usr/bin/redis-server 127.0.0.1:6379 文件保存在/var/lib/redis
- mongo:/usr/bin/mongod -f /etc/mongod.conf
- mysql:/usr/sbin/mysqld
- nginx:./nginx -c /usr/local/nginx/conf/nginx.conf
|