Announcement Module
No announcement yet.

Installation and my.conf location

Page Title Module
Move Remove Collapse
Conversation Detail Module
  • Filter
  • Time
  • Show
Clear All
new posts

  • Installation and my.conf location


    I am trying to install xtradb cluster for the first time, in Ubuntu. I have ran the folloiwng commands:
    sudo apt-get update && apt-get upgrade -y && apt-get dist-upgrade -y
    echo "deb precise main" >> /etc/apt/sources.list.d/percona.list
    echo "deb-src precise main" >> /etc/apt/sources.list.d/percona.list
    apt-key adv --keyserver --recv-keys 1C4CBDCDCD2EFD2A
    apt-get update
    apt-get install -y percona-xtradb-cluster-56 qpress xtrabackup
    apt-get install -y python-software-properties vim wget curl netcat
    echo "Installation of Percona xtradb completed"

    I need to create a my.conf file, but I'm not sure where to find the mysql directory.

    I have not installed MySQL but according to one of the following links,
    we need to create it in /etc/mysql/my.cnf

    Do I need to install MySQL first so that this directory exists already, or should I just create
    the missing /etc/mysql/ directory and then create the my.conf file in there?

    Thank you

  • #2

    You don't have to install Oracle's MySQL to have this directory or the configuration file, if for some reason /etc/mysql directory or /etc/mysql/my.cnf is not found you may be able to create it without any problems.

    You may use the sample my.cnf here -, or here Just make sure to change the parameters that would fit your test cluster.

    You may also read the blogpost by Jay Janssen below:

    Shameless plug of my blogpost (just skip through Docker specific commands)

    Or if you're like me who prefers watching a video, then you can visit this link to watch a recorded webinar presented by Peter Boros: