network profile
| bio | website | arafath.com |
|---|---|---|
| location | Singapore, Singapore | |
| age | 28 | |
| visits | member for | 2 years, 5 months |
| seen | May 8 at 8:55 | |
| stats | profile views | 3 |
|
Apr 10 |
awarded | Supporter |
|
Feb 10 |
awarded | Citizen Patrol |
|
Dec 31 |
comment |
Mysql ndb cluster - node restart Ya, SAS is faster than the SSD. 2 SAS RAID0 gives me two times faster than single SAS. I just tested with 350 tables and 20,000 records in total. I get 4 minutes node startup time. Man! where is 4 hours and 4 Minutes? Now I'm gonna proceed with atleast 8 GB of data. Let me see what happens. |
|
Dec 31 |
comment |
Mysql ndb cluster - node restart I think I should also do a test with SSD to compare with SAS. |
|
Dec 31 |
comment |
Mysql ndb cluster - node restart And, I did an interesting test. I just created 2 databases and created 20,000 tables with no data! no indexing! It took 4 hours for my nodes to be ready. So I believe node startup time also affected by the number of tables. I will post my second result, which I'm testing now. Second test is with few tables with huge data in it. Please stay in touch... |
|
Dec 31 |
comment |
Mysql ndb cluster - node restart We are now looking into combine all the clients table sets into one, since, NDB is really good at handling huge data per table. As for the HDD I/O speed, Im using SAS 6Gbps. Is that good enough or still I need to go for RAID 0 with two or more HDD? |
|
Dec 31 |
comment |
Mysql ndb cluster - node restart Thanks Matthew, for the reply. Right now, our database is Normalized to the maximum. One of a techy from oracle also suggested the same as you did. Denormalize!. |
|
Dec 30 |
comment |
Mysql ndb cluster - node restart I can't paste my whole config file here. Please follow this link for the config.ini arafath.com/config.txt |
|
Dec 30 |
awarded | Editor |
|
Dec 30 |
revised |
Mysql ndb cluster - node restart deleted 10 characters in body |
|
Dec 30 |
asked | Mysql ndb cluster - node restart |
|
Dec 30 |
awarded | Scholar |
|
Dec 30 |
accepted | BixData or Zabbix? |
|
Dec 30 |
comment |
BixData or Zabbix? I agree with this! |
|
Dec 30 |
comment |
BixData or Zabbix? I tried zabbix. It's very comprehensive. It satisfy my needs. And I prefer compiling from source. Cos, debian lenny repository doesn't t have the latest stable version of zabbix. |
|
Dec 25 |
awarded | Student |
|
Dec 22 |
comment |
BixData or Zabbix? I can see a lot of people recommend Zenoss.. I think I should try Zenoss too. I just tried Zabbix, seems like too many customization options... Thanks for the recommendation... |
|
Dec 22 |
asked | BixData or Zabbix? |
