MySQL Replication: Switch to your Master
Although performance is a much larger benefit of replication, it provides some redundancy for your application as well. Adding a slave server to a master allows you to perform read operations on either server, but you’re still bound to the master server for writes. In a group of multiple slaves with one master, you have your data available and online in multiple locations, which means that...
Read MoreSimple MySQL Commands
General Commands USE database_name Change to this database. You need to change to some database when you first connect to MySQL. SHOW DATABASES Lists all MySQL databases on the system. SHOW TABLES [FROM database_name] Lists all tables from the current database or from the database given in the command. DESCRIBE table_name SHOW FIELDS FROM table_name SHOW COLUMNS FROM table_name These commands...
Read MoreHow to start/stop 11g ASM CRS and HAS processes
Starting the High Availability Services Daemon. $ORACLE_ASM_HOME/bin/crsctl start has Stopping the High Availability Services Daemon. $ORACLE_ASM_HOME/bin/crsctl stop has Starting the Cluster Ready Services Daemon. $ORACLE_ASM_HOME/bin/crs_start -all Stopping the Cluster Ready Services Daemon. $ORACLE_ASM_HOME/bin/crs_stop...
Read MoreGeneral Oracle Standby Database Checks
Standby DB SELECT PROCESS, STATUS FROM V$MANAGED_STANDBY; Standby/Primary DB SELECT SEQUENCE#,APPLIED FROM V$ARCHIVED_LOG ORDER BY SEQUENCE#; Primary DB SELECT MESSAGE FROM V$DATAGUARD_STATUS; SELECT dest_name,ARCHIVED_THREAD#, ARCHIVED_SEQ#, APPLIED_THREAD#, APPLIED_SEQ# FROM...
Read MoreORA-16571 DG config file creation failure
While setting up Data Guard Broker I came across this particular error. ORA-16571 Data Guard configuration file creation failure. The Data Guard broker was unable to create the configuration file on permanent storage. In my case I am using ASM and noticed that the dataguard directory was missing. After I verified space, permissions and filename as indicated by the dg_broker_config_file[1|2]...
Read More