Find Jobs
Hire Freelancers

Mysql replication setup for existing voip billing

$100-150 USD

Closed
Posted over 2 years ago

$100-150 USD

Paid on delivery
VoIP provider company is using Portaone product Portabilling version MR24 as a billing system. Portabilling installation schema consists of 5 dedicated servers: Master Slave Replication server Configurator Radius machine Slave server hosted at OVH (dedicated server with 2 disks) had issue with one of the disks, which was replaced. During replacement, the second disk was moved and it got out of the raid, which was not noticed by technician who did the replacement. As a result, after booting the server from HD to get the new disk synched, server failed. Mysql stopped (probably to avoid corruption of master mysql). The mistake was found and corrected weeks later. Technician tried to copy the content of disk2, which had slave info. After copying, turned out that 2 partitions out of 3 are corrupted. Corrupted partitions have been restored from tar archives. Slave server has 2 versions of Portabilling (MR23 and MR24). Server is up now with 2 disks, which are synched. Master and slave servers have real time replication. Mysql replication is not done yet. Each of the servers (master and slave) have 3 interfaces (IP’s). The project is to complete the mysql replication and to put slave up, making sure nothing will break or get corrupted on master DB. Additional notes (points with questions needs to be answered by freelancer): 1. We have list of mysql users for slave (but not the privilege table). It is almost the same with slave (not fully). 2. Except mysql users and Porta-billing database, is there anything which is missing to complete the mysql replication and put the slave server up (DB copied + mysql users inserted)? DB is copied already (a week ago). 3. Master Bin files needs to be copied from master to slave, or when replication setup is done it will synch with the last one and we do not need those on slave server (Bin files do not archive in 24 hours, it is more, than 24 hours, we can check in config files if needed)? 4. Mysql version on master and slave must be the same? 5. Portabilling https interface is showing [login to view URL] now (I guess because slave can not connect via mysql to master to synch). 6. Replication goes from Master to slave, but when we do any change from slave https interface, it gets replicated on master (probably slave interface sends the change to master, and then replication goes to slave, as slave does not have write access on master?). 7. There are internal company documents on master > slave replication and the candidate needs to sign additional non disclose agreement to get access to that documents and to the servers (a copy of passport is needed). As well as, there are some outputs from slave server showing the ports, ip’s of replication, which could be helpful.
Project ID: 32997512

About the project

4 proposals
Remote project
Active 2 yrs ago

Looking to make some money?

Benefits of bidding on Freelancer

Set your budget and timeframe
Get paid for your work
Outline your proposal
It's free to sign up and bid on jobs
4 freelancers are bidding on average $119 USD for this job
User Avatar
Hey, I am having more than 10 years of experience in VoIP, based on Asterisk and Freeswitch and have confident enough to work with you on this project. I have gone through your requirement, and you need to help MySQL replication setup for existing VoIP billing. Thanks for reading my proposal. Looking forward to hearing back from you soon. (Note : Proposal amount may vary based on finalization of SOW) Thanks & Regards, Arpit
$125 USD in 7 days
5.0 (8 reviews)
4.4
4.4
User Avatar
Greetings I can surely help you for Mysql replication setup for existing voip billing I am in the IT industry since more than a decade and serve so many clients for building and rebuilding websites, software and applications and I have strong hands-on different programming languages like PHP, CSS 3, Laravel, C++, C- Sharp, HTML, JAVA, .NET, Joomla, Click funnel, Angular, React, Node.js, Django etc., And I did migration from HTML to click funnels. I have made so many websites (E-commerce, WordPress, Classified admin, WooCommerce etc.), bots, softwares, Mobile application (Android, IOS and Huawei Play store) in my entire career. I have strong hands on both front end and backend. Currently I am part of the team who are dealing miscellaneous task in dubizzle and Mzad Qatar including design and layouts and they both have more than 1 million users. I believe that you are looking for a web designer and for sure you will get your end desire result with plagiarism free work and with better quality as I am assuring you this. Package deal can also be done for long term collaboration as per the client requirement. Kindly do come on chat so that we can discuss project details further more.
$100 USD in 7 days
5.0 (2 reviews)
3.4
3.4
User Avatar
Hello, Greetings! I have carefully read the project’s requirements, And all the needs meet my skills and experience level. I am sure that I can do the project very well, and I think all your requirement meets my skill and expertise level with skills including MySQL, VoIP, UNIX and Telecommunications Engineering. Let me introduce myself. And I am a freelancer and director of a web design company. We are a team of professionals with more than ten years of experience to ensure complete customer satisfaction. The actual price and time will depend on work. Let’s discuss more your project in the chatbox, A fast response is appreciated, Anurag Saxena
$150 USD in 21 days
5.0 (6 reviews)
3.2
3.2
User Avatar
Hi. I read project detail completely and I can help you to reconfigure your replication. I have sufficient experiences in MySql replication and can answer all of your questions. You need to first reconfigure replication between your MySql servers, then try to sync lost data between them. There is no need to coping bin files from master to slave because after configuring repilication, slave server will connect to master and read this files. There is no restriction in master and slave MySql versions, but it's better that they have same version. Main doubt is your question number 6, are you sure you had Master-Slave configuratin? Maybe that was Master-Master replication! I’m available to get more info in chat. ** Bid Price is just an estimation and it depends on the scope of your project (maybe lower, maybe higher).
$100 USD in 7 days
5.0 (2 reviews)
2.1
2.1

About the client

Flag of ARMENIA
Armenia
0.0
0
Payment method verified
Member since Feb 4, 2021

Client Verification

Thanks! We’ve emailed you a link to claim your free credit.
Something went wrong while sending your email. Please try again.
Registered Users Total Jobs Posted
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Loading preview
Permission granted for Geolocation.
Your login session has expired and you have been logged out. Please log in again.