Database Administrator

MySQL read/write Splitting Based on Amoeba in CentOS Note: This configuration is based on CentOS 6.4_x86. Both MySQL servers are source code compiled (version 5.6.24), And amoeba proxy is version 2.2.0. Server Use Ip

Install and deploy Redis in Linux I recently learned about redis and also recorded the learning summary in this article. This article mainly describes how to install the redis service in Linux.1. Redis Introduction Redis is a non-relational

MySQL backup script for database/table sharding 1. Database shard backup: #! /Bin/sh MYUSER = root MYPASS = 123456 SOCKET =/data/3306/mysql. sock MYLOGIN = "mysql-u $ MYUSER-p $ MYPASS-S $ SOCKET" MYDUMP = "mysqldump-u $ MYUSER-p $ MYPASS-S $ SOCKET-

Use SQL to split and combine data in the database Using SQL to split and combine data in a database provides the following solutions: Method 1: With cte (Select a. Id, A. [Uid], UserName FROM (Select a. [id], REPLACE (Split. a. value ('.', 'nvarchar

Install the database Oracle client in Ubuntu 16.04 Install the Oracle database client in Ubuntu 16.04 to connect the Django project to a remote Oracle database. 1. Download the oracle client installation package: Go to

MySQL 5.6 locking users MySQL 5.7 has the same account lock function as Oracle, but MySQL 5.6 does not seem to have it, but it can be used in the following way to set password expiration. The mysql. usertable now has a password_expiredcolumn. Its

New Features of Oracle 12C-Extended Data Types New Feature of Oracle 12C-extended data types. In 12c, compared with earlier versions, data types such as VARCHAR2, NAVARCHAR2, and RAW are extended from 4 K and 2 K bytes to 32 K bytes. As long as

Principle and Practice of MySQL master-slave Replication MySQL master-slave ReplicationMySQL master-slave replication copies the SQL command set originally created and modified databases to the slave database, and re-executes these SQL commands

Install and start MySQL in LinuxI. Comparison of various MySQL installation methods In Linux, MySQL has three major installation methods: RPM installation, binary installation, and source code installation. The advantages and disadvantages of the

Use mysqldump to export a database (table) Mysqldump is used to back up databases or migrate data between different databases. The backup content of mydqldump includes SQL statements used to create and load tables.I. How to Use mysqldump (1) Back up

Reading the return values of Oracle functions using Python Create a function in Oracle to return an index table. When we thought that the text could also transmit information, we suddenly came to the inspiration and set the return value to the text

Two solutions to ORA-30078 errors Recently encountered a ORA-30078 error while trying to create a partition table, prompting "ORA-30078: partition limit must be TIME/timestamp with time zone text", why is it difficult. First, I create a test table

Install MySQL on Ubuntu Server 16.04 and set Remote Access I. Install MySQL on Ubuntu Server 16.04 1. Use the root account Sudo apt-get install mysql-serverApt-get isntall mysql-clientApt-get install libmysqlclient-dev If there is a problem in the

MySQL 5.6 -- dump-slave parameter usage In MySQL 5.5 and later versions, a parameter "dump-slave" is added. With this parameter, we can export data on the slave node to create a new slave to avoid pressure on the master database. The method is as

Install MySQL5.7.13 in CentOS 6.8 using a common binary method Installation environment: CentOS 6.8Objective: To install MySQL5.7.13 using the Generic Binary (Generic Binary) MethodRequired Software: mysql-5.7.13-linux-glibc2.5-x86_64.tar (Please

Steps for upgrading to MySQL 5.6.19 Steps for upgrading to MySQL 5.6.19 Pre-upgrade version check + test table Creation [Root @ localhost ~] # Mysql-uroot-p123456 -- socket =/var/lib/mysql/mysql3307.sock -- port = 3307-e "create database lottery;

Three methods of MySQL backup The main function of MySQL backup is to quickly, efficiently and securely solve problems in the case of hardware faults, software faults, natural disasters, hacker attacks, and human error, so as to avoid unnecessary

A small example of how PL/SQL implements the split () method in Java As we all know, Java provides the split () String segmentation method for the String class, so it is easy to split the String into a String array using the specified symbol.

MySQL semi-synchronous replication implementationI. Why do I need semi-synchronous replication? MySQL replication is asynchronous by default. After the Mysql Master Server transfers its Binary Log through the replication thread, the Mysql Master

Problems and Solutions for installing nexus private server in Maven nexus, mavennexus 1. When installing nexus in win10, the system prompts: wrapper | OpenSCManager failed-Access denied. (0x5) The primary reason is that you do not have permissions.