My experience on my daily works... helping others ease each other

Wednesday, November 25, 2015

Comparative report on Security Scanning Tool by NSS Labs

NSS Lab analysed few security scanning tools:

  1. Blue Coat Security Analytics
  2. Check Point 13500
  3. Cisco Advance Malware Protection
  4. Fidelis XPS Direct and XPS Internal
  5. FireEye EX-3400 and NX-4400
  6. Fortinet FortiSandbox-1000D
  7. Lastline Breach Detection
  8. Trend Micro Deep Discovery Inspector


The report measure the effectiveness in detection and reliability of the detection.

You may download it from here


Share:

Thursday, November 19, 2015

List of Conference - as of Nov 2015

New
Tenth international conference New Information Technologies in Education for All 
26th November 2015 
Kyiv, Ukraine
9th EAI International Conference on Bio-inspired Information and Communications Technologies (formerly BIONETICS) 
3rd December 2015 
New York, United States of America
3rd Conference of International Society for Wearable Technology in Healthcare (WATCH) 
5th December 2015 
Dubai, United Arab Emirates
The Third International Conference on Green Computing, Technology and Innovation (ICGCTI2015) 
8th December 2015 
Serdang, Malaysia
6th International Conference on e-Democracy: Citizen rights in the world of the new computing paradigms 
10th December 2015 
Athens, Greece
Leveraging Molecular LIMS to Deliver Precision Medicine 
11th December 2015 
Worldwide, United States of America
4th International Conference on Communications, Signal Processing Computing and Information Technologies (ICCSPCIT-15) December 18-19, 2015 
18th December 2015 
HYDERABAD, India
Kuala Lumpur 4th International Conference on “Engineering & Technology, Computer , Basic & Applied Sciences” ( ECBA- 2016 ) January 1-2, 2016 Kuala Lumpur, Malaysia 
1st January 2016 
Kuala Lumpur, Malaysia
Bali 4th International Conference on “Engineering & Technology, Computer , Basic & Applied Sciences” ( ECBA- 2016) January 7-8, 2016 Bali, Indonesia 
7th January 2016 
Bali, Indonesia
Bali 2nd International Conference on “ Business, Economics, Social Science & Humanities- BESSH-2016” January 7-8, 2016 Bali, Indonesia 
7th January 2016 
Bali, Indonesia
Istanbul 3rd International Conference on “ Business, Economics, Social Science & Humanities- BESSH-2016” January 12-13, 2016 Istanbul, Turkey 
12th January 2016 
Istanbul, Turkey
Bangkok 5th International Conference on “Engineering & Technology, Computer , Basic & Applied Sciences” ( ECBA- 2016 ) January 14-15, 2016 Bangkok, Thailand 
14th January 2016 
Bangkok, Thailand
Bangkok 6th International Conference on “Engineering & Technology, Computer , Basic & Applied Sciences” ( ECBA- 2016 ) January 19-20, 2016 Bangkok, Thailand 
19th January 2016 
Bangkok, Thailand
4th Istanbul International Conference on “Engineering & Technology, Computer , Basic & Applied Sciences” ( ECBA- 2016 ) January 20-21, 2016 Istanbul, Turkey 
20th January 2016 
Istanbul, Turkey
Bali International Conference on “Engineering & Technology, Computer , Basic & Applied Sciences” ( ECBA- 2016) January 21-22, 2016 Bali, Indonesia 
21st January 2016 
Bali, Indonesia
International Conference on Information & Engineering Sciences - 2016 
22nd January 2016 
Vijayawada, India
Beijing 2nd International Conference on “ Business, Economics, Social Science & Humanities- BESSH-2016” January 22-23, 2016 Beijing,China 
22nd January 2016 
Beijing, China
International Conference on Trends in Information, Management, Engineering and Science 
22nd January 2016 
Hyderabad, India
Beijing 4th International Conference on “Engineering & Technology, Computer , Basic & Applied Sciences” ( ECBA- 2016 ) January 22-23, 2016 Beijing,China 
22nd January 2016 
Beijing, China
Dubai 4th International Conference on “Engineering & Technology, Computer , Basic & Applied Sciences” ( ECBA- 2016 ) January 22-23, 2016 Dubai,UAE 
22nd January 2016 
Dubai, United Arab Emirates
Singapore 5th International Conference on “Engineering & Technology, Computer , Basic & Applied Sciences” ( ECBA- 2016 ) January 25-26, 2016 Singapore 
25th January 2016 
Singapore, Singapore
Shanghai 2nd International Conference on “ Business, Economics, Social Science & Humanities- BESSH-2016” January 26-27, 2016 Shanghai,China 
26th January 2016 
Shanghai, China
Istanbul 5th International Conference on “Engineering & Technology, Computer , Basic & Applied Sciences” ( ECBA- 2016 ) January 26-27, 2016 Istanbul, Turkey 
26th January 2016 
Istanbul, Turkey
Istanbul 5th International Conference on “ Business, Economics, Social Science & Humanities- BESSH-2016” January 26-27, 2016 Istanbul, Turkey 
26th January 2016 
Istanbul, Turkey
Jakarta 5th International Conference on “Engineering & Technology, Computer , Basic & Applied Sciences” ( ECBA- 2016 ) January 28-29, 2016 Jakarta, Indonesia 
28th January 2016 
Jakarta, Indonesia
Global Conference on Business Management and Social Sciences (GCBMS-2016) 
28th January 2016 
Dubai, United Arab Emirates
Colombo 1st International Conference on “Engineering & Technology, Computer , Basic & Applied Sciences” ( ECBA- 2016 ) January 30-31, 2016 Colombo, SriLanka 
30th January 2016 
Colombo, Sri Lanka
4th International Conference on Electrical, Computer, Mechanical and Mechatronics Engineering (ICE2016) 
4th February 2016 
Dubai, United Arab Emirates
Dubai 5th International Conference on “ Business, Economics, Social Science & Humanities- BESSH-2016” February 5-6, 2016 Dubai,UAE 
5th February 2016 
Dubai, United Arab Emirates
Taipei 1st International Conference on “ Business, Economics, Social Science & Humanities- BESSH-2016” February 6-7, 2016 , Taipei, Taiwan 
6th February 2016 
Taipei, Taiwan
Istanbul 7th International Conference on “ Business, Economics, Social Science & Humanities- BESSH-2016” February 9-10, 2016 Istanbul, Turkey 
9th February 2016 
Istanbul, Turkey
Fourth International Conference on Innovative Trends in Science, Engineering and Management 2016 (ICITSEM 2016) 
17th February 2016 
Dubai, United Arab Emirates
Anna University-PSGIM-ARC Multidisciplinary International Academic Research Conference (MIARC - 2016) 
18th February 2016 
Coimbatore, India
NATIONAL CONFERENCE on Expansions Beyond Horizon: Era of E-Business and E- Commerce 
19th February 2016 
Pune, India
Seoul 2nd International Conference on “ Business, Economics, Social Science & Humanities- BESSH-2016” February 26-27, 2016 Seoul, South Korea 
26th February 2016 
Seoul, Korea (south)
Manila 1st International Conference on “ Business, Economics, Social Science & Humanities- BESSH-2016” February 26-27, 2016 Manila, Philippines 
26th February 2016 
Manila, Philippines
Scopous&Ei Compendex - 2016 International Conference on Mechanical Automation and Control Engineering--ICMACE 2016 
27th February 2016 
Phuket, Thailand
EI&SCOPUS - 2016 International Conference on Material Engineering and Smart Materials (ICMESM 2016) 
27th February 2016 
Singapore, Singapore
Startup Conclave 2016 
29th February 2016 
Coimbatore, India
Innoxcell APAC Legal and Regulatory Compliance Symposium - Sydney 
3rd March 2016 
Sydney, Australia
International Conference on Mathematics, Physics & Allied Sciences - 2016 
3rd March 2016 
Goa, India
Defence Logistics Eastern Europe 
7th March 2016 
Prague, Czech Republic
Ei Compendex & Scopus--2016 International Conference on Composite Materials and Material Engineering (ICCMME2016) 
9th March 2016 
Bangkok, Thailand
Third International Conference on Engineering, Science, Business and Management 2016 (ICESBM 2016) 
9th March 2016 
Dubai, United Arab Emirates
2016 1st Journal Conference on Machine Learning and Computing (JCMLC 2016 1st) 
12th March 2016 
Hong Kong, China
2016 IEEE International Conference on Big Data Analysis (ICBDA 2016) - Ei Compendex 
12th March 2016 
Hangzhou, China
Oil and Gas Telecommunications 
14th March 2016 
London, United Kingdom
Sydney International Business Research Conference (SIBSRC) 2016 
19th March 2016 
Sydney, Australia
2016 1st Journal Conference on Innovation, Management and Technology (JCIMT 2016 1st) 
20th March 2016 
Amsterdam, Netherlands
ICGEA 2016 International Conference on Green Energy and Applications - Ei Compendex & Scopus 
23rd March 2016 
Singapore, Singapore
2016 Annual International Conference on Innovative Technologies and Advanced Computing (ICIAC-16) March 24-25, 2016 London (UK). 
24th March 2016 
London, United Kingdom
2016 International Conference on Image Processing, Production and Computer Science (ICIPCS'2016) March 26-27, 2016 London-UK 
26th March 2016 
London, United Kingdom
15th Annual Security Conference 
29th March 2016 
Las Vegas, United States of America
International Conference on Innovative Advancements in Engineering & Technology (IAET-2016) 
1st April 2016 
Jaipur, India
IEEE 2016 International Conference on Control and Robotics Engineering (ICCRE 2016)--Ei 
2nd April 2016 
Singapore, Singapore
2016 3rd International Conference on Mechatronics, Electronics and Automation Engineering (ICMEAE 2016)--Ei Compendex & Scopus 
2nd April 2016 
Singapore, Singapore
Fourth International Conference on Science, Technology, Engineering and Management 2016 (ICSTEM 2016) 
3rd April 2016 
Dubai, United Arab Emirates
Fifth International Conference on Modern Trends in Science, Engineering and Technology 2016 (ICMTSET 2016) 
3rd April 2016 
Dubai, United Arab Emirates
(Ei Compendex,Scopus)-2016 4th International Conference on Nano and Materials Engineering (ICNME 2016) 
7th April 2016 
Bali, Indonesia
ICMEA 2016 - International Conference on Mechatronics Engineering and Automation (Ei Compendex, Scopus) 
7th April 2016 
Dubai, United Arab Emirates
ICNSAM 2016 International Conference on Natural Science and Applied Mathematics - Scopus 
7th April 2016 
Dubai, United Arab Emirates
ICEMP 2016-International Conference on Engineering Mathematics and Physics (Scopus) 
7th April 2016 
Dubai, United Arab Emirates
Ei Compendex&Scopus - 2016 The 4th International Conference on Electronics Engineering and Technology (ICEET 2016) 
7th April 2016 
Bali, Indonesia
2016 2nd International Conference on Sensors and Mechanical Automation (ICSMA 2016) - Scopus&Ei Compendex 
7th April 2016 
Bali, Indonesia
The 2016 3rd International Conference on Coastal and Ocean Engineering (ICCOE 2016) 
8th April 2016 
Tokyo, Japan
2016 1st Journal Conference on Chemical Engineering and Applications (JCCEA 2016 1st) 
8th April 2016 
Tokyo, Japan
2016 2nd International Conference on Automatic Control (ICOAC 2016) - SCOPUS, Ei Compendex 
11th April 2016 
Istanbul, Turkey
2016 3rd International Conference on Electrical and Electronics Engineering (ICEEE 2016) - SCOPUS, Ei Compendex 
Share:

Wednesday, November 11, 2015

Known Limitation of MySQL Cluster NDB 7.3 and MySQL Cluster NDB 7.4

It is known limitations in current releases of MySQL Cluster as compared with the features available when using the MyISAM and InnoDB storage engines. MySQL will throw errors or failed to convert does DB into supported cluster DB in MySQL (Known as NDB).

Here are the list of basic rules:

1. Do not use temporary table.

2. Do not used key (primary or foreign) that exceed 3072 bytes width (length); equivalent to 3072 characters or 3KB data

3. Do not use TEXT or BLOB as key or unique identifier or index

4. Avoid indexing FULLTEXT (such as name, address, etc)

5. Avoid using HASH column/data as key or index

6. Ensure the Auto_Increment column is also a key.

7. Ensure the foreign key is referred to a table primary or unique key.

8. Do not implement spatial indexes.

9. Used only Latin-1 character for logging

10. Avoid using READ UNCOMMITTED, REPEATABLE READ, and SERIALIZABLE. NDB only support READ COMMITTED.

11. Avoid having BLOB and TEXT as part of table column. If need to have either those two types:
  • Avoid having multiple query on same table at the same time.
  • Avoid table scan and query the entire table including the TEXT/BLOB field.
  • Avoid query the entire table using primary or unique key
  • Avoid query and extracting the TEXT/BLOB field

12. Database and table name shall not more than 63 characters.

13. Number of database, table and index in a single cluster shall not more than 20320.

14. Number of column (attributes), key and index in a single table shall not be more than 512.

15. The maximum number of row size shall not exceed 14000 bytes (14Kb).

16. Avoid using PREFIXs


Disk Data object maximums and minimums. Disk data objects are subject to the following maximums and minimums:
  1. Maximum number of tablespaces: 232 (4294967296)
  2. Maximum number of data files per tablespace: 216 (65536)
  3. Maximum data file size: The theoretical limit is 64G; however, the practical upper limit is 32G. This is equivalent to 32768 extents of 1M each.
  4. Since a MySQL Cluster Disk Data table can use at most 1 tablespace, this means that the theoretical upper limit to the amount of data (in bytes) that can be stored on disk by a single NDB table is 32G * 65536 = 2251799813685248, or approximately 2 petabytes.
  5. The theoretical maximum number of extents per tablespace data file is 216 (65536); however, for practical purposes, the recommended maximum number of extents per data file is 215 (32768).
  6. The minimum and maximum possible sizes of extents for tablespace data files are 32K and 2G, respectively. 

Sources:
  1. http://dev.mysql.com/doc/refman/5.6/en/mysql-cluster.html
  2. http://dev.mysql.com/doc/refman/5.6/en/ha-overview.html
  3. https://blogs.oracle.com/jsmyth/entry/connection_failures_between_nodes_in
  4. https://www.mysql.com/why-mysql/presentations/mysql-cluster-deployment-best-practices/
  5. http://cdn.oreillystatic.com/en/assets/1/event/36/MySQL%20Cluster%20-%20Deployment%20Best%20Practices%20Presentation.pdf
  6. http://www.clusterdb.com/tag/performance
  7. http://dba.stackexchange.com/questions/72585/problem-with-mysql-cluster-in-practice
Share:

Wednesday, November 4, 2015

MyISAM vs InnoDb - Full-text search versus Fail-safe capability

I in the midst of developing an applications for my wife to ease her daily life as lecturer and suddenly this versus thing trigger me :).


