maria-discuss team mailing list archive
-
maria-discuss team
-
Mailing list archive
-
Message #02278
Re: MariaDB 10 multisource replication from AWS MySQL 5.6 RDS and Percona Server 5.6
-
To:
maria-discuss@xxxxxxxxxxxxxxxxxxx
-
From:
Reindl Harald <h.reindl@xxxxxxxxxxxxx>
-
Date:
Mon, 16 Feb 2015 23:02:33 +0100
-
In-reply-to:
<CAPrRguAC9zqZ5XTAKbFqfBPmkZznnhEi68KQkJqBy=9YfOkHZQ@mail.gmail.com>
-
Openpgp:
id=7F780279; url=http://arrakis.thelounge.net/gpg/h.reindl_thelounge.net.pub.txt
-
Organization:
the lounge interactive design
-
User-agent:
Mozilla/5.0 (X11; Linux x86_64; rv:31.0) Gecko/20100101 Thunderbird/31.4.0
Am 16.02.2015 um 22:53 schrieb Vadim Pestovnikov:
Thank you Reindl.
So basically what that means is that mariadb is not 100% compatable with
percona and mysql?
define 100% - replication is a *binary log*
if it would be identical in every aspect it would exist only one product
and even if all docs pretend 100% compatibility i would never come to
the idea even run different minor versions in a replication setup
just follow these instructions leads to the conclusion mix different
products is a bad idea:
http://dev.mysql.com/doc/refman/5.0/en/replication-upgrade.html
P.S.: i don't appreciate off-list replies
On Feb 16, 2015 1:23 PM, "Reindl Harald" <h.reindl@xxxxxxxxxxxxx
<mailto:h.reindl@xxxxxxxxxxxxx>> wrote:
Am 16.02.2015 um 22:19 schrieb Vadim Pestovnikov:
Error in Log_event::read_log_event(): 'Found invalid event in binary
log', data_len: 44, event_type: 33
Error reading relay log event: slave SQL thread aborted because
of I/O error
My slave is MariaDB 10 with data and logs partitions encrypted
by LUKS
and with SSL enabled. As far as RDS and Percona servers don't
use SSL I
am using non SSL user for the replication.
Any recommendations or suggestions would be extremely appreciated
don't mix different server versions in replication setups
there is a good reason why it is recommended always to update first
the slaves, run "mysql_upgrade" and then the masters to be 100% sure
that the maste rnever don't write anything into the binlog the slave
won't understand because differences in details
Attachment:
signature.asc
Description: OpenPGP digital signature
Follow ups
References