35 results about "Mysql cluster" patented technology

The invention discloses a method for setting a static IP (Internet Protocol) in Pod in Kubernetes. The method comprises the following steps: firstly, a Pod network management function is realized based on a Kubernetes cluster platform, and when workflows such as container network creation, container IP distribution, container IP recovery and the like need to be realized, if the container network needs to be created through the network management platform, the method relates to the technical field of system framework construction. According to the method for setting the static IP in the Pod inthe Kubernetes, the static IP is set; a Mysql cluster 5 is queried; a specified container network configuration is acquired; the corresponding IP record in the Mysql is updated; the fact the Pod IP record has been used is identified; meanwhile, a query result is returned to the network plug-in; after the network plug-in receives the network configuration of the container, a Network Namespace technology of Linux is adopted to switch to a Network Namespace of a container, the specified network configuration is configured for the container, and the use mode of the Pod IP is fixed, so that the efficiency of migrating the application to the Kubernetes cluster can be improved, the maintenance cost is reduced, and the method and the system are compatible with the modes of deploying the application and operating and maintaining the application by a user to the greatest extent.

The invention discloses a semantic-based hadoop system. The system comprises a data acquisition and loading component, a real-time data stream processing component, a storage system component, a bottom layer support component and a business layer component, wherein the data acquisition and loading component is used for data source detection, Internet data acquisition and HTML (hypertext markup language) preprocessing as well as third-party data resource access, the real-time data stream processing component is used for real-time processing of data streams; the storage system component is used for storing Hadoop clusters and mysql clusters; the bottom layer support component is used for extracting semantic information from text and supporting other services in need of semantic extraction and semantic analysis blocks and related to processing and text retrieval, text processing and semantic search and text processing; the business layer component is used for specific business execution, scheduling and presentation and application sets closely related to specific applications. The system realizes web-based hadoop, and is high in accuracy, rich in provided semantic information, highly practical and industrialized.

The invention particularly relates to an automatic MySQL cluster deployment system and method. According to the MySQL cluster automatic deployment system and method, a database cluster adopts a one-master multi-slave architecture, and all internal connections adopt an SSL encryption mode; a service provided by a Kubernetes system is adopted to provide load balancing, and the size of a cluster is dynamically adjusted according to the number of copies based on a container service provided by the Kubernetes system. According to the MySQL cluster automatic deployment system and the method, the number of cluster nodes can be dynamically adjusted according to the service volume and the service peak value, the service stability is guaranteed in the service peak period, resources are released in the service low peak period, the availability of a database system is improved, and the resource utilization rate is increased; and meanwhile, the node communication encryption mode in the cluster ensures the security of data and the system. Therefore, the problems of database connection security and dynamic cluster size adjustment are solved.

The invention discloses a MySQL master-slave cluster installation and deployment method and a cluster system, belongs to the technical field of cluster deployment and installation, and aims to solve the technical problem of how to quickly and automatically install and deploy MySQL clusters. The method comprises the following steps of: deploying servers for installing MySQL, and verifying the network connectivity of the servers; preparing a data directory/var/lib/mysql for each server, and initializing the data directory/var/lib/mysql; initializing a user; initializing other running scripts foreach server; setting a MySQL configuration file of the servers; configuring a Slave slave node server, enabling the data between the Slave slave node server and a Master master node server to be automatically synchronized; and starting other running scripts of each server. The system comprises a plurality of servers; and the MySQL master-slave cluster is installed and deployed through the method.

The invention provides a software deployment method based on a Kubernetes platform, and the method comprises the steps that a MySQL cluster is deployed on the Kubernetes platform, and the Kubernetes platform comprises a master node and a slave node; mHA software is provided, connection between the Kubernetes platform and the MHA software is established, and the MHA software comprises a management node and a plurality of database nodes; selecting a database master node from the plurality of database nodes in response to a request of a user for accessing the database; generating a master node label and a slave node label of the Kubernetes platform according to the information of the master node and the management node of the database; and controlling the MHA software to send a service request to the Kubernetes platform according to the master node label and the slave node label of the Kubernetes platform. According to the method, the MHA is transplanted to the Kubernetes platform, comprehensive containerization is carried out on enterprise applications, and the resource utilization rate and the operation and maintenance efficiency are improved.

