You're reading from Linux: Powerful Server Administration Recipes for CentOS 7, RHEL 7, and Ubuntu Server Administration

Product type Course

Published in Apr 2017

Publisher Packt

ISBN-13 9781788293778

Length 995 pages

Edition 1st Edition

Tools

CentOS

Concepts

System Administration

Authors (4):

Uday Sawant

William Leemans

Jonathan Hobson

Oliver Pelz

View More author details

Table of Contents (6) Chapters

Preface

1. Module 1

2. Module 2 FREE CHAPTER

3. Module 3

Bibliography

Index

Chapter 10. Working with Databases

In this chapter, we will cover:

Installing a MariaDB database server
Managing a MariaDB database
Allowing remote access to a MariaDB server
Installing a PostgreSQL server and managing a database
Configuring remote access to a PostgresSQL
Installing phpMyAdmin and phpPgAdmin

Introduction

This chapter is a collection of recipes that deliver the necessary steps to implement and maintain two of the most popular database management systems in the Linux world. The need for data is everywhere and is a must have service for almost any server, and this chapter provides the starting point required to deploy these database systems in any environment.

Installing a MariaDB database server

Supporting over 70 collations, more than 30 character sets, multiple storage engines, and deployment in virtualized environment, MySQL is a mission-critical database server that is used by production servers all over the world. It is capable of hosting a vast number of individual...

Authors (4)

Uday Sawant

Uday Sawant has completed Master's in Computer Applications from Mumbai University. He is skilled with more than four years of experience in software development and operations field. Before working as a software developer, he worked extensively with server hardware as a system administrator. He is an expert with the LAMP stack, JavaScript, and cloud infrastructure. Before starting as a software developer, he worked extensively with server hardware and has 2+ years' experience as system administrator. Currently, he is working as Software Scientist in a Mumbai based start-up called Sweetcouch. His responsibilities include developing back-end services, setting up a real-time communication server, and automating various daily tasks. With an immense interest in Machine Learning, he likes to spend his spare time exploring this subject. His first book was Instant Building Multipage Forms with Yii published by Packt publishing

See other products by Uday Sawant

William Leemans

William Leemans has over 20 years of experience in the IT industry in various positions and supporting several environments. In 2005, he started his own consulting company, Critter BVBA, in the hope of offering open source solutions to his customers, who are mainly enterprises. In 2010, William started supporting Red Hat products full time with the Federal Police, Belgium. Since then, he has moved on to support Red Hat products at Proximus and now Euroclear. William is a strong open source supporter and contributes where he can. He has a couple of projects running at GitHub (https://github.com/bushvin). During the course of writing this book, William recertified himself as a Red Hat Certified Engineer, hoping to one day become a Red Hat Certified Architect. When he's not tapping away at the keyboard of his laptop, William likes to play around with his two young children, listen to rock music (Foo Fighters, AC/DC, and Queens of the Stone Age are some of his favorites), and devising complicated and intricate plots for the stories that he runs at his biweekly roleplaying sessions with his friends.

See other products by William Leemans

Jonathan Hobson

Jonathan is a web developer, systems engineer and applications programmer, who, for more than 20 years has been working behind the scenes to support companies, organizations and individuals around the world to realize their digital ambitions. With an honors degree in both English and History and as a respected practitioner of many computer languages Jonathan enjoys writing code, publishing articles, building computers, playing the video games and getting 'out and about' in the big outdoors. He has been using CentOS since its inception and over the years, it has not only earned his trust, but it has become his first choice server solution. CentOS is a first class community based enterprise class operating system, it is a pleasure to work with, and because of this Jonathan has written this book in order that his knowledge and experience can be passed on to others.

See other products by Jonathan Hobson

Oliver Pelz

Oliver Pelz has more than 10 years of experience as a software developer and system administrator. He graduated with a diploma degree in Bioinformatics and is currently working at the German Cancer Research center in Heidelberg where he authored and co-authored several scientific publications in the field of Bioinformatics. Next to developing web applications and biological databases for his department and scientists all over the world he is administrating a division-wide Linux-based data center and has setup two high-performance CentOS clusters for the analysis of high-troughput microscope and genome sequencing data. He loves writing code, riding his mountainbike in the Black Forest of Germany and is an absolute Linux and open-source enthusiast for many years. He has contributed to several open-source projects in the past and also worked as a reviewer on the book Centos 7 High Performance. He maintains an IT tech blog at www.oliverpelz.de **********************************Acknowledgement************************************** I would like to thank my family and especially my wonderful wife Beatrice and little son Jonah for their patience and understanding for all these long working hours while writing this book. Also I would like to thank the folks at Packt Publishing for all their support and the opportunity to to write this book, it was a great pleasure for me. Last but not least I would like to thank Jonathan Hobson for writing the first edition of this book, without him no second edition of this book would have been possible. I would also like to thank all of the mentors that I've had over the years, especially Tobias Dykerhoff who introduced me to the whole world of Linux a long time ago and infected me with his enthusiasm about open-source and the free software movement. **********************************Dedication*********************************** This work is dedicated to my son Marlin Pelz who was stillborn on 2.10.15 just a few days before his expected date of delivery while writing the last few chapters of this book. Marlin, words can not express how much I miss you!

See other products by Oliver Pelz

You're reading from Linux: Powerful Server Administration Recipes for CentOS 7, RHEL 7, and Ubuntu Server Administration

Table of Contents (6) Chapters

Chapter 10. Working with Databases

Introduction

Installing a MariaDB database server

Authors (4)

Personalised recommendations for you