Dear fellow
users,
I am having a
peculiar problem trying to replace the MySQL database
server which works on my Kannel application server.
I have Kannel
application in separate VM, and MySQL database in
another. So far I understood and have been working with
Kannel is that my Kannel has SQLBox installed, which
picks SMS from kannelDb.send_sms table and stores in
local redis, then sends to SMPP smsc and writes to
kannelDb.sent_sms table of the MySQL server.
My Kannel
application information is as below:
Kannel
bearerbox version `1.4.5'. Build `Jan 10 2024 17:30:02',
compiler `9.4.0'. System Linux, release
5.4.0-170-generic, version #188-Ubuntu SMP Wed Jan 10
09:51:01 UTC 2024, machine x86_64. Hostname localhost,
IP 127.0.0.1. Libxml version 2.9.10. Using OpenSSL
1.1.1f 31 Mar 2020. Compiled with MySQL 5.7.42, using
MySQL 5.7.42. Using hiredis API 1.2.0 Using native
malloc.
Kannel
application server is installed on a Ubuntu 20.04.6
LTS. And my running MySQL server is running on a
Ubuntu 22.04.3 LTS, MySQL version 8.0.36 (VM1). Now,
when the application is running with this DB server,
the performance is smooth. The throughput of my SMPP
SMSC are 100 each in 4 separate SMSC, so I see that
kannelDb.send_sms table clears up almost instantly.
But, I have a problem with the running DB server VM
physical host machine; and for this, I need to shift
the DB server in another VM. I have tried with two
separate VMs: one with Ubuntu 22.04.3 LTS with MySQL
8.0.36 (VM2) and another with Ubuntu 22.04.3 with
MySQL 8.0.41 (VM3). But strangely whenever I try to
run Kannel with VM2 or VM3, the performance gets
really low. Entries of kannelDb.send_sms does not get
cleared as fast as it does with VM1; instead, I get
only around 10 TPS in sending SMS.
Can
anyone please suggest what can be the issue? I have
the same configuration for MySQL in all the three
database server VMs. And I use the working IP address
of VM1 whenever I try with either VM2 or VM3. But
cannot find out the reason for the problem. Please
help.
Please
let me know if you need any further information.
