Advance Sharding Solution with ProxySQL
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 lacks in sharding capability. This significant missing part had often cause developer do implement sharding at application level, or DBA/SA to move on to another solution. ProxySQL comes with an elegant and simple solution that allow us to implement sharding capability with MySQL without the need to perform significant, or at all, changes in the code. This brief presentation will illustrate how to successfully configure and use ProxySQL to perform sharding, from very simple approach based on connection user/ip/port, to complicate ones that see the need to read values inside queries.
Principal Consultant , Percona
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 hyper textual environment.Team leader for the FAO corporate database support.