Find Jobs
Hire Freelancers

Optimize a very large MySQL database

$750-1500 USD

Cerrado
Publicado hace 10 meses

$750-1500 USD

Pagado a la entrega
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!
ID del proyecto: 36705586

Información sobre el proyecto

59 propuestas
Proyecto remoto
Activo hace 9 meses

¿Buscas ganar dinero?

Beneficios de presentar ofertas en Freelancer

Fija tu plazo y presupuesto
Cobra por tu trabajo
Describe tu propuesta
Es gratis registrarse y presentar ofertas en los trabajos
59 freelancers están ofertando un promedio de $1.115 USD por este trabajo
Avatar del usuario
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 experience in web and app development. I understand that you have a large MySQL database that uses LVM on a normal Linux VPS on Linode that is now 200GB+ large. 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 anymore because of the amount of inserts and updates going on at all times. 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 thisDB bottleneck. I would be delighted to review your current DB structure and provide advice on how best to optimize it for your needs. Additionally, I can provide recommendations for how to structure or migrate the DB so that you can make any needed changes without issue.
$1.125 USD en 7 días
4,9 (264 comentarios)
8,2
8,2
Avatar del usuario
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 can discuss all work in details, thank you Gaurav D.
$1.125 USD en 7 días
4,9 (42 comentarios)
6,7
6,7
Avatar del usuario
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 you overcome them. Firstly, regarding your current DB structure, I would like to review and analyze it thoroughly to identify the root cause of the problem. Based on my experience with large MySQL databases, I can suggest several optimization techniques, including indexing and partitioning, that can help improve your database's performance. However, considering the size and complexity of your database and the high volume of INSERTs and UPDATEs, it might be more beneficial to migrate to another solution like AWS RDS or Linode Managed Databases, which are designed to handle high workload databases. I have extensive experience in migrating databases and can guide you through the entire process, from selecting the appropriate server configuration to setting up and optimizing your new database. As LVM usage is involved with your current DB, I would like to know more about the LVM settings and configuration for your database to ensure a smooth migration or optimization process. I have some technical questions concerning the project requirements that I would like to discuss further before providing you with a quote and timeline. I am always flexible in building long-term relationships by providing top-notch support ...
$1.350 USD en 10 días
5,0 (20 comentarios)
6,4
6,4
Avatar del usuario
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 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 would like to help you optimize your database so that you can make changes easily. With our expertise in MySQL and experience working with large databases we are confident we can find a solution that works best for you. We understand that it is impossible to scale your project without this bottleneck being addressed so we offer unlimited repetitions for our services as well as a free consultation before hiring so you don't have to worry about getting incorrect information or wasting your time with us.
$1.025 USD en 15 días
5,0 (20 comentarios)
6,3
6,3
Avatar del usuario
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 looking for a true Freelancer, I am the Right person for you. I am available almost 24-7 and am very responsive. I feel proud that I am a trusted Freelancer who pleases almost every single client. You can rest assure, your work will be delivered well in advance of others, with passion and accuracy. I guarantee you instant communication & responses when you need me. Why choose me? I think every client is the reason for my success. I only take projects which I am sure I can do quickly. My Portfolio Items: https://www.freelancer.com/u/schoudhary1553 I would really like to work with you on this project. If interested, Kindly contact me via chat for further details and discussion. Thank you Sandeep
$1.200 USD en 10 días
4,9 (56 comentarios)
6,4
6,4
Avatar del usuario
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
$1.500 USD en 5 días
4,9 (19 comentarios)
5,8
5,8
Avatar del usuario
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 customer support. I have extensive experience with the following control panels: CPanel, Plesk, Directadmin, SolusVM, VestaCP and many more. I can do what you are asking for. Message me for more details. Regards
$750 USD en 1 día
5,0 (56 comentarios)
5,5
5,5
Avatar del usuario
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! Let's have a chat and discuss this!
$1.125 USD en 7 días
4,4 (51 comentarios)
6,0
6,0
Avatar del usuario
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 Linode and that it is now 200GB+ with some tables reaching 100GB+. After running the database for a while, we can't do basic tasks like count(ID), sort by ID or order by DESC on timestamp columns any longer because of the amount of inserts and updates happening constantly. As a result, it's impossible to scale your project at this point due to this DB bottleneck. You would need my help to review your current DB structure and advise whether it is better to restructuring or migrate the DB so that you can get optimal performance from your system without needing to use specialized tools like LVMs. I would be more than happy to help you with this project! Please don't hesitate to reach out if you have any additional questions or would like me to provide more information about my services. Looking forward to hear from you! Thanks. Best Regards, Ali Khan.
$750 USD en 7 días
4,9 (8 comentarios)
4,6
4,6
Avatar del usuario
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 know when you are avaialble. Thank you Imad
$1.000 USD en 7 días
5,0 (4 comentarios)
4,6
4,6
Avatar del usuario
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 including RDB (MySQL, PostgreSQL, MSSQL), NoSQL(Mongodb, ArangoDB) and GraphQL. I always prioritize database structure design and optimization on any project development as it has a crucial impact on the overall development and performance of the product. I also have strong knowledge with advanced techniques and querying such as transactions, triggers, complex subqueries & joins in SQL databases and aggregation, indexing, projections, etc in NoSQL databases. With this professional experience, I can manage any complex database solutions professionally with an optimal performance guaranteed. Let's discuss further. Thanks,
$1.125 USD en 7 días
4,5 (10 comentarios)
4,9
4,9
Avatar del usuario
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 LVMs and can confidently review your current DB structure to assess the best course of action for your specific needs. We will advise whether it is better to restructure and optimize the existing database or migrate to a more scalable solution such as AWS RDS or Linode Managed Databases. We will consider factors such as data size, workload patterns, and growth projections to ensure a solution that meets your performance and scalability requirements. Once the best approach is determined, we will implement the recommended changes with meticulous attention to detail. This may include optimizing table structures, indexing, partitioning, query optimizations, or assisting with the migration process to a new database solution. We are committed to delivering a high-performing and scalable database solution that removes the current bottleneck and allows you to scale your project effectively. Please feel free to reach out to discuss the project further or if you have any questions. Best Regards, Roveem Shahid
$1.125 USD en 7 días
3,5 (21 comentarios)
6,3
6,3
Avatar del usuario
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, if you have any question. Regards, Jay
$800 USD en 7 días
4,9 (15 comentarios)
4,0
4,0
Avatar del usuario
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 project due to my expertise in database administration and Linux as well as my understanding of MySQL and LVM. My skill set includes database optimization as well as migrating databases to other solutions (AWS RDS or Linode Managed Databases). This makes me well-suited to tackle this project head-on and help you reach your goals faster than ever before. If you give me the chance to work on this project, I guarantee that you will not be disappointed with the results.
$870 USD en 4 días
5,0 (13 comentarios)
4,1
4,1
Avatar del usuario
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 experienced Linux, MySQL, Database Administration, I am confident that I have the skills and expertise necessary to deliver high-quality results that meet your needs. We are an expert team which have many years of experience on Linux, MySQL, Database Administration, Relational Databases, Database Management Please come over chat and discuss your requirement in a detailed way. Regards
$1.100 USD en 7 días
5,0 (4 comentarios)
3,2
3,2
Avatar del usuario
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 recommendations on whether it's best to restructure or migrate the database to a more scalable solution like AWS RDS or Linode Managed Databases. Once we agree on the approach, I will implement the necessary optimizations or perform the migration, ensuring minimal downtime and data integrity. I have extensive experience managing databases that use LVMs, so you can rely on my expertise to overcome your DB bottleneck and enable scalability for your project.
$1.125 USD en 7 días
4,2 (17 comentarios)
4,0
4,0
Avatar del usuario
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 MySQL database and I believe I am the best fit for the job. I would be delighted to review your current DB structure and provide advice on whether it is better to restructure or migrate the DB. Additionally, I can implement any improvements or modifications to make sure your experience with this project is successful. My team and I have extensive experience in all aspects of web development which makes us well-suited to help you reach your full potential. If you choose me for this job please don't hesitate to put us out there! We'll definitely bid competitively so we can get the job done quickly and efficiently.
$1.350 USD en 20 días
5,0 (2 comentarios)
3,1
3,1
Avatar del usuario
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 MySQL database that uses LVM on Linode. After running the DB for a while, we can't do basic tasks like counting IDs, sorting by ID or ordering by DESC on timestamp columns anymore due to its size. As an AI/ML developer, I have expertise in developing and implementing machine learning algorithms and models to solve complex problems. With my experience in optimizing large MySQL databases, I am confident that I can find the best way forward to get your database running at its full potential without causing any issues for you or other users. If you would like me to review your current DB structure and give you advice on whether it would be better to restructure it or migrate it to another solution, please don't hesitate to reach out to me directly.
$800 USD en 7 días
4,6 (3 comentarios)
3,1
3,1
Avatar del usuario
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.... Need to take some decision which kind of support of storage need to use (Remark: This price is for implementation the DB architect solution not for API) Please contact me for more details Thanks
$1.500 USD en 30 días
5,0 (1 comentario)
2,7
2,7
Avatar del usuario
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 slow query log to identify queries that are taking a long time to execute. You can then optimize these queries by adding indexes, rewriting them, or tuning the MySQL configuration. Optimize table structure: Ensure that your table structure is optimized for performance. This includes normalizing your data, avoiding unnecessary large data types, and partitioning large tables. Optimize indexes: Ensure that you have appropriate indexes on your tables. Indexes can significantly improve query performance, but having too many indexes can also negatively impact performance. Optimize the MySQL configuration: Ensure that your MySQL configuration is optimized for your specific use case. This includes settings such as buffer sizes, query cache size, and max connections. Consider database migration: If you have exhausted all optimization options and are still experiencing performance issues, you may want to consider migrating your database to a more scalable solution such as AWS RDS or Linode Managed Databases. If you want more details, kindly message me and let's discuss on the chat. Thanks.
$750 USD en 5 días
5,0 (1 comentario)
1,9
1,9

Sobre este cliente

Bandera de CANADA
Toronto, Canada
5,0
10
Forma de pago verificada
Miembro desde oct 1, 2013

Verificación del cliente

¡Gracias! Te hemos enviado un enlace para reclamar tu crédito gratuito.
Algo salió mal al enviar tu correo electrónico. Por favor, intenta de nuevo.
Usuarios registrados Total de empleos publicados
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Cargando visualización previa
Permiso concedido para Geolocalización.
Tu sesión de acceso ha expirado y has sido desconectado. Por favor, inica sesión nuevamente.