Patents
Literature
Hiro is an intelligent assistant for R&D personnel, combined with Patent DNA, to facilitate innovative research.
35 results about "Mysql cluster" patented technology
Efficacy Topic
Property
Owner
Technical Advancement
Application Domain
Technology Topic
Technology Field Word
Patent Country/Region
Patent Type
Patent Status
Application Year
Inventor
Method for setting static IP (Internet Protocol) in Pod in Kubernetes
InactiveCN110750332AImprove efficiencyReduce maintenance costsSoftware simulation/interpretation/emulationEngineeringNetwork management
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.
Owner:广西梯度科技股份有限公司
Security and protection cloud platform
ActiveCN106303428AIncrease the number of concurrencyReduce use costClosed circuit television systemsTransmissionWeb serviceThe Internet
The invention discloses a security and protection cloud platform, and belongs to the technical field of security and protection. The platform comprises an IP camera, a client live streaming source, a handset live streaming source, an open storage cloud service, an on-demand client, an on-demand live streaming server platform, an IDM server cluster, a Web Service interface, a Web business server cluster, a Redis memory database, a MySQL database cluster and an ETS business server. According to the security and protection cloud platform, mature Nginx and Redis frameworks on the Internet are introduced, unification of system data is achieved by using the MySQL cluster technology based on P2Pdirect connection and forward automatic switching technologies, the system adopts a multi-domain mode to allow each user and equipment to be rapidly connected, thus being stronger in expansibility; the number of concurrent user is large, reaching a level of 20W and more per single server, and an Nginx plug-in is used for developing, so that the system is rapid in development and low in cost.
Owner:杭州蛮牛网络技术有限公司
Semantic-based hadoop system
InactiveCN104281697AInsight into dynamic trendsSolving Big Data Analytics ProblemsWeb data indexingSemantic analysisData streamData acquisition
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.
Owner:ANHUI HUAZHEN INFORMATION SCI & TECH
Automatic MySQL cluster deployment system and method
PendingCN111651275ALoad balancingGuaranteed stabilityResource allocationRelational databasesResource utilizationNode count
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.
Owner:山东汇贸电子口岸有限公司
MySQL master-slave cluster installation and deployment method and cluster system
PendingCN112035435ARapid deploymentImprove service responsivenessDatabase distribution/replicationProgram loading/initiatingSoftware engineeringDirectory
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.
Owner:SHANDONG LANGCHAO YUNTOU INFORMATION TECH CO LTD
Software deployment method and device based on Kubernetes platform
PendingCN114138754AMeet the requirements of fast deliveryCompliant with containerizationDatabase distribution/replicationRelational databasesSoftware deploymentMysql cluster
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.
Owner:安超云软件有限公司
Method and device for detecting MySQL operation information
ActiveCN103870377AGuaranteed detectionIncreased persistenceHardware monitoringComputer scienceMysql cluster
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.
Owner:SHENZHEN TENCENT COMP SYST CO LTD
System and method for ensuring high availability and consistency of MHA cluster
PendingCN111752962AImprove availabilityImprove consistencyDatabase updatingDatabase distribution/replicationHigh availabilityMysql cluster
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.
Owner:SHANDONG LANGCHAO YUNTOU INFORMATION TECH CO LTD
Data processing method and device
ActiveCN109145060AReduce the burden onAchieve zero intrusionDatabase distribution/replicationDatabase modelsCold standbyThe Internet
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.
Owner:TENCENT TECH (SHENZHEN) CO LTD
Automatic deployment method and device based on MySQL cluster and related equipment
ActiveCN113138882AReduce complexityAutomate deploymentDatabase distribution/replicationHardware monitoringSmart cityDirectory
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.
Owner:深圳赛安特技术服务有限公司
High-availability framework system for hidden danger troubleshooting data storage and implementation method thereof
PendingCN112685403AEliminate performance bottlenecksImprove responsivenessSpecial data processing applicationsDatabase indexingDistributed servicesData store
The invention discloses a high-availability framework system for hidden danger troubleshooting data storage. The high-availability framework system comprises an MYSQL cluster, an EUREKA service provider, an EUREKA registration center and an EUREKA service consumer. A REST service architecture is adopted to construct the frame system, and the EUREKA distributed service, the MYSQL cluster partition storage, the database data and the static text file are organically integrated and used, so that the problems that the access concurrency is too low, the access time is too long, the system is easy to crash and the like caused by large volume of hidden danger troubleshooting data are solved. In addition, the invention also discloses an implementation method of the system. In addition to the characteristics of high availability and flexible scalability of the existing system deployment storage, the method also has stronger cross-platform deployment capability and can support more database systems, and the availability of the system is not influenced by a single-node fault.
Owner:上海同是科技股份有限公司
Database backup method and device based on openstack
PendingCN111475333AReduce R&D costsQuick and unified managementRedundant operation error correctionEnergy efficient computingPersonalizationMessage queue
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.
Owner:新浪技术(中国)有限公司
Container scheduling method and device, electronic equipment and medium
PendingCN113312145ASolve the difficulty of achieving enterprise-level support capabilitiesAchieve clusteringSoftware simulation/interpretation/emulationLogisimMysql cluster
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.
Owner:CCB FINTECH CO LTD
MOM system automation equipment data interaction integration platform and method based on OPC UA protocol
PendingCN112764944ARealize data interactionImplement integrated managementInterprogram communicationData switching networksOLE for Process ControlPrivate network
Owner:HARBIN YULONG AUTOMATION
Mysql cluster online data redistribution method based on data redundancy and related equipment
PendingCN110427383APerformance is not affectedEfficient copy processDatabase updatingDatabase distribution/replicationData synchronizationTablespace
The invention discloses a mysql cluster online data redistribution method based on data redundancy and related equipment. The method comprises the following steps: receiving a data redistribution request; interrupting a change application of data synchronization between a first main data copy and a first standby data copy in the first node according to the data redistribution request; exporting the physical table space of the first standby data copy to generate a table space file, and respectively copying the table space file to a second main data copy and a second standby data copy of a second node; incrementally synchronizing incremental data stored in the first main data copy after a data synchronization change application is interrupted to the second main data copy and the second standby data copy respectively. According to the method, complex sql splicing conversion does not need to be carried out, the consistency of migrated data is guaranteed, and meanwhile the data redistribution efficiency is improved.
Owner:STATE GRID JIBEI ELECTRIC POWER COMPANY +4
Method and system for realizing MYSQL cluster
InactiveCN105227353ALoad balancingImprove availabilityData switching networksSpecial data processing applicationsWeighted least connectionHigh availability
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.
Owner:深圳市华验防伪科技有限公司
Control processing method and device for multiple sets of clusters and computer equipment
PendingCN112714022AEfficient managementReduce wasteDatabase updatingDatabase distribution/replicationControl setConfiguration item
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.
Owner:PINGAN PUHUI ENTERPRISE MANAGEMENT CO LTD
Autonomous capacity expansion and shrinkage method for cloud native MySQL cluster
PendingCN114153518AImprove the efficiency of capacity expansion and contractionProgram loading/initiatingSpecial data processing applicationsNode countData mining
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.
Owner:INFORMATION & COMM BRANCH OF STATE GRID JIANGSU ELECTRIC POWER +2
MySQL fault switching method and device based on sentry mechanism
PendingCN111831489AGuaranteed service qualitySmooth switchingRedundant hardware error correctionSentinel nodeResource information
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.
Owner:新浪技术(中国)有限公司
Distributed file storage method based on ShardingSphere and Fastdfs
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.
Owner:中电万维信息技术有限责任公司
Database intelligent management platform and management method thereof
ActiveCN111177116AReduce manual involvementLow costHardware monitoringEnergy efficient computingMetadata managementEngineering
The invention discloses a database intelligent management platform and a management method thereof, and relatles to the technical field of database intelligent management, and the database intelligentmanagement platform specifically comprises the following modules: a host management module, a mysql cluster installation module, a metadata management module, a host performance monitoring module, amonitoring data icon display module, an alarm management module, a mysql backup management module and a slow query management module. In order to improve the database management capability, the intelligent management platform is designed, daily database management work is simplified through the platform, manual participation is reduced, the efficiency is improved, the cost is reduced, the accuracyis improved, the machine utilization rate is increased, faults are detected and processed in time, and some common fault platforms automatically process the faults.
Owner:江苏艾佳家居用品有限公司
Call number circulation processing method based on call center
PendingCN113766071AImprove circulation speedSolve flow processing problemsSpecial service for subscribersTransmissionMobile Telephone NumberMysql cluster
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.
Owner:广州华工中云信息技术有限公司
ProxySQL automatic operation and maintenance system and method, corresponding equipment and storage medium
ActiveCN112328581AAvoid destructionReduce misuseDatabase management systemsDatabase distribution/replicationHealth outcomesMysql cluster
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.
Owner:望海康信(北京)科技股份公司
Data processing method and device
ActiveCN109145060BReduce the burden onAchieve zero intrusionDatabase distribution/replicationDatabase modelsCold standbySoftware engineering
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.
Owner:TENCENT TECH (SHENZHEN) CO LTD +1
A method of file collection and monitoring based on distributed
ActiveCN108881477BEasy and intuitive to useExtended collection applicationData switching networksMysql clusterDistributed computing
Owner:上海新炬网络技术有限公司
Large-scale CFD parallel computing method based on distributed mysql cluster storage
ActiveCN104036031BImprove development efficiencyReduce the chance of introducing bugsSpecial data processing applicationsComplete dataParallel computing
The invention provides a large-scale CFD parallel computing method based on distributed Mysqul cluster storage, and relates to communication between cooperating processes and data storage on multiple computing nodes. The large-scale CFD parallel computing method comprises the steps that the CFD process on each computing node be connected to a database through the fact that an API is driven by a Mysql, and initial data are acquired from a database to be used for computing; according to the CFD process, MPI protocol communication is used in the computing process, and the data or global reduction information on a zone boundary are / is exchanged; for data on each iterative step, the process is connected with a handle through the Mysqul to write the data into the database; after CFD parallel program computing is completed, Mysqul clusters are synchronized to obtain complete data in the computing process. Compared with an existing CFD parallel computing method, an open source Mysql database is fully used for achieving high performance and high reliability of data storage, and various information and data in the computing process can be flexibly and completely stored by CFD parallel programs. According to the large-scale CFD parallel computing method, a development process is simplified, the wall time of execution of the CFD parallel programs is reduced, the practicability is high, and popularization is easy.
Owner:三多(杭州)科技有限公司
Method and device for detecting mysql running information
ActiveCN103870377BGuaranteed detectionIncreased persistenceHardware monitoringHigh loadComputer science
The invention discloses a method and a device for detecting MySQL operation information. The long connection method is used to periodically detect MySQL, and the detection results of each cycle are cached. When a detection request is received, the detection results are extracted from the cache. . Therefore, when the MySQL load to be detected is high or the network concurrency of the system where the device is located is large, normal detection can also be guaranteed, which improves the continuity and stability of detection, and is especially suitable for the monitoring and operation of MySQL clusters that require high reliability.
Owner:SHENZHEN TENCENT COMP SYST CO LTD
Public network access restriction method and system for public cloud MySQL cluster
PendingCN114584373AImprove usabilityEasy accessSecuring communicationElastic networkHigh availability
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.
Owner:SHANDONG LANGCHAO YUNTOU INFORMATION TECH CO LTD
Proxysql automatic operation and maintenance system, method, corresponding equipment and storage medium
ActiveCN112328581BAvoid destructionReduce misuseDatabase management systemsDatabase distribution/replicationMysql clusterHealth well being
This application discloses a ProxySQL automatic operation and maintenance system, method, corresponding equipment, and storage medium for the operation and maintenance of a ProxySQL cluster, wherein the ProxySQL cluster includes multiple sets of ProxySQL and communicates with the MySQL cluster, wherein the system includes: deployed on each ProxySQL The monitoring service module in is used to determine the health status of the ProxySQL node and the health status of the MySQL cluster; the health service module is used to determine whether the ProxySQL master node is available according to the health status of ProxySQL and the health status of the MySQL cluster; The node migration module is used to recommend a new master node in response to the unavailability of the ProxySQL master node, and switch the virtual IP of the ProxySQL cluster to the recommended master node. The present invention enables automatic configuration, operation and maintenance of ProxySQL, and reduces risks caused by misoperation.
Owner:望海康信(北京)科技股份公司
Method and device for building MySQL high-availability group
PendingCN112395269ARapid deploymentFast deliverySpecial data processing applicationsDatabase design/maintainanceComputer networkEngineering
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.
Owner:INDUSTRIAL AND COMMERCIAL BANK OF CHINA
Features
- R&D
- Intellectual Property
- Life Sciences
- Materials
- Tech Scout
Why Patsnap Eureka
- Unparalleled Data Quality
- Higher Quality Content
- 60% Fewer Hallucinations
Social media
Patsnap Eureka Blog
Learn More Browse by: Latest US Patents, China's latest patents, Technical Efficacy Thesaurus, Application Domain, Technology Topic, Popular Technical Reports.
© 2025 PatSnap. All rights reserved.Legal|Privacy policy|Modern Slavery Act Transparency Statement|Sitemap|About US| Contact US: help@patsnap.com