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.
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.