After some digging of information, I switches from InnoDb to MyISAM because I need to Full-text queries highly then insert/update process.

My conclusion:
1. Used MyISAM when your system is highly utilize for viewing and querying.
2. Used InnoDb when your system highly processing insert/update such as logging data or inserting raw data like track-and-trace system.
3. Used MyISAM if your application has the capability to roll-back or hold the data.
4. Used MyISAM if your data will grow beyond 1TB as at this point of time, query will cause problem for InnoDB.

References:
  1. http://www.thegeekstuff.com/2014/02/myisam-innodb-memory/
  2. http://dev.mysql.com/doc/refman/5.0/en/myisam-storage-engine.html
  3. http://dev.mysql.com/doc/refman/5.0/en/innodb-storage-engine.html
  4. http://tag1consulting.com/MySQL_Engines_MyISAM_vs_InnoDB#comment-115
  5. https://www.percona.com/blog/2007/01/08/innodb-vs-myisam-vs-falcon-benchmarks-part-1/
  6. http://www.rackspace.com/knowledge_center/article/mysql-engines-myisam-vs-innodb
  7. http://dba.stackexchange.com/questions/1/what-are-the-main-differences-between-innodb-and-myisam
  8. http://dba.stackexchange.com/questions/1/what-are-the-main-differences-between-innodb-and-myisam
  9. https://www.quora.com/How-are-deadlocks-resolved-in-Innodb-vs-MyISAM




Share:

About Me

Somewhere, Selangor, Malaysia
An IT by profession, a beginner in photography

Blog Archive

Blogger templates