O'Reilly logo

MariaDB High Performance by Pierre MAVRO

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Use cases and troubleshooting

Use cases are really needed for novices and for those who do not practice these kind of solutions in production. That's why you'll see schema with explanations of what could happen in production. Now, let's discuss outages and how to resolve them.

SQL errors

In a replication mode, you can encounter errors if you do not respect what has been established. A common mistake is for the privileges to be configured on a slave node and not the master.

Here is a scenario with a database as an example:

  • Master: This is the server used as read/write
  • Slave1: This is the server used as read only

A junior database administrator connects to the slave server as someone asked for a new database and creates a database crap. The database is ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required