Find Jobs
Hire Freelancers

Configure MySQL Master/Slave Replication with Sphinx Search

$30-5000 USD

En curso
Publicado hace más de 13 años

$30-5000 USD

Pagado a la entrega
I am in the process of converting an application that has traditionally been a desktop-based app into a "cloud service" which needs to be efficient and can scale well. My application requires use of Full Text Search. I've been using MySQL with the myisam engine for that, but it doesn't work well when the table gets a lot of writes, which it will. So I've done some research and see that a project called Sphinx Search can be installed as a mysql engine and perform better full text searches than myisam. Thing is, I've tried installing it with no success. I'm fairly new to Linux programming and server administration, so it exceeds my capabilities and I need help. So this is what I would like to hire someone to do: My current database server is hosted at the Rack Space Cloud. What I would like to do is make this current server a "Master" server in a mysql master/slave setup and convert the tables from myisam to innodb to improve write performance. The master will only be used for insert and update queries only. Next I would like to setup 2 mysql slaves. The slaves will be used for all select full text search queries and will have copies of the master table but use the Sphinx engine instead of myisam or innodb. One of the slaves will be a new image in the Rack Space Cloud and the other slave should be an VirtualBox image I can run off my home DSL connection. I prefer to use Ubuntu Server 10.10 as this is what the current server is and I'd like to be consistent. I also need instructions on how to add more slaves in the future should I need it and what the most cost effective server from Rackspace is (e.g. better to have more low ram server instances or less high ram servers). Along the way I'd also appreciate any insight on how to make my queries more efficient or a better way to configure the server. Or if you have a better plan for my needs than what I've come up with, I'm open to suggestions.
ID del proyecto: 3035799

Información sobre el proyecto

2 propuestas
Proyecto remoto
Activo hace 13 años

¿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
Adjudicado a:
Avatar del usuario
See private message.
$204 USD en 20 días
4,8 (61 comentarios)
5,8
5,8
2 freelancers están ofertando un promedio de $593 USD por este trabajo
Avatar del usuario
See private message.
$981,75 USD en 20 días
5,0 (12 comentarios)
5,6
5,6

Sobre este cliente

Bandera de UNITED STATES
United States
5,0
10
Forma de pago verificada
Miembro desde nov 17, 2000

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.