How to set both Index Servers to Primary (Active)

I tried to use DQL to set both my IS to active, by setting the is_standby flag to ‘0’, but instead encountered an error. The DQL was:

select r_object_id, index_name, ft_engine_id, is_standby from dm_fulltext_index

But I managed to do it by using API. Obtain the r_object_id from the DQL above. Using API:

  • Command: dump,c,r_object_id
  • Command: set,c,r_object_id,is_standby
  • Data: F
  • Command: save,c,r_object_id

Run the DQL again, both entries will have is_standby as ‘0’.


Leave a Reply

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out /  Change )

Google+ photo

You are commenting using your Google+ account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )


Connecting to %s

%d bloggers like this: