Temporary backups

When you change a dynamic parameter and save the parameter group, the change is applied immediately regardless of the Apply Immediately setting. When you change a static parameter and save the DB parameter group, the parameter change will take effect after you manually reboot the DB instance. You can reboot a DB instance using the RDS console or explicitly calling the RebootDbInstance API action..

GRANT LOAD FROM S3 ON *.* TO `root`@`%`; LOAD DATA FROM S3 MANIFEST 's3://aprdsflip01/aurora_test3.manifest' INTO TABLE `sbtest`.`TB_CM_EMP` FIELDS TERMINATED BY ',' LINES TERMINATED BY '\n' SET MOD_DATE = NOW(); select * from sbtest.TB_CM_EMP; TRUNCATE sbtest.TB_CM_EMP; LOAD DATA FROM S3 PREFIX 's3://aprdsflip01/aurora_test3.part' INTO TABLE `sbtest`.`TB_CM_EMP` FIELDS TERMINATED BY ',' LINES T..

PostgreSQL extension PG-Strom, allows users to customize the data scan and run queries faster. CPU-intensive work load is identified and transferred to the GPU to take advantage of the powerful GPU parallel execution ability to complete the data task. The combination of few number of core processors, RAM bandwidth, and the GPU has a unique advantage. GPUs typically have hundreds of processor cor..

master 프로세스 소켓 파일을 생성하는 위치를 큐브리드를 설치한 OS 계정의 profile 파일에서 CUBRID_TMP 환경변수를 정의함으로써 변경할 수 있지만 CUBRID_TMP 파라미터로 경로를 별도 지정해도 서버 구동 시 /tmp 폴더에 최초 파일을 write 하도록 되어있어 큐브리드가 설치된 계정이 /tmp 디렉토리에 대한 읽기,쓰기 권한을 갖고 있지 않으면 구동에 실패하는 문제가 있습니다. 위 문제로 특정 사이트의 관리 정책 상 other 그룹에 대해 모든 권한을 해지해야 함에도 불가피하게 /tmp 디렉토리만 권한을 부여한 경우가 있었는데 이러한 경우에 TMPDIR 환경변수를 지정함으로써 최초 파일 쓰기 시도하는 디렉토리를 변경하여 해결할 수 있습니다. ● CentOS , RHEL 에서 계정..

SQL> connect sys/secret_password as sysdba; SQL> alter user sysman account unlock ; -- SQL> alter user DBUSER identified by newpa$$word; Next, change the profile limit to unlimited. SQL> alter profile DEFAULT limit PASSWORD_REUSE_TIME unlimited; SQL> alter profile DEFAULT limit PASSWORD_LIFE_TIME unlimited; Check the password expiry date SQL> select username, account_status, EXPIRY_DATE from dba..

To view Microsoft SQL server error and agent logs, use the Amazon RDS stored procedure rds_read_error_log with the following parameters: @index – the version of the log to retrieve. The default value is 0, which retrieves the current error log. Specify 1 to retrieve the previous log, specify 2 to retrieve the one before that, and so on. @type – the type of log to retrieve. Specify 1 to retrieve ..

You can enable the binlog in Aurora by creating a cluster parameter group with the binlog_format parameter set to the binary logging format of your choice (either MIXED, STATEMENT or ROW), and then applying it to your Aurora instance/cluster. In order for the parameter to take effect, make sure you choose "apply immediately" and then reboot the instance.

An empty string is treated as a null value in Oracle. Let's demonstrate.We've created a table called suppliers with the following table definition:create table suppliers ( supplier_id number, supplier_name varchar2(100) ); Next, we'll insert two records into this table.insert into suppliers (supplier_id, supplier_name ) values ( 10565, null ); insert into suppliers (supplier_id, supplier_name ) ..