A customer is considering changing the server configuration in there data center to virtual machines and Network-attached storage. Are there any issues we should be aware of regarding SQL Anywhere in this configuration? We are currently moving all databases to 12.0.1 but will have a few still running 9.0.2 when this is scheduled to take place.



asked 18 May '12, 18:13

J%20Diaz's gravatar image

J Diaz
accept rate: 14%

(20 May '12, 14:13) Volker Barth

See http://www.sybase.com/detail?id=1034790

FWIW I found that article by using the search box on this page: http://sqlanywhere.blogspot.ca/2012/03/tales-from-doc-face.html

permanent link

answered 18 May '12, 20:59

Breck%20Carter's gravatar image

Breck Carter
accept rate: 20%

edited 18 May '12, 21:02

Thanks Breck, I'm learning...

(20 May '12, 09:25) J Diaz

@Breck: Now is the time to spread the "tales" link, methinks:)

(20 May '12, 14:07) Volker Barth
Replies hidden

@Volker: Not yet. The Google Custom Search Engine feature seems to be broken. I have done some fiddling, but it will probably take some time to see any results. The symptom? Bogus result sets for some searches, like "select" returning only one hit, but "olap" returning several. The Google CSE GUI also seems to be unstable.

(20 May '12, 14:21) Breck Carter

See http://www.sybase.com/detail?id=1092313 that discusses some important factors related to I/O semantics across Linux and Windows operating systems.

What virtual machine OS software are you planning to use, Jim? VMWare?

permanent link

answered 18 May '12, 22:10

Glenn%20Paulley's gravatar image

Glenn Paulley
accept rate: 43%

How does that article relate to NAS, SAN or VM usage? None of those terms appear in the article (which might explain why it didn't turn up in the search).

(19 May '12, 08:59) Breck Carter
Replies hidden

The article explains the I/O semantics required by both Linux and Windows with respect to their filesystems. The issue with running under a VM is whether or not the VM relays flush() and similar calls from the host OS through to the underlying hardware. If it does not, then potential exists for corruption, particularly with power failures.

(19 May '12, 16:28) Glenn Paulley

I believe the plan is to use VMWare. I've asked for proposed specifications on both the Virtual Machine and NAS. Thanks as always for the assistance.

(20 May '12, 09:03) J Diaz
Your answer
toggle preview

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here



Answers and Comments

Markdown Basics

  • *italic* or _italic_
  • **bold** or __bold__
  • link:[text](http://url.com/ "title")
  • image?![alt text](/path/img.jpg "title")
  • numbered list: 1. Foo 2. Bar
  • to add a line break simply add two spaces to where you would like the new line to be.
  • basic HTML tags are also supported

Question tags:


question asked: 18 May '12, 18:13

question was seen: 1,238 times

last updated: 20 May '12, 14:21