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.

Навыки: MySQL, Управление базами данных, Системное администрирование, MariaDB

О клиенте:
( 46 отзыв(-а, -ов) ) hemet, United States

ID проекта: #33655751

19 фрилансеров(-а) готовы выполнить эту работу в среднем за $213

(24 отзывов(-а))
(41 отзывов(-а))

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 Больше

$250 USD за 1 день
(108 отзывов(-а))
(16 отзывов(-а))

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 Больше

$250 USD за 5 дней(-я)
(38 отзывов(-а))

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 Больше

$140 USD за 7 дней(-я)
(40 отзывов(-а))

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 Больше

$166.67 USD за 1 день
(72 отзывов(-а))
(12 отзывов(-а))

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 Больше

$750 USD за 15 дней(-я)
(20 отзывов(-а))

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 Больше

$250 USD за 3 дней(-я)
(7 отзывов(-а))

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 Больше

$80 USD за 1 день
(5 отзывов(-а))

[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 Больше

$140 USD за 7 дней(-я)
(4 отзывов(-а))

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 Больше

$200 USD за 3 дней(-я)
(1 отзыв)

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 Больше

$140 USD за 7 дней(-я)
(1 отзыв)

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] Больше

$150 USD за 3 дней(-я)
(0 отзывов(-а))

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 Больше

$140 USD за 7 дней(-я)
(0 отзывов(-а))

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. Больше

$140 USD за 5 дней(-я)
(0 отзывов(-а))

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 за 1 день
(0 отзывов(-а))

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 за 15 дней(-я)
(0 отзывов(-а))