开发者

query on MySQL 5 replication

I have a table which contains a large volume of data...thousands of million of rows. I am planning to have a replica of this table. Can I have an index on replica only not on the original table, so that insertion in the orignal table will 开发者_C百科be fast.


Yes that's possible. You can even change the underlying engine of the replicated table (a common scenario is to replicate a InnoDB table to another server, change the engine to MyISAM and add a full-text-index to the appropriate table columns).

0

上一篇:

下一篇:

精彩评论

暂无评论...
验证码 换一张
取 消

最新问答

问答排行榜