I have a highly normalized & indexed innodb database (search managed with an external sphinx server) that I am considering moving to NDB to handle a possible soon-coming mega-influx in traffic.
我有一个高度规范化和索引的innodb数据库(使用外部sphinx服务器进行搜索),我正在考虑转移到NDB来处理可能即将到来的巨型流量。
To the best of my research and understanding, this isn't an overly difficult maneuver as I have no fulltext fields (varchar(256) at worst) and searching is handled externally anyways.
据我所知,这不是一个过于困难的策略,因为我没有全文字段(最坏的是varchar(256)),无论如何都要在外部处理搜索。
I do realize that my join queries will degrade quite a bit, however i'm dealing with that by caching most queries with memcached (also external).
我确实意识到我的连接查询会降级很多,但是我通过使用memcached(也是外部)缓存大多数查询来处理它。
Is there anything else I should be aware of when considering this migration? The get-up-and-go document provided at http://www.mysql.com/products/cluster/get-started.html#quickstart make the setup for linux seem pretty easy, although I'm not 100% on the best way to do backups and adding new nodes yet (assuming that I'll just do EBS snapshots via AWS, the system is running on EC2 Currently).
在考虑这种迁移时,还有什么我应该注意的吗?在http://www.mysql.com/products/cluster/get-started.html#quickstart上提供的“get-up-and-go”文档使得linux的设置看起来非常简单,尽管我不是100%的尚未进行备份和添加新节点的最佳方式(假设我只是通过AWS执行EBS快照,系统目前正在EC2上运行)。
Any wisdom from the gods of ndb?
来自ndb之神的任何智慧?
1 个解决方案
#1
2
would be worth checking out the functional differences between MySQL Cluster (NDB) and InnoDB, see the docs here: http://dev.mysql.com/doc/refman/5.5/en/mysql-cluster-compared.html
值得查看MySQL Cluster(NDB)和InnoDB之间的功能差异,请参阅此处的文档:http://dev.mysql.com/doc/refman/5.5/en/mysql-cluster-compared.html
Also, the deployment best practices webinar includes a section on migrating from innodb to Cluster (note: registration required): http://mysql.com/news-and-events/on-demand-webinars/display-od-559.html
此外,部署最佳实践网络研讨会还包括从innodb迁移到Cluster的部分(注意:需要注册):http://mysql.com/news-and-events/on-demand-webinars/display-od-559.html
Any questions, please post to the cluster forum forums.mysql.com/list.php?25
有任何问题,请发布到集群论坛forums.mysql.com/list.php?25
#1
2
would be worth checking out the functional differences between MySQL Cluster (NDB) and InnoDB, see the docs here: http://dev.mysql.com/doc/refman/5.5/en/mysql-cluster-compared.html
值得查看MySQL Cluster(NDB)和InnoDB之间的功能差异,请参阅此处的文档:http://dev.mysql.com/doc/refman/5.5/en/mysql-cluster-compared.html
Also, the deployment best practices webinar includes a section on migrating from innodb to Cluster (note: registration required): http://mysql.com/news-and-events/on-demand-webinars/display-od-559.html
此外,部署最佳实践网络研讨会还包括从innodb迁移到Cluster的部分(注意:需要注册):http://mysql.com/news-and-events/on-demand-webinars/display-od-559.html
Any questions, please post to the cluster forum forums.mysql.com/list.php?25
有任何问题,请发布到集群论坛forums.mysql.com/list.php?25