Re: Faster bulk keyspace creation

2022-03-09 Thread Bowen Song
AFAIK, Cassandra will not process schema changes in parallel. However, by sending requests in parallel, you can minimise the time Cassandra staying idle while the client is waiting for schema agreement after each CREATE KEYSPACE statement. On 09/03/2022 20:46, Leon Zaruvinsky wrote: Hi

Re: Faster bulk keyspace creation

2022-03-09 Thread Leon Zaruvinsky
Hi Bowen, Haha, agree with you on wanting fewer keyspaces but unfortunately we're kind of locked in to our architecture for the time being. We do part of what you're saying, in that we shut down all but one node and then run CREATE against that single node. But we do that serially,

Re: Faster bulk keyspace creation

2022-03-09 Thread Bowen Song
First of all, you really shouldn't have that many keyspaces. Put that aside, the quickest way to create large number of keyspaces without causing schema disagreement is create keyspaces in parallel over a connection pool with a number of connections all against the same single Cassandra node.

Faster bulk keyspace creation

2022-03-09 Thread Leon Zaruvinsky
Hey folks, A step in our Cassandra restore process is to re-create every keyspace that existed in the backup in a brand new cluster. Because these creations are sequential, and because we have _a lot_ of keyspaces, this ends up being the slowest part of our restore. We already have some