听说飞信服务器端用的是 MySQL，集群方案用的是 MySQL Cluster 吗？
飞信服务器的msyql集群是否是mysql cluster?
回复内容：
@mysqlops 别扯淡了，当年飞信从SQLServer迁移到MySQL的时候，没有上海某公司，新媒传信那帮人自己能搞定？那会儿新媒有拿得出手的MySQL DBA？那会儿的吴炳锡是什么水平？几万行存储过程的代码迁移如果没有上海某公司他们根本搞不定，更别说后来割接的时候出现的各种状况，如果没有上海某公司，这个迁移项目早就死翘翘了，割接的时候没有上海某公司的坚持，新媒的CTO自己都说准备放弃了。不了解内情就不要在这儿乱说。看你装逼实在看不下去了，别装了好吗？另外，当年想用MySQL Cluster的是飞信企业版，最后失败和上海某公司没有半毛钱关系，MySQL Cluster本身就不适合他们的业务。 1.飞信的数据库产品确实是MySQL；
2.飞信初期确实是上了MySQL Cluster版本，遗憾是那个时候这个产品并不稳定，性能也不好，
尤其是 提供MySQL技术支持方的 上海 某公司 实力太弱，最后导致MySQL Cluster失败；
3.当下飞信是没有使用MySQL Cluster，虽然移动每年给钱到甲骨文和上海某公司，但是第三方的MySQL技术支持方也不要了，而是飞信内部招聘众多DBA，以及吴斌锡等都能自己搞定；
4.当下飞信的数据库架构师，类似Cobar的数据库中间件 + MySQL双主复制； MySQL Cluster不适合飞信的应用（当时SQLServer移植存在大量的外键和存储过程等），并不是某公司实力太弱(虽然我觉得公司实力的强弱只是相对概念，对客户来说只要能够负责的把事情干好就够了)，呵呵
飞信还在持续购买服务... 对于这些问题，没必要涉及到一些不关于本问题的东西。
飞信，唉》》》很久很久没用了，不过你问的很对，确实，可惜夭折 我怎么听说是 sql server
Hot AI Tools
Undresser.AI Undress
AI-powered app for creating realistic nude photos
AI Clothes Remover
Online AI tool for removing clothes from photos.
Undress AI Tool
Undress images for free
Clothoff.io
AI clothes remover
AI Hentai Generator
Generate AI Hentai for free.
Hot Article
Hot Tools
Notepad++7.3.1
Easy-to-use and free code editor
SublimeText3 Chinese version
Chinese version, very easy to use
Zend Studio 13.0.1
Powerful PHP integrated development environment
Dreamweaver CS6
Visual web development tools
SublimeText3 Mac version
God-level code editing software (SublimeText3)
Hot Topics
1359
52
How to solve mysql cannot be started
Apr 08, 2025 pm 02:21 PM
There are many reasons why MySQL startup fails, and it can be diagnosed by checking the error log. Common causes include port conflicts (check port occupancy and modify configuration), permission issues (check service running user permissions), configuration file errors (check parameter settings), data directory corruption (restore data or rebuild table space), InnoDB table space issues (check ibdata1 files), plug-in loading failure (check error log). When solving problems, you should analyze them based on the error log, find the root cause of the problem, and develop the habit of backing up data regularly to prevent and solve problems.
Does mysql optimize lock tables
Apr 08, 2025 pm 01:51 PM
MySQL uses shared locks and exclusive locks to manage concurrency, providing three lock types: table locks, row locks and page locks. Row locks can improve concurrency, and use the FOR UPDATE statement to add exclusive locks to rows. Pessimistic locks assume conflicts, and optimistic locks judge the data through the version number. Common lock table problems manifest as slow querying, use the SHOW PROCESSLIST command to view the queries held by the lock. Optimization measures include selecting appropriate indexes, reducing transaction scope, batch operations, and optimizing SQL statements.
How to use SUBSTRING_INDEX in MySQL
Apr 08, 2025 pm 02:09 PM
In MySQL database operations, string processing is an inevitable link. The SUBSTRING_INDEX function is designed for this, which can efficiently extract substrings based on separators. SUBSTRING_INDEX function application example The following example shows the flexibility and practicality of the SUBSTRING_INDEX function: Extract specific parts from the URL For example, extract domain name: SELECTSUBSTRING_INDEX('www.mysql.com','.',2); Extract file extension to easily get file extension: SELECTSUBSTRING_INDEX('file.pdf','.',-1); Processing does not exist
Does mysql need the internet
Apr 08, 2025 pm 02:18 PM
MySQL can run without network connections for basic data storage and management. However, network connection is required for interaction with other systems, remote access, or using advanced features such as replication and clustering. Additionally, security measures (such as firewalls), performance optimization (choose the right network connection), and data backup are critical to connecting to the Internet.
Can mysql and mariadb coexist
Apr 08, 2025 pm 02:27 PM
MySQL and MariaDB can coexist, but need to be configured with caution. The key is to allocate different port numbers and data directories to each database, and adjust parameters such as memory allocation and cache size. Connection pooling, application configuration, and version differences also need to be considered and need to be carefully tested and planned to avoid pitfalls. Running two databases simultaneously can cause performance problems in situations where resources are limited.
The primary key of mysql can be null
Apr 08, 2025 pm 03:03 PM
The MySQL primary key cannot be empty because the primary key is a key attribute that uniquely identifies each row in the database. If the primary key can be empty, the record cannot be uniquely identifies, which will lead to data confusion. When using self-incremental integer columns or UUIDs as primary keys, you should consider factors such as efficiency and space occupancy and choose an appropriate solution.
Does mysql need a server
Apr 08, 2025 pm 02:12 PM
For production environments, a server is usually required to run MySQL, for reasons including performance, reliability, security, and scalability. Servers usually have more powerful hardware, redundant configurations and stricter security measures. For small, low-load applications, MySQL can be run on local machines, but resource consumption, security risks and maintenance costs need to be carefully considered. For greater reliability and security, MySQL should be deployed on cloud or other servers. Choosing the appropriate server configuration requires evaluation based on application load and data volume.
Can mysql return json
Apr 08, 2025 pm 03:09 PM
MySQL can return JSON data. The JSON_EXTRACT function extracts field values. For complex queries, you can consider using the WHERE clause to filter JSON data, but pay attention to its performance impact. MySQL's support for JSON is constantly increasing, and it is recommended to pay attention to the latest version and features.
