Search icon CANCEL
Subscription
0
Cart icon
Your Cart (0 item)
Close icon
You have no products in your basket yet
Arrow left icon
Explore Products
Best Sellers
New Releases
Books
Videos
Audiobooks
Learning Hub
Free Learning
Arrow right icon
Arrow up icon
GO TO TOP
Mastering Ubuntu Server

You're reading from   Mastering Ubuntu Server Master the art of deploying, configuring, managing, and troubleshooting Ubuntu Server 18.04

Arrow left icon
Product type Paperback
Published in May 2018
Publisher Packt
ISBN-13 9781788997560
Length 552 pages
Edition 2nd Edition
Concepts
Arrow right icon
Author (1):
Arrow left icon
Jay LaCroix Jay LaCroix
Author Profile Icon Jay LaCroix
Jay LaCroix
Arrow right icon
View More author details
Toc

Table of Contents (21) Chapters Close

Preface 1. Deploying Ubuntu Server 2. Managing Users FREE CHAPTER 3. Managing Storage Volumes 4. Connecting to Networks 5. Managing Software Packages 6. Controlling and Monitoring Processes 7. Setting Up Network Services 8. Sharing and Transferring Files 9. Managing Databases 10. Serving Web Content 11. Learning Advanced Shell Techniques 12. Virtualization 13. Running Containers 14. Automating Server Configuration with Ansible 15. Securing Your Server 16. Troubleshooting Ubuntu Servers 17. Preventing and Recovering from Disasters 18. Using the Alternate Installer 19. Assessments 20. Other Books You May Enjoy

Setting up a slave database server

Earlier in this chapter, we discussed installing MariaDB on a server. To set up a slave, all you really need to begin the process is set up another database server. If you've already set up two database servers, you're ready to begin. If not, feel free to spin up another VM and follow the process from earlier in this chapter that covered installing MariaDB. Go ahead and set up another server if you haven't already done so. Of your two servers, one should be designated as the master and the other the slave, so make a note of the IP addresses for each.

To begin, we'll first start working on the master. We'll need to edit the /etc/mysql/conf.d/mysql.cnf file. Currently, the file contains just the following line:

[mysql] 

Right underneath that, add a blank line and then the following code:

[mysqld] 
log-bin 
binlog-do-db...
lock icon The rest of the chapter is locked
Register for a free Packt account to unlock a world of extra content!
A free Packt account unlocks extra newsletters, articles, discounted offers, and much more. Start advancing your knowledge today.
Unlock this book and the full library FREE for 7 days
Get unlimited access to 7000+ expert-authored eBooks and videos courses covering every tech area you can think of
Renews at $19.99/month. Cancel anytime
Banner background image