Advance Sharding Solutions with ProxySQL

Tuesday 11:20AM-12:10PM

@ Field Suite 2

MySQL / MariaDBOpen Source Databases

50 minutes conference

Advanced

Tracks:
Developer, Business / Case Studies

ProxySQL is a very powerful platform that allows us to manipulate and manage our connections and queries in a simple but effective way.

Historically MySQL falls short in sharding capabilities. This significant area often caused developers to implement sharding at the application level, or DBAs/SAs to move on to another solution. ProxySQL has an elegant and simple solution that allows us to implement MySQL sharding capabilities without the need to perform significant (or any) changes in the code.

This brief presentation will illustrate how to successfully configure and use ProxySQL to perform sharding. We will cover very simple approaches based on connection user/IP/port, to complicated ones that see the need to read values inside queries.

Please note this presentation requires at least some basic ProxySQL knowledge.


Speakers

Marco Tusa

Marco Tusa (Percona)

Consulting Manager

Biography:

Marco Tusa had his own international practice for the past twenty seven years. His experience and expertise are in a wide variety of information technology and information management fields of application and cover research, development, analysis, quality control, project management and team management. Marco has move back to Percona in March 2016 as Manager HA, after being Principal consultant for Pythian for a brief period and manager of the Consulting Rapid Response Team in Percona from October 2013. Marco Tusa has moved from Italy to Ottawa in 2011 and had being working at Pythian as Cluster Technical Leader for the MySQL technology until September 2013. He has being working as employee the SUN Microsystems as MySQL Professional Service manager for South Europe., and previously in MySQL AB. He has worked with the Food and Agriculture Organization of the United Nation since 1994, leading the development of the Organization?s hypertextual environment.


Slides



  Download Slides  

Percona Live

Stay Connected on:

Percona Live Conferences

The Percona Live Open Source Database Conferences are the premier event for the diverse and active open source database community, as well as businesses that develop and use open source database software.
 

Contact Us

For general information about the event/expo/conference, including registration, please contact us at:

  • info(@) percona.com
  • +1-888-401-3401
  • +1-919-948-2863
  • 8081 Arco Corporate Drive - Suite 330 - Raleigh, NC 27617, USA