MySQL

A mature database architecture is not designed to be high availability, high scalability and other features, it is with the increase in user volume, the infrastructure is gradually improved. The development cycle of the database is broadly divided

MySQL Master-slave configurationConfigure to prepare the database to be configured for master-slave synchronization, the master-slave server must have the same databaseFirst, configure the MySQL master server[[email protected] ~]# vim /etc/my.cnf....

Resolve multiple Write Server Master self-growth ID duplication problemTwo MySQL servers, their IP addresses are:a:192.168.0.97b:192.168.0.98The databases are all test_3306.First, I'll post the My.ini for two servers.A:my.iniserver-id=2master-host=19

Environment Introduction:OS Version: RHEL5.5MySQL version: 5.5.40Reference Link: http://dev.mysql.com/doc/refman/5.5/en/time-zone-leap-seconds.htmlThere is a need: An attendance system, multiple APS distributed around the world, time must be in the 8

Implementation process:(1) Master changes the record to binary log (these are called binary log events, binary logs event);(2) Slave copies the binary log events of master to its trunk logs (relay log);(3) Slave redo the event in the trunk log and

What can MySQL do to remove spaces from a field character in bulk? Not only the space before and after the string, but also the space in the middle of the string, the answer is replace, using the MySQL self-contained replace function, plus a trim

I have long heard that the two commands, lock tables and unlock tables , literally know that the function of the former is to lock the table and the latter is to unlock it. But how to use, how to use, not very clear. Today, in a detailed study, we

Recently, their business to go online, after the launch, need to consider the various services to monitor, including (httpd services, mysqld services, etc.), now want to take mysqld services as an example to summarize the way the script is the most

MySQL installation (Windows) 1. Download the MySQL installation file1) Login to MySQL website (http://www.mysql.com)2) There are two types of installation format files, MSI and zip2. Installing the MSI type MySQL1) and install common software

MySQL master-slave replication is believed to have been used a lot, but because of the work of the reason has not been used. While this period of time is relatively idle, it will be realized again. Although there are a lot of similar articles on the

I. MySQL master-slave synchronizationScenario: one Master one fromA master more fromSlave (master) fromMaster slave172.30.13.8 Database service 172.30.13.191 database serviceThe database server on the slave role must have a library on the primary

MySQL relational database management systemMySQL is a relational database management system , developed by the Swedish MySQL AB Company, is currently owned by Oracle Corporation. MySQL's most popular relational database management system, MySQL is

MySQL Sequence UsageThe MySQL sequence is a set of integers: 1, 2, 3, ..., because a data table can only have one field self-increment primary key, if you want to implement other fields also automatically increase, you can use the MySQL sequence to

Transaction processing in various management systems have a wide range of applications, such as personnel management system, many synchronous database operations need to use the transaction processing. For example, in the Personnel Management system,

In the operation of MySQL, often need to convert characters into numbers, this step is simple, but not commonly used words are easy to forget, now will be found on the Internet The method is recorded as follows:1. Convert the number of characters to

Overview?? Indexing is one of the most common and important tools in database optimization. This article looks at the classification of indexes, the use of scenes, the inability to use scenes, etc.Index Classification?? The index is implemented in

First, in the Mac, MySQL installed, in order to use MySQL to start the MySQL service, then how to start by the terminal command line form? Here are 2 ways to do it:1.mysql Service Start/stop command: Sudo/usr/local/mysql/support-files/mysql.server

Use python on mac to operate mysql Databases To write a MySQL script with a DB-API, make sure that MySQL is installed. Copy and execute the following code: import MySQLdbIf the output result after execution is as follows, it means that you have not

Bind hive to a local mysql database I suddenly wrote an article about changing the hive metadatabase from the default local derby to bind to a remote mysql database. I flipped through the cloud notes and found that it was actually true, share it

Use of MySQL triggersOverview: When a specific database event occurs in a specific table, the trigger executes the corresponding SQL command.Syntax: The General Command for creating a trigger is as follows: CREATE [temp | temporary] trigger