MySQL read/write splitting using MyCAT

MySQL read/write splitting using MyCAT MyCAT is a database middleware developed based on Alibaba's open-source cobar product. It is jointly developed and open-source by several talented people with lofty ideals. Provides highly available data

SQLite3 simple operation

SQLite3 simple operationDirectory 1. Create Database Files 2. operate in the sqlite3 prompt Column 3. SQL command format 4. Create a data table 5. Create an index 6. Add a document 7. query data 8. How to change or delete Materials 9 other

About Replication in redis

About Replication in redis I. Introduction Redis's replication mechanism allows slave to transmit copies from the master over the network to complete data backup. It has the following features: Asynchronous replication One master, multiple slaves

Oracle sets a scheduled task JOB to schedule and execute stored procedures or PL/SQL code blocks

Oracle sets a scheduled task JOB to schedule and execute stored procedures or PL/SQL code blocks Currently, there are two methods for configuring scheduled job Scheduling in Oracle Database: dbms_scheduler to create job scheduling and dbms_job to

MySQL monitoring tool-orzdba

MySQL monitoring tool-orzdba Source code: http://code.taobao.org/p/orzdba/src/trunk/[Root @ bkjia servers] # chmod + x orzdbaConfigure your MySQL verification information in line 1 of the Code: username, password, socket, host, port[Root @ bkjia

Install MySQL 5.7.9 through source code compilation

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

Implement master-slave synchronization between two MySQL Databases

Implement master-slave synchronization between two MySQL Databases I. OverviewMySQL versions later than 3.23.15 provide the database replication function, which enables the synchronization, master-slave mode, and mutual backup of two databases.II.

Using Redis as a time series database: Reasons and Methods

Using Redis as a time series database: Reasons and Methods Since the emergence of Redis, it has been used in the storage and analysis of time series data to a certain extent. Redis was initially implemented as a buffer for logging. With the

MySQL displays the name of the connected database

MySQL displays the name of the connected database By default, MySQL does not display the name of the connected database when using databasename!Mysql> show databases;+ -------------------- +| Database |+ -------------------- +| Information_schema ||

Ubuntu 10.10 Oracle 10g Installation Guide

Ubuntu 10.10 Oracle 10g Installation Guide Ubuntu 10.10 Oracle 10g Installation Guide Step 1: Download The oracle10 installation package (server and

Use Linux commands to filter out the complete SQL statements in binlog

Use Linux commands to filter out the complete SQL statements in binlog DB: MySQL 5.6.16CentOS: CentOS release 6.3 (Final) How to extract the complete insert statement when an insert statement is input across rows using spaces! Create an empty

Connect Python to the MySQL database

Connect Python to the MySQL database Create Database Connection import MySQLdbConn = MySQLdb. connect (host = "localhost", user = "root", passwd = "sa", db = "mytable ") Common parameters includeHost: The host Name of the connected database server.

MySQL has more slave database logs than the master database

MySQL has more slave database logs than the master database When chatting in the Group, a group member said that the master database of the MySQL production database is down, but the data of the master and slave databases is consistent, but the

How can I test your MongoDB application upgrade?

How can I test your MongoDB application upgrade? You have selected MongoDB as your application database. You may already have a large amount of production data in your database. Now you need to make a major version change to your application. How do

In CentOS Linux, MySQL databases are automatically backed up every day.

In CentOS Linux, MySQL databases are automatically backed up every day. In CentOS Linux, MySQL databases are automatically backed up every day. 1. Create the following three folders on the server: mkdir/bak, mkdir/bak/bakmysql, mkdir/bak/bakmysqlold.

Install MySQL 5.6.26 source code

gpg

Install MySQL 5.6.26 source code MySQL 5.6.26 source code installation package and cmake installation package link: http://pan.baidu.com/s/1eRsF4noOperating system version: CentOS release 6.3 (Final)Installation Process: (remember to mount the image

Upgrade to MySQL 5.7 to solve the partition problem.

Upgrade to MySQL 5.7 to solve the partition problem. Preface Some friends often ask, How is MySQL partition? Can I use it? Are there many bugs? I don't know why MySQL partitions have such an impression on the general public. However, in the

Ubuntu 10.10 Oracle 10g graphic tutorial

Ubuntu 10.10 Oracle 10g graphic tutorial Environment: Host XP, 3 GB memory, VMware: Ubuntu10.10, hard disk 30 GB, memory 1024 MB The installation of virtual machines is not described. 2. Update ubuntuSudo apt-get updateSudo apt-get upgradeOracle is

MySQL 5.7 new feature: Generated Column (function index)

MySQL 5.7 new feature: Generated Column (function index) MySQL 5.7 introduces Generated Column. This article briefly introduces the usage and precautions of Generated Column, and provides a quick and complete tutorial for readers to understand MySQL

Common Oracle and SDE maintenance commands-view tablespaces

Common Oracle and SDE maintenance commands-view tablespaces Previously, I reported a data update problem on the site. I thought it was caused by the full table space (the error was written in the previous blog article). Therefore, I remotely checked

Total Pages: 1013 1 .... 74 75 76 77 78 .... 1013 Go to: GO

Alibaba Cloud 10 Year Anniversary

With You, We are Shaping a Digital World, 2009-2019

Learn more >

Apsara Conference 2019

The Rise of Data Intelligence, September 25th - 27th, Hangzhou, China

Learn more >

Alibaba Cloud Free Trial

Learn and experience the power of Alibaba Cloud with a free trial worth $300-1200 USD

Learn more >

Contact Us

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.