Optimize a very large MySQL database

Fermé Publié le il y a 3 mois Paiement à la livraison
Fermé Paiement à la livraison

I have a very large MySQL database that uses LVM on a normal Linux VPS on Linode. The database is now 200GB+ and some tables are 100GB+. The DB has a lot of inserts and updates at all times. After running the DB for a while, we can't do basic tasks like count(ID), sort by ID or order by DESC on timestamp columns. As a result, we can't make any changes to the table at all.

We either need to optimize the DB or migrate it to another solution (i.e. AWS RDS, Linode Managed Databases). Right now it is impossible to scale our project because of this DB bottleneck.

You will need to:

1. Review our current DB structure

2. Advise us whether it is better to restructure or migrate the DB

3. Implement whatever you suggest

Important: The DB uses LVMs. If you aren't familiar/comfortable with managing DBs that use LVMs, please don't bid

We will select whoever has the best bid and suggestion/experience, so please bid competitively!

MySQL Relational Databases Database Management Linux Administration de Bases de données

Nº du projet : #36705586

À propos du projet

59 propositions Projet à distance Actif il y a 2 mois

59 freelances font une offre moyenne de 1115 $ pour ce travail

OutsourceMan

Hello there! My name is Raman and I am here to help you with your optimization project. I have been working with PHP, WordPress, WooCommerce, Data Scrapping, Buddypress and React Native for 18+ years and have extensive Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 7 jours
(264 Commentaires)
8.2
gauravgargcs

Hello, Hope you are doing great, i have a 8+ year experience in Database development, i can optimize your database as per your work requirements which you mentioned in project description, please come on chat so we c Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 7 jours
(42 Commentaires)
6.7
ahmadayaz

Dear [Client], Thank you for sharing your project requirements. As an experienced MySQL database administrator, I understand the challenges you are facing with your current database and I'm confident that I can help y Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 10 jours
(20 Commentaires)
6.4
einnovention

Hello there! My name is Asif and I am the founder of Einnovention. I understand that you have a very large MySQL database that uses LVM on a normal Linux VPS on Linode. After running the database for a while, we can't Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 15 jours
(20 Commentaires)
6.3
schoudhary1553

Top 1% in Freelancer.com Hi, Greetings! ✅checked your project details: ✅Completed Time: In project deadline We have worked on 900 + Projects. I have 6 + years of the experience in same kind of projects. If you are look Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 10 jours
(56 Commentaires)
6.4
omnamasshivay

Hello, I understood the project but have few doubts, please text me so i can clear all my questions right away and to confirm my skills and expertise you can have a look to my profile

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 5 jours
(19 Commentaires)
5.8
nickdevops

Hello my name is Nikos and Im working on the Linux server administration field for the past 9 years. Over these years I worked for two web hosting companies as a Senior Administrator managing their servers & providing Plus

%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% USD en 1 jour
(56 Commentaires)
5.5
crystalhitesh

Hy there, As per the description, I have relevant experience of 8 years as a security/network engineer and can help you out with your task as I have my expertise in it starting right away and finishing today only! L Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 7 jours
(51 Commentaires)
6.0
AliKhanXZT

Hi there! My name is Ali and I'm a Web Developer, App Developer and Graphic Designer with 10+ years of professional experience. I understand you have a very large MySQL database that uses LVM on a normal Linux VPS on L Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 7 jours
(8 Commentaires)
4.6
jeghalef

Hi. I have good experience with database optimization in Mysql. I think you know about SP in sql database. We can update the data using sp functions. I have some suggestions for big database management. Please let me k Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 7 jours
(4 Commentaires)
4.6
DidiaSc

Hi, Having worked on web development for more than 8 years with strong focus on backend, I have attained a thorough experience with database management. I have dealt with most of the famous database solutions known i Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 7 jours
(10 Commentaires)
4.9
EvenLogics

Hi there, OPTIMIZING OR MIGRATING YOU LARGE DATABASE. As a skilled team of database administrators, we have extensive experience in managing and optimizing large-scale MySQL databases. We are comfortable working with Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 7 jours
(21 Commentaires)
6.3
sqtech

Hi There, I have gone through your requirement for optimizing large mysql database. I can do that for you. I am having more than 15 years of experience as mysql database administrator. Please feel free to contact me, Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 7 jours
(15 Commentaires)
4.0
ashishsharma648

I understand that you are looking for someone to help you optimize a very large MySQL database that uses LVM on a normal Linux VPS on Linode. I can help you optimize it for you I believe I am the best fit for this p Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 4 jours
(13 Commentaires)
4.1
MilosDelic0203

Thanks for your posting with Optimize a very large MySQL database. I love Canada and I'd like to work with Canada clients. I am excited to submit my bid for the Optimize a very large MySQL database project. As an exp Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 7 jours
(4 Commentaires)
3.2
devendrathakur12

I am an experienced MySQL database administrator and I can help optimize your large MySQL database and address the performance issues you are facing. I will carefully review your current database structure and provide Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 7 jours
(17 Commentaires)
4.0
Dominantsoftech

Hi there! My name is Bharat and I am a freelancer specializing in web development, blockchain development, graphic design and Android application development. I understand that you need help optimizing your very large Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 20 jours
(2 Commentaires)
3.1
gargankit642

Hello there! My name is Ankit and I'm a 10-year experienced web application and AWS/DevOps engineer with a strong focus on delivering high quality solutions. You are looking for someone to help you with your very large Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 7 jours
(3 Commentaires)
3.1
ionstefanache1

Hi, I can do that project for you using AWS Maybe need NoSQL to go to MongoDB or DynamoDB ....and if need sharding or clustering ... or.... maybe need to remain at RDB will see Maybe will work with AWS autoscaling, EBS Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 30 jours
(1 Évaluation)
2.7
thonguyenfreela1

Hi, sir. Optimizing a large MySQL database can be a complex task, especially if it is experiencing performance issues. Here are some steps you can take to optimize your database: Analyze slow queries: Use the MySQL s Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 5 jours
(1 Évaluation)
1.9