Scribd
Upload
73 views

Pertemuan 3 Introduction To MySQL

This document provides an overview of database administration and security with MySQL. It discusses MySQL's objectives of installing and configuring the MySQL database server on Linux. It then summarizes that MySQL is an open-source SQL database management system developed by Oracle. It functions as a client-server system and can be used in embedded applications. MySQL databases are relational and scalable for handling large amounts of data. The document also outlines how to run multiple MySQL instances on a single machine.

Uploaded by

Eriko Novi Trianto
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd
73 views

Pertemuan 3 Introduction To MySQL

This document provides an overview of database administration and security with MySQL. It discusses MySQL's objectives of installing and configuring the MySQL database server on Linux. It then summarizes that MySQL is an open-source SQL database management system developed by Oracle. It functions as a client-server system and can be used in embedded applications. MySQL databases are relational and scalable for handling large amounts of data. The document also outlines how to run multiple MySQL instances on a single machine.

Uploaded by

Eriko Novi Trianto
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd
You are on page 1/ 14

DATABASE ADMINISTRATION

AND SECURITY

Chapter 3

Bandarlampung, Februari 2020


Jupriyadi, S.Kom. M.T. https://spada.teknokrat.ac.id
jupriyadi@teknokrat.ac.id
Course Objectives
 The students will be able to:
 Install MySQL database server on linux OS.
 Basic configuration MySQL database server
MySQL, the most popular Open Source SQL database
management system, is developed, distributed, and
supported by Oracle Corporation.

The MySQL website (http://www.mysql.com/) provides the latest


information about MySQL software.
What is MySQL ..? (cont’d)
• MySQL is a database management system.
• MySQL databases are relational.
• MySQL software is Open Source.
• The MySQL Database Server is very fast, reliable, scalable,
and easy to use.
• MySQL Server works in client/server or embedded systems.
• A large amount of contributed MySQL software is available.
MySQL IS A DATABASE MANAGEMENT
SYSTEM
A database is a structured collection of data. It may be anything from a
simple shopping list to a picture gallery or the vast amounts of
information in a corporate network. To add, access, and process data
stored in a computer database, you need a database management
system such as MySQL Server. Since computers are very good at
handling large amounts of data, database management systems play a
central role in computing, as standalone utilities, or as parts of other
applications
MySQL DATABASE ARE RELATIONAL

 A relational database stores data in separate tables rather


than putting all the data in one big storeroom.
 The database structures are organized into physical files
optimized for speed.
 The logical model, with objects such as databases, tables,
views, rows, and columns, offers a flexible programming
environment
MySQL SOFTWARE IS OPEN SOURCE

Open Source means that it is possible for anyone to use and modify
the software. Anybody can download the MySQL software from the
Internet and use it without paying anything. If you wish, you may study
the source code and change it to suit your needs. The MySQL
software uses the GPL (GNU General Public License),
http://www.fsf.org/licenses/, to define what you may and may not do
with the software in different situations
The MySQL Database Server is very
fast, reliable, scalable, and easy to use

 If that is what you are looking for, you should give it a try.
 MySQL Server can run comfortably on a desktop or laptop,
alongside your other applications, web servers, and so on,
requiring little or no attention.
 If you dedicate an entire machine to MySQL, you can adjust
the settings to take advantage of all the memory, CPU
power, and I/O capacity available.
 MySQL can also scale up to clusters of machines,
networked together
MySQL Server works in client/server or
embedded systems
 The MySQL Database Software is a client/server system
that consists of a multithreaded SQL server that supports
different back ends, several different client programs and
libraries, administrative tools, and a wide range of
application programming interfaces (APIs).

 We also provide MySQL Server as an embedded


multithreaded library that you can link into your application
to get a smaller, faster, easier-to-manage standalone
product
A large amount of contributed MySQL
software is available

 MySQL Server has a practical set of features developed in


close cooperation with our users. It is very likely that your
favorite application or language supports the MySQL
Database Server.
The Main Features of MySQL
 Designed to be fully multithreaded using kernel threads, to easily
use multiple CPUs if they are available
 Many data types and Fixed-length and variable-length string
types
 Full operator and function support in the SELECT list and
WHERE clause of queries
 A privilege and password system that is very flexible and secure,
and that enables host-based verification.
 Password security by encryption of all password traffic when you
connect to a server
 Support for large databases
 Clients can connect to MySQL Server using several protocols
The MySQL Data Directory
 Data directory subdirectories. Each subdirectory of the data
directory is a database directory and corresponds to a database
managed by the server.
 All MySQL installations have certain standard databases
 Log files written by the server
 InnoDB tablespace and log files
 Default/autogenerated SSL and RSA certificate and key files
 he server process ID file (while the server is running)
Running Multiple MySQL Instances on
One Machine
In addition to using different data directories, several other options
must have different values for each server instance:
--port=port_num
--socket={file_name|pipe_name}
--shared-memory-base-name=name
--pid-file=file_name
If you use the following log file options, their values must differ for
each server:
--general_log_file=file_name
--log-bin[=file_name]
--slow_query_log_file=file_name
--log-error[=file_name]
What's Next ?

You might also like