The general architecture is using 'slave' worker threads on the
slave machine to process replicated transactions to the slave databases.
MySQL Enterprise Backup (MEB) 3.7 - Backup and Restore Examples
I have been working with MEB and put a few examples of
working with MEB on-line. It's not a
comprehensive list of everything MEB does but hopefully will be enough to get
things started. For a more comprehensive
information please see the documentation.
http://dev.mysql.com/doc/mysql-enterprise-backup/3.8/en/index.html
http://dev.mysql.com/doc/mysql-enterprise-backup/3.8/en/index.html
MySQL 5.6 DateTime Column Type
Whilst migrating a table I found an interesting thing. The table contained a datetime field and the plan was to migrate directly from 5.5 to 5.6. The method I choose was to SELECT INTO....OUTFILE (mainly because the table was large, over 1 billion rows, and is partitioned). As I was loading the data into the table using LOAD INFILE it was thoroughing out errors:
ERROR 1292 (22007): Incorrect datetime value: '1970-01-01 00:00:00' for column 'publish_date' at row 2374801
Interestingly enough the earliest time the column can have is '1970-01-01 00:00:01' UTC.
Subscribe to:
Posts (Atom)