Birmingham mumbai

[
 348 
]
And that should be all there is to it. At this point, you should have fully functional 
primary and secondary database servers at your disposal. To get additional practice, 
try adding additional databases, tables, and users, and insert new rows into your 
databases. It's worth mentioning that the users we've created here will not be synced 
to the secondary server, so you can use the commands we used earlier in this chapter 
to create users on the secondary server if you wish for them to be present there.
Summary
Depending on your skillset, you're either an administrator who is learning about 
SQL databases for the first time, or you're a seasoned veteran who is curious about 
how to implement a database server with Ubuntu Server. In this chapter, we dove 
into Ubuntu's implementation of this technology and worked through setting up 
our own database server. We also worked through some examples of the MariaDB 
syntax, such as creating databases, as well as setting up users and their grants. We 
also worked through setting up a primary and secondary server for replication.
Database administration is a vast topic, and we've only scratched the surface here. 
Being able to manage MySQL and MariaDB databases is a very sought-after skill for 
sure. If you haven't worked with these databases before, this chapter will serve as a 
good foundation for you to start your research.
In the next chapter, we'll use our database server to act as a foundation for 
Nextcloud, which we will set up as part of our look into setting up a web server. 
When you've finished practicing these database concepts, head on over to 
Chapter 14
, 
Serving Web Content
, where we'll journey into the world of web hosting.
Further reading
• 
Configuring MariaDB with Option Files: 
https://mariadb.com/kb/en/
configuring-mariadb-with-option-files/

---