search

三个问题
1:自己写分布式数据库,当从数据库多个的时候,应该如何去选择查询哪个从数据库?(最好能根据用户当前网络最优选择,另外)
2:分布式与集群的区别?我一直搞不明白,能举比较实际的例子最好
3:插入2个表的数据,如果mysql表不支持事务.我如何保证一致性?


回复讨论(解决方案)

简单点说分布式是数据库服务器分布在各个地点, 然后在一个统一的平台的共享资源
集群顾名思义就是大量数据库服务器的集群进行资源共享, 这样也是有优点的, 比如说便于维护等等

3:插入2个表的数据,如果mysql表不支持事务.我如何保证一致性?
自己编程完成
1、插入第一个表,保存 last_insert_id
2、第一步成功,则插入第二个表
3、第二步失败,从第一个表中删去保存的 last_insert_id 指向的记录

简单点说分布式是数据库服务器分布在各个地点, 然后在一个统一的平台的共享资源
集群顾名思义就是大量数据库服务器的集群进行资源共享, 这样也是有优点的, 比如说便于维护等等

3:插入2个表的数据,如果mysql表不支持事务.我如何保证一致性?
自己编程完成
1、插入第一个表,保存 last_insert_id
2、第一步成功,则插入第二个表
3、第二步失败,……
分布式和集群跟业务逻辑有没有关系?
比如说:分布式有没有可能是指多个业务逻辑?
而集群是指单一业务逻辑?
第三个方法思路,非常感谢,估计也只能这么办了!
第一个问题的答案是?

分布式和集群跟业务逻辑有没有关系?
当然是有关系啦,正因为业务量巨大,所以才需要多的数据库服务器协同作战

有一个认知是需要弄清的:数据库是数据的仓库,他同时为多个用户提供服务。数据库中存放的数据不一定都是你具体的业务所需要的。就像停车场一样,虽然停车场停满了汽车,但属于你的也就只有那一辆

分布式和集群跟业务逻辑有没有关系?
当然是有关系啦,正因为业务量巨大,所以才需要多的数据库服务器协同作战

有一个认知是需要弄清的:数据库是数据的仓库,他同时为多个用户提供服务。数据库中存放的数据不一定都是你具体的业务所需要的。就像停车场一样,虽然停车场停满了汽车,但属于你的也就只有那一辆
如果是集群的话,当主从数据库插入数据之后,他们之间互相有接口进行同步复制操作.也就代表了.从数据库实际上和主数据库里的数据都是一样的,并且会及时同步?
那么不是也代表了?我查询任意一个从数据库数据都会存在?而如何选择去查哪个从数据库,如果能根据用户网络判断最优解,这个是比较完美的做法.而我的问题正在于此

分布式和集群跟业务逻辑有没有关系?
当然是有关系啦,正因为业务量巨大,所以才需要多的数据库服务器协同作战

有一个认知是需要弄清的:数据库是数据的仓库,他同时为多个用户提供服务。数据库中存放的数据不一定都是你具体的业务所需要的。就像停车场一样,虽然停车场停满了汽车,但属于你的也就只有那一辆
还有就是关于业务逻辑..
我指的不是VP量或者访问巨大
我指的是,比如同一个参数带进去,这次会输出a,下次会输出b,我指的是这个业务逻辑不一样

集群呢 你可以理解成一堆人在一起拔河,很多时候集群应用在高负载或者需要大量同步计算的场景上。

分布式呢 可以理解成一大群人在玩接力游戏,人很多但数量不一定是固定的,谁现在不累就上来玩。


集群呢 你可以理解成一堆人在一起拔河,很多时候集群应用在高负载或者需要大量同步计算的场景上。

分布式呢 可以理解成一大群人在玩接力游戏,人很多但数量不一定是固定的,谁现在不累就上来玩。
好的,非常感谢

Statement
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn
Working with Flash Session Data in LaravelWorking with Flash Session Data in LaravelMar 12, 2025 pm 05:08 PM

Laravel simplifies handling temporary session data using its intuitive flash methods. This is perfect for displaying brief messages, alerts, or notifications within your application. Data persists only for the subsequent request by default: $request-

PHP Logging: Best Practices for PHP Log AnalysisPHP Logging: Best Practices for PHP Log AnalysisMar 10, 2025 pm 02:32 PM

