MySQL cluster CGE telecom carrier-level version

As the Internet continues to expand, the amount of data in social networks, high-speed mobile broadband, and even M2M connections to more intelligent devices and machine-to-machine interactions are exploding.

With unparalleled scalability, high availability, and flexibility, MySQL clusters allow users to meet the database challenges of the next generation Internet, cloud, and communication services.

MySQL clusters provide you with the following benefits:

Auto-sharding, and therefore highly scalable write operations

The MySQL cluster automatically divides the table into different nodes, allowing the database to scale horizontally on low-cost commercial hardware to support large read/write tasks, it can be accessed through SQL or NoSQL APIs.

Fragments are completely transparent to applications. Applications can connect to any node in the cluster and automatically access the correct area through queries.

Because of the active/active multi-master architecture, updates can be performed on any node and can be immediately used to access all other clients in the cluster.

 
MySQL clusters have no single point of failure and have high fault resistance.

Unlike other sharded databases, when performing queries or transaction processing in different regions, you do not have to lose the JOIN operation or sacrifice ACID guarantee.

MySQL clusters can also replicate data in different data centers, improving disaster recovery and global scalability. Using its conflict processing mechanism, each cluster can be active and can be updated while maintaining consistency between different locations.

Availability of 99.999%

The MySQL cluster has a distributed and non-shared architecture that delivers 99.999% availability. This ensures strong fault recovery capability and the ability to perform scheduled maintenance without downtime.

Prevent operation interruption:

• Synchronous replication-data in each data node is synchronized to one or more other nodes. When a data node fails, other data nodes always store the same information.
• Automatic failover-the MySQL cluster's "Heartbeat" mechanism can immediately detect any faults and automatically perform failover to other nodes in the cluster, which is generally completed within one second, the client service will not be interrupted.
• Self-recovery-Failed nodes can be automatically restarted and re-synchronized with other nodes before re-joining the cluster to achieve self-recovery. In this process, the application is completely transparent.
• No shared architecture and no spof-each node has its own disk and memory, eliminating the risk of failure caused by shared components such as memory.
• Cross-region replication-cross-region replication enables the node to be mirrored to a remote data center for disaster recovery.

 
MySQL clusters have no single point of failure and have high fault resistance.

MySQL clusters also support online operations to prevent around 30% of the downtime caused by regular maintenance activities. These online operations include:

• Online Schema) Update.
• Online expansion of nodes to improve capacity and performance ).
• Online upgrades and patches for hosts, operating systems, and databases.
• Online backup.

SQL and NoSQL APIs

MySQL clusters allow users to integrate the best part of relational and NoSQL technologies in their solutions to reduce costs, risks, and complexity, including:

• NoSQL and SQL access to databases at the same time.
• Simple multi-master and Master/Slave replication enables failover and disaster recovery between the data center and the data center.
• Automatic partitioning and outward scaling between low-cost hardware.
• Online scaling and schema changes.
• Meets ACID Requirements and supports complex queries.

The MySQL cluster has multiple database interfaces, which provide developers with the maximum flexibility and can quickly access local tables by bypassing the SQL layer. Each SQL and NoSQL API can be used in the same dataset at the same time.

 
SQL and NoSQL APIs of MySQL Clusters

The MySQL server provides an industry standard SQL interface to connect to the cluster, which is used to run complex link queries and provides connections for all standard MySQL connectors, including:

• Daily web development languages and frameworks, including PHP, Perl, Python, Django, Ruby, and Ruby on Rails.
• JDBC is applicable to special connections to ORM, including javasselink and Hibernate ).
• . NET, ODBC, etc.

MySQL clusters also support the selection of NoSQL APIs:

• Use simple Key-Value) Memcached API Memcached for Web Services.
• YSQL Cluster Connect for Java (ClusterJ & Cluster JPA) is used to Connect to enterprise applications.
• C ++ NDB APIs are used for real-time emergence and location-based Internet and telecommunications services ).
• Apache mod_ndb for local HTTP/REST access.

Real-time performance

The MySQL cluster provides real-time response time and throughput to meet the requirements of the most stringent Internet, telecom, and enterprise applications.

Multi-site cluster with cross-region replication function

Cross-region replication allows multiple clusters to be distributed in different locations, improving disaster recovery and global Internet service scalability.

Line Extension and Schema upgrade

To support continuous operation, the MySQL cluster allows you to add nodes and update content online to the running database Schema. Therefore, it supports fast change and highly dynamic tasks.

MySQL Cluster Manager

To provide new and highly available services at the lowest cost, administrators must do the most with the least amount of resources. The MySQL Cluster Manager simplifies the creation and management of MySQL cluster telecom carrier-level version databases by automatically executing daily management tasks.

In this way, Database Administrators and System Administrators can work more efficiently, focus more on strategic IT activities, and respond faster to changing user requirements. At the same time, it can greatly reduce the risk of database downtime caused by manual configuration errors.

The MySQL Cluster Manager has three core capabilities to help administrators improve efficiency and simplify management.

• Automated Management.
• Monitoring and self-recovery.
• High Availability operation.

MySQL Cluster Manager is part of the commercial MySQL cluster telecom carrier-level version database.

24x7 Technical Support

MySQL Technical Support Service provides 24x7 expert-level MySQL support engineers who can help you develop, deploy, and manage MySQL applications.

Learn more: http://www.mysql.com/products/cluster/