Database Administrator

 MySQL master-slave Architecture and Data replication based on SSL I. Mysql Master/Slave architecture topology:650) this. width = 650; "src =" http://www.bkjia.com/uploads/allimg/131229/193QUD5-0.png "border =" 0 "alt =" "/> Ii. Knowledge about

From MySQL5.6, a new parameter innodb_page_size can be set to 8 K and 4 K for Innodb data pages. The default value is 16 K. This parameter must be added to my. cnf at the beginning of initialization. If a table has been created and modified, an

In the forum, I encountered a problem where I could not Attach the database. The error message is:   Msg 5171, Level 16, State 1, Line2 "path \ allen_log.ldfcm not a primary database file.   Obviously, this error indicates that the file selected by

I. Configure mongodb Master/Slave using the command line [root@server11 ~]#  /usr/local/mongodb/bin/mongod --bind_ip 192.168.1.112 -port 3306 --dbpath /data/mongodb/db1/ --logpath /usr/local/mongodb/logs/server1.log  --rest --master &  [1] 144

It is very important to regularly Delete the mysql Master/Slave binlog. Generally, you can use expire_logs_days = 10 to set the number of days that binlog is retained. mysql5.0 is not supported in the current version), but sometimes this is not

A batch of data was updated last night. It took more than 20 minutes to use the old update method, but it took less than two seconds to end with merge. For details, see: Use the BIRTH field of T_TMP_SCHOOL135868) to update the BIRTHDATE field of

MySQL-mmm-two nodes (master) Architecture 650) this. width = 650; "border =" 0 "alt =" "src =" http://www.bkjia.com/uploads/allimg/131229/1Q2143928-0.png "/>In two node master-master setup, MMM uses five IPs: single permanent IP for each nodethat is

Go to the mysql homepage and cover all the articles about how good mysql 5.6 is. Later, I browsed the 5.6 update description, saying that replication was enhanced, and some people tested to enable replication, which had little impact on performance.

  If an archived backup set exceeds the backup retention policy, report obsolete reports that it has expired. therefore, the Backup Redundancy policy is set to 1, and the archive is backed up twice. The report obsolete command is initiated to view

# Scripts are only used for communication and learning!# The current script version is 1. 0. implements the detection of physical memory and swap space. The RPM package is automatically installed (you need to configure Yum or attach the disc. If you

mysql> show slave status\G;  *************************** 1. row ***************************                 Slave_IO_State: Waiting for master to send event                    Master_Host: 192.168.8.22                    Master_User: repl 

Sometimes the database cannot be started because the data file is damaged for some reason. How can this problem be recovered? The following is a simulated experiment: 1. First create a tablespace TEST, and then create a table test on the tablespace

SCANIP is a new feature of the ORACLE11G database. It can simplify the vip configuration of the client. during last year's ORACLE11 RAC environment, the company did not test SCANIP due to the hasty setup. This year, due to business needs, when you

The user wishes to dynamically display the product Log in Cognos according to the product. This can be achieved through the condition variable in Cognos, and each product value corresponds to an image name. This is more complex. You must first

I saw a post in the Forum, saying that the database slowed down for a while and found that the last modification time of the database file was the same as that of the slow world. I want to know if the file actually increased during this time. In

Oracle Database 12c Release 1 (12.1.0.1.0) for Linux x86-64 OS: Redhat Linux 5 Update 8 64bit   1. Follow the official manual to enable varchar2 32 k support 2. If the rman recover table function is used, the following error occurs: RMAN-03015:

As we all know, SQL Server transactions are a single unit of work. If a transaction succeeds, all data modifications made in the transaction will be committed and become a permanent component of the database. If the transaction encounters an error

A few days ago I wrote something btree (http://thuhak.blog.51cto.com/2891595/1261783), continue this idea today, continue to write B + tree. In addition, B + tree is my goal. I have a better understanding of the basic principles of file and database

Hello, the following is the eighth lecture address of my oracle series training courses. This lecture mainly describes how to migrate databases across platforms! The main content involved is: 1: describes and demonstrates how to migrate a database

ORACLE 8.0.XSGA = (db_block_buffers * block size) + (shared_pool_size + large_pool_size + log_buffers) + 1 MBORACLE 8.1.XSGA = (db_block_buffers * block size) + (shared_pool_size + large_pool_size + java_pool_size + log_buffers) + 1 MBIn theory, SGA