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’.

Advertisements

Leave a Reply

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

WordPress.com Logo

You are commenting using your WordPress.com 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 )

Google+ photo

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

Connecting to %s

%d bloggers like this: