Add XAPI support

[rykr]

Hey guys

Any interest in adding xapi support to your Go driver to support the new protocol and APIs that we have introduced with 5.7? If so please reach out to me as we would love to help.

[methane]

I am.
Is it stable now?

[dgryski]

@rykr Do you mean https://dev.mysql.com/doc/internals/en/x-protocol.html ?

[rykr]

@methane @dgryski Yes that is the one. The protocol is documented although new features are still being added but what has been documented and released is certainly stable enough to work against. The API is not publicly documented as a standard but our released connectors show the pattern we are using. Certainly driver developers can use whatever API they choose but we feel it would be better to follow a similar pattern.

[rykr]

We will be setting up a page highlighting externally maintained drivers. When that page is ready would be ok to list this provider there?

[methane]

@rykr While I'm interested in X Protocol, I don't know this project should use it.
This project doesn't provide APIs to users directly. It works behind "database/sql" standard library.
So providing X Dev API is out of scope.

One possibility is use X Protocol only for standard SQL. I'll try it and benchmark it.
If it's significant faster than current MySQL protocol, I'll create RFC issue here.

[dgryski]

@sjmudd has been working on implementing a Go driver for the X Protocol, and will be speaking about it at Oracle OpenWorld 2016 in SF. He probably has something useful to contribute to this discussion.

[rykr]

Great. Will that be a different project here on GitHub?

On Sep 7, 2016 3:27 AM, "Damian Gryski" notifications@github.com wrote:

@sjmudd https://github.com/sjmudd has been working on implementing a Go
driver for the X Protocol, and will be speaking about it at Oracle
OpenWorld 2016 in SF. He probably has something useful to contribute to
this discussion.

—
You are receiving this because you were mentioned.
Reply to this email directly, view it on GitHub
#478 (comment),
or mute the thread
https://github.com/notifications/unsubscribe-auth/AAGpXLp18iXv6n57afOWyGWAVsqIB5sQks5qnnVWgaJpZM4J15XK
.

[sjmudd]

It will be yes. It's still at an early stage and I can talk to you directly if you're interested.

[sjmudd]

There seem to be several different issues here:

• Support for the new API (document store) which might work through the existing MySQL protocol. I would not expect that database/sql would be able to support that as it only supports a "SQL interface"
• Support for the X protocol, announced in the MySQL 5.7.12 server, in database/sql. This as I've seen has some issues as use of the X protocol potentially provides more flexibility to the user. However the user will be unlikely to be able to make use of these features as database/sql does not provide any hooks into lower level drivers which might be relevant here.
• To make use of all the planned features in the X protocol perhaps a full driver is needed and this has all the inconvenience of starting from scratch.
• See also: database/sql: add API and give it some love golang/go#16673 which is relevant.
• Also note that for other languages MySQL exposes the protocol for "Document store" access using the XDEV API: https://dev.mysql.com/doc/x-devapi-userguide/en/. This does not use SQL at all and it may be that some Go users might want to have a similar interface as offered in other currently supported languages.

[lefred]

Hi, what kind of help are you looking for ? Our MySQL connectors engineer will be please to answer all your questions and provide you directions to include MySQL X Protocol to the Go SQL Driver. Please join #connectors in MySQL Community Slack (https://lefred.be/mysql-community-on-slack/)

[dgryski]

@lefred Does Oracle have any plans for contributing an XAPI driver for Go?