1. I want to use Continuent uni/cluster, but all backend must save on local disk, adding a node that mean I need to adding same disk space.
2. I want to use GridSQL, but when I add a new node it will haven't any data. If want to scale-out the data, I need to reload all data again.
Any ideas for OLTP scale-out Database on Postgres Plus?
GridSQL works well for parallel query such as in data warehousing, but is not designed for scaling OLTP.
Anyway, the version of GridSQL that comes with Advanced Server version does include the AddNode utility which makes this a little bit easier.
We have some new software coming out soon that may be able to help you with your OLTP scalability needs. Feel free to send me a private message if you would like someone from EnterpriseDB to contact you to speak about it.