The invention discloses a method and a device for detecting MySQL operation information. The method for detecting MySQL operation information includes: using a long connection mode to periodically detect the MySQL, caching the detection result of each period, and extracting the detection result from the cache when receiving a detection request. The method and the device for detecting MySQL operation information are capable of guaranteeing the normal detection even if the load of the MySQL to be detected is high or the concurrency of a system network with the device is large, enable the detection persistence and stability to be improved, and are especially suitable for the cluster monitoring operation of the MySQL with higher reliability requirement.

The invention discloses a system and method for ensuring high availability and consistency of an MHA cluster and belongs to the technical field of database management. The technical problem to be solved by the invention is how to avoid the problem that the MySQL cluster cannot be normally switched due to simultaneous failure of the MHA and the MySQL cluster. According to the technical scheme, thesystem comprises a Redis cluster used for providing a published lock and configuring global notification issuing capacity; an MHA module used for registering an exclusive lock in the Redis cluster when disaster recovery switching is executed, preventing other MHA instances from executing disaster recovery switching operation at the same time, pushing the switched MHA instances to the Redis clusterand releasing the lock; an MHA module based on an MHA native tool, and locking, releasing and configuration pushing functions of an exclusive lock are achieved at two user-defined scripts of a segment _ check _ script and an ip _ failover _ script; and a configuration manager used for ensuring that the local configuration of the MHA node is consistent with other MHA moments.

The invention relates to the technical field of the Internet, in particular to a data processing method and apparatus. A manufacture module and a table storage module are preset, a cold standby serveris determined from the MySQL cluster's slave servers, through the producer module of the cold standby server to parse the binlog file to obtain the binlog parsing data, by analyzing the binlog parsing data, the table structure information is obtained and stored in the table storage module; when the message entity is outputted, the binlog parsing data and the corresponding table structure information in the table storage module are encapsulated into the message entity and outputted. The scheme of the invention obtains and parses the binlog file by bypass mode, does not increase the burden of MySQL cluster, ensures the integrity of the data, and enriches the content of the data at the same time.

The invention relates to a data processing technology, and provides an automatic deployment method and device based on a MySQL cluster, computer equipment and a storage medium. The method comprises the steps of determining a master server, and obtaining a target slave server set located in the same MySQL cluster as the master server; establishing heartbeat connection between the master server and each target slave server in the target slave server set; receiving and analyzing a first heartbeat packet sent by the target slave server to the master server, obtaining an installation data directory corresponding to the target slave server, and the installation data directory being used for deploying a preset file; sending a second heartbeat packet to the target slave server, the second heartbeat packet carrying the preset file, and deploying the preset file to the installation data directory; when it is monitored that deployment of the preset file is completed, obtaining target state information of the main server; and automatically synchronizing the state information in the target slave server according to the target state information. The deployment efficiency can be improved, and rapid development of a smart city is promoted.

The embodiment of the invention provides a database backup method and device based on openstack, and the method comprises the steps: obtaining a backup task of a MySQL database from a meta-database through a task manager deployed on a server in a daemon process mode; sending the backup task in the task manager to a guest deployed in each MySQL database in a message queue manner through a remote procedure call protocol rpc; and obtaining a backup task of the MySQL database connected with the guest through the guest, executing the backup task, and updating a backup state at the same time. According to the technical scheme, the mass MySQL cluster backup device is low in research and development cost, high in research and development efficiency and high in expandability, unified management ofbackup tasks and intelligent scheduling of the backup tasks can be supported, and personalized backup strategy requirements of services can be flexibly met.

The embodiment of the invention discloses a container scheduling method and device, electronic equipment and a medium, and relates to the technical field of cloud computing. The method is realized on the basis of a Kubernetes platform, and comprises the following steps of: developing a MySQL-Operator controller according to a set service logic by using a CoreOS KubernetesOperator Framework; deploying an Orchestrator cluster in a Kubernetes Global cluster; and establishing a communication connection between the Orchestrator cluster and the MySQL-Operator controller, so that the Orchestrator cluster obtains construction data of a MySQL instance cluster through the MySQL-Operator controller, and carrying out high-availability management on the MySQL instance cluster. According to the scheme, the problem that the Kubernetes platform does not realize the enterprise-level support capability of the MySQL cluster is solved, so that clustering, stateful and data persistence are realized on the Kubernetes platform, and the capability of multiple clusters in a large-scale deployment scene is provided.

