memsql完全兼容mysql吗_MemSQL学习笔记-类似MySQL的数据库

比眉伴天荒 2022-10-28 13:26 218阅读 0赞

http://www.gxlcms.com/

\-- 多主-从

http://www.gxlcms.com/

前facebook员工和前微软sql server工程师联合搞的一个分布式关系数据库

全部内存运行，将sql转化成速度更快的c++, 原理类似HipHop

有mysql api, 完全兼容mysql,没有学习使用成本

速度是mysql的30倍，每秒可处理150万的事务

官方网站：http://www.gxlcms.com/

参考文档：http://www.gxlcms.com/

参考官方文档：http://www.gxlcms.com/

http://www.gxlcms.com/

\-- ==============================================================

1 Installwget http://www.gxlcms.com/

tar xvfz memsqlbin\_amd64.tar.gzcd memsqlbin./check\_systemWarning: The version of CentOS that you're using (5.5) is too low.MemSQL supports versions 6.0 and up.

/home/manchun/memsqlbin/objdir/usr/local/bin/memsql-g++: /lib64/libc.so.6: version GLIBC\_2.11' not

found (required by /home/manchun/memsqlbin/objdir/usr/local/bin/memsql-g++)

【解决办法】安装glibc\[root@banggo ~\]\#

wget http://www.gxlcms.com/

tar zxvf glibc-2.11.tar.gz

cd glibc-2.11

mkdir glibc-2.11-build

退出去在别的目录执行如下编译

/usr/src/glibc-2.11/configure --prefix=/usr/src/glibc-2.11/glibc-2.11-build/

error:

checking for .cfi\_personality and .cfi\_lsda pseudo-ops... no

configure: error: assembler too old, .cfi\_personality support missing

【解决】参考网址

http://www.gxlcms.com/

http://www.gxlcms.com/I couldn't overcome that problem, and I'm wondering how I can, but I

said, "hey cuda only requires glibc-2.7, so lets compile that". I went

ahead, and installed it into /share/apps/glibc-2.7. So here comes the

main question: how can I link CUDA C to the glibc-2.7 installed in

/share/apps ? Years ago, Tim Carlson has said "It is really not

practical to try and upgrade glibc to 2.5. You might want to try

installing a glibc 2.5 from source in /share/apps/glibc-2.5 and then

use LD\_PRELOAD to load that library in for you CMAQ binary.", but I

don't know how to use LD\_PRELOAD, and I would appreciate any

guideline.

\[换成2.8\]\[root@banggo ~\]\#

wget http://www.gxlcms.com/

tar zxvf glibc-2.8.tar.gz

cd glibc-2.8

mkdir glibc-2.8-build

退出去在别的目录执行如下编译/usr/src/glibc-2.8/configure --prefix=/usr/src/glibc-2.8/glibc-2.8-build/

make

make install

继续执行刚才的check\_system\[root@banggo memsqlbin\]\# ./check\_system

Warning: The version of CentOS that you're using (5.5) is too low.

MemSQL supports versions 6.0 and up.

/home/manchun/memsqlbin/objdir/usr/local/bin/memsql-g++: /lib64/libc.so.6: version 'GLIBC\_2.11' not

found (required by /home/manchun/memsqlbin/objdir/usr/local/bin/memsql-g++)

【】我不得不承认，我out了，仔细一看，原来需要centos 6.0的。

2 重新安装wget http://www.gxlcms.com/

tar xvfz memsqlbin\_amd64.tar.gz

cd memsqlbin

./check\_system

报错如下：Warning: The recommended configuration for MemSQL is at least 8 GB of RAM

【】解决方案：let "mem\_mb=$(free -m | sed -n -e '/^Mem:/s/^\[^0-9\]\*\$\[0-9\]\*\$ .\*/\\1/p')";

if \[ $mem\_mb -lt 1000 \]; then

echo "Warning: The recommended configuration for MemSQL is at least 1 GB of RAM" 1>&2

invalid='1'

\[root@memdb memsqlbin\]\# ./check\_system

System check successful

3 登陆测试\[root@memdb memsqlbin\]\# ./memsqld --port 3308

299691 2012-06-27 13:26:26 WARNING: SSE4.2 is not supported. Resorting to software CRC32C.

497378 2012-06-27 13:26:27 INFO: Log level changed to 0

120627 13:26:27 \[ERROR\] Fatal error: Please run MemSQL as a non-root user or specify -u root on the command line.

120627 13:26:27 \[ERROR\] Aborting

120627 13:26:27 \[Note\] ./memsqld: Shutdown complete

\[root@memdb memsqlbin\]\# ./memsqld -u root --port 3308

292356 2012-06-27 13:26:54 WARNING: SSE4.2 is not supported. Resorting to software CRC32C.

480363 2012-06-27 13:26:55 INFO: Log level changed to 0

120627 13:26:55 \[Note\] ./memsqld: ready for connections.

Version: '1b' socket: '/tmp/memsql.sock' port: 3308

4 客户端使用\[root@memdb ~\]\# mysql -uroot -p -h 127.0.0.1 -P3308 --prompt="MemSQL> "

Enter password:

