linkedin/databus

How to generate Mysql table schema?

synckey opened this issue · 6 comments

Dear all
I want to use databus with Mysql.But the com.linkedin.databus.util.InteractiveSchemaGenerator tool and related classes can only generate Oracle DB Table schemas. It seems that there is not a tool for Mysql to generate schemas.Is there any alternative ways for me to do with mysql?
Thanks.

I haven't found something for this yet, but it would be helpful. Wonder if I can set aside some time in the next week or two to update that to work.

For now. I've just been doing them by hand. All sorts of fun for 30+ column tables...

Currently, we haven't updated the tool to support vanilla MySQL. In
general, the Avro schema can be any schema as long as it has some metadata
about the mapping from an Avro field to a DB field. Let me first write a
Wiki about the meta data format in the next couple of days.

On Tue, Nov 18, 2014 at 9:05 AM, Jason Powers notifications@github.com
wrote:

I haven't found something for this yet, but it would be helpful. Wonder if
I can set aside some time in the next week or two to update that to work.


Reply to this email directly or view it on GitHub
#46 (comment).

In the databus cmdtool, there is a dbus2-avro-schema-gen.sh script which could create the schema, but it does not support the mysql well, I suggest that you could modify the codes for mysql and use this tool.

Hi,all
I'v written a tool that can generate avro schema from mysql table.The tool is based on sqool code, I wonder if I can write the tool on that way and if I have the right to contribute it to the databus.

Thanks @jagadeesh-huliyar. Do you use databus for Mysql in your organization? Are you using this avro schema generator with respect to databus for Mysql?

Hi @hopecheng - Hope your question is answered.

Thanks,
Srini.