Welcome to dbForumz.com!
FAQFAQ    SearchSearch      ProfileProfile    Private MessagesPrivate Messages   Log inLog in

Clustering, Security, Performance, Load Balance

 
   Database Forums (Home) -> Ingres RSS
Next:  Tracking History Challenge  
Author Message
Manish

External


Since: Nov 27, 2007
Posts: 3



(Msg. 1) Posted: Tue Nov 27, 2007 6:10 pm
Post subject: Clustering, Security, Performance, Load Balance
Archived from groups: comp>databases>ingres (more info?)

I think this question has been asked number of times. However, I am
looking for some specific information. Perhaps some of you can help
close the gap. Or perhaps you can point me towards right direction.

Perhaps this group can help me fill in Ingress related following
questions.

1. Do this database have data Clustering capabilities?
1a. If yes, what mechanism is used such as shared disk, share nothing,
etc.
2. Do these dB have Security features?
2a. If yes, what security features are supported? For instance do they
support encryption or SSL connection?
3. How does the database perform and what is the criteria for the
performance matrix?
4. Do they have inbuilt load balance capabilities?

I want to thank everyone for taking your time to read this
correspondence. I will also greatly appreciate your efforts in sharing
your thoughts.

Regards,
Manish

 >> Stay informed about: Clustering, Security, Performance, Load Balance 
Back to top
Login to vote
grof

External


Since: Nov 16, 2007
Posts: 5



(Msg. 2) Posted: Thu Nov 29, 2007 9:52 pm
Post subject: Re: Clustering, Security, Performance, Load Balance [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)

Hi Manish,

I'll chip away at your questions. I'm sure someone else will add to
it.

If you post some details on what you'd like to do, you'll likely get
great tips and suggestions on how to get the performance/security that
you're looking for.

Please see inline below:

On Nov 27, 4:10 pm, Manish wrote:
> I think this question has been asked number of times. However, I am
> looking for some specific information. Perhaps some of you can help
> close the gap. Or perhaps you can point me towards right direction.
>
> Perhaps this group can help me fill in Ingress related following
> questions.
>
> 1. Do this database have data Clustering capabilities?
> 1a. If yes, what mechanism is used such as shared disk, share nothing,
> etc.

Yes. Ingres has shared disk failover clustering.

That said, Ingres also has replication you could use as a foundation
for shared nothing. You'd need to do a little work to set up the
failover.

> 4. Do they have inbuilt load balance capabilities?

On VMS (though I suspect this won't help you), Ingres can do active/
active load balanced clustering.

> 2. Do these dB have Security features?
> 2a. If yes, what security features are supported? For instance do they
> support encryption or SSL connection?
> 3. How does the database perform and what is the criteria for the
> performance matrix?

I'll defer these to others with more expertise in the area.

>
> I want to thank everyone for taking your time to read this
> correspondence. I will also greatly appreciate your efforts in sharing
> your thoughts.
>
> Regards,
> Manish

Thank you for your questions and interest Manish. Please share details
of your plans so we can help.

Andrew

 >> Stay informed about: Clustering, Security, Performance, Load Balance 
Back to top
Login to vote
Mark R. Winston

External


Since: Oct 26, 2007
Posts: 16



(Msg. 3) Posted: Sun Dec 02, 2007 5:27 am
Post subject: Re: [Info-Ingres] Clustering, Security, Performance, Load Balance [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)

grof.DeleteThis@rogers.com wrote:
[snip]
>> 2. Do these dB have Security features?
>> 2a. If yes, what security features are supported? For instance do they
>> support encryption or SSL connection?
>> 3. How does the database perform and what is the criteria for the
>> performance matrix?
>
> I'll defer these to others with more expertise in the area.

2.) Yes, INGRES has the "standard" DBMS security permissions and
constraints, including password-protected roles. INGRES also provides
auditing, which is complementary to any security implementation.

2a.) Here's a section from the online INGRES documentation regarding
using INGRES with Kerberos
<http://docs.ingres.com/connectivity/ConfiguringIngrestoUseKerberos>.

As an aside, I'm actually tinkering with using SASL with INGRES and have
used SSH port forwarding in other circumstances.

3.) Performance metrics are always loaded with vendor skew and bloat, so
I'll simply say that INGRES performs very well when tuned properly, and
it *can* be tuned properly if one takes the time to appreciate its
multi-threaded architecture, memory management system, storage
structures, and file system-based table implementation.

If you have specific performance considerations there are many that
monitor this list which can answer your questions specifically and with
consummate expertise.


Mark R. Winston
www.datavailable.com
 >> Stay informed about: Clustering, Security, Performance, Load Balance 
Back to top
Login to vote
Display posts from previous:   
Related Topics:
Bulk Load Stratagies - Bulk Load Stratagies Ok ok... I'm having a brain fart here. (normal I know...) One of the DBA's I work with is trying to reload about 1.2 mil rows into a new table under VMS Ingres 2.0 and is encountering "force abort" errors. (i.e. the rel...

Replicator option for high availability and load balancing - Hi, We want to use replication (with INGRES 2006 on Linux) to configure 2 active servers for high availability and load balancing. The 2 target types are full peer, the replicator servers start automatically with the application. To start the..

Setting up Ingres Security Auditing for query_text - Had a very enjoyable evening a while back setting up Ingres 2.6 Security Auditing for query_text. I wanted to trace all SQL statements inbound to the iidbms to find the query causing the server to SIGBUS. Setting up Sec Auditing isn't well described in....

Process hanging on Endselect - We have a process which needs to produce an average figure over the last 16 qualifying weeks. The way it currently works is to select the rows from the two relevant tables ordered by date descending, then in a select loop check if the week qualifies and...

E_DM9063_LK_TABLE_MAXLOCKS - We have a weekly job that takes a COPY.OUT from the "Live" database and then does a COPY.IN to a development database in a separate installation. I've noticed that in one instance, the ERRLOG is getting a number of messages of the general form...
   Database Forums (Home) -> Ingres All times are: Pacific Time (US & Canada)
Page 1 of 1

 
You can post new topics in this forum
You can reply to topics in this forum
You can edit your posts in this forum
You can delete your posts in this forum
You can vote in polls in this forum



[ Contact us | Terms of Service/Privacy Policy ]