Today I read a nice article , which give a new design for mysql database . In this article , Author (Mr.lou) uses OneSQL (a branch of MySQL) for the whole test.
you can read from : http://www.onexsoft.com/?page_id=378
This article explain how to use mysql in seckilling scenario (especially f[……]
Read more
Recently, we create a mysql data warehouse which is based on message queue.
Most companies must prepare for particular queries in their systems if they consider to split their databases or tables into many pieces.
some problems should be solved in this situation:
1. how to get correct re[……]
Read more
In this post ,we mainly talk about MHA GTID behavior, we test different cases and find something is different from previous versions .
we have four machines for this test.
environment:
master server: 10.0.128.77
slave server : 10.0.128.110/113/114
port : 3306
———————–[……]
Read more
Copy table between different hbase clusters – Version 0.96.2-hadoop2
Create test table and initial some records.
$hbase shell
2014-12-19 15:01:36,085 INFO [main] Configuration.deprecation: hadoop.native.lib is deprecated. Instead, use io.native.lib.available
HBase Shell; enter 'help<[......]Read more
upload on 2014.12
important tips of MySQL database design for better performance
Read : mysql-system-opt[……]
Read more
Introducing MQ system based on MySQL (canal + roma)
Using this system to subscribe message between different platforms.
View this PDF roma_system
Also download this PDF from slideshare[……]
Read more
myawr-v3 release now !
history of myawr:
————————–
v1: create by noodba
mysql load information and system information
v2: create by louis liu
myawr_v2 add :
1 more os information module.
2 multiple instance support (extend table by db_port)
3 modified[......]Read more
Webm_v2 was add oracle and mongodb monitor module
webm was agent uploaded mode to save statistics
we use mysql database as monitor server
we already design tables to store these data (consider for future analysis)
you can download from github : https://github.com/ylouis83/webm[……]
Read more
You can download webm from github: https://github.com/ylouis83/webm
webm: mysql web key performance monitor
webm is a tool that display key value graph on website and webm was developed by javascript and mysqlmon ( mysql data collection tool wrote by AnySQL)
Environment need:
Linux vers[……]
Read more
戴尔近日推出了旗下的13G服务器,其主力机型为R730xd,包含了诸多的特性,为其成为主流db server以及规模存储集群打下了良好的基础。
具体参考:http://www.storagereview.com/dell_poweredge_13g_r730xd_review
http://www.storagereview.com/dell_poweredge_gen13_servers_released
https://www.youtube.com/watch?v=YSGzB7umHa0
具体增强为:
1.CPU 为intel haswall最新架构,减少了功能[……]
Read more