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?