#binlog — Public Fediverse posts
Live and recent posts from across the Fediverse tagged #binlog, aggregated by home.social.
-
Dropped a MySQL table? Skip full database restores. Reconstruct the DDL and replay targeted row/DML events using mysqlbinlog or my2sql. #mysql #binlog #ValtersIT
https://www.valtersit.com/vault/recover-dropped-table-from-binlog-without-full-restore-c9dfe0/
-
Dropped a MySQL table? Skip full database restores. Reconstruct the DDL and replay targeted row/DML events using mysqlbinlog or my2sql. #mysql #binlog #ValtersIT
https://www.valtersit.com/vault/recover-dropped-table-from-binlog-without-full-restore-c9dfe0/
-
Avoid PITR failures by validating archived MySQL binary logs. `mysqlbinlog --verify-binlog-checksum` recalculates the 4-byte CRC32 per event to detect corruption.
https://www.valtersit.com/vault/verify-binlog-integrity-with-mysqlbinlog-and-checksums-9760cd/
-
Avoid PITR failures by validating archived MySQL binary logs. `mysqlbinlog --verify-binlog-checksum` recalculates the 4-byte CRC32 per event to detect corruption.
https://www.valtersit.com/vault/verify-binlog-integrity-with-mysqlbinlog-and-checksums-9760cd/
-
Как проверить, что бэкап действительно можно восстановить
У вас есть бэкапы? Хорошо, лёгкий вопрос. А когда вы в последний раз восстанавливали из них хотя бы один файл? Вот она неловкая пауза, понимаю… Между «бэкап есть» и «бэкап восстанавливается» находится пропасть, и в неё регулярно падают даже большие компании. Под катом две страшилки из реальной жизни и разбор того, как проверить свои бэкапы до того, как восстанавливать их придётся на боевом сервере. Читать
https://habr.com/ru/companies/ruvds/articles/1076952/
#резервное_копирование #бэкап #backup_restore #PostgreSQL #MySQL #mysqldump #binlog #BorgBackup #Linux #ruvds_статьи
-
Как проверить, что бэкап действительно можно восстановить
У вас есть бэкапы? Хорошо, лёгкий вопрос. А когда вы в последний раз восстанавливали из них хотя бы один файл? Вот она неловкая пауза, понимаю… Между «бэкап есть» и «бэкап восстанавливается» находится пропасть, и в неё регулярно падают даже большие компании. Под катом две страшилки из реальной жизни и разбор того, как проверить свои бэкапы до того, как восстанавливать их придётся на боевом сервере. Читать
https://habr.com/ru/companies/ruvds/articles/1076952/
#резервное_копирование #бэкап #backup_restore #PostgreSQL #MySQL #mysqldump #binlog #BorgBackup #Linux #ruvds_статьи
-
🚀 Hold onto your keyboards, folks! In an astounding revelation, periodic #MySQL syncs don't have psychic powers to detect deleted rows or intermediate updates 🤯. But fear not, mere mortals, for the almighty #binlog is here to save the day with its magical abilities that, shockingly, require specific settings to function! 🧙♂️
https://www.erathos.com/en/blog/mysql-cdc-to-bigquery #Myths #DataRecovery #TechNews #DatabaseManagement #HackerNews #ngated -
🚀 Hold onto your keyboards, folks! In an astounding revelation, periodic #MySQL syncs don't have psychic powers to detect deleted rows or intermediate updates 🤯. But fear not, mere mortals, for the almighty #binlog is here to save the day with its magical abilities that, shockingly, require specific settings to function! 🧙♂️
https://www.erathos.com/en/blog/mysql-cdc-to-bigquery #Myths #DataRecovery #TechNews #DatabaseManagement #HackerNews #ngated -
🚀 Hold onto your keyboards, folks! In an astounding revelation, periodic #MySQL syncs don't have psychic powers to detect deleted rows or intermediate updates 🤯. But fear not, mere mortals, for the almighty #binlog is here to save the day with its magical abilities that, shockingly, require specific settings to function! 🧙♂️
https://www.erathos.com/en/blog/mysql-cdc-to-bigquery #Myths #DataRecovery #TechNews #DatabaseManagement #HackerNews #ngated -
🚀 Hold onto your keyboards, folks! In an astounding revelation, periodic #MySQL syncs don't have psychic powers to detect deleted rows or intermediate updates 🤯. But fear not, mere mortals, for the almighty #binlog is here to save the day with its magical abilities that, shockingly, require specific settings to function! 🧙♂️
https://www.erathos.com/en/blog/mysql-cdc-to-bigquery #Myths #DataRecovery #TechNews #DatabaseManagement #HackerNews #ngated -
MySQL CDC to BigQuery: what periodic syncs miss, and how binlog avoids it
https://www.erathos.com/en/blog/mysql-cdc-to-bigquery
-
MySQL CDC to BigQuery: what periodic syncs miss, and how binlog avoids it
https://www.erathos.com/en/blog/mysql-cdc-to-bigquery
-
MySQL CDC to BigQuery: what periodic syncs miss, and how binlog avoids it
https://www.erathos.com/en/blog/mysql-cdc-to-bigquery
-
MySQL CDC to BigQuery: what periodic syncs miss, and how binlog avoids it
https://www.erathos.com/en/blog/mysql-cdc-to-bigquery
-
From the .NET blog...
In case you missed it earlier...
Analyze MSBuild Binary Logs with Copilot in VS Code
https://devblogs.microsoft.com/dotnet/msbuild-binlog-analyzer-vscode/ #dotnet #AI #VisualStudioCode #binlog #builddiagnostics #BuildPerformance #GitHubCopilot #MCP #ModelContextProtocol #msbuild #VSCode -
From the .NET blog...
In case you missed it earlier...
Analyze MSBuild Binary Logs with Copilot in VS Code
https://devblogs.microsoft.com/dotnet/msbuild-binlog-analyzer-vscode/ #dotnet #AI #VisualStudioCode #binlog #builddiagnostics #BuildPerformance #GitHubCopilot #MCP #ModelContextProtocol #msbuild #VSCode -
From the .NET blog...
In case you missed it earlier...
Analyze MSBuild Binary Logs with Copilot in VS Code
https://devblogs.microsoft.com/dotnet/msbuild-binlog-analyzer-vscode/ #dotnet #AI #VisualStudioCode #binlog #builddiagnostics #BuildPerformance #GitHubCopilot #MCP #ModelContextProtocol #msbuild #VSCode -
From the .NET blog...
In case you missed it earlier...
Analyze MSBuild Binary Logs with Copilot in VS Code
https://devblogs.microsoft.com/dotnet/msbuild-binlog-analyzer-vscode/ #dotnet #AI #VisualStudioCode #binlog #builddiagnostics #BuildPerformance #GitHubCopilot #MCP #ModelContextProtocol #msbuild #VSCode -
Analyze MSBuild Binary Logs with Copilot in VS Code
https://devblogs.microsoft.com/dotnet/msbuild-binlog-analyzer-vscode/#microsoft #NET #AI #Visual_Studio_Code #binlog #build_diagnostics #Build_Performance #GitHub_Copilot #MCP #Model_Context_Protocol #msbuild #VS_Code
-
Analyze MSBuild Binary Logs with Copilot in VS Code
https://devblogs.microsoft.com/dotnet/msbuild-binlog-analyzer-vscode/#microsoft #NET #AI #Visual_Studio_Code #binlog #build_diagnostics #Build_Performance #GitHub_Copilot #MCP #Model_Context_Protocol #msbuild #VS_Code
-
Analyze MSBuild Binary Logs with Copilot in VS Code
https://devblogs.microsoft.com/dotnet/msbuild-binlog-analyzer-vscode/#microsoft #NET #AI #Visual_Studio_Code #binlog #build_diagnostics #Build_Performance #GitHub_Copilot #MCP #Model_Context_Protocol #msbuild #VS_Code
-
From the .NET blog...
Analyze MSBuild Binary Logs with Copilot in VS Code
https://devblogs.microsoft.com/dotnet/msbuild-binlog-analyzer-vscode/ #dotnet #AI #VisualStudioCode #binlog #builddiagnostics #BuildPerformance #GitHubCopilot #MCP #ModelContextProtocol #msbuild #VSCode -
From the .NET blog...
Analyze MSBuild Binary Logs with Copilot in VS Code
https://devblogs.microsoft.com/dotnet/msbuild-binlog-analyzer-vscode/ #dotnet #AI #VisualStudioCode #binlog #builddiagnostics #BuildPerformance #GitHubCopilot #MCP #ModelContextProtocol #msbuild #VSCode -
From the .NET blog...
Analyze MSBuild Binary Logs with Copilot in VS Code
https://devblogs.microsoft.com/dotnet/msbuild-binlog-analyzer-vscode/ #dotnet #AI #VisualStudioCode #binlog #builddiagnostics #BuildPerformance #GitHubCopilot #MCP #ModelContextProtocol #msbuild #VSCode -
From the .NET blog...
Analyze MSBuild Binary Logs with Copilot in VS Code
https://devblogs.microsoft.com/dotnet/msbuild-binlog-analyzer-vscode/ #dotnet #AI #VisualStudioCode #binlog #builddiagnostics #BuildPerformance #GitHubCopilot #MCP #ModelContextProtocol #msbuild #VSCode -
via @dotnet : MCP Beyond the Chat Window: Build Diagnostics in CI
https://ift.tt/azRNoku
#mcp #binlog #ci #githubactions #dotnet #msbuild #diagnostics #binlogtools #buildfailureanalysis #prcomments #automation #aiassistance #continuousintegration #binlogserver #… -
via @dotnet : MCP Beyond the Chat Window: Build Diagnostics in CI
https://ift.tt/azRNoku
#mcp #binlog #ci #githubactions #dotnet #msbuild #diagnostics #binlogtools #buildfailureanalysis #prcomments #automation #aiassistance #continuousintegration #binlogserver #… -
via @dotnet : MCP Beyond the Chat Window: Build Diagnostics in CI
https://ift.tt/azRNoku
#mcp #binlog #ci #githubactions #dotnet #msbuild #diagnostics #binlogtools #buildfailureanalysis #prcomments #automation #aiassistance #continuousintegration #binlogserver #… -
via @dotnet : MCP Beyond the Chat Window: Build Diagnostics in CI
https://ift.tt/azRNoku
#mcp #binlog #ci #githubactions #dotnet #msbuild #diagnostics #binlogtools #buildfailureanalysis #prcomments #automation #aiassistance #continuousintegration #binlogserver #… -
From the .NET blog...
In case you missed it earlier...
MCP Beyond the Chat Window: Build Diagnostics in CI
https://devblogs.microsoft.com/dotnet/mcp-build-diagnostics-workflows/ #dotnet #AI #binlog #builddiagnostics #GitHubActions #GitHubCopilot #MCP #MicrosoftBinlogMCP #ModelContextProtocol #msbuild -
From the .NET blog...
In case you missed it earlier...
MCP Beyond the Chat Window: Build Diagnostics in CI
https://devblogs.microsoft.com/dotnet/mcp-build-diagnostics-workflows/ #dotnet #AI #binlog #builddiagnostics #GitHubActions #GitHubCopilot #MCP #MicrosoftBinlogMCP #ModelContextProtocol #msbuild -
From the .NET blog...
In case you missed it earlier...
MCP Beyond the Chat Window: Build Diagnostics in CI
https://devblogs.microsoft.com/dotnet/mcp-build-diagnostics-workflows/ #dotnet #AI #binlog #builddiagnostics #GitHubActions #GitHubCopilot #MCP #MicrosoftBinlogMCP #ModelContextProtocol #msbuild -
From the .NET blog...
In case you missed it earlier...
MCP Beyond the Chat Window: Build Diagnostics in CI
https://devblogs.microsoft.com/dotnet/mcp-build-diagnostics-workflows/ #dotnet #AI #binlog #builddiagnostics #GitHubActions #GitHubCopilot #MCP #MicrosoftBinlogMCP #ModelContextProtocol #msbuild -
MCP Beyond the Chat Window: Build Diagnostics in CI
https://devblogs.microsoft.com/dotnet/mcp-build-diagnostics-workflows/#microsoft #NET #AI #binlog #build_diagnostics #GitHub_Actions #GitHub_Copilot #MCP #Microsoft_Binlog_MCP #Model_Context_Protocol #msbuild
-
MCP Beyond the Chat Window: Build Diagnostics in CI
https://devblogs.microsoft.com/dotnet/mcp-build-diagnostics-workflows/#microsoft #NET #AI #binlog #build_diagnostics #GitHub_Actions #GitHub_Copilot #MCP #Microsoft_Binlog_MCP #Model_Context_Protocol #msbuild
-
MCP Beyond the Chat Window: Build Diagnostics in CI
https://devblogs.microsoft.com/dotnet/mcp-build-diagnostics-workflows/#microsoft #NET #AI #binlog #build_diagnostics #GitHub_Actions #GitHub_Copilot #MCP #Microsoft_Binlog_MCP #Model_Context_Protocol #msbuild
-
From the .NET blog...
MCP Beyond the Chat Window: Build Diagnostics in CI
https://devblogs.microsoft.com/dotnet/mcp-build-diagnostics-workflows/ #dotnet #AI #binlog #builddiagnostics #GitHubActions #GitHubCopilot #MCP #MicrosoftBinlogMCP #ModelContextProtocol #msbuild -
From the .NET blog...
MCP Beyond the Chat Window: Build Diagnostics in CI
https://devblogs.microsoft.com/dotnet/mcp-build-diagnostics-workflows/ #dotnet #AI #binlog #builddiagnostics #GitHubActions #GitHubCopilot #MCP #MicrosoftBinlogMCP #ModelContextProtocol #msbuild -
From the .NET blog...
MCP Beyond the Chat Window: Build Diagnostics in CI
https://devblogs.microsoft.com/dotnet/mcp-build-diagnostics-workflows/ #dotnet #AI #binlog #builddiagnostics #GitHubActions #GitHubCopilot #MCP #MicrosoftBinlogMCP #ModelContextProtocol #msbuild -
From the .NET blog...
MCP Beyond the Chat Window: Build Diagnostics in CI
https://devblogs.microsoft.com/dotnet/mcp-build-diagnostics-workflows/ #dotnet #AI #binlog #builddiagnostics #GitHubActions #GitHubCopilot #MCP #MicrosoftBinlogMCP #ModelContextProtocol #msbuild -
From the .NET blog...
In case you missed it earlier...
AI-Powered MSBuild Investigation with the Microsoft Binlog MCP Server
https://devblogs.microsoft.com/dotnet/msbuild-binlog-mcp-server/ #dotnet #AI #binlog #builddiagnostics #GitHubCopilot #MCP #ModelContextProtocol #msbuild -
From the .NET blog...
In case you missed it earlier...
AI-Powered MSBuild Investigation with the Microsoft Binlog MCP Server
https://devblogs.microsoft.com/dotnet/msbuild-binlog-mcp-server/ #dotnet #AI #binlog #builddiagnostics #GitHubCopilot #MCP #ModelContextProtocol #msbuild -
From the .NET blog...
In case you missed it earlier...
AI-Powered MSBuild Investigation with the Microsoft Binlog MCP Server
https://devblogs.microsoft.com/dotnet/msbuild-binlog-mcp-server/ #dotnet #AI #binlog #builddiagnostics #GitHubCopilot #MCP #ModelContextProtocol #msbuild -
From the .NET blog...
In case you missed it earlier...
AI-Powered MSBuild Investigation with the Microsoft Binlog MCP Server
https://devblogs.microsoft.com/dotnet/msbuild-binlog-mcp-server/ #dotnet #AI #binlog #builddiagnostics #GitHubCopilot #MCP #ModelContextProtocol #msbuild -
via @dotnet : AI-Powered MSBuild Investigation with the Microsoft Binlog MCP Server
https://ift.tt/3rhFpL9
#AI #MSBuild #Binlog #MCP #MSBuildBinlog #BinlogMCPServer #AIWorkspace #CodeAssist #BuildDiagnostics #PerformanceAnalysis #BuildComparison #StructuredLogge… -
via @dotnet : AI-Powered MSBuild Investigation with the Microsoft Binlog MCP Server
https://ift.tt/3rhFpL9
#AI #MSBuild #Binlog #MCP #MSBuildBinlog #BinlogMCPServer #AIWorkspace #CodeAssist #BuildDiagnostics #PerformanceAnalysis #BuildComparison #StructuredLogge… -
via @dotnet : AI-Powered MSBuild Investigation with the Microsoft Binlog MCP Server
https://ift.tt/3rhFpL9
#AI #MSBuild #Binlog #MCP #MSBuildBinlog #BinlogMCPServer #AIWorkspace #CodeAssist #BuildDiagnostics #PerformanceAnalysis #BuildComparison #StructuredLogge… -
via @dotnet : AI-Powered MSBuild Investigation with the Microsoft Binlog MCP Server
https://ift.tt/3rhFpL9
#AI #MSBuild #Binlog #MCP #MSBuildBinlog #BinlogMCPServer #AIWorkspace #CodeAssist #BuildDiagnostics #PerformanceAnalysis #BuildComparison #StructuredLogge… -
From the .NET blog...
AI-Powered MSBuild Investigation with the Microsoft Binlog MCP Server
https://devblogs.microsoft.com/dotnet/msbuild-binlog-mcp-server/ #dotnet #AI #binlog #builddiagnostics #GitHubCopilot #MCP #ModelContextProtocol #msbuild -
From the .NET blog...
AI-Powered MSBuild Investigation with the Microsoft Binlog MCP Server
https://devblogs.microsoft.com/dotnet/msbuild-binlog-mcp-server/ #dotnet #AI #binlog #builddiagnostics #GitHubCopilot #MCP #ModelContextProtocol #msbuild -
From the .NET blog...
AI-Powered MSBuild Investigation with the Microsoft Binlog MCP Server
https://devblogs.microsoft.com/dotnet/msbuild-binlog-mcp-server/ #dotnet #AI #binlog #builddiagnostics #GitHubCopilot #MCP #ModelContextProtocol #msbuild -
From the .NET blog...
AI-Powered MSBuild Investigation with the Microsoft Binlog MCP Server
https://devblogs.microsoft.com/dotnet/msbuild-binlog-mcp-server/ #dotnet #AI #binlog #builddiagnostics #GitHubCopilot #MCP #ModelContextProtocol #msbuild -
AI-Powered MSBuild Investigation with the Microsoft Binlog MCP Server
https://devblogs.microsoft.com/dotnet/msbuild-binlog-mcp-server/#microsoft #NET #AI #binlog #build_diagnostics #GitHub_Copilot #MCP #Model_Context_Protocol #msbuild
-
AI-Powered MSBuild Investigation with the Microsoft Binlog MCP Server
https://devblogs.microsoft.com/dotnet/msbuild-binlog-mcp-server/#microsoft #NET #AI #binlog #build_diagnostics #GitHub_Copilot #MCP #Model_Context_Protocol #msbuild
-
AI-Powered MSBuild Investigation with the Microsoft Binlog MCP Server
https://devblogs.microsoft.com/dotnet/msbuild-binlog-mcp-server/#microsoft #NET #AI #binlog #build_diagnostics #GitHub_Copilot #MCP #Model_Context_Protocol #msbuild
-
[Перевод] 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
-
[Перевод] 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