The invention discloses an MOM system automation equipment data interaction integration platform and method based on an OPC UA protocol, and relates to the technical field of industrial intelligent manufacturing. The problems that in an existing MOM system, communication protocol standards of field devices are inconsistent, and message blockage is likely to occur in the real-time data communication process are solved. According to the MOM system automation equipment data interaction integration platform based on the OPC UA protocol, the upper layer is a Kafka and MySQL cluster, the middle layer adopts an OPC UA Client to build a framework, and the bottom layer adopts a KepServerEX to build an OPC UA server. The data interaction between the KepServerEX and the application program is realized through an OPC (OLE for Process Control) protocol. The platform is communicated with the PLC equipment through the KepServerEX, and the application program is connected with the KepServerEX through an OPC (OLE for Process Control) protocol. According to the OPC UA Client, an OPC UA Client Driver is adopted, so that two OPC servers on the same network are connected through a VPN (Virtual Private Network) or the Internet, and a tunnel is created between the two OPC servers. The system has a unified framework, is an open platform, is high in expandability, and is suitable for the field of industrial intelligent manufacturing.

The invention discloses a method and a system for realizing an MYSQL cluster. The method comprises the following steps: setting up a load scheduling layer on a Linux server, generating a virtual node, and providing a unified external entrance; using the load scheduling layer to obtain current total number of SQL nodes in connection of an SQL layer according to a weighted least connection scheduling algorithm, to perform weighing calculation and to send the latest connection to an SQL node with the minimum weight in the SQL layer; and checking the states of double computers of the load scheduling layer through keepalived, and when a host in the double computers has failure, enabling a slave computer to provide scheduling service. The method disclosed by the invention is used for realizing high availability of a database in various aspects and load balance in an inquiry process, and meanwhile, double management nodes are configured so as to prevent a single-node failure problem.

The invention discloses a control processing method and device for multiple sets of clusters and computer equipment, and relates to the technical field of distribution. The method comprises the following steps: firstly, acquiring an MHA global configuration file of each set of MySQL cluster; respectively renaming the MHA global configuration file of each set of MySQL cluster; adding address information of respective corresponding MySQL clusters into configuration items of target scripts used for controlling switching of master and slave nodes of the MySQL clusters in each renamed MHA global configuration file; and executing the target script in each MHA global configuration file, and controlling the master node and the slave node in each set of MySQL cluster corresponding to each piece of address information to perform master-slave switching. According to the invention, one set of management node can effectively manage multiple sets of MySQL clusters, and the resource waste of the management node is reduced. Moreover, the invention also relates to a blockchain technology, and the modified MHA global configuration file data can be stored in the blockchain to ensure data privacy and security.

The invention discloses an autonomous capacity expansion and shrinkage method for a cloud native MySQL cluster. The method comprises the steps of collecting a plurality of resource indexes of container resources and a plurality of performance indexes of a database; if the resource index exceeds the pre-configured resource threshold range, modifying the resource limitation of the container resource based on the resource index, and adjusting the performance parameter of the database; and if the performance index exceeds the pre-configured performance threshold range, automatically modifying the resource limitation of the container resource or automatically adjusting the number of nodes of the database cluster based on the performance index. The technical problem that when a database cluster needs to be expanded and shrunk in the prior art, a user needs to manually adjust resource configuration and manually adjust database parameter configuration, and a large amount of energy and time of the user are consumed is solved.

The embodiment of the invention provides a MySQL fault switching method and device based on a sentry mechanism. The method comprises the steps that MySQL main library nodes are periodically monitoredthrough sentinel nodes, and when one sentinel node finds that the MySQL main library node breaks down, other sentinel nodes are required to judge whether the MySQL main library node breaks down or not; if the number of the sentinel nodes exceeds the set number, the MySQL main library node is determined to fail, and a resource information score value given by each sentinel node according to the resource information of the corresponding MySQL cluster library node is obtained; a MySQL cluster library node with the highest copying speed is determined, and a difference log of a copying point position of the MySQL cluster library node with the highest copying speed is copied to each MySQL cluster library node and executed; and the MySQL cluster library node with the maximum resource informationscore value is determined as a new MySQL main library node, and metadata are modified. According to the technical scheme, the information acquired by the machine information is comprehensively judgedthrough a sentry mechanism, and the MySQL node most suitable for becoming a new master node is selected.

