Find Jobs
Hire Freelancers

High performance Kannel 1.4.5 with MySQL, OpenSMPP, SQLBox and SMPPSim -- 2

$30-250 USD

Fermé
Publié il y a presque 5 ans

$30-250 USD

Payé lors de la livraison
Install and configure Kannel 1.4.5 with MySQL, OpenSMPP, SQLBox & SMPPSim on Linux server I would prefer Ubuntu but happy for your recommendations I have already installed and configured most of this myself however I am only getting speeds of 130 messages per second no matter what hardware I use so I am looking for an MySQL and Kannel expert :) ssh access will be given on fresh virtual server Install Configure Kannel, OpenSMPP, SQLBox with the following 5 SMS boxes, 1 of which will recive inbound messages and store in the sent_sms database 6 SQL boxes all looking at the own send_sms database (send_sms high_priority, send_sms1/2/3/4/5) 10 SMPP binds to SMPPSim Install Configure & tweak MySQL (database should be in en_US.UTF-8 so we can support symbols on MO and MT messages) should have the followings databases the send_sms high_priority, send_sms1/2/3/4/5 (for the other 5 SQLbox), sent_sms (all history), dlr (pending DLRs) and send_sms_dump tables The send_sms_dump table will need to have trigger to split on data between send_sms1/2/3/4/5 so the SQLboxes can process the messages, going forward I might host the sqlboxes on different server at a later date to increase the messages per second The dlr table will have auto trigger to clean up (something like DELETE FROM dlr WHERE TIME_TO_SEC([login to view URL]) + 604800 < TIME_TO_SEC(CURRENT_TIMESTAMP);) My application will add data to send_sms_dump or send_sms high_priority the send_sms_dump table will then split data (and remove) to the other tables send_sms1/2/3/4/5 - Note the send_sms high_priority the send_sms_dump table should not be locked or dropped as my system could insert more data at any time, if you need to add adding colunm to the data to avoid loss of data or duplicated data feel free Configure 2 different OpenSMPP users. All Messages should route via the SQLbox Install Configure SMPPSim (this is a test SMPP platform) more information from [login to view URL] Setup some sort of log management system to create new log at midnight and compress older logs keeping full history for 7 days only Provide full list of command history and SQL database templates and triggers for the database so this can be installed again on another server No Auto bids please and if you/your company are not an experts with MySQL and Kannel please do not bid
N° de projet : 20242947

Concernant le projet

5 propositions
Projet à distance
Actif à il y a 5 ans

Cherchez-vous à gagner de l'argent ?

Avantages de faire une offre sur Freelancer

Fixez votre budget et vos délais
Soyez payé pour votre travail
Surlignez votre proposition
Il est gratuit de s'inscrire et de faire des offres sur des travaux
5 freelances proposent en moyenne $208 USD pour ce travail
Avatar de l'utilisateur
Hi, I am an expert with MySQL and Kannel. please contact me@@@Vu.
$200 USD en 7 jours
4,6 (13 commentaires)
5,9
5,9

À propos du client

Drapeau de UNITED KINGDOM
Bilton, United Kingdom
5,0
7
Méthode de paiement vérifiée
Membre depuis avr. 30, 2014

Vérification du client

Merci ! Nous vous avons envoyé un lien par e-mail afin de réclamer votre crédit gratuit.
Une erreur a eu lieu lors de l'envoi de votre e-mail. Veuillez réessayer.
Utilisateurs enregistrés Total des travaux publiés
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Chargement de l'aperçu
Permission donnée pour la géolocalisation.
Votre session de connexion a expiré et vous avez été déconnecté. Veuillez vous connecter à nouveau.