limitation of mysql database

"Development Environment"Physical machine Version: Win 7 Ultimate Edition (64-bit)MySQL version: Version 5.5.40MSI (64-bit)First, the database type:(1) Relational database(2) Object-oriented database(3) XML databaseThe current mainstream is the

The database design may only be based on the current business needs. It may not need high availability, high scaling, and other features at that time, but as the business and user volume increase, the infrastructure is gradually improved. This blog

A mature database architecture is not designed to have a high availability, high scalability, and so on, it is with the increase in user volume, the infrastructure is gradually improved. This blog post mainly discusses the MySQL database development

Overview replication is usually used to create a copy of the master node to ensure high availability by adding redundant nodes. Of course, replication can also be used for other purposes, such as reading and analyzing data on the slave node. In

MySQL master-slave replication principle and architecture, mysql master-slave architecture1 copy Overview The built-in replication function of Mysql is the basis for building large and high-performance applications. This distribution mechanism

MySQL master-slave Copy Data Summary1. Replication Principle As shown in 1.png:     The first part of this process is that the master records binary logs. Before each Transaction Completes data update, the master will record these changes in the

Database trigger details bitsCN. com1 introduction Like the stored procedure, Mysql triggers are embedded into a mysql program. The trigger is a new function of mysql5. Currently, the online Fengchao system, Beidou system, and Columbus system use

Guide to MySQL upgrade Http://blog.sina.com.cn/s/blog_5a8b8eb80100ld7a.html We recommend that you upgrade the version from one released version to another. For example, to upgrade MySQL 3.23 to MySQL 4.0, instead of directly upgrading to MySQL 4.1

Mysql master-slave replication principle and Configuration1 copy Overview The built-in replication function of Mysql is the basis for building large and high-performance applications. This distribution mechanism replicates data from a Mysql host to

Let's take a look at the basic features of MySQL: 1. Internal Components and portability Written using C and C + + Tested with a number of different compilers Able to work on many different platforms. See 2.1.1 "MySQL Supported