Take the 2-minute tour ×
Server Fault is a question and answer site for professional system and network administrators. It's 100% free, no registration required.

I want to host an application on a single server running MySQL server. To get the best performance I plan on using a UNIX socket connection (to avoid TCP overhead). Later, I would like to scale up by adding extra servers which would be MySQL read-only instances (slave) replicated from the first server (master). What I'm interested in is coming up with an initial design that allows me to scale up easily and smoothly to the replication setup in a later phase, and I have a few questions regarding this:

Q1: Is it recommended NOT to use a same server via a UNIX socket while doing replication to other servers over TCP?

Q2: Is there a performance impact (if so what is the order of magnitude) to setting up a MySQL server for replication as a master but not use the replication?

share|improve this question
    
Did you get your question answered? –  KayakJim Oct 3 '12 at 22:22
    
First thanks for your answer. It seems that Q2 was addressed but not Q1. If you know some online resources you can share that support your answer that would be great as it would give me and future readers more material for analysis, as right now it very much feels like you're just stating your opinion without explaining why and some might be tempted to ignore your answer (although you may be right). –  user64204 Oct 4 '12 at 7:37

1 Answer 1

up vote 1 down vote accepted

There is a large impact when a server is setup for replication due to the logging to the binary log files. If replication isn't being used then it would certainly be counter-intuitive to incur those performance penalties while not gaining the benefits. Although the logs would be useful for recovery purposes should your database server crash prior to the replication being put into effect.

Setting up for replication is a relatively easy task and you can hold-off on doing so until you actually need it.

share|improve this answer

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.