PHP logging is essential for monitoring and debugging web applications, as well as capturing critical events, errors, and runtime behavior. It provides valuable insights into system performance, helps identify issues, and supports faster troubleshoot

cURL in PHP: How to Use the PHP cURL Extension in REST APIscURL in PHP: How to Use the PHP cURL Extension in REST APIsMar 14, 2025 am 11:42 AM

The PHP Client URL (cURL) extension is a powerful tool for developers, enabling seamless interaction with remote servers and REST APIs. By leveraging libcurl, a well-respected multi-protocol file transfer library, PHP cURL facilitates efficient execution of various network protocols, including HTTP, HTTPS, and FTP. This extension offers granular control over HTTP requests, supports multiple concurrent operations, and provides built-in security features.

Simplified HTTP Response Mocking in Laravel TestsSimplified HTTP Response Mocking in Laravel TestsMar 12, 2025 pm 05:09 PM

Laravel provides concise HTTP response simulation syntax, simplifying HTTP interaction testing. This approach significantly reduces code redundancy while making your test simulation more intuitive. The basic implementation provides a variety of response type shortcuts: use Illuminate\Support\Facades\Http; Http::fake([ 'google.com' => 'Hello World', 'github.com' => ['foo' => 'bar'], 'forge.laravel.com' =>

12 Best PHP Chat Scripts on CodeCanyon12 Best PHP Chat Scripts on CodeCanyonMar 13, 2025 pm 12:08 PM

Do you want to provide real-time, instant solutions to your customers' most pressing problems? Live chat lets you have real-time conversations with customers and resolve their problems instantly. It allows you to provide faster service to your custom

Explain the concept of late static binding in PHP.Explain the concept of late static binding in PHP.Mar 21, 2025 pm 01:33 PM

Article discusses late static binding (LSB) in PHP, introduced in PHP 5.3, allowing runtime resolution of static method calls for more flexible inheritance.Main issue: LSB vs. traditional polymorphism; LSB's practical applications and potential perfo

Customizing/Extending Frameworks: How to add custom functionality.Customizing/Extending Frameworks: How to add custom functionality.Mar 28, 2025 pm 05:12 PM

The article discusses adding custom functionality to frameworks, focusing on understanding architecture, identifying extension points, and best practices for integration and debugging.

See all articles

Hot AI Tools

Undresser.AI Undress

Undresser.AI Undress

AI-powered app for creating realistic nude photos

AI Clothes Remover

AI Clothes Remover

Online AI tool for removing clothes from photos.

Undress AI Tool

Undress AI Tool

Undress images for free

Clothoff.io

Clothoff.io

AI clothes remover

AI Hentai Generator

AI Hentai Generator

Generate AI Hentai for free.

Hot Article

R.E.P.O. Energy Crystals Explained and What They Do (Yellow Crystal)
3 weeks agoBy尊渡假赌尊渡假赌尊渡假赌
R.E.P.O. Best Graphic Settings
3 weeks agoBy尊渡假赌尊渡假赌尊渡假赌
R.E.P.O. How to Fix Audio if You Can't Hear Anyone
3 weeks agoBy尊渡假赌尊渡假赌尊渡假赌

Hot Tools

SublimeText3 Chinese version

SublimeText3 Chinese version

Chinese version, very easy to use

MinGW - Minimalist GNU for Windows

MinGW - Minimalist GNU for Windows

This project is in the process of being migrated to osdn.net/projects/mingw, you can continue to follow us there. MinGW: A native Windows port of the GNU Compiler Collection (GCC), freely distributable import libraries and header files for building native Windows applications; includes extensions to the MSVC runtime to support C99 functionality. All MinGW software can run on 64-bit Windows platforms.

Atom editor mac version download

Atom editor mac version download

The most popular open source editor

Notepad++7.3.1

Notepad++7.3.1

Easy-to-use and free code editor

mPDF

mPDF

mPDF is a PHP library that can generate PDF files from UTF-8 encoded HTML. The original author, Ian Back, wrote mPDF to output PDF files "on the fly" from his website and handle different languages. It is slower than original scripts like HTML2FPDF and produces larger files when using Unicode fonts, but supports CSS styles etc. and has a lot of enhancements. Supports almost all languages, including RTL (Arabic and Hebrew) and CJK (Chinese, Japanese and Korean). Supports nested block-level elements (such as P, DIV),