|
| Iniciado por guest, 16,feb. 2016 20:32 - 4 respuestas |
| |
| | | |
|
| |
| Publicado el 16,febrero 2016 - 20:32 |
Hi everybody,
Is anybody using clusters of HFsql servers and would like to comment on usefullness or otherwise.
Thanks
Noel |
| |
| |
| | | |
|
| | |
| |
| Publicado el 17,febrero 2016 - 01:07 |
Hi Noel
I did some light testing and was not too happy with the result. This is why (remember this is only my understanding after reading and doing light testing):
- HFSQL clusters needs at least 3 servers (ok)
- One is the master and redirects traffic to all the others
- so if THAT server crashes, everything crashes.
- I was hoping that each client could connect to any of the servers, but that's not the case, everything goes to the main server only
So, that may be useful to increase data access speed and load, but it does nothing to increase uptime security.
So instead of using THIS system, you can use the server to server quasi real time replication and have the same load balancing (but YOU manage it) and increase the security at the same time. Or you can use MY replication (wxreplication) to do the same, of course if you want more control. And that is the way -I- decided to go.
Best regards |
| |
| |
| | | |
|
| | |
| |
| Publicado el 17,febrero 2016 - 07:22 |
HI Fabrice,
thanks for taking the time to answer.
Will try to add replication and see how it goes.
Regards
Noel |
| |
| |
| | | |
|
| | |
| |
| Publicado el 17,febrero 2016 - 13:58 |
HI again
about the replication...
PCSoft server to server replication seems to be working fine when setup. However, it seems (from the returns on the french forum) that it does not manage very well interruptions of communications. In many cases, the server that was cut from the network needed to be reenrolled from scratch (ie remove the db and transfer the whole DB again). And of course, you have no way of debugging anything when there is a problem.
Best regards |
| |
| |
| | | |
|
| | |
| |
| Publicado el 18,febrero 2016 - 11:57 |
In bidirectional replication every month lost 2-3 records on some server.
Imagine now that I sold without testing this solution users with my program ?
Btw. Pervasive.PSQL + DataExchange you simply can not corrupt your replication whatever you try.
On HFSQL 5 minutes or less (disconnect / connect network while replicating, restart server etc)  |
| |
| |
| | | |
|
| | | | |
| | |
|