Database Administrator

MySQL semi-synchronous Replication MySQL supports semi-synchronous replication as a plug-in starting from MySQL5.5. How can we understand semi-sync? First, let's look at the concept of Asynchronization and full synchronization. Asynchronous

MySQL 5.5 upgrades the character set from utf8 to utf8mb4Reason for upgrade MySQL supports only three-byte UTF-8 characters by default, and does not support Emoji emoticons (four bytes). If there are four-byte characters, an error is returned. MySQL

Mysqldump -- master-data parameter for Fast deployment of master-slave Replication Mysqldump -- help-- Master-data [= #] This causes the binary log position and filename to beAppended to the output. If equal to 1, will print it asChange master

Oracle 10gR2 enables asynchronous IO under RHEL 5 Record the steps for enabling asynchronous IO for Oracle 10gR2 under RHEL 5 Platform: RedHat Enterprise Linux 5 64bit, Oracle 10gR2 10.2.0.4 64bit 1. First install the following necessary rpm

Oracle graphical and command line installationOracle Installation version description Different Versions of Oracle must be installed on a specific system version.For example, 11.2.0.1.0 of Oracle 11gR2 needs to be installed in CentOS 5.X and RHLE

C-Basic redis cache access Introduction Let's talk about redis installation. The environment used here is. Linux version 4.4.0-22-generic (buildd@lgw01-41) (gcc version 5.3.1 20160413 (Ubuntu 5.3.1-14ubuntu2) ) #40-Ubuntu SMP Thu May 12 22:03:46 UTC

MySQL 5.6.x semi-sync replication Configuration EnvironmentMaster Database: CentOS6.5 x64 192.168.0.65 mysql-5.6.29Slave Database: CentOS6.5 x64 192.168.0.66 mysql-5.6.29 Connection: MySQL 5.6 master-slave synchronization configuration case The

Detailed description of Redis info Parameters The official Redis website has clearly explained info. Refer to the documentation. As you can see, the output result of info is several pieces, including Servers, Clients, and Memory. You can specify a

How to automatically start PDB Pluggable Database in Oracle 12c PDB Pluggable Database is an important new feature of 12c, but for PDB in CDB, all PDB is not brought when CDB is started by default, in this way, we need to manually alter pluggable

In-depth analysis of MySQL logon principles The first step in using the MySQL database is to establish a connection and log on, and then execute the SQL command above. Whether it is through the MySQL client, or through the C-API, JDBC standard

Install MySQL on Redhat Linux On Linux, Mysql usually has three installation methods:Rpm InstallationGeneral Binary Package InstallationSource code installation packageThis article first introduces the RPM installation method. Here we will mainly

Oracle manages disk space and resources1. Recoverable space allocation 1.1 learn about recoverable space allocation Generally, we initiate a large database operation, such as creating a large table index. If the tablespace is insufficient, the

Install MySQL 5.7.9 through source code compilation Install CentOS 6.3Configure yum:[Root @ bkjia ~] # Cd/etc/yum. repos. d/[Root @ bkjia yum. repos. d] # mkdir[Root @ bkjia yum. repos. d] # lsA CentOS-Base.repo CentOS-Debuginfo.repo

Create an Oracle 12c user Oracle 12c accounts can be divided into public accounts and local users. A common account is created under CDB and can be used by all PDB users. A local account can only be created in PDB. Create a public userAlter session

Oracle 11g installation diagram and related dependent libraries in SUSE 11 Installation environment Linux Server: SUSE11-linux 64/32-bit Oracle Server: Oracle11gR2 64/32-bit System Requirements Memory: physical memory must be higher than 1 GB

How to install Redis in Linux Redis will be used in recent projects. We will share our learning experience with you during this period. This is a summary of the learning results during this period and technical refinement. I hope you can criticize

Notes for installing Oracle 11g RAC This article is only used to record some issues that occur during the installation of Oracle RAC at ordinary times. If you encounter minor issues, we will also add them.1. HAIP hosts file dual-inline Nic

Oracle Shared Server Configuration 1. Exclusive server (dedicatedserver) Each session is assigned a serverprocess independently. Resources occupied by the process are released only when the user disconnects. In most cases, sessions are idle, so

MyBatis is used to obtain the auto-generated primary key Id and instance code. MyBatis obtains the auto-generated primary key Id and instance code. When using a MySQL database, we generally use the auto-incrementing primary key of the database to

The method for assigning values to SQL fields unrelated to the business in the CRUD operation, crudsql Improving efficiency has always been an eternal topic. One of the topics in programming can also mention efficiency, that is, focusing on one