Mysql Scalability(2)Sharding - Thoughts
1. Amoeba
Build Codes and Installation
>svn checkout http://amoeba.googlecode.com/svn/trunk amoeba-svn
Install ant on MAC to build that.
>ant -version
Apache Ant(TM) version 1.9.4 compiled on April 29 2014
Just build it ,we will get the binary file amoeba-mysql-binary-2.2.0.tar.gz
>mkdir amoeba-mysql-binary-2.2.0
>cd amoeba-mysql-binary-2.2.0/
>tar zxvf amoeba-mysql-binary-2.2.0.tar.gz
Move to working directory
>mv amoeba-mysql-binary-2.2.0 /Users/carl/tool/amoeba-mysql-2.2.0
>sudo ln -s /Users/carl/tool/amoeba-mysql-2.2.0 /opt/amoeba-mysql-2.2.0
>sudo ln -s /opt/amoeba-mysql-2.2.0 /opt/amoeba-mysql
Add to Path /opt/amoeba-mysql
Verify the Installation is done.
>amoeba
amoeba start|stop
Configuration Basic
databases connections
conf/dbServers.xml
sharding rule
conf/rule.xml
access IP list
conf/access_list.conf
One DB node
Seems that I only can get the 2.2.0 version of the source codes, and the 2.2.0 binary is having class load problem on jdk1.6. And I do not plan to use 3.0.5 without source codes.
2. vitess
No enough document and source codes to understand that.
3. Atlas
https://github.com/Qihoo360/Atlas
Based on Mysql-Proxy, but do not support multiple DB rules, only support multiple tables.
4. Cobar
Nice code and nice document, but open source part does not support separate reads and writes.
Tips
Show the Slow Query
>sudo vi /etc/mysql/my.cnf
log_slow_queries = /var/log/mysql/mysql-slow.log long_query_time = 5 #log-queries-not-using-indexes
But when I start this mysql server I got error as follow
>sudo mysqld --verbose
2014-07-24 15:59:25 3340 [ERROR] mysqld: unknown variable 'log_slow_queries=/var/log/mysql/mysql-slow.log' 2014-07-24 15:59:25 3340 [ERROR] Aborting
Solution:
This is the right configuration for mysql 5.6
slow-query-log-file = /var/log/mysql/mysql-slow.log long_query_time = 5 #log-queries-not-using-indexes
Change the user and group
>sudo chown mysql:mysql pathname
References:
http://sillycat.iteye.com/blog/2094908 Master-Slave
http://docs.hexnova.com/amoeba/index.html
https://code.google.com/p/amoeba/source/checkout
https://www.centos.bz/2012/05/amoeba-for-mysql/
http://www.aslibra.com/blog/post/amoeba_mysql_proxy_rw_split.php
http://www.cnblogs.com/taven/archive/2012/09/11/2680282.html
http://boke.25k5.com/kan16489.html
https://github.com/vispractice/Amoeba-Plus-For-MySQL
vitess
https://github.com/youtube/vitess
https://code.google.com/p/vitess/
show slow SQL
https://www.centos.bz/2012/01/active-mysql-slow-log-mysqldumpslow/
- 浏览: 2491998 次
- 性别:
- 来自: 成都
最新评论
-
nation:
你好,在部署Mesos+Spark的运行环境时,出现一个现象, ...
Spark(4)Deal with Mesos -
sillycat:
AMAZON Relatedhttps://www.godad ...
AMAZON API Gateway(2)Client Side SSL with NGINX -
sillycat:
sudo usermod -aG docker ec2-use ...
Docker and VirtualBox(1)Set up Shared Disk for Virtual Box -
sillycat:
Every Half an Hour30 * * * * /u ...
Build Home NAS(3)Data Redundancy -
sillycat:
3 List the Cron Job I Have>c ...
Build Home NAS(3)Data Redundancy
相关推荐
Designing for Scalability with Erlang-OTP.pdf Designing for Scalability with Erlang-OTP.pdf Designing for Scalability with Erlang-OTP.pdf
Bit-Rate-Scalability-in-Audio-Coding.rar etd
What You’ll Learn Architect and develop applications so that they are easy to scale. ... Effectively balance scalability, performance, responsiveness, and availability while minimizing downtime.
MPEG FGS分级编码的 好文章,是MPEG-4采用的一种很好的质量可分级方式
学习java性能调优的好书,国外专家写的,很不错
市面上有很多关于软件设计及软件架构的书和资料,也有不少domain specific的。但是对于Carrier-Grade方面的专著基本上没有。本书关注如何设计高性能,高可靠性,高可用性的,高伸缩性的电信级系统。...
MySQL 8 Administrator's Guide pdf ...MySQL 8 - Scalability & High Availability MySQL 8 - Security Optimizing MySQL 8 Extending MySQL 8 MySQL 8 Best Practices & Benchmarking Troubleshooting MySQL 8
使用 Erlang/OTP 设计可扩展性 - 练习 在这个存储库中,我将阅读 Francesco Cesarini 和 Steve Vinoski 所著的“Designing for scaling with Erlang and Otp”一书时编写的代码组合在一起,你可以在购买这本书。...
该项目收集了作为OSG可伸缩性,可靠性和可用性领域的一部分而开发的软件。
MySQL + .NET Framework 4.5.2 安装包 ...MySQL Cluster enables users to meet the database challenges of next generation web, cloud, and communications services with uncompromising scalability, uptime...
Auto-sharding for write-scalability; SQL and NoSQL interfaces; Real-time responsiveness; Active / active geographic replication; Online scaling and schema upgrades; 99.999% availability. This Guide ...
The Art of Scalability is by far the best book on scalability on the market today.
2. Installing and Upgrading MySQL 2.1. General Installation Guidance 2.1.1. Operating Systems Supported by MySQL Community Server 2.1.2. Choosing Which MySQL Distribution to Install 2.1.3. How to Get ...
px2scalability-loader A loader for Install npm install px2scalability-loader webpack-config module.exports = { // ... module: { rules: [ { test: /\.(scss|sass)$/, use: ExtractTextWebpackPlugin....
java餐厅智能推荐系统源码 一个更新的、有组织的阅读清单,用于说明可扩展、可靠和高性能的大型系统的模式。 著名工程师的文章和可靠的参考文献中对概念进行了解释。 案例研究取自为数百万到数十亿用户提供服务的...
注意是Programming Scala的第二版,而不是Programming in Scala的第二版,更注重于与Spark相关的知识!强烈推荐!Programming Scala- Scalability = Functional Programming + Objects, 2 edition
AKKA指南 Simpler Scalability, Fault-Tolerance, Concurrency & Remoting through Actors
I have coded an entire chat application using the Spring Framework, WebSocket, Cassandra, Redis, RabbitMQ, and MySQL, and I discuss how you can horizontally scale this application implementing a ...
Achieving the Impossible: Unlimited Application Scalability -- Oracle Whitepaper
Learn how to design scalable, robust software for cutting-edge communications products?...Robust Communications Software: Extreme Availability, Reliability and Scalability for Carrier-Grade Systems