MySQL Study Notes (6) scalability design-memcached

Source: Internet
Author: User
MySQL Study Notes (6) scalability design-memcached1. as a tool for improving system performance

The following figure shows a brief diagram of using memchched as the cache service layer:

It can be seen that all data needs to be inserted, updated, and deleted to the Master. If the master is updated or deleted, it will be deleted from memcached to maintain data consistency. When reading data, read data from memcached first. If the data cannot be read, read data from slave.

In fact, this method has little to do with Mysql itself, and can be implemented through applications.

2. Integrate with MySQL into the data service layer

We usually have two ways to implement this architecture:

1. Use memcached's memory capacity as MySQL's second-level cache to increase MySQL's cache capacity;

It can be implemented through an open-source project waffle Grid

2. MySQL communicates with memcached through udfs, and the client can directly interact with memcached.

In this way, memcached maintenance is handed over to the master

Related Article

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.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.