PyCon TW 2016 Tutorial - Creating python app with MySQL Router and MySQL Group Replication

  • 2016/06/03(周五) 14:10(+0800) ~ 17:10(+0800) ( iCal/Outlook, Google 日曆 )
  • Room R3, International Conference Hall, Humanities & Social Sciences Building, Academia Sinica. Taipei.Taiwan / 中央研究院 人文社會科學館 國際會議廳 R3 廳 / 台北市南港區研究院路二段 128 號
  • 25 / 30
  • PyCon Taiwan聯絡主辦單位

Registration Schedule 售票時程

  • The registration will begin on April 18 06:03 p.m. 
    開始售票 2016  4 月18 下午 6:03.

  • The whole registration is expected to end on May 13 06:05 p.m. 
    其餘為 2016 5 13 日下午 6:05 截止.

 

Ticket Info 售票資訊

  • The Tickets are only availabe for those who have already bought tickets for PyCon.
    PyCon課程票僅提供給已購買PyCon主活動票的會眾。

 

  • The tutorial will be held if there are more than 4 participants. PyCon will return full ticket price if the tutorial is cancelled.
    報名人數達 5 人即開班,未滿 5 人則流團退還全額報名費。

 

  • For those who bought the ticket without qualifacation above, PyCon will return the money with excluding the administration fee.
    不符資格者,大會將扣除行政費用後退餘款。

 

Receipt Policy 發票處理說明

  • Payment receipt will be handed over on-site.
    可提供發票,您將在會議當天報到處收到發票。

  • Please provide your Company Name and Unified Business Number.
    請註明統一編號和公司抬頭

 

Notice 注意事項

  1. No Refund 不接受退票
    Except the condition above, there would be no refund once registration is confirmed.
    除上述情況外,本次活動恕不接受退票。

  2. Everybody Pays 公平付費
    PyCon Taiwan 2016 is a paid conference; everybody, including staffs and speakers, has to pay to attend. (See also: Everybody Pays)
    PyCon Taiwan 2016
    為使用者需付費之議程,所有工作人員和講者均自行付費參加。(另見公平付費

  3. Ticketing Consultancy 票務諮詢
    Please kindly mail to organizers[at]pycon.tw
    如有任何問題,請寄信至 organizers[at]pycon.tw

For more information, please refer to our official website : https://tw.pycon.org/2016/en/registration/ticket-info/
更多資訊,請參考官網 :

 

Tutorial Info

  • Abstract

Database with High Availability is so much important to the application reliability.  

The tutorial is setup to guide thru from the creation of redundant MySQL Database Instances with Group Replication.

The Group of MySQL Database Instances is setup so that the data is synchronized and replicated across all database instances.   MySQL Router is setup to allow python application to connect to the group of servers without knowing the details.   The Routing setup is done within the MySQL Router.

 

  • Speaker Bio
Ivan Ma is the MySQL User Group Lead in Hong Kong. He has over 20+ years of experience in enterprise system infrastructure and software technologies. He has certification on MySQL DBA 5.6, MySQL Developer 5.1 and MySQL Cluster 5.1 DBA.
He Joined MySQL responsible for pre-sales consulting, technical education &update.
Prior to joining MySQL team@Oracle, he joined Oracle in System Team from Sun Mircosystems acquisition.
 
  • Detail Description

The tutorial will go thru the following

  • Installing MySQL Database

  • Creating multiple instances of MySQL Databases

  • Enabling and Configuring the Group of MySQL Servers as Group Replication

  • Seting up MySQL Router to point to the group of MySQL Servers

  • Running simple mysql client to MySQL Router into the Group of MySQL Servers (with Group Replication)

  • Creating simple python application connecting to MySQL Router into the Group of MySQL Servers (with Group Replication)

The full tutorial shows the creation of reliable service for Python Application.

 

  • Outline
  1. Briefing and Introduction (20 mins)

  2. Envrionment Setup (20mins)

  3. Installing MySQL Database (15 mins) - Once installed, run a few test.

  4. Creating multiple instances (extra 3 more) of MySQL Databases - 15 mins (Ready-made configuration are provided)

  5. Enabling and Configuring the Group of MySQL Servers as Group Replication - 30 mins

  6. Seting up MySQL Router to point to the group of MySQL Servers - 15 mins

  7. Running simple mysql client to MySQL Router into the Group of MySQL Servers (with Group Replication) - 10 mins

  8. Creating simple python application connecting to MySQL Router into the Group of MySQL Servers (with Group Replication) - 10 mins Wrapup Presentation - Python Conneting MySQL (20 mins)

Total : 165 mins : Estimated : 2.5 to 3 hours

  • Requirement

Firstly, the VM image will be provided.  Each participant is required to bring in notebook with Virtualbox installation.  

Disk Space Requirements : 20G

USB flash disk to be prepared.

- VM image

- Virtualbox installation (just in case)

 

 

Sponsors 贊助商

 

If you wish to support PyCon Taiwan 2016 on your own, you are welcome to be a patron!

希望用個人身份支持 PyCon Taiwan 2016 嗎?歡迎您成為 PyCon Taiwan 2016 的個人贊助成員
 

Room R3, International Conference Hall, Humanities & Social Sciences Building, Academia Sinica. Taipei.Taiwan / 中央研究院 人文社會科學館 國際會議廳 R3 廳 / 台北市南港區研究院路二段 128 號

活動票券

票種 販售時間 售價
[ Tutorial ] Creating python app with MySQL Router and MySQL Group Replication 2016/04/18 18:03(+0800) ~ 2016/06/03 12:00(+0800) 結束販售
  • 免費
下一步