[Info-Ingres] INGRES GNU/Linux Cluster Support?


    Sponsored Links


  • 1. seleting from tablename without "ownername."
    So, we've an older install of ingres: OI 2.0 most of our tables are created using the ingres user and have insert/delete/etc persmissions granted... lets say ingres user does: create table selecttest as select 1; grant all on selecttest to public; now if a user (other than ingres) goes into terminal monitor and types: select * from selecttest; they will see the table fine. We were test migrating from the old ingres to Ingres II 9.0.4 (since support expired) and would like this behavior duplicated, but it doesn't seem to be... you have to specify the username select * from ingres.selecttest; Is there some switch to throw, does the table have to be created by certain user(s) for this to work, or has this behavior been phased out? Note, even on the old system If a user that isn't ingres does the same thing (create/grant all), you have to type: select * from username.selecttest; Mostly I'm worried about all the openroad apps and scripts we've written. Probably a dirt easy answer... but i didn't see it in the migration guides... (just skimming.... I'm reading more in depth right now.) Thanks in advance! -- flip
  • 2. [Info-Ingres] Migrating off OpenVMS
    At 10:30 AM -0700 3/12/07, XXXX@XXXXX.COM wrote: >I have a customer currently running the Ingres database under OpenVMS >with applications written in C and FORTRAN. They would like to migrate >however they are concerned about the data access SQL statements. Surely you jest. I can imagine various excuses for migrating away from VMS, but the SQL isn't one of them. Ingres is handling the SQL, not VMS, and Ingres supports the exact same SQL statements regardless of platform. If someone is itching to get away from OpenVMS because it's not trendy enough, they really ought to come up with a better excuse. (Or, if they do have a real excuse, they need to do a better job communicating it.) >Are there any significant differences or gotcha's in moving from >OpenVMS to Unix or Windows ? >From an SQL perspective, no. Their C and Fortran apps are likely to see differences in the non-SQL part. For instance, if the apps were written to the DEC variants of C or Fortran, it may take a little effort just to get them to compile on another OS, never mind making them work. Karl
  • 3. Migrating off OpenVMS
    I have a customer currently running the Ingres database under OpenVMS with applications written in C and FORTRAN. They would like to migrate however they are concerned about the data access SQL statements. Are there any significant differences or gotcha's in moving from OpenVMS to Unix or Windows ? Mike
  • 4. Ingres 2006 release 3
    I see that Ingres 2006 release 3 alpha is available for download on the Ingres communities site. Not having a linux box here to try it out, does anybody know what new features this Ingres 2006 release 3 alpha has? John H.

[Info-Ingres] INGRES GNU/Linux Cluster Support?

Postby Mark R. Winston » Mon, 23 Feb 2009 03:50:59 GMT

Does anyone know the current status of INGRES clustering support, not
the HA solutions supported for Solaris and VMS, but specifically
GNU/Linux?  There was something "in the works" with Red Hat Enterprise
Linux but I don't see anything about it in the documentation or on the
Ingres website.

I ask because I'm working on a few variations of a clustered iSCSI/Samba
storage implementation and we're using RHEL5.3AP and AFAIK the work that
was/is being done was specifically using the Red Hat Cluster Suite.  At
the risk of starting an unproductive argument, MySQL offers integration
of DRBD (iSCSI Target block-device mirroring), and we're using DRBD for
mirroring, which prompted the recollection of the above.

Mark R. Winston

Re: [Info-Ingres] INGRES GNU/Linux Cluster Support?

Postby Betty & Karl Schendel » Mon, 23 Feb 2009 04:12:35 GMT

This is not an "inside" answer, but ...

The VMS work nearing completion is for true active/active clustering;
in fact, a good deal of the most recent work centered around
fixes for distributed deadlock detection.  The last time true clustering
worked in production was 6.4, and it had a totally different deadlock
detection architecture, completely incompatible with the way Ingres
does things now.  There has been an awful lot of stress testing, and
fixing of bugs that would take a week or so of running to put in
an appearance.  (Ouch.)

Anyway, I don't think any effort has been put into the linux side of
things for a while.  I am reasonably sure that if and when linux
clustering is revived, most of the work will be integrating with a
different distributed lock manager.  The old linux cluster effort
used OpenDLM, which turned out to be a dead end.  I doubt
that OpenDLM is worth rescuing, since there is at least one DLM
out there now as part of one of the cluster filesystems (not sure
which one at the moment);  one might assume that a DLM
associated with a working filesystem might itself actually work,
unlike OpenDLM.

Anyone wanting an active/active cluster solution on linux today
would probably start with the latest open source "main", and would
need to figure out what to do on the DLM side of things.  The
Ingres/DLM interface is reasonably well isolated into the CX
area of the CL, but who knows what adaptations might be needed.

It's entirely possible that stuff has been going on behind the curtain
that I don't know about;  the above is my personal best guess at
the status.


Similar Threads:

1.[Info-Ingres] OT hostnames (was Ingres on Linux)

<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
  <meta content="text/html;charset=ISO-8859-1" http-equiv="Content-Type">
<body bgcolor="#ffffff" text="#000000">
Roy Hann wrote:
<blockquote cite="mid: XXXX@XXXXX.COM " type="cite">
  <pre wrap="">"Michael Leo" <a class="moz-txt-link-rfc2396E" href="mailto: XXXX@XXXXX.COM ">< XXXX@XXXXX.COM ></a> wrote in message 
<a class="moz-txt-link-freetext" href="news: XXXX@XXXXX.COM ">news: XXXX@XXXXX.COM </a>...

  <blockquote type="cite">
    <pre wrap=""> [root@starbuck jsvr]#
  <pre wrap=""><!---->
I'm just curious Mike.  Do you also have a host called kaldi?


Not many folks would know to what you refer!<br>
Actually, the host-naming theme at Caribou Lake (before it was
absorbed) by<br>
its parent was "South Pacific Islands", of which there are plenty.<br>
At Kettle River, our theme is "Cities of North Dakota".  We think we
be unique ;-)<br>

2.[Info-ingres] Ingres R3 - replication on Linux

3.[Info-Ingres] Ingres on Linux

Hi everyone,

can someone tell me please, preferably by a pointer to a web site, when 
was first made available on Linux ?  I can't find historic release dates
on ingres.com

Thanks, Jgen

4.[Info-ingres] ingres/apache/linux/DBD

5.[Info-ingres] Ingres 2006 on Linux

6. [Info-Ingres] Ingres 2006 R? GA for linux

7. [Info-ingres] Ingres file size limit Linux

8. [Info-ingres] Linux NPTL Ingres ...

Return to DATABASE


Who is online

Users browsing this forum: No registered users and 63 guest