PHPackages                             jiangslee/laravel-mysql-forcemaster - PHPackages - PHPackages  [Skip to content](#main-content)[PHPackages](/)[Directory](/)[Categories](/categories)[Trending](/trending)[Leaderboard](/leaderboard)[Changelog](/changelog)[Analyze](/analyze)[Collections](/collections)[Log in](/login)[Sign up](/register)

1. [Directory](/)
2. /
3. jiangslee/laravel-mysql-forcemaster

ActiveLibrary

jiangslee/laravel-mysql-forcemaster
===================================

Laravel forcemaster hint for mysql

v1.0.0(4y ago)018MITPHP

Since May 3Pushed 4y ago1 watchersCompare

[ Source](https://github.com/jiangslee/laravel-mysql-forcemaster)[ Packagist](https://packagist.org/packages/jiangslee/laravel-mysql-forcemaster)[ RSS](/packages/jiangslee-laravel-mysql-forcemaster/feed)WikiDiscussions master Synced 1mo ago

READMEChangelogDependencies (9)Versions (2)Used By (0)

Laravel Mysql Force Master Package
==================================

[](#laravel-mysql-force-master-package)

---

RDS MySQL读写分离如何确保数据读取的时效性
=========================

[](#rds-mysql读写分离如何确保数据读取的时效性)

> 阿里云内部网络会确保同步日志在主实例和只读实例间的实时传输，正常情况下只读实例不会有延迟产生。但受限于MySQL本身的复制机制，若同步日志的应用时间较久，会产生数据同步的延迟，这个是MySQL尚无法在技术手段上规避的问题。为减小延迟，建议您的只读实例规格不小于主实例，从而确保有足够高的性能来应用同步日志。 RDS支持用户设置延迟阈值，当某个只读实例的延迟超过该阈值时，系统会不再转发任何请求至该实例。当所有只读实例均超过延迟阈值时，请求直接路由到主库，不管主库的读权重是否开启。 在使用读写分离过程中，若您需要某些查询语句获取实时性的数据，可通过Hint格式将这些查询语句强制转发至主实例执行。RDS读写分离支持的Hint格式为`/*FORCE_MASTER*/`，指定后续SQL到主实例执行。示例如下：

```
/*FORCE_MASTER*/ SELECT * FROM table_name;
```

相关链接： [https://help.aliyun.com/document\_detail/52221.html](https://help.aliyun.com/document_detail/52221.html)

Installing
----------

[](#installing)

```
composer require jiangslee/laravel-mysql-forcemaster -vvv
```

Usage
-----

[](#usage)

使用`->forceMaster()`手动增加`/*FORCE_MASTER*/`
-----------------------------------------

[](#使用-forcemaster手动增加force_master)

```
$sql = DB::table('users')->select('*')->forceMaster()->toSql();
// /*FORCE_MASTER*/SELECT * FROM `users`

$sql = DB::table('users')->select('*')->toSql();
// SELECT * FROM `users`
```

在事务中自动增加`/*FORCE_MASTER*/`
--------------------------

[](#在事务中自动增加force_master)

```
DB::beginTransaction();
$users = User::first();
try {
    $users->name = 'test';
    $users->save();
    dump($users->toSql());
    // "/*FORCE_MASTER*/select * from `users`"

    $customers = CrmCustomer::first();
    dump($customers->toSql());
    // /*FORCE_MASTER*/select * from `crm_customers`

    $contacts = CrmContact::query()->first();
    dump($contacts->toSql());
    // /*FORCE_MASTER*/select * from `crm_contacts`

    // throw new Exception('test');
    DB::commit();
} catch (\Throwable $th) {
    dump($users->toSql());
    DB::rollBack();
}

dump($users->toSql());
// select * from `users`
```

Contributing
------------

[](#contributing)

You can contribute in one of three ways:

1. File bug reports using the [issue tracker](https://github.com/jiangslee/laravel-mysql-forcemaster/issues).
2. Answer questions or fix bugs on the [issue tracker](https://github.com/jiangslee/laravel-mysql-forcemaster/issues).
3. Contribute new features or update the wiki.

*The code contribution process is not very formal. You just need to make sure that you follow the PSR-0, PSR-1, and PSR-2 coding guidelines. Any new code contributions must be accompanied by unit tests where applicable.*

PHP 扩展包开发
---------

[](#php-扩展包开发)

> 想知道如何从零开始构建 PHP 扩展包？
>
> 请关注我的实战课程，我会在此课程中分享一些扩展开发经验 —— [《PHP 扩展包实战教程 - 从入门到发布》](https://learnku.com/courses/creating-package)

License
-------

[](#license)

MIT

###  Health Score

22

—

LowBetter than 22% of packages

Maintenance20

Infrequent updates — may be unmaintained

Popularity6

Limited adoption so far

Community7

Small or concentrated contributor base

Maturity48

Maturing project, gaining track record

 Bus Factor1

Top contributor holds 100% of commits — single point of failure

How is this calculated?**Maintenance (25%)** — Last commit recency, latest release date, and issue-to-star ratio. Uses a 2-year decay window.

**Popularity (30%)** — Total and monthly downloads, GitHub stars, and forks. Logarithmic scaling prevents top-heavy scores.

**Community (15%)** — Contributors, dependents, forks, watchers, and maintainers. Measures real ecosystem engagement.

**Maturity (30%)** — Project age, version count, PHP version support, and release stability.

###  Release Activity

Cadence

Unknown

Total

1

Last Release

1470d ago

### Community

Maintainers

![](https://www.gravatar.com/avatar/254cae97accd7455de8100afa00249fbc845de5fad77aeb6620210a048ff05a8?d=identicon)[jiangslee](/maintainers/jiangslee)

---

Top Contributors

[![jiangslee](https://avatars.githubusercontent.com/u/27892476?v=4)](https://github.com/jiangslee "jiangslee (7 commits)")

###  Code Quality

TestsPHPUnit

Static AnalysisPsalm

Code StylePHP CS Fixer

Type Coverage Yes

### Embed Badge

![Health badge](/badges/jiangslee-laravel-mysql-forcemaster/health.svg)

```
[![Health](https://phpackages.com/badges/jiangslee-laravel-mysql-forcemaster/health.svg)](https://phpackages.com/packages/jiangslee-laravel-mysql-forcemaster)
```

###  Alternatives

[anourvalar/eloquent-serialize

Laravel Query Builder (Eloquent) serialization

11320.2M21](/packages/anourvalar-eloquent-serialize)[statamic-rad-pack/runway

Eloquently manage your database models in Statamic.

135192.6k5](/packages/statamic-rad-pack-runway)

PHPackages © 2026

[Directory](/)[Categories](/categories)[Trending](/trending)[Changelog](/changelog)[Analyze](/analyze)