freeswitch 把SIP注册信息数据库从SQLITE 改为MYSQL的方法
实际线上应用中,在线注册人数超过4000 ,SQLITE就吃不消了,容易造成锁表,考虑转入MYSQL,查了下官网 超过转入了MYSQL。
https://wiki.freeswitch.org/wiki/Using_ODBC_in_the_core#.2Fetc.2Fodbcinst.ini_for_MySQL 参考地址
CentOS 5.2
Install unixODBC and the MySQL ODBC Connector
yum install unixODBC-devel mysql-connector-odbc
- Make symlink from
/usr/lib[64]/libmyodbc3.so
to/usr/lib[64]/libmyodbc.so
- Run
odbcinst -j
. This will show you list of config files. - Uncomment the MySQL sample driver confirguration in
/etc/odbcinst.ini
. - Add the following with the correct information into your odbc.ini file located at
/etc/odbc.ini
[freeswitch] Driver = MySQL SERVER = localhost PORT = 3306 DATABASE = myDatabase OPTION = 67108864 Socket = /var/lib/mysql/mysql.sock
Note: If you are connecting your freeswitch server to a remote MySQL database, you can take out the last line from the above setting. Take off the "Socket = /var/lib/mysql/mysql.sock" line.
Note: OPTION allows you to set client specific FLAGS, in the example 67108864 (FLAG_MULTI_STATEMENTS) is set - See [1] for all flags. The number represents the addition of all flag numbers that you want enabled.
Note: On CentOS is OPTION (without S), instead of OPTIONS.
For some tips on setting up your dsn up in unixODBC see Mod_spidermonkey_odbc#unixodbcc
- Test your ODBC setup by running the utility
isql
isql maxpowersoft_odbc myUser myPass
相关文章
- mysql的udf应用
- MySQL在update发现要修改值跟原值相同,会再执行修改吗?
- MySQL的各种语句是如何加锁的?
- MySQL学习笔记(十二)__连接查询(一)
- innodb_data_file_path配置变更引发mysql重启失败
- mysql回滚日志
- 7 个超实用的 MySQL 语句写法,让同事们眼前一亮!
- Sun推出针对MySQL的新系统和存储解决方案
- Mysql:mysqlslap:自带的简单压力测试工具:使用、bug等
- mysql:名次排名 (并列与不并列)
- MySQL的InnoDB加锁原理和常见死锁
- 2022-09-09 MySQL查询优化器
- FastAPI 学习之路(六十一)使用mysql数据库替换sqlite数据库
- MySQL系列:数据类型、运算符及函数(5)
- MYSQL错误解决:ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)