The invention relates to the technical field of data storage, in particular to a distributed file storage method based on ShardingSphere and Fastdfs (Fastdfs). The invention provides a distributed file storage method based on ShardSphere and Fastdfs, a distributed file storage architecture is formed by integrating components of a sub-library, a sub-table, a database and the Fastdfs, a file service API (Application Program Interface) is developed on the basis of the architecture, functions of storage, query, deletion and the like are provided, the storage function mainly uses a Fastdfs cluster to realize distributed storage of massive files, and the distributed file storage method has the advantages of being simple in structure, convenient to operate and high in practicability. And the query and deletion function mainly realizes the query and deletion of the file through massive file meta-information stored in the ShardingSphere and Mysql cluster. Distributed storage realized by the method mainly comprises a file data storage cluster based on Fastdfs, a database cluster based on ShardingSphere middleware and Mysql file meta-information storage, and a cluster based on Nginx and application service, and distributed expansion and load balancing can be realized from a data layer and a service layer.

The invention provides a call number circulation processing method based on a call center, and belongs to the technical field of call number flow processing of the call center. The method uses distributed deployment of a database and a redis cluster, the call number is processed by a mysql cluster, the redis cluster is asynchronously inquired and inserted, and an echelon level recovery algorithm is used. On one hand, the problem of working continuity of the telephone operator is solved, a good and appropriate calling speed is controlled, the working enthusiasm of the telephone operator is improved, and the overall number circulation efficiency is improved; and on the other hand, the problem of the utilization rate of the mobile phone numbers is solved, different algorithms are adopted according to different conditions in marketing failure, the numbers are recycled according to gradients, and the numbers are dialed after days of the corresponding gradients, so that the waste of the mobile phone numbers is avoided, the disgusting of an owner is avoided, and the service success rate is increased.

The application discloses a ProxySQL automatic operation and maintenance system and method, corresponding equipment and a storage medium. The ProxySQL automatic operation and maintenance system and method are used for operation and maintenance of a ProxySQL cluster; the ProxySQL cluster comprises multiple sets of ProxySQL and communicates with a MySQL cluster; and the system comprises a monitoringservice module deployed in each ProxySQL and used for determining the health condition of a ProxySQL node and determining the health condition of the MySQL cluster, a health service module used for determining whether the ProxySQL main node is available or not according to the health condition of the ProxySQL and the health condition of the MySQL cluster, and a node migration module used for responding to the situation that the ProxySQL main node is not available, pushing a new main node, and switching the virtual IP of the ProxySQL cluster to the pushed main node. According to the invention,automatic configuration, operation and maintenance of ProxySQL can be realized, and risks caused by misoperation are reduced.

The invention particularly relates to a public network access restriction method and system for a public cloud MySQL cluster. According to the public network access limiting method and system for the public cloud MySQL cluster, an elastic public network IP is created on the public cloud, the elastic public network IP is bound to an elastic network card, and meanwhile the elastic network card is bound to a Master node virtual machine of the MySQL cluster; when the MySQL cluster breaks down and the Master node is abnormal, a MySQL cluster disaster recovery mechanism is triggered to conduct master-slave switching, meanwhile, the elastic network card is unbound from the old Master node, after master-slave switching, the elastic network card is bound to the new Master node, the elastic public network IP migrates along with the elastic network card, and it is ensured that the public network IP can always access the Master node. According to the public network access limitation method and system for the public cloud MySQL cluster, public network access and IP and IP segment access limitation of the MySQL cluster are realized based on the public cloud, meanwhile, the public network IP and the MySQL cluster are high in availability, services can be normally provided after disaster recovery switching occurs, and the availability of a cloud database RDS MySQL and the use safety of a user are enhanced.

The invention discloses a method and a device for building a MySQL high-availability group, which can be used in the financial field or other fields, the method comprises the following steps: receiving a building request for the MySQL high-availability group, the MySQL high-availability group comprises a plurality of nodes, and the nodes comprise a master node and a slave node; for each node of the MySQL high-availability group, screening out all candidate scheduling clusters corresponding to the node from all current MySQL clusters according to a preset cluster screening rule, determining a to-be-scheduled cluster corresponding to the node according to the master-slave balance score of each candidate scheduling cluster, and establishing the MySQL high-availability group according to the to-be-scheduled cluster corresponding to each node. According to the invention, rapid deployment of the MySQL high-availability group is realized.