Announcement

Announcement Module
Collapse
No announcement yet.

IP list in Percona 5.5.23

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

  • IP list in Percona 5.5.23

    Hi,

    You know with the new version of Percona, it's able to pass list of IP addresses for a new node, it will connect to the first available.
    But I don't know how to configure it.

    Can you help me

    Thx

  • #2
    Add the following to my.cnf:


    [mysqld_safe]wsrep__urls=gcomm://node1ort1,gcomm://node2ort2,gcomm://


    it will first try node1ort1, then node2ort2 and if no success, will form a new cluster.

    Comment


    • #3
      Hi ayurchen,

      Thx a lot for your response. I'm so excited to test it but before I have 2 questions.
      I must create mysql_safe section or can I use mysqld section ?
      What am I doing with wsrep_cluster_address ? I comment it ?

      Thx again for your help

      Comment


      • #4
        1. it is a feature of mysqld_safe, so you have to put it in [mysqld_safe] section
        2. wsrep_cluster_address is ignored if any of wsrep_urls work, so essentially it is not needed.

        Comment


        • #5
          Also, ports in urls are mandatory!

          Comment


          • #6
            Tnx for your response but I have this error message when I start mysql :
            ERROR 1047 (08S01) at line 1: Unknown command

            I look in my log and i'm not found an error :
            120525 15:55:48 mysqld_safe mysqld from pid file /var/lib/mysql/percona-1.pid ended
            120525 15:57:51 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql
            120525 15:57:51 [Warning] option 'wsrep_max_ws_rows': unsigned value 67108864 adjusted to 1048576
            120525 15:57:51 [Note] Flashcache bypass: disabled
            120525 15:57:51 [Note] Flashcache setup error is : ioctl failed

            120525 15:57:51 [Note] WSREP: Read nil XID from storage engines, skipping position init
            120525 15:57:51 [Note] WSREP: wsrep_load(): loading provider library '/usr/lib64/libgalera_smm.so'
            120525 15:57:51 [Note] WSREP: wsrep_load(): Galera 2.1dev(r112) by Codership Oy loaded succesfully.
            120525 15:57:51 [Note] WSREP: Found saved state: 134487b3-8f74-11e1-0800-14b30cfd2465:-1
            120525 15:57:51 [Note] WSREP: Preallocating 134219048/134219048 bytes in '/var/lib/mysql//galera.cache'...
            120525 15:57:52 [Note] WSREP: Passing config to GCS: base_host = 10.7.110.3; gcache.dir = /var/lib/mysql/; gcache.keep_pages_size = 0; gcache.mem_size = 0; gcache.name = /var/lib/mysql//galera.cache; gcache.page_size = 128M; gcache.size = 128M; gcs.fc_debug = 0; gcs.fc_factor = 0.5; gcs.fc_limit = 16; gcs.fc_master_slave = NO; gcs.max_packet_size = 64500; gcs.max_throttle = 0.25; gcs.recv_q_hard_limit = 9223372036854775807; gcs.recv_q_soft_limit = 0.25; gcs.sync_donor = NO; replicator.causal_read_timeout = PT30S; replicator.commit_order = 3
            120525 15:57:52 [Note] WSREP: Assign initial position for certification: -1, protocol version: -1
            120525 15:57:52 [Note] Plugin 'FEDERATED' is disabled.
            120525 15:57:52 InnoDB: The InnoDB memory heap is disabled
            120525 15:57:52 InnoDB: Mutexes and rw_locks use GCC atomic builtins
            120525 15:57:52 InnoDB: Compressed tables use zlib 1.2.3
            120525 15:57:52 InnoDB: Using Linux native AIO
            120525 15:57:52 InnoDB: Initializing buffer pool, size = 1.0G
            120525 15:57:52 InnoDB: Completed initialization of buffer pool
            120525 15:57:52 InnoDB: highest supported file format is Barracuda.
            120525 15:58:03 InnoDB: Waiting for the background threads to start
            120525 15:58:04 Percona XtraDB (http://www.percona.com) 1.1.8-rel25.3 started; log sequence number 1120176965
            120525 15:58:04 [Note] Event Scheduler: Loaded 0 events
            120525 15:58:04 [Note] /usr/sbin/mysqld: ready for connections.
            Version: '5.5.23-55-log' socket: '/var/run/mysqld/mysqld.sock' port: 3306 Percona XtraDB Cluster (GPL),
            wsrep_23.5.r333

            I don't know what is the problem

            Best regards

            Comment


            • #7
              Have you restarted the whole service or just killed mysqld? It looks like the latter and that means that mysqld_safe didn't reread my.cnf

              Comment


              • #8
                Hi,

                I shutdown my nodes and restart my first node.
                I have the same error

                Comment


                • #9
                  It's working.
                  The pb is there was 2 underscore in my wsrep_urls variable

                  Thx for your help

                  Comment


                  • #10
                    Useful ! not documented yet, thanks.

                    Comment

                    Working...
                    X