Re: How to create a SQL engine like MySQL server

On Thu, Jan 29, 2015 at 6:16 AM, Stewart Smith
<[email protected]> wrote:
[...]
> Check out some older libdrizzle, it had some server side
> support. There's some documentation there too. The protocol isn't *that*
> tricky, you could probably work it out from looking at some sources or
> other protocol documentation. Also, there's no *real* good reason to be
> wire compatible, the MySQL protocol isn't that great for a number of
> reasons. A simple wrapper around protobufs is probably vastly superior.
>
> You should be able to expand libattachsql to support server side things,
> Andrew is pretty awesome and would quite likely love patches.
>

I have not found MySQL server side protocol part codes (can be
connected by MySQL client) in drizzle codes. However, I found
MySQL-Proxy seems what I want. I did some experiments showing here
(http://tab.d-thinker.org/showthread.php?tid=3083&pid=7688#pid7688)

After I did the experiments, I had two questions as follows.

Questions
1, When I start MySQL-proxy, it gives me a message showing "2015-01-29
11:07:10: (critical) chassis.c:968: could not raise RLIMIT_NOFILE to
8192, Invalid argument (22). Current limit still 1024."

2, I cannot connect to MySQL-Proxy with port 4040 by MySQL-client.


I am not clear about above two questions. Still, I may
design/implement a lightweight MySQL-server side (currently, I want it
can only be connected by MySQL-client) taking MySQL-proxy as a
reference, cann't I?


Thanks, Harry

-- 
MySQL Internals Mailing List
For list archives: http://lists.mysql.com/internals
To unsubscribe:    http://lists.mysql.com/internals