2
votes
1answer
1k views

Is mysql-proxy ready for production use?

I've been doing a bit of research, and I would love to use mysql-proxy in production, because It supports sockets It supports read-write splitting My other option is to use HAProxy and change all ...
2
votes
4answers
482 views

Virtualizing a production MySQL server

We have a MySQL server that supports several internal business systems. Our infrastructure team is having a spirited debate as to whether or not we can switch this database server to a VM. The ...
3
votes
1answer
922 views

How to deploy changes to staging database while still keep it in sync with production master database?

I want to set up a staging server to do final test for my website. The staging site's database is replicating production master mysql db in order to reflect a real environment. If a deploy only ...
2
votes
2answers
368 views

Setting up a Production Server for Rails

I am currently installing Ubuntu Server 10.04 in a virtual machine and I am going to run my web app in it so I can see how it runs, etc in a 'production' environment. What software should be ...
3
votes
3answers
885 views

Is XtraDB stable enough for production?

Is anyone using XtraDB (a MySQL build) from Percona? The features & benchmark data looks nice. I wondered if it's stable enough for production. What is your experience?
2
votes
2answers
628 views

How do you handle the task of changing the schema of a production MySQL database?

One of the biggest complaints I have heard about MySQL is that it locks up a table if you try to change its schema like adding a column or adding an index. By "locking up the table" does it mean I ...
14
votes
5answers
3k views

What is the best way to monitor a production server?

We are running two production servers with Apache 2 and MySQL. I am looking for a reliable way of monitoring our load, stability and uptime. I have come across monit, but are there better ...