Schedule Meeting

a

Database Automation for MySQL

Automate MySQL deployment and configuration with the Vettabase team of experts

Subscribe For Free eBook

Get a PDF version of our “MariaDB and MySQL indexes for DBAs and DevOps” ebook when subscribed. You’ll also receive our technical blog updates and the most notable industry news in the digest form.


Quick Intro to MySQL Automation

If you still deploy and configure each MySQL instance manually, this is not the best use of your time. The Vettabase experts will help you implement wise automations and save a lot of time for growth-related tasks. We don’t overautomate things and apply only what’s clearly needed and necessary for your infrastructure.

How Database Automation Will Benefit You

Building a powerful automation for your infrastructure means that you don't waste your time on routine tasks anymore and don't put your data at risk working manually long hours. Automated operations mean that you can trust your infrastructure.

Reliable automation from experts

Vettabase professionals knowing the database internals and top automation tools will offer you stable & elegant automations.

Server & operations testing

Understand what will work and what will not thanks to automation: all your automated operations are easy to test.

Lower costs for operations

Proper automation turns hours of work into minutes and offloads your team reducing the number of repetitive & frustrating tasks.

Less downtime

If your backup and restore procedures are pre-planned and automated, you get your node or cluster up almost instantly.

No human mistakes

With automation in place, you eliminate database anomalies that often result in IT problems and losses for your business.

Easier configurations

By leveraging a configuration management system, you can clone your optimal database configurations in no time.

Database Automation Tools:
Ansible and more

We prefer to use Ansible for all our database and ecosystem automations. It is an open source tool that proved to work well even in the most complicated installations.

We also have experience with Puppet and Chef, but these are commercial tools depending on their corresponding companies.

How We Build and Apply Database Automations

1

Meet with your team

To understand your needs, it's necessary to meet at least once to define the scope of work.

2

Create and approve the plan

Before we start doing anything, we'll present to you a clear automation plan and get your consent.

3

Build automation for you

We will apply the database industry best practices and strive to comply with the standards.

4

Setup a test environment

Before any automation goes to production, you'll be able to play with it and see how it works.

5

Conduct training (optional)

To make sure that your DBAs can leverage the new automation, you may want to get your staff trained.

6

Automation goes to production!

Your team can focus on its primary tasks and goals, without hours of unnecessary work!

How We Charge You for Database Automation

Our goal is to make routine work much easier for your particular database team. This means that we'll create tailored solutions for your operations and your infrastructure based on the conversations we had with you. So the cost of such a project depends on how complicated your database infrastructure is and what you do with it, but we'll provide you with a quotation after a free consultation.

We recommend you to focus on both current issues and desired outcomes so you could achieve what you want thanks to the solutions we'll build for you. We'll keep our automations clear, elegant and easy to understand for everyone on your team. Just describe your project and ask for a quote!

Security Standards

We understand that you trust us your database and the data inside it. This is why we will follow the industry's highest security standards to protect the integral part of your business.

  • No password will ever be transferred via unsafe communication channels.
  • A Non-Disclosure Agreement will be signed upon your first request.
  • SSH connection and key-based authentication will be employed by our experts when connecting to your database.
  • A Virtual Private Network (VPN) or jumphosts will be used by our team connecting to your database if you find it reasonable.

For full information on what else we do to ensure your database security, read our Consultancy Policy.

Client Testimonials

Take a look at the testimonials provided by Vettabase customers and partners - many of them are key people of the open source database community. If you want to add your reference, please contact us.

Justin Swanhart

Federico is a consultant who is extremely familiar with the entire MySQL ecosystem, and the LAMP stack, among other things. Federico has contributed source to Flexviews, part of the Swanhart Toolkit, and has tested my software extensively, offering bug reports and authoring code to fix problems and improve test cases. I would trust Federico to work on my systems, which is a trust that I extend to very few. He is an excellent engineer that I would be proud to have in any team that I work with.

Justin Swanhart
Vitali Tsevan

We’ve spent a year developing Catawiki platform together. During this year Federico helped a lot to improve our operational database setup.
Deep knowledge of MySQL internals helped us tuning our production database servers performance. We’ve created a bunch of meaningful charts in Grafana. They explained important MySQL metrics in a simple manner. This effort helped us to achieve better transparency in the database topic.
Federico showed ability to talk to developers simply and efficiently. During organized company events and private conversations he was explaining them do’s and dont’s of working with RDBMS. This guidance resulted not only in countless refactoring improvements in our applications but also in several wiki articles presented to our developers.

Vitali Tsevan
Dov Endress

Federico’s ability to explain high level concepts in a clear, concise fashion has saved me countless hours educating developers. It is one thing to explain a concept in depth to an audience of one, it is quite another to make clear the same information in a way everyone can understand.
His willingness to contribute to the overall knowledge base is a credit to the open source community.
In a time when so many people call themselves ‘full stack’ or ‘subject matter experts’, Federico is indeed just that. He has the respect and gratitude of his peers, colleagues, and customers alike.

Dov Endress
Karl Erik Levik

Vettabase performed a remote health check of our MariaDB cluster and MaxScale database proxy. The cluster is a critical infrastructure component for many of our experiments at the synchrotron. Vettabase produced a detailed report with all identified issues and recommended solutions for each. The report has given us reassurances about our database health and will serve as a guide for future improvements. Vettabase has demonstrated a deep technical understanding of MariaDB, Galera and MaxScale in a Linux environment. It was a pleasure to work with them!

Karl Erik Levik
Tommaso Franceschi

Vettabase is a valuable partner for Treedom. Their consulting services allowed us to improve our databases performance, scalability and security over time. In the process, Vettabase automated several maintenance tasks for our databases, using Ansible and custom scripts. Vettabase also trained our developers to write faster and more expressive SQL queries. The feedback from the attendees was great.

Tommaso Franceschi
Marco Visibelli

At Currencies Direct, Federico Razzoli reviewed our Cassandra infrastructure, providing us with precious recommendations on how to improve its configuration and our data models. His consulting clarified the intricacies of a distributed database and the Java Virtual Machine, and allowed us to take advantage of the peculiarities of Cassandra.
I would recommend Federico to other companies to handle their database problems.

Marco Visibelli
Lead Data Scientist at Currencies Direct

Get Started With Vettabase Today

Professional help for your database infrastructure is just one click away! Use our contact form to explain your recent and (or) critical database issues to us. Your message will remain strictly confidential to the Vettabase team. Our experts will respond to you as soon as possible. You can also book a meeting with Federico Razzoli, the Director and Founder of Vettabase Ltd.

We at Vettabase respect our customers and offer good value for money compared to many other database consulting companies. We automate things where others leave them as they are because it means more support incidents or consulting engagements. Unlike many other companies, we will not recommend you a solution we are interested in. Quite the opposite, we will remain unbiased and use the best tools and technologies that fit your existing infrastructure, plans for growth and budget.


How to compose strings in MariaDB

How to compose strings in MariaDB

MariaDB supports several ways to compose strings dynamically. Some of them might be well-known, others aren’t familiar to you. This article covers all the ways to compose strings.

read more

How to compose strings in MariaDB

How to compose strings in MariaDB

MariaDB supports several ways to compose strings dynamically. Some of them might be well-known, others aren’t familiar to you. This article covers all the ways to compose strings.

read more