[Maria-discuss] mysqlbinlog
Hello All,
I've been playing with mysqlbinlog today. I'm Looking at performing backups of the binary logs.
The MariaDBhttps://mariadb.com/kb/en/mariadb/mysqlbinlog-options/ mysqlbinlog lags behind the MySQLhttps://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.commailto:Rhys.Campbell@swisscom.com> <Rhys.Campbell@swisscom.commailto: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 MariaDBhttps://mariadb.com/kb/en/mariadb/mysqlbinlog-options/ mysqlbinlog lags behind the MySQLhttps://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.netmailto: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
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.commailto: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.commailto:greenlion@gmail.com> Date: 09/07/2015 18:20 (GMT+01:00) To: "Campbell Rhys, INI-TPD-QPM" <Rhys.Campbell@swisscom.commailto:Rhys.Campbell@swisscom.com> Cc: "<maria-discuss@lists.launchpad.netmailto:maria-discuss@lists.launchpad.net>" <maria-discuss@lists.launchpad.netmailto: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.commailto:Rhys.Campbell@swisscom.com> <Rhys.Campbell@swisscom.commailto: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 MariaDBhttps://mariadb.com/kb/en/mariadb/mysqlbinlog-options/ mysqlbinlog lags behind the MySQLhttps://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.netmailto: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.netmailto: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
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
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.commailto:Rhys.Campbell@swisscom.com> <Rhys.Campbell@swisscom.commailto: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.commailto:greenlion@gmail.com> Date: 09/07/2015 18:20 (GMT+01:00) To: "Campbell Rhys, INI-TPD-QPM" <Rhys.Campbell@swisscom.commailto:Rhys.Campbell@swisscom.com> Cc: "<maria-discuss@lists.launchpad.netmailto:maria-discuss@lists.launchpad.net>" <maria-discuss@lists.launchpad.netmailto: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.commailto:Rhys.Campbell@swisscom.com> <Rhys.Campbell@swisscom.commailto: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 MariaDBhttps://mariadb.com/kb/en/mariadb/mysqlbinlog-options/ mysqlbinlog lags behind the MySQLhttps://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.netmailto: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