← Back to team overview

maria-discuss team mailing list archive

Re: mysqlbinlog

 

On 10 Jul 2015, at 01:11, Justin Swanhart <greenlion@xxxxxxxxx> wrote:

> There is a closed Oracle MySQL bug.  I thought you guys tracked upstream for 5.6 changes but I guess not, at least not in this case:
> 
> https://bugs.mysql.com/bug.php?id=65812
> 
> I've spoken with Colin about it on Facebook and at FOSDEM.
> 
> The new features such as --follow and --raw are missing as well.
> 
> If possible, can you file a Jira task if none exists?  I am a bit busy atm.  If you can't  I'll file one later this week.
> 

we have a jira task -- https://mariadb.atlassian.net/browse/MDEV-4989
and now we have https://mariadb.atlassian.net/browse/MDEV-8473 as a related bug

Our target to fix this is 10.2 

> 
> Sent from my iPhone
> 
> On Jul 9, 2015, at 10:05 AM, Guillaume Lefranc <guillaume.lefranc@xxxxxxxxxxx> wrote:
> 
>> Justin do you have a bug case open? If yes can you reference the #?
>> 
>> On Thu, Jul 9, 2015 at 7:04 PM, Justin Swanhart <greenlion@xxxxxxxxx> wrote:
>> These MySQLbinlog features are extremely important.  It is extra ridiculous that I have to force users to use Oracle mysqlbinlog with MariaDB to decode DECIMAL.  It is silly and stupid and sad.
>> 
>> Sent from my iPhone
>> 
>> On Jul 9, 2015, at 9:40 AM, Guillaume Lefranc <guillaume.lefranc@xxxxxxxxxxx> wrote:
>> 
>>> Thinking of something else, would the MaxScale Binlog Server module satisfy your use case? I'm not 100% sure of what you need. If you need to stream binlogs, Binlog Server can do that.
>>> 
>>> -GL
>>> 
>>> On Thu, Jul 9, 2015 at 6:28 PM, <Rhys.Campbell@xxxxxxxxxxxx> wrote:
>>> Thanks but it's not going to work for my use case.
>>> 
>>> Rhys
>>> 
>>> 
>>> 
>>> Sent from my Samsung Galaxy smartphone.
>>> 
>>> 
>>> -------- Original message --------
>>> From: Justin Swanhart <greenlion@xxxxxxxxx>
>>> Date: 09/07/2015 18:20 (GMT+01:00)
>>> To: "Campbell Rhys, INI-TPD-QPM" <Rhys.Campbell@xxxxxxxxxxxx>
>>> Cc: "<maria-discuss@xxxxxxxxxxxxxxxxxxx>" <maria-discuss@xxxxxxxxxxxxxxxxxxx>
>>> Subject: Re: [Maria-discuss] mysqlbinlog
>>> 
>>> I use non-MariaDB mysqlbinlog with MariaDB all the time.  Flexviews users needs to use the MySQL version because MariaDB mysqlbinlog does not properly decide DECIMAL columns when displaying RBR with -v
>>> 
>>> Sent from my iPhone
>>> 
>>> On Jul 9, 2015, at 3:23 AM, <Rhys.Campbell@xxxxxxxxxxxx> <Rhys.Campbell@xxxxxxxxxxxx> wrote:
>>> 
>>>> Hello All,
>>>> 
>>>>  
>>>> I’ve been playing with mysqlbinlog today. I’m Looking at performing backups of the binary logs.  
>>>> 
>>>>  
>>>> The MariaDB mysqlbinlog lags behind the MySQL version in the sense it’s missing a few features. Namely the ability to ‘tail’ a live binary log…
>>>> 
>>>>  
>>>> mysqlbinlog --read-from-remote-server --host=host_name --raw
>>>> 
>>>>   --stop-never binlog.000999
>>>> 
>>>>  
>>>> I haven’t fully tested this but running the MySQL version against MariaDB doesn’t appear viable. I’m probably going to fall back to a FLUSH LOGS / file copy solution for the moment.
>>>> 
>>>>  
>>>> What would be the chances of back-porting these features into the MariaDB version?
>>>> 
>>>>  
>>>> Cheers,
>>>> 
>>>>  
>>>> Rhys
>>>> 
>>>> _______________________________________________
>>>> Mailing list: https://launchpad.net/~maria-discuss
>>>> Post to     : maria-discuss@xxxxxxxxxxxxxxxxxxx
>>>> Unsubscribe : https://launchpad.net/~maria-discuss
>>>> More help   : https://help.launchpad.net/ListHelp
>>> 
>>> _______________________________________________
>>> Mailing list: https://launchpad.net/~maria-discuss
>>> Post to     : maria-discuss@xxxxxxxxxxxxxxxxxxx
>>> Unsubscribe : https://launchpad.net/~maria-discuss
>>> More help   : https://help.launchpad.net/ListHelp
>>> 
>>> 
>>> 
>>> 
>>> -- 
>>> Guillaume Lefranc
>>> RemoteDBA Services Manager - MariaDB Corporation Ab
>>>  +33682425893
>> 
>> 
>> 
>> -- 
>> Guillaume Lefranc
>> RemoteDBA Services Manager - MariaDB Corporation Ab
>>  +33682425893
> _______________________________________________
> Mailing list: https://launchpad.net/~maria-discuss
> Post to     : maria-discuss@xxxxxxxxxxxxxxxxxxx
> Unsubscribe : https://launchpad.net/~maria-discuss
> More help   : https://help.launchpad.net/ListHelp

--
Colin Charles, Chief Evangelist, MariaDB Corporation
blog: http://bytebot.net/blog/ | t: +6-012-204-3201 | Skype: colincharles



References