MySQL Concurrent reads and writes to database

1. I have a single Maria DB, MySQL database running on a cloud server. The server is 4 CPU, 16GB RAM. The tables are InnoDB type (50 total tables)

2. We're having the issue with concurrent writes to the MySQL database. During peak time we can have as many as 100 writes every 5 seconds. This is causing some of the writes entries into the database to be skipped.

I believe we're going to need a high availability setup that can handle concurrent inserts and reads into the database. But also allow us to scale up as more writes and reads are occuring.

I'm looking at options that aren't expensive where this can be done.

Skills: MySQL, Database Administration, System Admin, MariaDB

About the Client:
( 46 reviews ) hemet, United States

Project ID: #33655751

19 freelancers are bidding on average $213 for this job

(24 Reviews)
(41 Reviews)

Hi there, ★★★ Database Design & Development Expert ★★★ 8+ Years of Experience ★★★ I've read requirements and ready to debug & fix errors on your website. I have completed multiple projects across various domains like More

$250 USD in 1 day
(108 Reviews)
(16 Reviews)

Hello, Thanks for reviewing my application. I analyze job requirements for a PHP developer, So I am well familiar with the requirements and will surely help you in this project and I'm able to start right now. I have More

$250 USD in 5 days
(38 Reviews)

Dear sir, I have gone through your outsourced requirement " MySQL Concurrent reads and writes to database " and have analyzed that I have right credentials ( System Admin MySQL Database Administration MariaDB ) to e More

$140 USD in 7 days
(40 Reviews)

Hi I can help you with the mysql database. I read through the job details extremely carefully and I am confident I can exceed your expectations. I have long experience with right skills to work on this project. I want More

$166.67 USD in 1 day
(72 Reviews)
(12 Reviews)

Hi There!! No upfront milestone and 24*7 Support With a 100% money-back guarantee. We are here to provide the best quality solution for all your requirements related to: - Websites design and development - Online Sto More

$750 USD in 15 days
(20 Reviews)

Hi, we can start trying the easiest way, low cost yet effective, to speed up write time by use of the available RAM. We must analyze which tables are the most used. Another issue might be if not all of the cores are in More

$250 USD in 3 days
(7 Reviews)

Hi, It seems you have multifold fold problem and I can fix your concerns. I've done many HA DB setup and configuration for MySQL, Galera, Snowflake, Postgresql, Mongo, Cassendra etc. Kindly initiate a chat to discuss More

$80 USD in 1 day
(5 Reviews)

[login to view URL] Hi, I have read your request, I will acomplete your task in real quick time with 110% satisfaction and perfection.. I'll give you unlimited revisions till your satisfaction and dream wo More

$140 USD in 7 days
(4 Reviews)

Hi There, I'm interested to work on your project regarding MySQL Concurrent reads and writes to database I am an expert PHP/WordPress designer and developer who has 7+ years of experience in designing and developing More

$200 USD in 3 days
(1 Review)

Hi, nice to meet you. I am senior Web developer. I have a lot of experiences in PHP and JavaScript. I am also very familiar with PHP templates such as Laravel and CodeIgniter. I can build backend with Laravel, frontend More

$140 USD in 7 days
(1 Review)

Feel fee to contact me for MySQL Concurrent reads and writes to database .Shoot me message to discuss further more details .I provide the comments,images,videos,demos and live sessions in order to help the [login to view URL] More

$150 USD in 3 days
(0 Reviews)

Warm Greeting, We are a strong team of innovative developers known as "IncomparableSoft" ([login to view URL]) we are located in India and skilled in Web Development, Mobile App Development, Cloud Development, Dat More

$140 USD in 7 days
(0 Reviews)

Hi I think user concurrency can be handled through Load Balancing and optimizing the User threads by creating connection pools. Let me know if you need further assistance, will be glad to make your project successful. More

$140 USD in 5 days
(0 Reviews)

I can setup Mariadb H.A. with Maxscale LB with in 3hrs and resolve the write and read problem. I have configured many Mariadb H.A. setup for many clients.

$140 USD in 1 day
(0 Reviews)

Hi, Please more details about your operating system Have you one VPS or dedicated server? Which hosting? Please let me know more details about this project. Thanks

$250 USD in 15 days
(0 Reviews)