All Projects → arstercz → Portproxy

arstercz / Portproxy

A TCP port proxy to record MySQL sql query

Programming Languages

go
31211 projects - #10 most used programming language

Labels

Projects that are alternatives of or similar to Portproxy

Go Mysql Server
An extensible MySQL server implementation in Go.
Stars: ✭ 1,017 (+1855.77%)
Mutual labels:  mysql
Admin
AutoQuery + Admin UI for ServiceStack Projects
Stars: ✭ 47 (-9.62%)
Mutual labels:  mysql
Grocerystore With Server
Grocery Store with server integration
Stars: ✭ 51 (-1.92%)
Mutual labels:  mysql
Phalcon Vm
Vagrant configuration for PHP7, Phalcon 3.x and Zephir development.
Stars: ✭ 43 (-17.31%)
Mutual labels:  mysql
Node Server Project
基于 node.js + express 技术栈,采用MVC结构设计、JWT + RESTful API、PM2服务监控的Node服务器端项目框架.
Stars: ✭ 47 (-9.62%)
Mutual labels:  mysql
Racingworld
💥 A multiplayer online 3D game about racing 💥
Stars: ✭ 50 (-3.85%)
Mutual labels:  mysql
Usermanager React Native
Login and Signup system with PHP/MySQL and Json in React native
Stars: ✭ 42 (-19.23%)
Mutual labels:  mysql
Mycollab
An open source, free, high performance, stable and secure Java Application Business Platform of Project Management and Document
Stars: ✭ 1,063 (+1944.23%)
Mutual labels:  mysql
Kiba Plus
Kiba enhancement for Ruby ETL.
Stars: ✭ 47 (-9.62%)
Mutual labels:  mysql
Aclify
🔒 Node Access Control Lists (ACL).
Stars: ✭ 49 (-5.77%)
Mutual labels:  mysql
Activity
A PHP API to log anything anywhere
Stars: ✭ 44 (-15.38%)
Mutual labels:  mysql
Mybatis Generator Plugin
Mybatis Generator 代码生成插件拓展,增加:查询单条数据插件(SelectOneByExamplePlugin)、MySQL分页插件(LimitPlugin)、数据Model链式构建插件(ModelBuilderPlugin)、Example Criteria 增强插件(ExampleEnhancedPlugin)、Example 目标包修改插件(ExampleTargetPlugin)、批量插入插件(BatchInsertPlugin)、逻辑删除插件(LogicalDeletePlugin)、数据Model属性对应Column获取插件(ModelColumnPlugin)、存在即更新(UpsertPlugin)、Selective选择插入更新增强插件(SelectiveEnhancedPlugin)、Table增加前缀插件(TableSuffixPlugin)、自定义注释插件(CommentPlugin)、增量插件(IncrementsPlugin)、查询结果选择性返回插件(SelectSelectivePlugin)、乐观锁插件(OptimisticLockerPlugin)、LombokPlugin等拓展。
Stars: ✭ 1,038 (+1896.15%)
Mutual labels:  mysql
Tianti
java轻量级的CMS解决方案-天梯。天梯是一个用java相关技术搭建的后台CMS解决方案,用户可以结合自身业务进行相应扩展,同时提供了针对dao、service等的代码生成工具。技术选型:Spring Data JPA、Hibernate、Shiro、 Spring MVC、Layer、Mysql等。
Stars: ✭ 1,053 (+1925%)
Mutual labels:  mysql
Drupal Nginx Php Kubernetes
Demonstration of a set of NGINX and PHP-FPM containers running Drupal deployed to Kubernetes on the IBM Container Service. This is a work in progress.
Stars: ✭ 43 (-17.31%)
Mutual labels:  mysql
Springboot Beginner
🔰 📝 这可能是流程最清晰、代码最干净、注释最详细的 SpringBoot 入门项目咯,对于初学 SpringBoot 的同学非常具有参考与学习价值哟 ~
Stars: ✭ 51 (-1.92%)
Mutual labels:  mysql
Laravel
Muito conteúdo sobre o framework Laravel. Controllers, Models, Views, Blade, Migrations, Seeders, Middlewares, Autenticação, Autorização, Providers, pacotes, laravel 8, etc.
Stars: ✭ 43 (-17.31%)
Mutual labels:  mysql
Pop
A Tasty Treat For All Your Database Needs
Stars: ✭ 1,045 (+1909.62%)
Mutual labels:  mysql
Ddlparse
DDL parase and Convert to BigQuery JSON schema and DDL statements
Stars: ✭ 52 (+0%)
Mutual labels:  mysql
Hunt Entity
An object-relational mapping (ORM) framework for D language (Similar to JPA / Doctrine), support PostgreSQL and MySQL.
Stars: ✭ 51 (-1.92%)
Mutual labels:  mysql
Finagle
A fault tolerant, protocol-agnostic RPC system
Stars: ✭ 8,126 (+15526.92%)
Mutual labels:  mysql

portproxy

A TCP port proxy utility inspired by qtunnel(https://github.com/getqujing/qtunnel).

note: portproxy does not suport ssl mode(mysql 5.7/8.0 client), only used in test environments.

How to Install

go get github.com/arstercz/portproxy

Usage

Usage of ./portproxy:
  -backend string
        backend server ip and port (default "127.0.0.1:8003")
  -bind string
        locate ip and port (default ":8002")
  -buffer uint
        buffer size (default 4096)
  -conf string
        config file to verify database and record sql query
  -daemon
        run as daemon process
  -logTo string
        stdout or syslog (default "stdout")
  -verbose
        print verbose sql query

portproxy only print mysql queries when conf is not set:

./portproxy -backend="10.0.21.5:3301" -bind=":3316" -buffer=16384  --verbose
2017/01/12 17:27:23 portproxy started.
2017/01/12 17:27:32 client: 10.0.21.7:29110 ==> 10.0.21.5:3316
2017/01/12 17:27:32 proxy: 10.0.21.5:18386 ==> 10.0.21.5:3301
2017/01/12 17:27:32 From 10.0.21.7:29110 To 10.0.21.5:3301; Query: select @@version_comment limit 1
2017/01/12 17:27:48 From 10.0.21.7:29110 To 10.0.21.5:3301; Query: SELECT DATABASE()
2017/01/12 17:27:48 From 10.0.21.7:29110 To 10.0.21.5:3301; schema: use percona
2017/01/12 17:27:48 From 10.0.21.7:29110 To 10.0.21.5:3301; Query: show databases
2017/01/12 17:27:49 From 10.0.21.7:29110 To 10.0.21.5:3301; Query: show tables
2017/01/12 17:27:49 From 10.0.21.7:29110 To 10.0.21.5:3301; Query: table columns list: item
2017/01/12 17:27:49 From 10.0.21.7:29110 To 10.0.21.5:3301; Query: table columns list: stock
2017/01/12 17:27:56 From 10.0.21.7:29110 To 10.0.21.5:3301; Query: show tables
2017/01/12 17:28:01 From 10.0.21.7:29110 To 10.0.21.5:3301; Query: show create table item
2017/01/12 17:28:04 From 10.0.21.7:29110 To 10.0.21.5:3301; Query: kill 2

changelog:

20200423: skip error when does not set conf option
20170112: log mysql query
Note that the project description data, including the texts, logos, images, and/or trademarks, for each open source project belongs to its rightful owner. If you wish to add or remove any projects, please contact us at [email protected].