Mysql transaction processing details, mysql Transaction Processing
I. Mysql transaction concepts
MySQL transactions are mainly used to process data with large operations and high complexity. A logical execution unit consists of database operation sequences of one or more steps. These operations are either executed in full or abandoned. In MySQL, transactions are
Redis Learning Guide, redis
I. Introduction
Redis is an open-source log-type database written in ansi c language that supports Network, memory persistence, and high-performance key-value. It also provides APIs in multiple languages. Speaking of the Key-Value database NoSQL database, you can think of MongoDB.Similar to Memcached, Memcached supports more storage
Profile:Four characteristics of a transaction: atomicity, consistency, isolation, persistenceIssues caused by transaction non-isolation: dirty read, non-repeatable read, virtual read (Phantom Read)Level of Transaction Isolation: Serialization (111), Repeatable Read (110), Read committed (100), read UNCOMMITTED (000)1. Four features of the transactionIf a database
1. Installing RedisRedis does not have an official version of Windows, but the Microsoft Open Technology team (Microsoft Open Tech Group) develops and maintains this Win64 version.I downloaded this version of 3.0: https://github.com/MicrosoftArchive/redis/releasesDownload and then unzip. I unzip here to the D packing directory:1.1 Start the Redis server terminal program:Open the cmd command, enter the
2. Set up the Redis cluster environment; 2. Set up the redis Cluster
Reprinted from source: Http://www.cnblogs.com/hd3013779515/
I. Basic Concepts
1. A redis cluster is a facility for data sharing between multiple nodes. Redis clusters provide the following two benefits:1.1 automatically split data into multiple nodes1
There are three types of Java transactions: JDBC Transactions, JTA (Java Transaction API) transactions, container transactions. Common container transactions such as spring transactions, container transactions are mainly provided by the Java Application Server, container transactions are mostly based on JTA completion, which is a jndi based, rather complex API implementation. So this article does not discuss container transactions. This article mainly
Redis configuration details, redis details
Web programmer blog: http://blog.csdn.net/thinkercode
If it is a professional DBA, many parameters will be added when the instance is started to make the system run very stably, so that a parameter may be added after Redis at startup, you can specify the path of the configuration file to start the database by readin
redis's support for transactions is still relatively simple. Redis can only ensure that the commands in the transaction initiated by one client can be executed continuously without inserting commands from other clients. Redis processes all client requests in a single thread, so it is easy to do so. Generally, redis imm
Oracle Transaction Processing Mechanism explanation, oracle Transaction Processing Mechanism
I. Transaction Concept
Concept: transactions in databases are logical units of work. A transaction is composed of one or more SQL statements that complete a group of related behaviors, the
add the following configuration to the slave configuration file: slaveof 192.168.111.138 6379 #master_link_status:up, while my slave shows down, modify the Protected-mode in redis-conf to no .Transaction Management:Multi Open transaction Exec executes the command in the queue discard clears the command queue for the transact
scripts.2. Script Class RedisscriptRedistemplate provides a high level of support for scripting, and the execution method is similar to the previous one, all through the connection callback. However, it is important to note that the script does not support transactions, so the script can not be connection.multi () to open the transaction, or use the @transactional annotation to let spring to open the transaction
recovery,
Redis support (snapshot and AOF): It depends on snapshots for persistence. aof enhances reliability and affects performance.
Memcache is not supported and is usually used for caching to improve performance;
MongoDB 1.8 adopts the binlog method to support persistent reliability
6. data consistency (transaction support)
Memcache ensures consistency with cas in concurrent scenarios
About MySQL transaction isolation level and MySQL transaction isolation level
This article elaborates four concepts related to databases: transactions, database read phenomena, isolation levels, and lock mechanisms.
I. Transactions
Let's take a look at Baidu encyclopedia's definition of database transactions:
Perform a series of operations as a single logical unit, either completely or completely.
EF + Redis (StackExchange. Redis) implements distributed locks, which is feasible in self-testing. stackexchange. redis
E-commerce platforms will have a flash sale, for example, 1 yuan flash sale. The most important thing about flash sales is inventory. In many cases, if the inventory is not properly processed, the oversold status may occur.
This article uses
Spring entry (3) [transaction control], spring entry transaction control
The database needs to be operated during development, and the process of adding, deleting, and modifying operations is one operation. If you need to update multiple tables in a business, the update of any table fails, update of the entire business is a failure. In this case, tables that have been successfully updated must be rolled bac
1 Series Catalogue
The Distributed Transaction series (opening) raises questions and research processes
Distributed Transaction Series (1.1) Spring transaction manager Platformtransactionmanager Source analysis
2 JDBC Transaction2.1 Examplespublic void save(User user) throws SQLException{ Connection conn=jdbcDao.getConnection(); conn.setA
related information
Stats: General Statistics
Replication:master/slave Request Information
CPU:CPU Occupancy Information Statistics
Cluster:redis Cluster Information
Keyspace: Database Information statistics
All: Return all information
Default: Returns general settings information
If the command argument is empty, the info command returns all information.> info keyspace> info serverOperation:Introduction to Redis's advanced application experimentsBefore learning
applications, Redis segmentation is usually not considered. (see this very good article, "Running Redis" to learn more about Redis performance optimization and segmentation.) )Transactions in RedisRedis does not support full ACID transactions like a relational database management system, but its own transactions are also very effective. In essence,
There are four database isolation levels, as described in the high-performance mysql book:
Then let's talk about how to modify the transaction isolation level:
1. Modify the global settings, modify the mysql. ini configuration file, and add
Copy codeThe Code is as follows:# Optional parameters include: READ-UNCOMMITTED, READ-COMMITTED, REPEATABLE-READ, SERIALIZABLE.[Mysqld]Transaction-isolation = REPEATA
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.