Add new nodes(from new server) to the Gridsql database

Hi,

We are using postgresplus standard server with default grid version available in it as the details are shown below.

Postgres version

postgres=# select version();
version
--------------------------------------------------------------------------------------------------------------
PostgreSQL 8.3.2 on x86_64-unknown-linux-gnu, compiled by GCC gcc (GCC) 3.4.3 20041212 (Red Hat 3.4.3-9.EL4)
(1 row)

Grid version

GridSQL -> select version();
+---------+
| version |
+---------+
| 1.1.0.9 |
+---------+
1 row(s).

Now, in grid I have the database running on 14 nodes with 1 coordinator and 2 agents as shown below.

coordinator nodes: 1,2,3,4,5
agent1 nodes: 6,7,8,9,10
agent2 nodes: 11,12,13,14

GridSQL -> show databases;
+-----------------------------------------------------------+
| DATABASE | STATUS | NODES |
+-----------------------------------------------------------+
| testdb | Started | 1,2,3,4,5,6,7,8,9,10,11,12,13,14 |
+-----------------------------------------------------------+
3 row(s).

Now, i need to add new nodes from the different server to the above currently existing database(testdb) , the database have many tables with huge amount of data.
Please help me to add the nodes.

Thanks in advance.

Pavani

Hi Pavani,

There is a closed source version that includes an AddNode feature to make this just a bit easier, but you will still likely want to redistribute tables.

I am afraid you will need to create a 2nd cluster, dump your tables and reload.If you want to reuse some of the same nodes, you could configure the new cluster to use different ports.

Also, one consideration is, if you expect future growth, you could create extra partitions on each node, such that you can later move these to new servers when you need them without reloading any data.

Regards,

Mason