Version 4
Created by pablo on Jul 6, 2011 12:55 PM. Last modified by pablo on Jul 13, 2011 5:20 PM.
Visibility: Open to anyone
    1. yum install mysql mysql-sever
    2. mv /var/lib/mysql/* /new_place/*
    3. chown -r mysql:mysql /new_place
    4. rmdir /var/lib/mysql
    5. cd /var/lib
    6. ln -s /new_place mysql
    7. vi /etc/my.cnf
      1. datadir=/new_place
      2. socket=/new_place/mysql.sock
    8. mysql_install_db --user=mysql --ldata=/new_place
    9. mysqld_safe --datadir=/new_place --user=mysql &
    10. /etc/init.d/mysqld start
    11. mysql
      1. GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' WITH GRANT OPTION; (da permisos al user root para conectarse de cualquier maquina, obviamente para usar solo en testing)
    12. Edit /etc/my.cnf. Add:

      1. [mysqld]

      2. max_allowed_packet=32M // maximo tamaño para attachments...

      3. max_connections=550 // Asumiendo 5 nodos con 100 connections por nodo + 10% para liberar connections...

    • 469 Views
    • Categories: Tags: