- 博客(10)
- 资源 (1)
- 收藏
- 关注
原创 Configure IPC connection to oracle PDB instead of tcp
[oracle@oraclelinux ~]$ cat $ORACLE_HOME/network/admin/listener.ora# listener.ora Network Configuration File: /u01/app/oracle/product/19.0.0/dbhome_1/network/admin/listener.ora# Generated by Oracle configuration tools.LISTENER = (DESCRIPTION_LIST =
2025-07-21 22:46:02
716
原创 MySQL Replication 1
[root@oraclelinux1 ~]# vi /etc/my.cnf[mysqld]server_id = 1port = 3306datadir=/var/lib/mysqlread-only = 0log_binsocket=/var/lib/mysql/mysql.socklog-error=/var/log/mysqld.logpid-file=/var/run/mysqld/mysqld.pidbinlog-ignore-db=mysqlbinlog-ignore-db=
2025-06-06 15:34:06
755
原创 Mysqld_multi manage multi instances 实践
[mysqld_multi]mysqld=/usr/local/mysql/bin/mysqld_safemysqladmin=/usr/local/mysql/bin/mysqladminlog=/home/mysql/multi/mysqld_multi.log[mysqld]user=mysqlbasedir=/usr/local/mysql[mysqld3310]datadir=/home/mysql/multi/3310/dataport=3310server_id=3310socket=/hom
2025-06-01 18:32:29
738
原创 Grant sudo permission on Linux
linux sudo permission, login with sudo permission accountin CentOS,Redhat,Fedora the group is wheelin Debian, Ubuntu, the group is sudo[root@oraclelinux ~]# cat /etc/sudoers## Allows people in group wheel to run all commands%wheel ALL=(ALL) ALL[
2025-03-08 21:46:14
312
原创 Checkpoint and Wal Archiving in PostgreSQL
checkpoint , wal archive, PostgreSQL
2025-03-07 14:50:12
523
原创 Linux 硬链接 & 软链接
postgres@oraclelinux ~]$ ln -s file1 file3 ---给file1 创建软链接 file3。[postgres@oraclelinux ~]$ ln file1 file2 --- 给file1 创建硬链接 file2。可以在多个文件之间进行,ls -l 命令显示文件的硬链接数。1, 不能对目录做硬链接。
2025-03-02 10:04:26
809
原创 SQL SERVER ALWAYS ON FAILOVER CLUSTER INSTANCE
4G 内存的机器干脆 直接部署DC – server0 , 另外一台8G 安装有win10 - Desktop, 虚拟化安装两台 windows server (winserver1, winserver2)配置网卡IP 等,开通防火墙配置或者关闭防火墙,vmserver1,vmserver2 加入域,DC的安装配置就不再该节写了。假期无事,未来大概率会有部署微软sqlserver群集的任务,提前用家中家中闲置两台laptop演练一番,创建两个vhd, 一个计划用作仲裁,另一个计划当作共享存储。
2025-02-03 11:06:30
739
1
空空如也
TA创建的收藏夹 TA关注的收藏夹
TA关注的人
RSS订阅