oracle - mysql比较 [英] oracle - mysql comparison
问题描述
嘿所有，
我意识到这个问题可能会不时出现，但是我没有看到它b / b
事情可能会改变，所以 -
现在（2004年7月）与oracle相比，mysql如何站起来？
我们正在认真考虑迁移我们的多-processor oracle
系统到mysql节省许可费用，并且需要几个mysql可能有或没有的b $ b功能：
- 复制
- 归档日志记录
- 与oracle的oracle /数据库链接的互操作性
- PL / SQL类型语言/存储过程
- 角色
- oracle迁移脚本/转换
- 嵌入式java API
- 分区/表空间赋值
- 导入/导出工具
- 等效的oracle数据类型
- 多处理器支持
- 性能（相对等效）或者更好）
另外，hav任何oracle DBA都经过了mysql和oracle之间的转换过程吗？如果是这样，你经历了什么？b
陷阱/捕获？你喜欢或感觉缺少什么功能？
？我提前道歉
这个交叉的帖子，但我确实希望获得尽可能广泛的意见，因为
可能..
非常感谢，
jon
hey all,
I realize that this question might pop up from time to time, but I
haven''t seen it a while and things might of changed, so -
Right now (July 2004) how does mysql stand up in comparison to oracle?
We are seriously considering migrating our multi-processor oracle
system to mysql to save on licensing costs, and would need several
features that mysql may or may not have:
- replication
- archive logging
- interoperability with oracle/database links with oracle
- PL/SQL type language/stored procedures
- roles
- oracle migration scripts/conversion
- embedded java API
- partitioning/tablespace assignment
- import/export tools
- equivalent oracle datatypes
- multi-processor support
- performance (relatively equivalent or better)
In addition, have any oracle DBAs out there gone through the
conversion process between mysql and oracle? If so, what were the
gotchas/catches that you went through? What are features that are
there that you like or feel are missing? I apologize in advance for
the cross-post, but I did want to get as wide a range of opinion as
possible..
Thanks much,
jon
推荐答案
jonathan写道：
jonathan wrote:
嘿所有，
我意识到这个问题可能会不时出现，但是我没有看到它一段时间，事情可能会改变，所以 -
现在（2004年7月）与oracle相比，mysql如何站起来？
我们正在认真考虑将我们的多处理器oracle系统迁移到mysql以节省许可成本，并且需要mysql可能有或没有的几个功能：
- 复制
- 归档日志 - 与Oracle的oracle /数据库链接的互操作性
- PL / SQL类型语言/存储过程
- 角色
- oracle迁移脚本/转换
- 嵌入式java API
- 分区/表空间分配
- 导入/导出工具
- 等效的oracle数据类型
- 多处理器支持
- 性能（相对等效或更好）
<另外，有任何oracle DBA在那里经历了mysql和oracle之间的转换过程吗？如果是这样，你经历了什么/陷阱？那些你喜欢或感觉缺失的功能是什么？我提前为交叉帖道歉，但我确实希望获得尽可能广泛的意见..
非常感谢，
jon
hey all,
I realize that this question might pop up from time to time, but I
haven''t seen it a while and things might of changed, so -
Right now (July 2004) how does mysql stand up in comparison to oracle?
We are seriously considering migrating our multi-processor oracle
system to mysql to save on licensing costs, and would need several
features that mysql may or may not have:
- replication
- archive logging
- interoperability with oracle/database links with oracle
- PL/SQL type language/stored procedures
- roles
- oracle migration scripts/conversion
- embedded java API
- partitioning/tablespace assignment
- import/export tools
- equivalent oracle datatypes
- multi-processor support
- performance (relatively equivalent or better)
In addition, have any oracle DBAs out there gone through the
conversion process between mysql and oracle? If so, what were the
gotchas/catches that you went through? What are features that are
there that you like or feel are missing? I apologize in advance for
the cross-post, but I did want to get as wide a range of opinion as
possible..
Thanks much,
jon
没有比较，你错过了最重要的问题，除非你正在运行一个热狗站，否则你应该关注
。
1.如果有问题，我们在哪里寻求支持我们无法解决？
2.我们如何恢复发生的交易最后一次备份之间
和系统失败的时间？
3.我们可以从对象和/或文件损坏中恢复吗？
非常简单......向管理层询问公司的成本是多少？系统不可用的每小时
。然后将其与
小于
No comparison and you have missed the most important questions you
should be concerned about unless you are running a hotdog stand.
1. Where to we call for support if there is a problem we can''t solve?
2. How do we recover transactions that occur between the last backup
and the time when the system fails?
3. Can we recover from object and/or file corruption?
Very simply ... ask your management what the cost is to the company
for every hour the system is unavailable. Then compare that to the
less than
800的Oracle SE1许可费用进行比较。
但如果你真的需要然后，分区等EE功能与Oracle保持一致。你不会在其他任何地方找到它。
Daniel Morgan
800 cost for licensing Oracle SE1.
But if you truly need EE capabilities such as partitioning then stick
with Oracle. You won''t find it anywhere else.
Daniel Morgan
试试谷歌搜索mysql比较oracle或类似的。
显然oracle有财力投入增强功能
，mysql不是，但令人惊讶的是看到mysql有多远已经在过去的几个版本中进化了
。
Try a google search "mysql comparison oracle" or similar.
Obviously oracle has financial resources to devote to enhancements
that mysql doesn''t but it''s amazing to see how far along mysql has
evolved over the last several versions.
这篇关于oracle - mysql比较的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！
