This is the 10th day of my participation in Gwen Challenge

I. Features and advantages of MySQL

What are the technical features and advantages of MySQL?

  1. MySQL Server + InnoDB Engine
  2. Plug-in engine idea, InnoDB, MyISAM, ArkDB.
  3. Mature Log mechanisms: REDO Log and Binlog.
  4. Unified file storage interface.
  5. Lightweight threading model.

What are the features and advantages of MySQL?

  1. Simple intervention, flexible programming.
  2. SQL is simple, convenient and fast.
  3. High popularity, large installation capacity.
  4. The community is active and open source is strong.

Ii. Future development direction

Technical development of MySQL

  1. Overall optimization of the optimizer to achieve parallel processing.
  2. Multiple engines coexist, changing the situation of one InnoDB support.
  3. Storage scalability, truly independent elastic expansion and distribution.
  4. InnoDB level optimizes storage structure and index organization to support large-scale data processing.

MySQL open source direction

  1. Modify the protocol to adopt a more lenient open source protocol, eliminating the worries of contributors.
  2. Establish an independent foundation to achieve independent management.
  3. Greater support for the open source community and surrounding open source software.

Three, demand pain point

1. Data islands, low value

Massive high-value data of enterprises are scattered in various business systems. In the early stage, due to the lack of data standards, data interfaces are complicated and varied, which makes it difficult to centralized and integrate uniformly.

2. Difficult data exchange and high cost

Traditional information technology has many isolated islands, high cost of data supply and low application efficiency. Database and data system lack unified management and unified scheduling. Information system architecture is complex, data processing software is abundant, technical barriers restrict development.

3. Data fusion, benefiting the old and innovating

There are many data sources and access modes (JDBC, ODBC, API, direct connection, text file), many database types (Oracle, MS, ArkDB, MySQL, DM, Avatar, Jincang, NTNU General, big Data), and the data development is not standardized.

Iv. Solutions

1. Use existing advanced experience

TTS mode is a data service platform independently developed by Ctrip Qunar, which can guarantee the security of users’ transaction funds, ensure the security of users’ information and privacy, provide a variety of products, easy to use interface, convenient operation, and support a variety of payment methods. The advantage of TTS for consumers lies in the unified user experience and transaction security. Consumers don’t have to re-enter information and learn the rules of presentation on various sites.

2. Adjust the solution architecture

Unified data processing API service layer, based on the data API data processing, again by API management cockpit, unification authentication, API authentication, fault isolation, API current limiting, access control, data format, data validation, service monitoring alarm, make use of the service registry, service control center, service center, service center of release unified management. Distributed database for reference at the same time, complete the calculation, engine layer, storage layer, the management of functional division, ensure that the data transparent replication, distributed storage, elastic expansion, snapshot backup, data redundancy and high availability cluster management, overload protection, installation, deployment, daily monitor, screen display, such as customization demand.

MySQL’s deep technical and market history has established it as the absolute leader in the open source space. In addition, the MySQL ecosystem has proven that open source technology is flourishing, better supporting more business needs, understanding and adhering to open source agreements, and technology is free to open source and business.