Need help in running ycsb on ScyllaDB

[praveenhello124@gmail.com]

Hi all,

I am trying to run YCSB on ScyllaDB cluster but  I found out that YCSB has no option for ScyllaDB to perform benchmarking.

Kindly let me know if any configuration changes need to be made for running YCSB on ScyllaDB

Currently I am using the following command as ScyllaDB is a variant for Cassandra

./bin/ycsb load cassandra-10  -s -p hosts="192.168.65.90" -P workloads/workloada

But above command is not working for me to run YSCB benchmark

[Dor Laor]

This is the command we used in the past:

https://gist.github.com/dorlaor/8cde6bcb6ab245fc8de6a2f64325426b#file-load-py-L31

--
You received this message because you are subscribed to the Google Groups "ScyllaDB users" group.
To unsubscribe from this group and stop receiving emails from it, send an email to scylladb-users+unsubscribe@googlegroups.com.
To post to this group, send email to scylladb-users@googlegroups.com.
Visit this group at https://groups.google.com/group/scylladb-users.
To view this discussion on the web visit https://groups.google.com/d/msgid/scylladb-users/c5ec9b54-8c1c-4486-b8d8-0d744d6dca98%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

[praveenhello124@gmail.com]

Hi Dor Laor,

Thanks for the help. I finally figured out the command is below:

./bin/ycsb load cassandra-10  -s -p hosts="192.168.65.90" -P workloads/workloadb

But now  I am gettting a different issue,  I am getting 0 operations per second while loading data (recordcount=1000) through YCSB.

2017-06-21 00:27:08:267 0 sec: 0 operations; est completion in 0 seconds

2017-06-21 00:27:18:232 10 sec: 0 operations; est completion in 106751991167300 days 15 hours

2017-06-21 00:27:28:229 20 sec: 0 operations; est completion in 106751991167300 days 15 hours

 

Kindly help in resolving this issue

On Wednesday, June 14, 2017 at 3:58:49 PM UTC-7, Dor Laor wrote:

This is the command we used in the past:

https://gist.github.com/dorlaor/8cde6bcb6ab245fc8de6a2f64325426b#file-load-py-L31

On Wed, Jun 14, 2017 at 2:49 PM, <praveen...@gmail.com> wrote:

Hi all,

I am trying to run YCSB on ScyllaDB cluster but  I found out that YCSB has no option for ScyllaDB to perform benchmarking.

Kindly let me know if any configuration changes need to be made for running YCSB on ScyllaDB

Currently I am using the following command as ScyllaDB is a variant for Cassandra

./bin/ycsb load cassandra-10  -s -p hosts="192.168.65.90" -P workloads/workloada

But above command is not working for me to run YSCB benchmark

--
You received this message because you are subscribed to the Google Groups "ScyllaDB users" group.

To unsubscribe from this group and stop receiving emails from it, send an email to scylladb-user...@googlegroups.com.
To post to this group, send email to scyllad...@googlegroups.com.

[Dor Laor]

Can you please check it Scylla listens on port 9042 and you can

connect to Scylla using cqlsh and describe the keyspace/table (you

do need to create it manually yourself)

To unsubscribe from this group and stop receiving emails from it, send an email to scylladb-users+unsubscribe@googlegroups.com.
To post to this group, send email to scylladb-users@googlegroups.com.

Visit this group at https://groups.google.com/group/scylladb-users.

To view this discussion on the web visit https://groups.google.com/d/msgid/scylladb-users/529370c9-0a41-4082-8711-2f184f404cec%40googlegroups.com.

[praveenhello124@gmail.com]

Hi Dor Laor,

I have checked it. Scylla is not running on 9042 port in local host but running on 9042 on 192.168.65.90 (Cluster environment) 

[vagrant@a1 ycsb-0.5.0]$ cqlsh

Connection error: ('Unable to connect to any servers', {'127.0.0.1': error(111, "Tried connecting to [('127.0.0.1', 9042)]. Last error: Connection refused")})

I have created keyspace/table already.

Kindly help in fixing this issue and removing this error

[praveenhello124@gmail.com]

Hi all,

Kindly someone help me in resolving this cluster environment issue.

[Glauber Costa]

Hi

On Wed, Jun 21, 2017 at 1:45 PM, <praveen...@gmail.com> wrote:
> Hi all,
>

