I need to create a load balancer for php maria db database using 2 different servers

In Progress Posted 4 months ago Paid on delivery
In Progress Paid on delivery

I am looking for a freelancer who can help me create a load balancer for my MariaDB database using two different servers. I have a general idea of what I need, but I will need assistance in implementing it.

Specific requirements for the load balancer:

- we will use 2 main servers, if there is a need for switching we will use a 3rd one

- we will use an existing website in php where users can login

- the same database will be imported in both servers

- when writing data it must go into 2 databases

- If the main server is down for any reason the data must be loaded automatically from the 2nd server without the user to see it and it will continue working

- open to any idea to any solution, ideas are welcomed

- I will test it with dedicated servers or vps servers

- I can provide you access to the server to test it too after completion

What not to use: I have tried to se gallera for a while and it did not work and I had sync issues and nightmare very close of losing data?

The ideal freelancer for this job will have experience with load balancing and working with MariaDB databases. It will be great if possible of seeing a working example. They should also have a good understanding of server configurations and be able to meet the deadline of 1-2 weeks.

Thanks!

Linux PHP MySQL Apache System Admin

Project ID: #37648674

About the project

23 proposals Remote project Active 3 mos ago

Awarded to:

MRARIFAKRAM

Being highly familiar with both Linux and Windows systems, I have spent the past 8 years building a robust set of skills that makes me an excellent fit for your load balancing project. I possess deep knowledge of Maria More

$100 USD in 1 day
(96 Reviews)
6.2

23 freelancers are bidding on average $37 for this job

NadMax

Hi. Experienced database and server configuration developer here with 8+ years of hands-on experience, I can assist you in creating a reliable MariaDB database load balancer with two servers. To proceed further, I kin More

$20 USD in 7 days
(23 Reviews)
6.6
netonepk

Hello, this is raza. i am senior system admin with more than 15 years experience. i have already implemented this solution for another client.

$250 USD in 3 days
(120 Reviews)
6.3
giaphung2k1

Hiya - The load balancer should evenly distribute the incoming traffic between the 2 servers. - The load balancer should be able to detect the status of the servers and redirect the traffic to a healthy server if one More

$14 USD in 7 days
(106 Reviews)
5.9
VakiYT

For a load balancer project of this magnitude, you need someone who's been around the block and knows their way around server configurations and MariaDB databases. I'm that person. My name is Vladimir, and I have a ext More

$20 USD in 7 days
(43 Reviews)
5.5
igorsavinkin

Hello, Client. Just read your job posting and immediately noticed to finish this project in a short time because I've already made a similar project a month ago. As I am an experienced full-stack developer who has ext More

$30 USD in 1 day
(3 Reviews)
4.6
SairaArifM

As a seasoned Linux Engineer, full stack developer and, more importantly, a resourceful problem solver, I believe I am well-equipped to tackle your load balancing project. With extensive experience in using Ubuntu, Cen More

$50 USD in 1 day
(39 Reviews)
4.6
mayankinnovative

I am writing to propose my services as a freelancer to assist you in creating a robust load balancer for your MariaDB database. I understand your specific requirements and challenges and am confident in delivering a so More

$50 USD in 2 days
(187 Reviews)
4.7
Kiranshaikh2388

Hi, I would like to grab this opportunity and I will work till you get 100% satisfied with our work. I am an expert which have many years of experience on PHP, System Admin, Linux, Apache, MySQL Please come over cha More

$17 USD in 7 days
(5 Reviews)
3.6
roysiya090

Hhi I am experienced in this and I can start right now but i have few doubts and questions lets have a quick chat and get it started waiting for your replyyy ! r!

$20 USD in 7 days
(2 Reviews)
1.8
wintersoldier538

Hi, Since, Galera clustering did not work out for you, we will have to look at all the other approaches. I think, your main objective here is achieving consistency across all the nodes. I have previously worked with More

$30 USD in 7 days
(2 Reviews)
1.5
toxatoor

Loadbalancing mariadb is not a big deal, but there're a number of underwater stones regarding data consistency. As both of db nodes must be in sync. I can guide you through the process, but final solution hardly depend More

$50 USD in 2 days
(2 Reviews)
1.1
SoftdevIndia21

Hello, The idea you mentioned here is very bad and will never be accurate, there will always be sync problem and chances of loosing integrity too. Rather move to amazon cloud server which will provide resources in real More

$20 USD in 1 day
(1 Review)
0.6
pbonline2

Hello Alexandru T., Good afternoon I have a few questions regarding the specs of the project. Could we please have a chat? My Skills: MySQL, Linux, PHP, System Admin and Apache

$10 USD in 10 days
(2 Reviews)
1.1
mikail151015

Hi, Hope you are doing well! Thanks for sharing your project requirement with me. It will be our great pleasure to work on your project. I have checked your requirement, yes I can do it, because I already work on si More

$10 USD in 1 day
(0 Reviews)
0.0
masihuddinkhan05

I will make your systems even faster by creating a load balancer in MariaDB Balancer using two different servers.

$20 USD in 7 days
(0 Reviews)
0.0
ihorniko767

As a Freelancer with significant experience in Linux, PHP and software architecture, I'm confident that I'm the ideal candidate to tackle your project. My knowledge and skills of MariaDB, load balancing, and server con More

$20 USD in 7 days
(0 Reviews)
0.0
fabiolv

I have deep experience in MariaDB, database management, several server hostign and microservices. I would like todiscuss previous project with you, dear~. The ball is on your court. Fabio.

$20 USD in 7 days
(0 Reviews)
0.0
gaganrai5523

Dear Sir, I am Gagandeep, a Cloud Infrastructure and DevOps Engineer with extensive experience in AWS, Docker, Kubernetes, and database management. I am excited about the opportunity to develop a load balancer for you More

$18 USD in 7 days
(0 Reviews)
0.0
ms7620281

Hello, Greetings! I hope you are doing great. I am writing to express my enthusiasm for the opportunity to collaborate on this project. With over 12 years of dedicated experience in the field, I bring a wealth of exper More

$20 USD in 7 days
(0 Reviews)
0.0