Skip to content

jvaidya/mysql-vt-proxy

Folders and files

NameName
Last commit message
Last commit date

Latest commit

 

History

3 Commits
 
 
 
 
 
 
 
 
 
 
 
 

Repository files navigation


*NOTE*: This project has become obsolete because Vitess now natively supports MySQL protocol.

mysql-vt-proxy allows clients that speak mysql text protocol to talk to the
vtgate component of vitess (http://www.vitess.io)

BUILD

cd vendor
govendor sync
cd ..
go build .

START SERVER

The following assumes that you have all vitess components running locally.

./mysql-vt-proxy -host 0.0.0.0 -P 15891 -vtgate "localhost:15991" -keyspace test_keyspace -tablettype master
I0106 15:34:14.362505    4520 main.go:58] Welcome to Mysql Vitess proxy.
I0106 15:34:14.362935    4520 main.go:59] Will use vtgate at localhost:15991 for test_keyspace:master
I0106 15:34:14.363242    4520 server.go:141] Server run MySQL Protocol Listen at [0.0.0.0:15891]
I0106 15:34:14.363624    4520 server.go:227] Listening on :10080 for status and metrics report.


CONNECT WITH CLIENT

/usr/local/mysql/bin/mysql -h 127.0.0.1 -P 15891 -u root -D test

Welcome to the MariaDB monitor.  Commands end with ; or \g.
Your MySQL connection id is 2
Server version: 5.7.1-TiDB-1.0 MariaDB Server

Copyright (c) 2000, 2016, Oracle, MariaDB Corporation Ab and others.

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

MySQL [test]> select * from messages;
+------+---------------------+--------------------------------+
| page | time_created_ns     | message                        |
+------+---------------------+--------------------------------+
|    9 | 1481525197125355008 | V is for speed                 |
|   14 | 1481525197109026816 | V is for speed                 |
|   78 | 1481525197078208000 | V is for speed                 |
+------+---------------------+--------------------------------+
3 rows in set (0.01 sec)

MySQL [test]> 

About

No description, website, or topics provided.

Resources

Stars

Watchers

Forks

Releases

No releases published

Packages

No packages published