00:04:56 ora_pmon_TESTDB testdb 17425 1 0 Aug29 ?...|grep TESTDB testdb 32541 1 2 10:09 ?...00:18:23 ora_p000_TESTDB testdb 32543 1 2 10:09 ?...00:17:41 ora_p001_TESTDB testdb 32545 1 2 10:09 ?...00:18:51 ora_p002_TESTDB testdb 32547 1 2 10:09 ?
先做个实验将故障重演一遍: 1.停止实例2 [Oracle@testdb2:/oracle] srvctl stop instance -d CQTEST -n testdb2 [oracle@testdb2...ONLINE testdb1 ONLINE ONLINE testdb2 ora.ons ONLINE ONLINE testdb1 ONLINE ONLINE testdb2 ora.registry.acfs...Open 2 OFFLINE OFFLINE Instance Shutdown ora.testdb1.vip 1 ONLINE ONLINE testdb1 ora.testdb2.vip...[oracle@testdb2:/oracle] exit testdb2:/#varyoffvg oradata04 3.重启实例2 testdb2:/#su - oracle [oracle@testdb2...ONLINE testdb2 Open ora.testdb1.vip 1 ONLINE ONLINE testdb1 ora.testdb2.vip 1 ONLINE ONLINE testdb2
127.0.0.1 6379 2 sentinel down-after-milliseconds testdb 5000 sentinel auth-pass testdb 123456 # 配置文件拷贝至另...127.0.0.1 6379 1 testdb任意定义,哨兵集群名称,127.0.0.1 6379 redis实例主节点 ;1 代表当1个哨兵实例判断主库不可用则进行转移,生产环境节点数要配置多一点...sentinel down-after-milliseconds testdb 5000 testdb同上,down-after-milliseconds代表 master 最长响应时间,超过这个时间就主观判断它下线...日志信息如下: 1895:X 29 Apr 23:57:31.778 # +sdown master testdb 127.0.0.1 6379 1895:X 29 Apr 23:57:31.779 #...:6379 127.0.0.1 6379 @ testdb 127.0.0.1 6380 再把6379端口启动,可以看到节点自动加入集群,且作为从节点 ?
具体案例 下面列举具体示例来演示 2.1 具体案例 需求: 假设服务器A实例中的testdb1库里有一张表tb1,现在想在服务器B的testdb2中直接访问testdb1中的tb1表的数据 实现步骤...: 1) 在服务器A中创建表 mysql> create database testdb1; Query OK, 1 row affected (0.00 sec) mysql> use testdb1...sec) mysql> show tables; +-------------------+ | Tables_in_testdb2 | +-------------------+ | testdb2...2.2 其他操作 除了查询,如果创建FEDERATED引擎表的账号(如本文用的t_user)有增删改的权限,那么也可以通过操作B服务器的testdb2.testdb2_tb1对远程表(服务器A上的testdb.tb1...'testdb2_tb1' doesn't have this option mysql> truncate table testdb2_tb1; Query OK, 0 rows affected (
[数据库名字] 示例: pg_dump testdb > testdb.sql pg_dump -F c -f testdb.dmp -C -E UTF8 -h 127.0.0.1 -U postgres...testdb pg_dump -F p -f testdb.sql -C -E UTF8 -h 127.0.0.1 -U postgres testdb 逻辑恢复 · 恢复顺序 1.创建新表 2....-d testdb testdb.dmp 其它导出导入技巧 · 利用管道符实现各种导出导入 导出并且压缩 pg_dump testdb |gzip testdb.sql 解压并且导入,压缩文件不变...,,导入到testdb数据库: gunzip -c testdb.sql.gz |psql testdb 导出后直接进行恢复,文件不落地,把testdb数据库的表导入到testdb1: pg_dump...testdb| psql testdb1 并行导出与导入 pg_dump -Fd -j4 -f testdb.p.dump testdb pg_restore -d testdb1 -j4 testdb.p.dump
/u01/app/oracle/oradata/testdb /u01/app/oracle/product/10.2.0/db_1/cfgtoollogs/emca/testdb /u01/app/.../emca/testdb /u01/app/oracle/product/10.2.0/db_1/cfgtoollogs/dbca/testdb /u01/app/oracle/product/10.2.0.../db_1/oc4j/j2ee/OC4J_DBConsole_host_testdb /u01/app/oracle/product/10.2.0/db_1/rdbms/log/alert_testdb.log.../u01/app/oracle/product/10.2.0/db_1/host_testdb /u01/app/oracle/product/10.2.0/db_1/host_testdb/sysman.../emd/state/A190EE260BF6B09EB580580728916A3B.alert_testdb.log /u01/app/oracle/product/10.2.0/db_1/host_testdb
2.指定数据和事务日志文件的数据库示例 IF DB_ID (N'TestDB') is not null -- 判断数据库是否存在如果存在则先删除 DROP DATABASE TestDB...GO CREATE DATABASE TestDB ON ( NAME = TestDB,-- 逻辑数据库文件名 FILENAME = 'D:\TestDB.mdf...(NAME = TestDB1, FILENAME = 'd:\TestDB1.mdf', SIZE = 100MB,...USE master GO IF DB_ID (N'TestDB') is not null -- 判断数据库是否存在如果存在则先删除 DROP DATABASE TestDB...GO CREATE DATABASE TestDB ON PRIMARY -- 数据库主文件 ( NAME = TestDB1, FILENAME =
mysql -uroot -proot 2、新建数据库testdb。 create database testdb; 3、新建数据表ts。...sqoop --options-file list_dbs.conf 5、查看testdb中所有表,使用非明文方式,手动输入密码。...--username root \ -P 7、将testdb.ts表中所有数据全量导入到hdfs的/tmp/sqoop/testdb/ts目录中。...hadoop fs -ls /tmp/sqoop/testdb/ts hadoop fs -cat /tmp/sqoop/testdb/ts/part-m-00000 9、在MySQL中新增一条数据。...hadoop fs -ls /tmp/sqoop/testdb/ts hadoop fs -cat /tmp/sqoop/testdb/ts/part-m-00001 Sqoop Job操作 将sqoop
testdb2; CREATE DATABASE postgres=# \c testdb1 You are now connected to database "testdb1" as user .../bin/psql --port 5433 postgres=# \c testdb1 testdb1=# CREATE PUBLICATION p_upgrade FOR ALL TABLES; testdb1...=# \c testdb2 testdb2=# CREATE PUBLICATION p_upgrade2 FOR ALL TABLES; testdb2=# \dRp+ .../bin/psql --port 5434 testdb2=# \c testdb1 testdb2=# CREATE SUBSCRIPTION s_sub CONNECTION 'host=192.168.2.4...8、后续如果在PG10上有加表操作,类似如下: PG10上,我们加一个表 testdb1=# \c testdb1 testdb1=# create table tb_new( a int ,b int
| +--------------------+ mysql> use testdb; Database changed mysql> use TestDb; Database changed mysql...> use TESTDB; ERROR 1049 (42000): Unknown database 'TESTDB' # 创建表 mysql> CREATE TABLE if not exists...... drwxr-x--- 2 mysql mysql 144 Jun 3 14:40 testdb [root@localhost ~]#:/var/lib/mysql# cd testdb/...同时我们注意到,允许创建名称同样但大小写不一样的库表名(比如允许 TestDb 和 testdb 库共存)。...', TABLE_NAME, ' to testdb.
create configuration dg_testdb as primary database is testdb connect identifier is testdb; 在经过大量的实践之后...Operation requires startup of instance "testdb" on database "testdb" Starting instance "testdb"......Operation requires a connection to instance "testdb" on database "testdb" Connecting to instance "testdb...Operation requires startup of instance "testdb" on database "stestdb" Starting instance "testdb"......Operation requires startup of instance "testdb" on database "stestdb" Starting instance "testdb"...
testdb 2)连入数据库 testdb $ psql testdb 3)创建测试表,插入数据 testdb=# create table tt( espace tbls_t; testdb...) $ createdb testdb 8)恢复数据 $ psql testdb < dm_bk /testdb.sql 9)查看数据是否回复 $ psql testdb testdb=# select...-F c -L testdb.toc -d testdb testdb.dmp 4)检查发现t1 表没有被导入。...使用 unix 管道压缩备份恢复: 1) 导出并且压缩 pg_dump testdb |gzip testdb.sql或者: pg_dump testdb >testdb.sql |gzip testdb.sql...数据库的表导入到 testdb1: pg_dump testdb| psql testdb1 4)并行备份恢复 pg_dump -Fd -j4 -f testdb.p.dump testdb 5)并行导入到
grant select on testdb.* to common_user@'%' grant insert on testdb.* to common_user@'%' grant update...on testdb.* to common_user@'%' grant delete on testdb.* to common_user@'%' 或者,用一条 MySQL 命令来替代: grant...grant create on testdb.* to developer@'192.168.0.%';grant alter on testdb.* to developer@'192.168.0....grant create view on testdb.* to developer@'192.168.0.....* to dba@localhost ; -- dba 可以查询 testdb 中的表。
grant select on testdb.* to common_user@'%' grant insert on testdb.* to common_user@'%' grant update...on testdb.* to common_user@'%' grant delete on testdb.* to common_user@'%' 或者,用一条 MySQL 命令来替代: grant...grant create on testdb.* to developer@'192.168.0.%'; grant alter on testdb.* to developer@'192.168.0....grant create view on testdb.* to developer@'192.168.0.%'; grant show view on testdb.* to developer@'192.168.0....* to dba@localhost; -- dba 可以查询 testdb 中的表。
; CREATE DATABASE postgres=# postgres=# \c testdb You are now connected to database "testdb" as user..."tbase". testdb=# testdb=# create table test_tab(id int primary key,name varchar(20)); CREATE TABLE...100 testdb=# testdb=# select * from test_tab limit 5; id | name ----+------- 1 | TEST1 2 | TEST2...因为我们发布的是testdb库的test_tab表。...连接testdb数据库,再次进行查询,表的发布信息如下: postgres=# \c testdb You are now connected to database "testdb" as user
17569 1 testdb=# insert into t1 values(2); INSERT 17570 1 testdb=# insert into t1 values(3); INSERT 17571...=# begin; BEGIN testdb=# select txid_current(); txid_current -------------- 80853360 (1 row) testdb...同理,可以看下删除一个tuple的结果 //seesion1: testdb=# delete from t1 where id = 2; DELETE 1 //seesion2: testdb=#...提交事务,查看最终结果如下: //seesion1: testdb=# commit; COMMIT testdb=# select ctid, xmin, xmax, cmin, cmax, oid...testdb=# begin ; BEGIN testdb=# update t1 set id = 5 where id = 4; UPDATE 1 testdb=# rollback; ROLLBACK
在test_1表的xh字段上创建唯一索引 testdb=> create unique index "rule_test_1" on "public"."...创建增加分布列的唯一索引 testdb=> create unique index "rule_test_1" on "public"."...* from test_1 testdb-> ; id | xh ----+----- 2 | 1s 1 | 2s (2 rows) testdb=> insert into test_1...values(3,'dd'); INSERT 0 1 testdb=> insert into test_1 values(4,'dd'); INSERT 0 1 testdb=> insert into...test_1 values(5,'dd'); INSERT 0 1 testdb=> testdb=> select * from test_1; id | xh ----+----- 1 |
``` SELECT ADD_LOCATION('/verticadata2/vertica/','v_testdb_node0001','DATA'); SELECT ADD_LOCATION('/...verticadata2/vertica/','v_testdb_node0002','DATA'); SELECT ADD_LOCATION('/verticadata2/vertica/','v_testdb_node0003...v_testdb_node0002 v_testdb_node0003 (3 rows) dbadmin=> SELECT ADD_LOCATION('/verticadata2/vertica.../','v_testdb_node0001','DATA'); SELECT ADD_LOCATION('/verticadata2/vertica/','v_testdb_node0002','DATA...'); SELECT ADD_LOCATION('/verticadata2/vertica/','v_testdb_node0003','DATA'); ADD_LOCATION
0.00 sec) 测试 在Master上创建测试数据库和数据表 [root@master ~]# mysql -uroot -p MariaDB [(none)]> create database testdb...; Query OK, 1 row affected (0.00 sec) MariaDB [(none)]> use testdb; Database changed MariaDB [testdb...| +--------------------+ 4 rows in set (0.00 sec) MariaDB [testdb]> use testdb; Database...changed MariaDB [testdb]> SHOW TABLES; +------------------+ | Tables_in_testdb | +------------------...+ | students | +------------------+ 1 row in set (0.00 sec) MariaDB [testdb]> SELECT * FROM
mysqldump -uroot -pxxxxxx --databases testdb1 testdb2 > /tmp/testdb.sqlmysqldump -uroot -pxxxxxx -B testdb1...testdb2 > /tmp/testdb.sql 3.备份部分表 平时我们也会有备份部分表的需求,比如说在表变更前做个备份,那么我们可以这样做: #只备份testdb库中的test_tb表mysqldump...mysqldump -uroot -pxxxxxx testdb --ignore-table=testdb.tb1 > /tmp/testdb.sql 6.只备份结构或只备份数据 只备份结构的话可以使用...mysqldump -uroot -pxxxxxx testdb --no-data > /tmp/testdb_jiegou.sqlmysqldump -uroot -pxxxxxx testdb -...例如:我们想备份整个testdb库,包含存储过程及事件: mysqldump -uroot -pxxxxxx -R -E --databases testdb > /tmp/testdb.sql 8.以事务的形式备份
领取专属 10元无门槛券
手把手带您无忧上云