> Kindly someone help me in resolving this cluster environment issue.
>
>
>
>
>
> On Tuesday, June 20, 2017 at 6:15:15 PM UTC-7, praveen...@gmail.com wrote:
>>
>> Hi Dor Laor,
>>
>> I have checked it. Scylla is not running on 9042 port in local host but
>> running on 9042 on 192.168.65.90 (Cluster environment)
>>
>> [vagrant@a1 ycsb-0.5.0]$ cqlsh
>> Connection error: ('Unable to connect to any servers', {'127.0.0.1':
>> error(111, "Tried connecting to [('127.0.0.1', 9042)]. Last error:
>> Connection refused")})
>>
>> I have created keyspace/table already.
>>
>> Kindly help in fixing this issue and removing this error

you need to specify the IP, as the database will listen to a specific
ip/port pair


So if your listen address is as specified on scylla.yaml, for instance
is 192.168.65.90,
then you need to do:

$ cqlsh 192.168.65.90

(please note how it complained that it failed to connect to 127.0.0.1
-> the default)

> https://groups.google.com/d/msgid/scylladb-users/360ec59f-afa3-4dff-bfac-45fc08a68651%40googlegroups.com.

[praveenhello124@gmail.com]

Hi Glauber Costa,

Thanks for the suggestion. I agree with what you have said. cqlsh ip works. But actual  issue is arising when I try to run ycsb as it is installed to localhost and not on the ip the cluster is on. 

./bin/ycsb load cassandra-10  -s -p hosts="192.168.65.90" -P workloads/workloadb 

O/P:

Loading workload...

Starting test.

2017-06-21 18:18:24:407 0 sec: 0 operations; est completion in 0 seconds

2017-06-21 18:18:34:360 10 sec: 0 operations; est completion in 106751991167300 days 15 hours

Kindly let me know how to change ycsb to detect scylladb on cluster ip and not local host.

[Glauber Costa]

On Wed, Jun 21, 2017 at 2:19 PM, <praveen...@gmail.com> wrote:
> Hi Glauber Costa,
>
>
> Thanks for the suggestion. I agree with what you have said. cqlsh ip works.
> But actual issue is arising when I try to run ycsb as it is installed to
> localhost and not on the ip the cluster is on.
>
> ./bin/ycsb load cassandra-10 -s -p hosts="192.168.65.90" -P
> workloads/workloadb
>
> O/P:
> Loading workload...
> Starting test.
> 2017-06-21 18:18:24:407 0 sec: 0 operations; est completion in 0 seconds
> 2017-06-21 18:18:34:360 10 sec: 0 operations; est completion in
> 106751991167300 days 15 hours
>
> Kindly let me know how to change ycsb to detect scylladb on cluster ip and
> not local host.
>

hosts="..." should have worked.

So maybe the problem is another one. By the way: are you running ycsb
in the same machine as Scylla ?

> https://groups.google.com/d/msgid/scylladb-users/180e7cbc-7d79-44e4-914a-e368473c8279%40googlegroups.com.

[praveenhello124@gmail.com]

Yes !! I am running ycsb on the same machine as scylla

[Glauber Costa]

On Wed, Jun 21, 2017 at 2:27 PM, <praveen...@gmail.com> wrote:
> Yes !! I am running ycsb on the same machine as scylla

We don't recommend that, as the benchmark load will now be competing
for resources with Scylla.
That likely has nothing to do with why it isn't working, but my first
recommendation would be to move it to a different machine, so we can
start from a supported environment.

> https://groups.google.com/d/msgid/scylladb-users/f7e4e9cc-d819-45dc-b620-d84281143556%40googlegroups.com.

[praveenhello124@gmail.com]

Thanks for the suggestion. So are you recommending me to move ycsb to another machine?

[Glauber Costa]

Yes.

> https://groups.google.com/d/msgid/scylladb-users/dddec806-8d55-4f99-9c19-7838c2737eac%40googlegroups.com.

[praveenhello124@gmail.com]

Hi Glauber Costa,

I tried running it from a different machine. The result is still the same :(

[Eyal Gutkind]

Hi,

Was the load process successful? (preferably with workload A)?

Can you share the information you have in the workload files?

Regards,

To unsubscribe from this group and stop receiving emails from it, send an email to scylladb-users+unsubscribe@googlegroups.com.
To post to this group, send email to scylladb-users@googlegroups.com.

Visit this group at https://groups.google.com/group/scylladb-users.

To view this discussion on the web visit https://groups.google.com/d/msgid/scylladb-users/d2d9ce52-7ebd-4289-8530-ea0917823017%40googlegroups.com.

For more options, visit https://groups.google.com/d/optout.

--

Eyal Gutkind

ScyllaDB

www.scylladb.com

[praveenhello124@gmail.com]

Hi Eyal Gutkind,

Yes the load is now successful . I changed the ycsb command as follows and it worked :

./bin/ycsb load cassandra2-cql  -s -p hosts="192.168.65.90" -P  workloads/workloada

Thanks & Regards,

Praveen

To view this discussion on the web visit https://groups.google.com/d/msgid/scylladb-users/d2d9ce52-7ebd-4289-8530-ea0917823017%40googlegroups.com.

For more options, visit https://groups.google.com/d/optout.