Experts Exchange Solution brought to you by
"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.
The IT Service Excellence Tool Kit has best practices to keep your clients happy and business booming. Inside, you’ll find everything you need to increase client satisfaction and retention, become more competitive, and increase your overall success.
"You should definitely look at ver 16 which offers additional Replication Modes"
you mean Near-Synchronous Replication Mode (Hot Standby) ? which only need one of the member commit the replicated data but not all of the replication member?
"ASE 15.7 introduced Cluster Edition. In my opinion this creates more problems than it solves. Don't bother. "
is it like oracle RAC? does it do horizontal scale out like MS SQL, MySQL and MariaDB ? what problesm it created ?
this cluster edition still like Oracle RAC which MUST relies on shared storage ?
"There are some tips like using local not shared tempdb disk devices.
what is that mean sorry ?
"ASE also works out of the box with disk replication technologies like SRDF. Again, don't replicate tempdb."
is that mean all replication license included even on each site we need to setup replication, there are no need to by sybase replication server? replication license included?
I think it just STILL looks like MS SQL, system DB do not replicate, right?
so "new ASE 16 HADR or "Always On" option. " this works well ? it has always on feature like MS SQL ?
"You don't really need any development tools to develop SQL. Text editor is fine. Run in the built-in GUI tools for development but all serious SQL work will be in procs and/or OS scripts anyway."
from my understanding, sybase only offer iSQL out of the box as the admin and development tools, am i right?
what other tools you can suggest ?
I mean architecture diff, not upgrade path diff, any to share?
what is the multi master solution for Sybase? e..g what is the sybase solution close to Oracle RAC solution ?
what is the capability diff between Sybase replication and Sybase cluster ?
Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.
From novice to tech pro — start learning today.
Members can enroll in this course at no extra cost.