Welcome to the MySQL monitor. Commands end with ; or \\g.

Your MySQL connection id is 253

Server version: 5.5.8 MemSQL source distribution

This software comes with ABSOLUTELY NO WARRANTY. This is free software,

and you are welcome to modify and redistribute it under the GPL v2 license

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

MemSQL>

MemSQL> show databases;

\+--------------------+

| Database |

\+--------------------+

| information\_schema |

| memsql |

\+--------------------+

2 rows in set (0.00 sec)

MemSQL> use memsql;

Database changed

MemSQL> show tables;

Empty set (0.00 sec)

MemSQL> use information\_schema;

Reading table information for completion of table and column names

You can turn off this feature to get a quicker startup with -A

Database changed

MemSQL> show tables;

\+---------------------------------------+

| Tables\_in\_information\_schema |

\+---------------------------------------+

| CHARACTER\_SETS |

| COLLATIONS |

| COLLATION\_CHARACTER\_SET\_APPLICABILITY |

| COLUMNS |

| COLUMN\_PRIVILEGES |

| ENGINES |

| EVENTS |

| FILES |

| GLOBAL\_STATUS |

| GLOBAL\_VARIABLES |

| KEY\_COLUMN\_USAGE |

| PARAMETERS |

| PARTITIONS |

| PLUGINS |

| PROCESSLIST |

| PROFILING |

| REFERENTIAL\_CONSTRAINTS |

| ROUTINES |

| SCHEMATA |

| SCHEMA\_PRIVILEGES |

| STATISTICS |

| TABLES |

| TABLESPACES |

| TABLE\_CONSTRAINTS |

| TABLE\_PRIVILEGES |

| TRIGGERS |

| USER\_PRIVILEGES |

| VIEWS |

\+---------------------------------------+

28 rows in set (0.00 sec)

MemSQL>

库名字很mysql一模一样啊，好惊奇啊，居然information\_schema都有，而且里面的表名字也是一模一样的。

5 配置文件

看看memsql有没有跟mysql类似的配置文件呢，如下，果然找到了\[root@memdb memsqlbin\]\# ll /root/memsqlbin/memsql.cnf

\-rw-r--r--. 1 1001 1001 1026 6月 18 20:07 /root/memsqlbin/memsql.cnf

6 用户管理测试

\-- 创建新账号MemSQL> grant all on \*.\* to tim@'%' identified by "tim" with grant option;

Query OK, 1 row affected (0.01 sec)

MemSQL> exit

Bye

\-- 重新登录，输入-p密码，进不去，不输入密码一回车，反倒进去了，怪哉!\[root@memdb memsqlbin\]\# mysql -utim -ptim -h 127.0.0.1 -P3308 --prompt="MemSQL> "

ERROR 1045 (28000): Access denied for user 'tim'@'localhost' (using password: YES)

\[root@memdb memsqlbin\]\# mysql -utim -p -h 127.0.0.1 -P3308 --prompt="MemSQL> "

Enter password:

Welcome to the MySQL monitor. Commands end with ; or \\g.

Your MySQL connection id is 253

Server version: 5.5.8 MemSQL source distribution

This software comes with ABSOLUTELY NO WARRANTY. This is free software,

and you are welcome to modify and redistribute it under the GPL v2 license

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

MemSQL>

CREATE TABLE test (

id int(11) NOT NULL AUTO\_INCREMENT,

excel\_id varchar(100) NOT NULL,

rpt\_id int(10) unsigned NOT NULL,

acc\_std tinyint(3) unsigned NOT NULL,

prd\_year int(10) unsigned NOT NULL,

prd\_qtr tinyint(3) unsigned NOT NULL,

accumulate char(3) NOT NULL,

biz\_cd tinyint(3) unsigned NOT NULL,

acc\_cd tinyint(3) unsigned NOT NULL,

row\_num int(10) unsigned NOT NULL,

col\_num int(10) unsigned NOT NULL,

data\_id int(10) unsigned NOT NULL,

data\_trace mediumtext NOT NULL COMMENT 'trace信息',

trace\_edit tinyint(1) NOT NULL,

upd\_stmp timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',

PRIMARY KEY (id)

) ;

以上就是MemSQL学习笔记-类似MySQL的数据库的内容，更多相关内容请关注PHP中文网(www.gxlcms.com)！

本条技术文章来源于互联网，如果无意侵犯您的权益请点击此处反馈版权投诉

本文系统来源：php中文网

memsql完全兼容mysql吗_MemSQL学习笔记-类似MySQL的数据库

发表评论取消回复

还没有评论，来说两句吧...

相关阅读

相关 mysql数据库学习笔记

相关 windows完全删除MySQL数据库

相关 MySQL数据库的学习笔记

相关 MySQL数据库的笔记_Mysql数据库笔记

相关 memsql完全兼容mysql吗_MemSQL学习笔记-类似MySQL的数据库

相关 MemSQL初体验 - (3)性能测试

相关 MemSQL初体验 - (2)初始化测试环境

相关 MemSQL初体验 - (1)传说中速度最快的关系数据库软件

相关 Mysql数据库引擎(mysql 学习笔记)

相关 mysql数据库维护(mysql学习笔记)