1.drop configuration files and repository run :
emca -deconfig dbcontrol db -repos drop
2.Create configuration files and repository run
emca -config dbcontrol db -repos create
创建EM后会提示的端口号,应为实例的端口号,比如1521,不是EM的端口号(比如1158)
EM的端口号在这个文件中可以查到10.2.0\db_1\sysman\config\emca.properties
一个诡异的需求, 拿来的iso都是大写文件, 需要弄成小写的
先 zip起来, 然后unzip的时候 -L就使用了小写解压, 幸好没有去写什么垃圾shell, 否则又浪费时间, 总算第一步过关, 看到自符安装界面了.
MYSQL High Availability 高可用解决方案对比. http://dev.mysql.com/doc/refman/5.1/en/ha-overview.html
|
Requirements |
MySQL Replication |
MySQL Replication + Heartbeat |
MySQL Heartbeat + DRBD |
MySQL Cluster |
|
Availability |
|
|
|
|
|
Automated IP failover |
No |
Yes |
Yes |
No |
|
Automated database failover |
No |
No |
Yes |
Yes |
|
Typical failover time |
User/script-dependent |
Varies |
< 30 seconds |
< 3 seconds |
|
Automatic resynchronization of data |
No |
No |
Yes |
Yes |
|
Geographic redundancy support |
Yes |
Yes |
Yes, when combined with MySQL Replication |
Yes, when combined with MySQL Replication |
|
Scalability |
|
|
|
|
|
Built-in load balancing |
No |
No |
No |
Yes |
|
Supports Read-intensive applications |
Yes |
Yes |
Yes, when combined with MySQL Replication |
Yes |
|
Supports Write-intensive applications |
No |
No |
Yes |
Yes |
|
Maximum number of nodes per group |
One master, multiple slaves |
One master, multiple slaves |
One active (primary), one passive (secondary) node |
255 |
|
Maximum number of slaves |
Unlimited (reads only) |
Unlimited (reads only) |
One (failover only) |
Unlimited (reads only) |