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.
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.
Percona XtraDB Cluster is a very robust, high performing and widely used solution that answers high availability needs. But it can be very challenging when deploying the cluster over a geographically dispersed area.
This presentation will briefly discuss the right approach to successfully deploying Percona XtraDB Cluster when in the need to cover multiple geographical sites, close and far.
- What is Percona XtraDB Cluster and what happens in a set of nodes during commit
- Clarify what geo-dispersed means
- What to keep in mind
- How to correctly measure metrics
- Use sync the right way (sync/async)
- Use tools like replication_manager