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
This blog post aims to read and understand your own books and use this picture to explain. If there are any mistakes, I hope you can correct them and share them with us for the purpose of mutual discussion. First of all, let's introduce the source
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
How to operate MySQL database instances using JSP
I. Overview
Before starting the introduction, let's talk about why we should write this article. I personally think that as an O & M engineer, we should be familiar with the knowledge network, not
1: persistence is not enabled in the redis Master/Slave environment;When the master instance goes down, data from the instance is not affected;After the master instance recovers, the data on the master instance will continue to be synchronized to
Case:To reduce the burden on the core database, we adopt the logical STANDBY technology to separate the impact of physical reading on the core database. However, a report application uses a large number of intermediate tables. Generally, the basic
650) this. width = 650; "border =" 0 "alt =" "src =" http://www.bkjia.com/uploads/allimg/131229/1U0143T8-0.jpg "/>
Nosql leads us into a new database world. Literally, we should not regard it as "No SQL ", it should be correctly understood as "Not
Summary of MySQL query table data size
I. Data size of mysql tables
We know that mysql generally uses table space storage to store data files.
When mysql uses the innodb Storage engine,
Mysql uses table store data in two ways:
I created a storage process for sending emails a few days ago and wanted to automatically send the daily running status of the database to my mailbox. I did not expect the problem to occur the next day, A large number of xxx_j000_xxx.trc files are
These days, it was too busy. The provincial leaders on the 12th wanted to check the progress, so the project team was really a mess. Get off work at every night, and do not rest at noon. Learning over time has become a luxury. Over the past few days,
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
In general, DBA should focus on the SYSTEM, SYSAUX, UNDO, TEMP, and SYSTEM tablespaces in addition to the tablespace where business data is stored, the size of the UNDO and TEMP tablespaces is determined by the business conditions of the database.
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
SCN: System Change Number
SCN is a logical internal timestamp of the Oracle database, used to identify the version submitted by the database at a specific time. When a transaction is committed or rolled back, it is assigned a unique SCN that
One quiet afternoon, an AIX small machine with an ORACLE database in the test environment was shut down due to an unexpected power failure. In the test environment, an engineer was assigned to solve the problem. Specifically, the server was
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.
MySQL databases have been applied to many Internet companies. mysql permission management is very important. Properly planning mysql database permissions is very beneficial to the security and use of databases. A good standard and habit will not
The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion;
products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the
content of the page makes you feel confusing, please write us an email, we will handle the problem
within 5 days after receiving your email.
If you find any instances of plagiarism from the community, please send an email to:
info-contact@alibabacloud.com
and provide relevant evidence. A staff member will contact you within 5 working days.