[Maria-discuss] mysqlbinlog
Hello All, I've been playing with mysqlbinlog today. I'm Looking at performing backups of the binary logs. The MariaDB<https://mariadb.com/kb/en/mariadb/mysqlbinlog-options/> mysqlbinlog lags behind the MySQL<https://mariadb.com/kb/en/mariadb/mysqlbinlog-options/> 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
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@swisscom.com> <Rhys.Campbell@swisscom.com> 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@lists.launchpad.net Unsubscribe : https://launchpad.net/~maria-discuss More help : https://help.launchpad.net/ListHelp
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@gmail.com> Date: 09/07/2015 18:20 (GMT+01:00) To: "Campbell Rhys, INI-TPD-QPM" <Rhys.Campbell@swisscom.com> Cc: "<maria-discuss@lists.launchpad.net>" <maria-discuss@lists.launchpad.net> 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@swisscom.com<mailto:Rhys.Campbell@swisscom.com>> <Rhys.Campbell@swisscom.com<mailto:Rhys.Campbell@swisscom.com>> wrote: Hello All, I've been playing with mysqlbinlog today. I'm Looking at performing backups of the binary logs. The MariaDB<https://mariadb.com/kb/en/mariadb/mysqlbinlog-options/> mysqlbinlog lags behind the MySQL<https://mariadb.com/kb/en/mariadb/mysqlbinlog-options/> 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@lists.launchpad.net<mailto:maria-discuss@lists.launchpad.net> Unsubscribe : https://launchpad.net/~maria-discuss More help : https://help.launchpad.net/ListHelp
Rhys, Just saying, but your request would probably have more traction if you opened a FR in our Jira. -GL Le 9 juil. 2015 18:29, <Rhys.Campbell@swisscom.com> a écrit :
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@gmail.com> Date: 09/07/2015 18:20 (GMT+01:00) To: "Campbell Rhys, INI-TPD-QPM" <Rhys.Campbell@swisscom.com> Cc: "<maria-discuss@lists.launchpad.net>" < maria-discuss@lists.launchpad.net> 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@swisscom.com> < Rhys.Campbell@swisscom.com> wrote:
Hello All,
I’ve been playing with mysqlbinlog today. I’m Looking at performing backups of the binary logs.
The MariaDB <https://mariadb.com/kb/en/mariadb/mysqlbinlog-options/> mysqlbinlog lags behind the MySQL <https://mariadb.com/kb/en/mariadb/mysqlbinlog-options/> 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@lists.launchpad.net Unsubscribe : https://launchpad.net/~maria-discuss More help : https://help.launchpad.net/ListHelp
_______________________________________________ Mailing list: https://launchpad.net/~maria-discuss Post to : maria-discuss@lists.launchpad.net Unsubscribe : https://launchpad.net/~maria-discuss More help : https://help.launchpad.net/ListHelp
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@swisscom.com> 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@gmail.com> Date: 09/07/2015 18:20 (GMT+01:00) To: "Campbell Rhys, INI-TPD-QPM" <Rhys.Campbell@swisscom.com> Cc: "<maria-discuss@lists.launchpad.net>" < maria-discuss@lists.launchpad.net> 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@swisscom.com> < Rhys.Campbell@swisscom.com> wrote:
Hello All,
I’ve been playing with mysqlbinlog today. I’m Looking at performing backups of the binary logs.
The MariaDB <https://mariadb.com/kb/en/mariadb/mysqlbinlog-options/> mysqlbinlog lags behind the MySQL <https://mariadb.com/kb/en/mariadb/mysqlbinlog-options/> 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@lists.launchpad.net Unsubscribe : https://launchpad.net/~maria-discuss More help : https://help.launchpad.net/ListHelp
_______________________________________________ Mailing list: https://launchpad.net/~maria-discuss Post to : maria-discuss@lists.launchpad.net Unsubscribe : https://launchpad.net/~maria-discuss More help : https://help.launchpad.net/ListHelp
-- Guillaume Lefranc RemoteDBA Services Manager - MariaDB Corporation Ab +33682425893
It might do. I'll take a look. Thanks. Rhys Sent from my Samsung Galaxy smartphone. -------- Original message -------- From: Guillaume Lefranc <guillaume.lefranc@mariadb.com> Date: 09/07/2015 18:40 (GMT+01:00) To: "Campbell Rhys, INI-TPD-QPM" <Rhys.Campbell@swisscom.com> Cc: greenlion@gmail.com, maria-discuss@lists.launchpad.net Subject: Re: [Maria-discuss] mysqlbinlog 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@swisscom.com<mailto:Rhys.Campbell@swisscom.com>> 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@gmail.com<mailto:greenlion@gmail.com>> Date: 09/07/2015 18:20 (GMT+01:00) To: "Campbell Rhys, INI-TPD-QPM" <Rhys.Campbell@swisscom.com<mailto:Rhys.Campbell@swisscom.com>> Cc: "<maria-discuss@lists.launchpad.net<mailto:maria-discuss@lists.launchpad.net>>" <maria-discuss@lists.launchpad.net<mailto:maria-discuss@lists.launchpad.net>> 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@swisscom.com<mailto:Rhys.Campbell@swisscom.com>> <Rhys.Campbell@swisscom.com<mailto:Rhys.Campbell@swisscom.com>> wrote: Hello All, I've been playing with mysqlbinlog today. I'm Looking at performing backups of the binary logs. The MariaDB<https://mariadb.com/kb/en/mariadb/mysqlbinlog-options/> mysqlbinlog lags behind the MySQL<https://mariadb.com/kb/en/mariadb/mysqlbinlog-options/> 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@lists.launchpad.net<mailto:maria-discuss@lists.launchpad.net> Unsubscribe : https://launchpad.net/~maria-discuss More help : https://help.launchpad.net/ListHelp _______________________________________________ Mailing list: https://launchpad.net/~maria-discuss Post to : maria-discuss@lists.launchpad.net<mailto:maria-discuss@lists.launchpad.net> Unsubscribe : https://launchpad.net/~maria-discuss More help : https://help.launchpad.net/ListHelp -- Guillaume Lefranc RemoteDBA Services Manager - MariaDB Corporation Ab +33682425893
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@mariadb.com> 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@swisscom.com> 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@gmail.com> Date: 09/07/2015 18:20 (GMT+01:00) To: "Campbell Rhys, INI-TPD-QPM" <Rhys.Campbell@swisscom.com> Cc: "<maria-discuss@lists.launchpad.net>" <maria-discuss@lists.launchpad.net> 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@swisscom.com> <Rhys.Campbell@swisscom.com> 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@lists.launchpad.net Unsubscribe : https://launchpad.net/~maria-discuss More help : https://help.launchpad.net/ListHelp
_______________________________________________ Mailing list: https://launchpad.net/~maria-discuss Post to : maria-discuss@lists.launchpad.net Unsubscribe : https://launchpad.net/~maria-discuss More help : https://help.launchpad.net/ListHelp
-- Guillaume Lefranc RemoteDBA Services Manager - MariaDB Corporation Ab +33682425893
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@gmail.com> 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@mariadb.com> 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@swisscom.com> 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@gmail.com> Date: 09/07/2015 18:20 (GMT+01:00) To: "Campbell Rhys, INI-TPD-QPM" <Rhys.Campbell@swisscom.com> Cc: "<maria-discuss@lists.launchpad.net>" < maria-discuss@lists.launchpad.net> 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@swisscom.com> < Rhys.Campbell@swisscom.com> wrote:
Hello All,
I’ve been playing with mysqlbinlog today. I’m Looking at performing backups of the binary logs.
The MariaDB <https://mariadb.com/kb/en/mariadb/mysqlbinlog-options/> mysqlbinlog lags behind the MySQL <https://mariadb.com/kb/en/mariadb/mysqlbinlog-options/> 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@lists.launchpad.net Unsubscribe : https://launchpad.net/~maria-discuss More help : https://help.launchpad.net/ListHelp
_______________________________________________ Mailing list: https://launchpad.net/~maria-discuss Post to : maria-discuss@lists.launchpad.net 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
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. Sent from my iPhone
On Jul 9, 2015, at 10:05 AM, Guillaume Lefranc <guillaume.lefranc@mariadb.com> 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@gmail.com> 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@mariadb.com> 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@swisscom.com> 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@gmail.com> Date: 09/07/2015 18:20 (GMT+01:00) To: "Campbell Rhys, INI-TPD-QPM" <Rhys.Campbell@swisscom.com> Cc: "<maria-discuss@lists.launchpad.net>" <maria-discuss@lists.launchpad.net> 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@swisscom.com> <Rhys.Campbell@swisscom.com> 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@lists.launchpad.net Unsubscribe : https://launchpad.net/~maria-discuss More help : https://help.launchpad.net/ListHelp
_______________________________________________ Mailing list: https://launchpad.net/~maria-discuss Post to : maria-discuss@lists.launchpad.net 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
On 10 Jul 2015, at 01:11, Justin Swanhart <greenlion@gmail.com> 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@mariadb.com> 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@gmail.com> 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@mariadb.com> 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@swisscom.com> 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@gmail.com> Date: 09/07/2015 18:20 (GMT+01:00) To: "Campbell Rhys, INI-TPD-QPM" <Rhys.Campbell@swisscom.com> Cc: "<maria-discuss@lists.launchpad.net>" <maria-discuss@lists.launchpad.net> 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@swisscom.com> <Rhys.Campbell@swisscom.com> 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@lists.launchpad.net Unsubscribe : https://launchpad.net/~maria-discuss More help : https://help.launchpad.net/ListHelp
_______________________________________________ Mailing list: https://launchpad.net/~maria-discuss Post to : maria-discuss@lists.launchpad.net 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@lists.launchpad.net 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
I will, thanks for the info; I'll ping Colin too. On Thu, Jul 9, 2015 at 7:05 PM, Guillaume Lefranc < guillaume.lefranc@mariadb.com> 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@gmail.com> 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@mariadb.com> 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@swisscom.com> 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@gmail.com> Date: 09/07/2015 18:20 (GMT+01:00) To: "Campbell Rhys, INI-TPD-QPM" <Rhys.Campbell@swisscom.com> Cc: "<maria-discuss@lists.launchpad.net>" < maria-discuss@lists.launchpad.net> 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@swisscom.com> < Rhys.Campbell@swisscom.com> wrote:
Hello All,
I’ve been playing with mysqlbinlog today. I’m Looking at performing backups of the binary logs.
The MariaDB <https://mariadb.com/kb/en/mariadb/mysqlbinlog-options/> mysqlbinlog lags behind the MySQL <https://mariadb.com/kb/en/mariadb/mysqlbinlog-options/> 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@lists.launchpad.net Unsubscribe : https://launchpad.net/~maria-discuss More help : https://help.launchpad.net/ListHelp
_______________________________________________ Mailing list: https://launchpad.net/~maria-discuss Post to : maria-discuss@lists.launchpad.net 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
-- Guillaume Lefranc RemoteDBA Services Manager - MariaDB Corporation Ab +33682425893
What exactly do you mean? It is 100% compatible with MariaDB! Sent from my iPhone
On Jul 9, 2015, at 9:28 AM, <Rhys.Campbell@swisscom.com> <Rhys.Campbell@swisscom.com> 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@gmail.com> Date: 09/07/2015 18:20 (GMT+01:00) To: "Campbell Rhys, INI-TPD-QPM" <Rhys.Campbell@swisscom.com> Cc: "<maria-discuss@lists.launchpad.net>" <maria-discuss@lists.launchpad.net> 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@swisscom.com> <Rhys.Campbell@swisscom.com> 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@lists.launchpad.net Unsubscribe : https://launchpad.net/~maria-discuss More help : https://help.launchpad.net/ListHelp
No it isn't. Gtids is one example. Sent from my Samsung Galaxy smartphone. -------- Original message -------- From: Justin Swanhart <greenlion@gmail.com> Date: 09/07/2015 19:02 (GMT+01:00) To: "Campbell Rhys, INI-TPD-QPM" <Rhys.Campbell@swisscom.com> Cc: "<maria-discuss@lists.launchpad.net>" <maria-discuss@lists.launchpad.net> Subject: Re: [Maria-discuss] mysqlbinlog What exactly do you mean? It is 100% compatible with MariaDB! Sent from my iPhone On Jul 9, 2015, at 9:28 AM, <Rhys.Campbell@swisscom.com<mailto:Rhys.Campbell@swisscom.com>> <Rhys.Campbell@swisscom.com<mailto:Rhys.Campbell@swisscom.com>> 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@gmail.com<mailto:greenlion@gmail.com>> Date: 09/07/2015 18:20 (GMT+01:00) To: "Campbell Rhys, INI-TPD-QPM" <Rhys.Campbell@swisscom.com<mailto:Rhys.Campbell@swisscom.com>> Cc: "<maria-discuss@lists.launchpad.net<mailto:maria-discuss@lists.launchpad.net>>" <maria-discuss@lists.launchpad.net<mailto:maria-discuss@lists.launchpad.net>> 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@swisscom.com<mailto:Rhys.Campbell@swisscom.com>> <Rhys.Campbell@swisscom.com<mailto:Rhys.Campbell@swisscom.com>> wrote: Hello All, I've been playing with mysqlbinlog today. I'm Looking at performing backups of the binary logs. The MariaDB<https://mariadb.com/kb/en/mariadb/mysqlbinlog-options/> mysqlbinlog lags behind the MySQL<https://mariadb.com/kb/en/mariadb/mysqlbinlog-options/> 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@lists.launchpad.net<mailto:maria-discuss@lists.launchpad.net> Unsubscribe : https://launchpad.net/~maria-discuss More help : https://help.launchpad.net/ListHelp
Hi, Well, I wasn't aware that mariadb made non-compatible binlog changes. Oh well. I guess you will have to wait for a working mysqlbinlog in mariadb, or path mysql mysqlbinlog to handle MariaDB GTID (which should be trivial). --Justin On Thu, Jul 9, 2015 at 10:21 AM, <Rhys.Campbell@swisscom.com> wrote:
No it isn't. Gtids is one example.
Sent from my Samsung Galaxy smartphone.
-------- Original message -------- From: Justin Swanhart <greenlion@gmail.com> Date: 09/07/2015 19:02 (GMT+01:00) To: "Campbell Rhys, INI-TPD-QPM" <Rhys.Campbell@swisscom.com> Cc: "<maria-discuss@lists.launchpad.net>" < maria-discuss@lists.launchpad.net> Subject: Re: [Maria-discuss] mysqlbinlog
What exactly do you mean? It is 100% compatible with MariaDB!
Sent from my iPhone
On Jul 9, 2015, at 9:28 AM, <Rhys.Campbell@swisscom.com> < Rhys.Campbell@swisscom.com> 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@gmail.com> Date: 09/07/2015 18:20 (GMT+01:00) To: "Campbell Rhys, INI-TPD-QPM" <Rhys.Campbell@swisscom.com> Cc: "<maria-discuss@lists.launchpad.net>" < maria-discuss@lists.launchpad.net> 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@swisscom.com> < Rhys.Campbell@swisscom.com> wrote:
Hello All,
I’ve been playing with mysqlbinlog today. I’m Looking at performing backups of the binary logs.
The MariaDB <https://mariadb.com/kb/en/mariadb/mysqlbinlog-options/> mysqlbinlog lags behind the MySQL <https://mariadb.com/kb/en/mariadb/mysqlbinlog-options/> 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@lists.launchpad.net Unsubscribe : https://launchpad.net/~maria-discuss More help : https://help.launchpad.net/ListHelp
participants (4)
-
Colin Charles -
Guillaume Lefranc -
Justin Swanhart -
Rhys.Campbell＠swisscom.com