Contents:
Do you know how services of your system are finding out the process they need exactly?
but how can I stop the process with it?
How do I stop a MySQL instance?
DOES the slave copy old records ?
hello Ilia, is there a system that automatically does this?
Is there any query to get a list of column names and corresponding table name in which column name contain a keyword in Oracle?
do you know about a group of Mysql but in spanish?
Why do you need a database?
Inventory management and two rooms?
Or what kind of inventory management do you mean?
Do you know how services of your system are finding out the process they need exactly?
but how can I stop the process with it?
How do I stop a MySQL instance?
DOES the slave copy old records ?
hello Ilia, is there a system that automatically does this?
Is there any query to get a list of column names and corresponding table name in which column name contain a keyword in Oracle?
do you know about a group of Mysql but in spanish?
Why do you need a database?
Inventory management and two rooms?
Or what kind of inventory management do you mean?
piterden 2021-01-10 15:59:05
Do you know how services of your system are finding out the process they need exactly?
piterden 2021-01-10 15:59:36
They store pid in the file
Liran 2021-01-10 16:11:34
/var/run/mysqld/mysqld2.pid this is the PID location
Liran 2021-01-10 16:11:47
but how can I stop the process with it?
lee_crey 2021-01-10 19:44:09
$ service mysql stop?
MasterZiv 2021-01-10 19:51:37
Liran 2021-01-10 15:53:10
How do I stop a MySQL instance? I start it like this: mysqld –defaults-file=/etc/mysql/my2.cnf -u root
Press Ctrl-C
MasterZiv 2021-01-10 19:53:59
Liran 2021-01-10 15:53:10
How do I stop a MySQL instance? I start it like this: mysqld –defaults-file=/etc/mysql/my2.cnf -u root
If you start MySQL like this, there is no service of MySQL.
There is only a process you started manually.
Then, to stop it, you must send it kill signal.
Liran 2021-01-11 12:25:02
mysqladmin is the answer.
Liran 2021-01-12 12:56:44
When I create a master/slave on mysql, does the slave also copy old records? or only records from the time he started as a slave?
MasterZiv 2021-01-12 13:46:16
Liran 2021-01-12 12:56:44
When I create a master/slave on mysql, does the slave also copy old records? or only records from the time he started as a slave?
Well, you start creating slave from restoring a dump of master DB onto it…
DOES the slave copy old records ?
smlkw 2021-01-12 13:53:17
MasterZiv 2021-01-12 13:46:16
Well, you start creating slave from restoring a dump of master DB onto it…
DOES the slave copy old records ?
DOES the slave copy old records ?
hello Ilia, is there a system that automatically does this? For example, I want to add a new slave node to my MySQL cluster without stopping the cluster or is this impossible by the MySQL architecture?
MasterZiv 2021-01-12 13:54:09
smlkw 2021-01-12 13:53:17
hello Ilia, is there a system that automatically does this? For example, I want to add a new slave node to my MySQL cluster without stopping the cluster or is this impossible by the MySQL architecture?
IDK
Liran 2021-01-12 14:02:48
MasterZiv 2021-01-12 13:46:16
Well, you start creating slave from restoring a dump of master DB onto it…
DOES the slave copy old records ?
DOES the slave copy old records ?
I don’t use a dump on the slave…. I use on the slave the command “CHANGE MASTER TO” and the relevant MASTER_LOG_FILE & MASTER_LOG_POS
smlkw 2021-01-12 14:10:51
Liran 2021-01-12 14:02:48
I don’t use a dump on the slave…. I use on the slave the command “CHANGE MASTER TO” and the relevant MASTER_LOG_FILE & MASTER_LOG_POS
You need to stop the master, then import the dump of the database to a slave, connect to the master by the “CHANGE MASTER TO” command and then turn on the master and then a slave
MasterZiv 2021-01-12 14:12:33
Liran 2021-01-12 12:56:44
When I create a master/slave on mysql, does the slave also copy old records? or only records from the time he started as a slave?
It “copies” only the data modifications from the time you start slave
2021-01-13 10:28:03
How to Take backup using mysqlpump and Restore backup MySQL DBA Tutorial | MySQL 8 DBA Training
Compressed backups
Parallel processing
Exclude/include database objects
Backup users
Restore mysqlpump/mysqldump backup
29- How to Take backup using mysqlpump and Restore backup MySQL DBA Tutorial | MySQL 8 DBA Training – YouTube
Why backups?
Taking backups using mysqldump
Taking backups using mysqlpump
Taking backups using mydumper
Taking backups using flat files
Taking backups using XtraBackup
Locking instances for backup
Parallel processing mysqlpump
Exclude/include database objects using mysqlpump
Backup users using mysqlpump
how to take Compressed backup using mysqlpump
Recovering from mysqldump
restore MySQL backup
Binary log backup
Clone Plugin MySQL 8
Physical backup
Logical backups
Full Backups
Incremental Backups
Differential backups
Physical backup utilities
Logical backup utilities
Please Follow me on Social Media
Linkedin: https://www.linkedin.com/in/mughees-ahmed-oracle-mysql-dba-287214122/
Twitter: https://twitter.com/Mughees52
Facebook: https://www.facebook.com/Mughees52/
Why backups?
Taking backups using mysqldump
Taking backups using mysqlpump
Taking backups using mydumper
Taking backups using flat files
Taking backups using XtraBackup
Locking instances for backup
Parallel processing mysqlpump
Exclude/include database objects using mysqlpump
Backup users using mysqlpump
how to take Compressed backup using mysqlpump
Recovering from mysqldump
restore MySQL backup
Binary log backup
Clone Plugin MySQL 8
Physical backup
Logical backups
Full Backups
Incremental Backups
Differential backups
Physical backup utilities
Logical backup utilities
Please Follow me on Social Media
Linkedin: https://www.linkedin.com/in/mughees-ahmed-oracle-mysql-dba-287214122/
Twitter: https://twitter.com/Mughees52
Facebook: https://www.facebook.com/Mughees52/
2021-01-15 10:51:37
How To Recover MySQL InnoDB Cluster | Different failure scenarios | MySQL DBA Tutorial |
Below scenarios are covered:
Rebooting a Cluster from a Major Outage
Node Recovering
-Node Recovery: Auto distributed recovery
Recovering and provisioning with mysqldump
Node Recovery: Remove and add the node
Below scenarios are covered:
Rebooting a Cluster from a Major Outage
Node Recovering
-Node Recovery: Auto distributed recovery
Recovering and provisioning with mysqldump
Node Recovery: Remove and add the node
#innodbCluster #cluster #innodb #highavailability #mysql #mysqldba #mysql8 #databaseadministrator
6 – How To Recover MySQL InnoDB Cluster | Different failure scenarios | MySQL DBA Tutorial | Cluster – YouTube
Rebooting a Cluster from a Major OutageNode Recovering -Node Recovery: Auto distributed recoveryRecovering and provisioning with mysqldumpNode Recovery: Re…
Rebooting a Cluster from a Major OutageNode Recovering -Node Recovery: Auto distributed recoveryRecovering and provisioning with mysqldumpNode Recovery: Re…
2021-01-15 11:52:59
I need to migrate the tables in MySQL database to Oracle DB.
Is there any query to get a list of column names and corresponding table name in which column name contain a keyword in Oracle? Will use this list to rename those columns to Oracle supporting names
Is there any query to get a list of column names and corresponding table name in which column name contain a keyword in Oracle? Will use this list to rename those columns to Oracle supporting names
ColonelMustang 2021-01-15 20:27:20
MySQL Migration
https://www.oracle.com/database/technologies/migrating-mysql-oracle-database.html
https://www.oracle.com/database/technologies/migrating-mysql-oracle-database.html
MySQL Migration – Oracle
MySQL Migration using SQL Developer technology
MySQL Migration using SQL Developer technology
simonbrownstudio 2021-01-15 22:13:00
do you know about a group of Mysql but in spanish?
beimingg 2021-01-16 13:30:49
Who knows which site or channel I can get Mysql software from
minefolelser 2021-01-16 13:33:24
beimingg 2021-01-16 13:30:49
Who knows which site or channel I can get Mysql software from
Their official website?
beimingg 2021-01-16 13:35:22
Full version?
minefolelser 2021-01-16 13:36:05
beimingg 2021-01-16 13:35:22
Full version?
Yep
beimingg 2021-01-16 13:36:59
Thanks you
2021-01-19 12:46:44
this is kind of a poor presentation of entity structure of database that i want to create. Here is the explanation, i want to create a DB to manage every equipment in computer lab and also computer storage room. my problems are
1. i do not really know how many tables i need to create. ( i can think of to create tblRoom – to list all rooms, tblEquipment -to list all equipment. I do not know if i need to create tblType – to list equipment’s type, tblAssociatedDevice – to list all associated dev for each PC, tblInstalledApp – to list all necessary installed app in each PC.
2. Do i need to create another table to list every equipment in storage room. since the pc is unused without associated device and installed app.
2021-01-19 12:48:13
disclaimer : i did a data structure for this, but trouble to design such database.
piterden 2021-01-19 12:50:10
2021-01-19 12:46:44
this is kind of a poor presentation of entity structure of database that i want to create. Here is the explanation, i want to create a DB to manage every equipment in computer lab and also computer storage room. my problems are
1. i do not really know how many tables i need to create. ( i can think of to create tblRoom – to list all rooms, tblEquipment -to list all equipment. I do not know if i need to create tblType – to list equipment’s type, tblAssociatedDevice – to list all associated dev for each PC, tblInstalledApp – to list all necessary installed app in each PC.
2. Do i need to create another table to list every equipment in storage room. since the pc is unused without associated device and installed app.
1. i do not really know how many tables i need to create. ( i can think of to create tblRoom – to list all rooms, tblEquipment -to list all equipment. I do not know if i need to create tblType – to list equipment’s type, tblAssociatedDevice – to list all associated dev for each PC, tblInstalledApp – to list all necessary installed app in each PC.
2. Do i need to create another table to list every equipment in storage room. since the pc is unused without associated device and installed app.
It doesn’t seem like relational DB structure
2021-01-19 12:51:20
piterden 2021-01-19 12:50:10
It doesn’t seem like relational DB structure
no, it doesn’t. If i can create a ERD for that, i think i could manage to do the query. As i noted, it was a poor presentation for what i’m trying to create.
piterden 2021-01-19 12:51:43
You should start from your main goal. Why do you need a database? Are you sure you need exactly database?
2021-01-19 12:52:28
piterden 2021-01-19 12:51:43
You should start from your main goal. Why do you need a database? Are you sure you need exactly database?
for computer lab tools/ inventory management, i think yes, i need database.
piterden 2021-01-19 12:53:03
The second one thing should be the full list of storing stuff
piterden 2021-01-19 12:55:44
2021-01-19 12:52:28
for computer lab tools/ inventory management, i think yes, i need database.
Inventory management and two rooms? So if you would take something in lab and go with that thing to the storage room, you will have to mark this act to the database. Have I got it clear?
piterden 2021-01-19 12:56:52
Or what kind of inventory management do you mean?
2021-01-19 12:57:17
piterden 2021-01-19 12:53:03
The second one thing should be the full list of storing stuff
pls elaborate.