MySQL Casual Talks vol.5 - MySQL Labs - @RKajiyama
-
Upload
ryusuke-kajiyama -
Category
Technology
-
view
4.260 -
download
0
description
Transcript of MySQL Casual Talks vol.5 - MySQL Labs - @RKajiyama
@RKajiyama
殿堂入りしてない方のアレ、Labs ~Multi-Source Replication を添えて~
@RKajiyama
labs.mysql.com
Please, DO NOT USE THESE BINARIES IN PRODUCTION.
Hadoop Applier for MySQL
MySQL JSON UDFs
MySQL Multi-source Replication
MySQL Utilities - Fabric
Hadoop Applier for MySQL
MySQL JSON UDFs
MySQL Multi-source Replication
MySQL Utilities - Fabric
INSERT only!!
Hadoop Applier for MySQL
MySQL JSON UDFs
MySQL Multi-source Replication
MySQL Utilities - Fabric
www.slideshare.net/ yoyamasaki/my-sql-jsonudf
Hadoop Applier for MySQL
MySQL JSON UDFs
MySQL Multi-source Replication
MySQL Utilities - Fabric
Binlog
Master 1
Binlog
Master 2
…
…
Binlog
Master N
IO 1
Relay 1
Coordinator
W1 W2 … WX
IO 2
Relay 2
Coordinator
W1 W2 … WX
…
…
Coordinator
W1 W2 … WX
IO N
Relay N
Coordinator
W1 W2 … WX
Slave
CHANGE MASTER TO master_def ….. FOR CHANNEL=”<channel_name>”
START SLAVE [thread_types] [until_option] [connection_options] FOR CHANNEL=”<channel_name>"
STOP SLAVE [thread_types] FOR CHANNEL=”<channel_name>”
RESET SLAVE [ALL] FOR CHANNEL=”<channel_name>”
FLUSH RELAY LOGS FOR CHANNEL=”channel_name>”
SHOW RELAY LOG EVENTS FOR CHANNEL=”<channel_name>”
SELECT MASTER_POS_WAIT(“master_log_file' master_log_pews [, timeout][, channel_name])
START SLAVE [thread_type] FOR ALL CHANNELS
STOP SLAVE [thread_type] FOR ALL CHANNELS
Hadoop Applier for MySQL
MySQL JSON UDFs
MySQL Multi-source Replication
MySQL Utilities - Fabric
MySQL Utilities Since 2010
App
PHP Python Java
vnwrites. blogspot.com
MySQL Utilities - Fabric +
MySQL Multi-source Replication +
Multi Thread Slave
labs.mysql.com &
bugs.mysql.com
Affects Me
告知
2013年11月 13-15日
db tech showcase by インサイトテクノロジー
松信さん 来日予定
MySQL 5.6 at
山崎さんMySQL 5.6時代のパフォチュー
奥野さんMySQL Cluster徹底活用術
梶山 MySQL 5.7 & Labs
@RKajiyama