Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
VFP coding and MySQL clustering
Message
De
26/04/2007 14:42:06
 
 
À
26/04/2007 14:03:00
Aldrich Arendsz
Gamma Research Inc.
Aruba
Information générale
Forum:
Visual FoxPro
Catégorie:
Codage, syntaxe et commandes
Divers
Thread ID:
01220177
Message ID:
01220223
Vues:
24
This message has been marked as the solution to the initial question of the thread.
>Dear Al,
>
>Maybe I was not that clear with "coding time", but what I meant was: does it take more time to code than usual because there may be aspects to take into account than when coding an app. that has a MySQL as backend that's not part of a clustering system.
>
>If there are aspects to consider, what would those be?

My understanding is that there should be no difference in coding a client app such as VFP against a clustered MySQL database, vs. one that is not clustered. Clustering is designed to improve backend performance and/or reliability without having to make changes to client apps. If you haven't found these links already there are some that look useful at the bottom of http://en.wikipedia.org/wiki/MySQL_Cluster

Having said all that, I understand there are certain types of applications - typically, low-level utilities such as backup applications - that may need to be "cluster-aware". But, typical VFP business applications should not need to be cluster-aware. If you have a fail-over cluster, my understanding is that during failover, there may be a short delay (these days, I believe only a few seconds or maybe even less) in queries or transactions that may have been in progress during the failover but I understand these queries will finish. For exact details of what happens during a failover you'd have to look at the MySQL docs/links.
Regards. Al

"Violence is the last refuge of the incompetent." -- Isaac Asimov
"Never let your sense of morals prevent you from doing what is right." -- Isaac Asimov

Neither a despot, nor a doormat, be

Every app wants to be a database app when it grows up
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform