1

Preparing a server for mysql replication and use it as standalone

view story
linux-howto

http://serverfault.com – 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 ot (HowTos)