Find Jobs
Hire Freelancers

Consulting - MySQL Clustered DataBase using complex Joint Queries

$100-150 USD

Cancelled
Posted over 12 years ago

$100-150 USD

Paid on delivery
Requesting EXPERIENCED MySQL Data Base Clustering Expertise for consultation with our technical staff. BACKGROUND 1. We have a performance issue with a webapp, (Linux,Java, PHP, MySQL, Apache & TomCat. The servers are high performance. Analysis shows the complex queries (joining several tables) which are gathering data for a report, are single threading through the Non Clustered MySQL Data Base, Version 5.0.77 The first query must finish before the next query can start. 2. Our team has experimented with the MySQL Cluster Beta and Release candidate. The results show the performance is much slower using the clustered approach. Our team has no experience with clustered databases. 3. The application allows the user to select many parameters from the GUI and then select from several complex reports. For example, a 5 page report may have 5 queries to select the data from multiple tables to produce charts and cross tabs. SERVICES REQUESTED 1. Advice on speeding up the threading, getting multiple queries to execute at the same time. a. Is it possible without clustering b. Is clustering MySQL databases the right approach when using complex join queries. 2. If there is a recommended approach from # 1 above, Respond to a list of ten questions from the technical team on the method and approach. I am looking for some support for tech team from some one has significant experience in MySQL performance work. Your consideration is appreciated.
Project ID: 3728556

About the project

2 proposals
Remote project
Active 12 yrs ago

Looking to make some money?

Benefits of bidding on Freelancer

Set your budget and timeframe
Get paid for your work
Outline your proposal
It's free to sign up and bid on jobs
2 freelancers are bidding on average $119 USD for this job
User Avatar
See private message.
$127.50 USD in 7 days
4.9 (62 reviews)
5.8
5.8
User Avatar
See private message.
$110.50 USD in 7 days
5.0 (56 reviews)
5.3
5.3

About the client

Flag of UNITED STATES
mt. pleasant, United States
5.0
12
Payment method verified
Member since Dec 16, 2003

Client Verification

Thanks! We’ve emailed you a link to claim your free credit.
Something went wrong while sending your email. Please try again.
Registered Users Total Jobs Posted
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Loading preview
Permission granted for Geolocation.
Your login session has expired and you have been logged out. Please log in again.