warning The transaction log file is corrupted.
来源:互联网 发布:80卡盟主站域名填什么 编辑:程序博客网 时间:2024/04/29 09:19
Remark
Even if appealing using compress option has a constraint when preparing the backup, as clearly stated by Percona:
Before you can prepare the backup you’ll need to uncompress all the files with qpress.
The error message you get is :
So I preferred not to compress it to avoid fighting in installing qpress…
Then, archive and transfer the file to your slave server (server2 in my case):
To restore it use:
参考:MySQL Replication with Global Transaction Identifiers (GTID) hands-on
Table Of Contents
- Preamble
- Replication with GTID prerequisites
- Using XtraBackup
- Using mysqldump
- Semi-synchronous replication
- How to remove replication
- References
Preamble
My initial idea was more to test MySQL Replication switchover and failover but had a presentation of MySQL 5.6 new replication features and realized that I have never setup such environment myself. So decided to give a try and use Percona backup tool (XtraBackup) and classic mysqldump utility to create from scratch a slave instance.
Blog post has been done using MySQL 5.6.11 (binary release i.e. Linux – Generic (glibc 2.5) (x86, 64-bit), Compressed TAR Archive), Oracle Enterprise Linux 6.4 64 bits and Percona XtraBackup 2.1.3. In below server1.domain.com is my master server and server2.domain.com the slave one. They are both virtual machine using non routable IP adresses.
Replication with GTID prerequisites
For better segregation I have decided to create a MySQL Replication dedicated account with minimum rights (using root would not be a good idea):
And create a test database and table:
Table I load with something like:
You can check master status and GTID position with:
The typical variables to setup for replication are (when using the new GTID functionality), I use non-default binlog_format = row as MySQL 5.6 has apparently been drastically improved for this most used replication format (as Oracle say). In below whether you are on server1 or server2 you must adapt server_id and report_host variables:
To ease testing I’m adding the three alias in profile of my mysql Linux account:
The .root_password file is in home directory of mysql Linux account:
As a reminder I personally use the below MySQL directory naming convention:
This MySQL directories naming convention should allow you to have multiple MySQL instance running on same server (mysql01, mysql02 and so on). Please note it is slightly different from what has been nicely presented by George Trujillo in hisInstalling MySQL 5.1 on Solaris 10 using MOCA post. MOCA stands for MySQL Optimal Configuration Architecture (MOCA) and I like this name… 0 0
- warning The transaction log file is corrupted.
- 移动硬盘显示:the file or directory is corrupted and unreadable
- U盘:the file or directory is corrupted and unreadable
- U盘the file or directory is corrupted and unreadable
- SQL0964C The transaction log for the database is full.
- DB2 SQL0964C The transaction log for the database is full
- Msg 9002 The transaction log for database '' is full
- [Error Fix] The transaction log for database 'DATABASENAME' is full
- The event log file is full 处理
- The log file for database '' is full
- Last_Errno: 1594 the master's binary log is corrupted Last_SQL_Errno: 1062
- The file 'none' is corrupted! Remove it and launch unity again!
- unity发布失败,文件读取出错的解决方法(The file 'resources.assets' is corrupted)
- 解决Unity的 The file 'MemoryStream' is corrupted! Remove it and launch 崩溃问题
- The file "MemoryStream" is corrupted! Remove it and launch unity again!
- Oracle使用Linux nfs方式挂载备份文件后访问出错The file header is corrupted
- Unity 移动端 The file 'none' is corrupted. 报错解决
- [Unity问题]The file "MemoryStream" is corrupted! Remove it and launch unity again!
- mvc controller 解析上传的中文数据总是乱码问题
- 数据结构-图
- 我在学习程序中遇到的问题!
- 批量删除Maven中失败的下载项
- Android开发之ExpandableListView: 可展开的ListView
- warning The transaction log file is corrupted.
- Server Tomcat v6.0 Server at localhost was unable to start within 40 seconds.
- 【C++探索之旅】第一部分第十三课:第一部分小测验
- 在Yaf中使用Yar
- HDU 3271 SNIBB[数位DP]
- C++扬帆远航——5(换分币)
- 自定义view,实现手势密码功能
- java多线程Runnable、Callable、Executor、Future、FutureTask关系解读
- mvn clean install -e -U