[Перевод] MariaDB 12.3: binlog внутри InnoDB

Коротко для ленивых В MariaDB 12.3 binlog можно хранить внутри InnoDB через binlog_storage_engine=innodb . Главный эффект: вместо двух fsync() на commit остаётся один, поэтому на write-heavy нагрузке резко растут TPS и снижается tail latency. В тестах из статьи прирост на полном durability-профиле составил примерно 2.4x–3.3x . Backup, restore и ресинк реплик становятся проще, потому что binlog и данные теперь консистентны на уровне одного механизма хранения. Цена за это: обязателен GTID, Galera пока не поддерживается, а innodb_log_file_size нужно подбирать внимательнее из-за роста объёма redo. Если у вас обычная схема primary + async replica на InnoDB, эту возможность точно стоит хотя бы протестировать.

https://habr.com/ru/articles/1011298/

#MariaDB_123 #InnoDB #binlog #GTID #репликация #производительность_SQL #crash_recovery #fsync #OLTP

https://blog.gslin.org/archives/2026/02/21/12901/mariadb-12-3-%e5%b0%8d-innodb-%e7%9a%84%e5%a4%a7%e6%94%b9%e9%80%b2/

MariaDB 12.3 對 InnoDB 的大改進

#binlog #cpu #database #db #engine #fsync #i/o #innodb #latency #mariadb #mysql #performance #rdbms #speed #storage #write

Thanks to @maxkatz6 we now have signed and notarized Avalonia builds for MSBuild Structured Log Viewer for Mac:

https://github.com/KirillOsenkov/MSBuildStructuredLog/discussions/847

Powered by @avaloniaui

#msbuild #binlog #dotnet

If anyone wants samples of how to read MSBuild binlogs programmatically, the binlogtool project contains a bunch. Here's an example of dumping all properties and their values from a binlog:

https://github.com/KirillOsenkov/MSBuildStructuredLog/blob/main/src/BinlogTool/ListProperties.cs

binlogtool is a .NET tool, install using:

`dotnet tool update -g binlogtool`

#dotnet #msbuild #binlog

Pushed a small update to the MSBuild Log Viewer VS Code extension. It should now be able to open .NET 8 binlogs

https://marketplace.visualstudio.com/items?itemName=lambdageek.msbuild-structured-log-viewer

#vscode #vscodeExtension #dotnet #msbuild #msbuldLogViewer #msbuildStructuredLogViewer #binlog

One problem we have with #MSBuild #binlogs is when the MSBuild team updates the #binlog format, older versions of MSBuild.StructuredLogger NuGet package can't read the new format and blow up with an exception.

People use the library in various CI and tools. I wish I had a way to notify them all to update the NuGet to latest, which adds support for the latest format. The library unfortunately can't be easily made forwards-compatible.

So I made a thing...

It's a VS Code extension based on Kirill Osenkov's @KirillOsenkov MS Build structured log viewer.

https://marketplace.visualstudio.com/items?itemName=lambdageek.msbuild-structured-log-viewer

The desktop version runs on CoreCLR, the https://insiders.vscode.dev version runs using the new (and still very experimental!) .NET 8 WASI workload on top of VS Code's WASI extension host (https://code.visualstudio.com/blogs/2023/06/05/vscode-wasm-wasi)

#vscode #dotnet #dotnet8 #net8 #wasi #coreclr #vscodeExtension #mono #msbuild #msbuildLogViewer #msbuildStructuredLogViewer #binlog