ORS and Apache Cassandra

[PFCCWA]

Hello,
Has anyone successfully deployed ORS 8.1.2 with Apache Cassandra (1.1.2)?
Im having problem with deploying Cassandra.
Have followed the ORS Deployment guide, not sure what to do here:

[i]Procedure:
Loading the Cassandra Schema
Purpose: To load the schema after the Cassandra Server is started
Summary
After all nodes in the cluster are started (which might be only one), execute
one of the commands in this procedure (for Windows or Linux) from the
Cassandra installation directory. Execute these commands on a single node
only; Cassandra distributes the schema from the executing node to all nodes in
the cluster.
Start of procedure
1. Execute the following command on Windows:
.\bin\cassandra-cli.bat -host ip-address-of-cassandra-host
--file conf/orchestration-schema-sample.txt
where ip-address-of-cassandra-host is the host IP. For example,
135.225.58.81.[/i]

When I attempt to start the cassandra-cli.bat, I receive a connection refused message where it seems to be trying to connect to 127.0.0.1/9160.
In ORS logs I am receiving this message:
[i]09:36:25.962 Std 21006 ORS Cluster: Node 139@102:3900 added
09:36:25.962 Std 21001 ORS Cluster: Enabled - this node Routing_Cluster_1/139@102:3900
09:36:27.930 Std 23002 ORS Cassandra schema version ORS8110000 No Cassandra hosts available <TTransportException: Internal error>: Orchestration terminating
09:36:28.274 Std 01000 ors Exiting[/i]

Could be related to loading the cassandra schema.
Have set JAVA_HOME (on java 6)
Have set CASSANDRA_HOME environment variables.

Thanks.

[Kubig]

You have to start Cassandra before start ORS. I have deployed ORS with Cassandra in version 8.1.2 and both runned correctly. So,according to my opinion,current ORS is unusable for real traffic.

[PFCCWA]

Did try to start cassandra first however received java memory errors.
Will attempt to deploy ORS version 8.1.0 with Cassandra 0.6.8 as I have a course manual covering these versions.

Does anyone which cassandra version ships with ORS 8.1.2

[Adam G.]

Sorry to hijack the thread....

Why did G use Cassandra for ORS? It's completely different from their usual architecture. A standard RDB would do the same job (and be more easily supportable). Cassandra is a bit of a sledgehammer to crack a nut.

W

[Kubig]

I had the same question..so:

Cassandra is distributed database,nonSQL datastore,used for session store,fault mgmt and many others -> according to the doc.

As I wrote above,my opinion is that the ORS is currently unusable for real traffic.

[Adam G.]

[quote author=Kubig link=topic=7486.msg32084#msg32084 date=1352214259]
I had the same question..so:

Cassandra is distributed database,nonSQL datastore,used for session store,fault mgmt and many others -> according to the doc.

As I wrote above,my opinion is that the ORS is currently unusable for real traffic.
[/quote]

I'm currently doing some heavy duty development using Cassandra (not Genesys related) and its a great DB when its used for the right purpose. In my opinion ORS is not the right use.

[Kubig]

I guess,that the whole ORS solution is poor(currently)..Cassandra is not used for right purpose and ORS is in real traffic unusable...sadly.

[Adam G.]

[quote author=Kubig link=topic=7486.msg32086#msg32086 date=1352214908]
I guess,that the whole ORS solution is poor(currently)..Cassandra is not used for right purpose and ORS is in real traffic unusable...sadly.
[/quote]

I have something similar based on MySQL in the pipeline that I will eventually publish and make open source. ;-)

[PFCCWA]

What should I use for these options:

[i]For a single-node cluster, if the IP address 127.0.0.1 resolves correctly, it
is not necessary to modify the <seeds> entry. Otherwise, enter the IP
address of the node (for example, seeds: 127.0.0.1).
9. A potential port conflict with URS might occur for storage_port 7000.
This can be modified for Cassandra to remove the conflict by setting the
storage_port entry to something other than 7000. Choose a port that does
not conflict with any other existing port usage. This port must be the same
for all nodes in the Cassandra cluster.
For example:
storage_port: 7001[/i]

The SSL Storage port is 7001, think the deployment guide forgets this..

[rpenney]

[quote author=Kubig link=topic=7486.msg32086#msg32086 date=1352214908]
I guess,that the whole ORS solution is poor(currently)..Cassandra is not used for right purpose and ORS is in real traffic unusable...sadly.
[/quote]

Can you explain why you say this? I know of several ORS installations taking real traffic and they are certainly not unusable.

[Adam G.]

[quote author=rpenney link=topic=7486.msg32114#msg32114 date=1352414226]
[quote author=Kubig link=topic=7486.msg32086#msg32086 date=1352214908]
I guess,that the whole ORS solution is poor(currently)..Cassandra is not used for right purpose and ORS is in real traffic unusable...sadly.
[/quote]

Can you explain why you say this? I know of several ORS installations taking real traffic and they are certainly not unusable.
[/quote]

I can't comment about ORS in production environments but I will support the [quote]Cassandra is not used for right purpose [/quote]comment. As a techie, I'd say the original developers discovered Cassandra and thought, this is cool. They used it for being cool rather than the right type of datastore.

[Fra]

Really, guys?
There is no relation data base model which is enough scalable for very high data sets such as millions of records; if you want a technology which is scalable, performant, truly fully distributed, with no single point of failure, that's Cassandra. So for me it makes sense that Genesys followed this route to provide an architecture which is capable of providing millions of SCXML sessions & persistent storage.

Fra

[Timur Karimov]

Hi all!

Well, let me renew this good topic =)
[it's a place for some dramatic music and then silince]
If you don't know  - Genesys public the plan to move out from URS to ORS.
[why i don't hear a handclap? =))]

Seriously. Now more different voice/multimedia strategy. No more different why to create GVP or simple routing strategy. One solid and complex engine (i mean ORS)to route everithing and one good tool (i mean Eclipse aka  Composer) to create stategy for this engine.

Well this is a good idea, at least =) Let's see what would happen in real world =)

WBR Tim

P.S. And yes - CCPulse is part of history too. Of couse after the EZPulse is be a real product. =)

[cavagnaro]

I guess they will think and put a method to export/convert/import IRD strategies to ORS...if not pain in the ass....

EZPulse?? What is that!!??

[bublepaw]

There is already conversion wizard to import IRD strategies into ORS. In my opinion it is good strat to use wizard but You will gain more benefit if You rewrite strategies to use all new features of ORS in some point of time.

EZPulse is web based real time statistics display - new version of CCPulse - it will be available somewhere next year