-->
SQL Clone
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 

Apache Hadoop Ozone+HDDs and Kubernetes

As Hadoop is already a great on BIG Data, now as you know hadoop has addition stuff in it with concept called “Ozone” works with HDFS Datanode plugin and HDDs. “Ozone is designed to scale to tens of billions of … Continue reading

Read more

0 comments, 156 reads

Posted in Vinay Thakur on 9 July 2018

Kubernetes

Have you heard the name Kubernetes, it is another open source in the market by Google and works one Containers, like Docker on Cloud. Kubernetes v1.0 was released on July 21, 2015 by Cloud Native Computing Foundation (CNCF). Future is … Continue reading

Read more

0 comments, 137 reads

Posted in Vinay Thakur on 6 July 2018

Microsoft Acquire GitHub after Linkedin

Microsoft acquires GitHub is a very big news after LinkedIn… that way now Microsoft will grow like anything as considering the information it has at GitHub, it will have a great help of open source information at GitHub will provide … Continue reading

Read more

0 comments, 215 reads

Posted in Vinay Thakur on 6 July 2018

Day 25 Optimization

Locking is depends upon Isolation level and Storage Engine. MySQL uses table level locking (instead of page, row, or column locking) for all storage engines except InnoDB, which uses row level locking locking system in MySQL: Implicit Locking: To maintain the … Continue reading

Read more

0 comments, 155 reads

Posted in Vinay Thakur on 25 May 2018

Day 24 Replication Setup

Today we will discuss how setup a replication: Master – Slave Replication: Requirement: 2 (Linux) System (MasterServer and SlaveServer) MySQL Installed Connection to both servers are accessible. On Master Server: Edit my.cnf with following information: [mysqld] Log-Bin =MySQL_Binlog Server_ID=1 Create … Continue reading

Read more

0 comments, 174 reads

Posted in Vinay Thakur on 24 May 2018

Day 23 Replication

Replication means making copy of the objects and moving transaction from primary server to secondary/standby/Slave server. There are two type of Replication Master-Master Replication Master-Slave Replication Like other RDBMS MySQL works replication on Transactions. The pre requisite of replication is … Continue reading

Read more

0 comments, 145 reads

Posted in Vinay Thakur on 23 May 2018

Day 22 Other Storage Engines

So far we have discussed InnoDB, MyIASM and NDB Storage engine which are most standard/common and important storage engine MySQL has, there are some other Storage engine which are specific to the business requirement and used only for their special … Continue reading

Read more

0 comments, 108 reads

Posted in Vinay Thakur on 21 May 2018

Day 21 NDB Storage Engine (Cluster)

MySQL also support High Availability, NDB Storage engine provides high availability- shared-nothing system, NDB Cluster integrates the standard MySQL server with an in-memory clustered storage engine called NDB (which stands for “Network DataBase” NDB Cluster required 3 Nodes required complete the setup: Management node(mgmd): … Continue reading

Read more

0 comments, 135 reads

Posted in Vinay Thakur on 21 May 2018

Day 20 Innodb Storage engine

InnoDB is the major Storage engine and is default Storage engine after MySQL 5.5 version. As standard RDBMS requires ACID properties and to make the Enterprise level of the system requires Transaction management. Before this MySQL was known to be … Continue reading

Read more

0 comments, 115 reads

Posted in Vinay Thakur on 21 May 2018

Day 19 MyIASM Storage engine

MyIASM storage engine is available from the early stage of MySQL this engine is developed from IASM language and it is used for Read intensive operations. As described in yesterday this Engine was default till MySQL 5.5 and is widely … Continue reading

Read more

0 comments, 118 reads

Posted in Vinay Thakur on 19 May 2018

Day 18 Storage engine

MySQL is special compare to all the other RDBMs System because of its special architecture, the STORAGE Engine. MySQL has many storage engine as per the developer/application requirements. With this good part is that MySQL can work multiple storage engine … Continue reading

Read more

0 comments, 119 reads

Posted in Vinay Thakur on 18 May 2018

Day 17 Backup and Recovery

There are there types of Backup: Full Backup Incremental Backup Bin-Log Backup Full Backup: is a complete backup of the database You can use following some of the options in the MySQLDump command –all-databases             Dump all tables in all … Continue reading

Read more

0 comments, 139 reads

Posted in Vinay Thakur on 17 May 2018

Day 16 Security

MySQL user format it as ‘User_name’@’hostname’ To create the user account use following syntax: CREATE USER ‘User_name’@’Host_name’ IDENTIFIED BY <Pwd>;   We can specify same name user for different hosts. Hostname can be specify either of this: ‘local_host’ –> for … Continue reading

Read more

0 comments, 128 reads

Posted in Vinay Thakur on 16 May 2018

Day 15 Server Logs

There are 6 types of logs available for MySQL environment, Logs are important information for DBA to troubleshoot or understand the system. MySQL track the information in those logs. Following are the list of logs: Error Log (– start/stop/errors) Query … Continue reading

Read more

0 comments, 139 reads

Posted in Vinay Thakur on 15 May 2018

Day 14 MySQL sys Schema

MySQL 5.7.7 and higher includes the sys schema, This has View, Stored Procedures and Functions to gather the performance related information, as it works on Performance Schema the Performance Schema must be enabled for the sys database. Following some of the important tables: sys_config: … Continue reading

Read more

0 comments, 114 reads

Posted in Vinay Thakur on 14 May 2018

Day 13 MySQL Performance_Schema

performace_schema is a dynamic database created when you restart the mysql, all the data from performance_schema database will be clear. This database has its own storage engine –“performance_schema” Even you may have this database but it could be possible that … Continue reading

Read more

0 comments, 154 reads

Posted in Vinay Thakur on 13 May 2018

Day 12 INFORMATION_SCHEMA database

Yesterday we discuss about mysql system database, today we will see “INFORMATION_SCHEMA” database, this we cannot call as database because it is not stored any data directly, it provides information about metadata and other information which mysql has – data … Continue reading

Read more

0 comments, 162 reads

Posted in Vinay Thakur on 12 May 2018

Day 11 MySQL System Database

Previous days we discuss Variables and configurations which are quite important for DBA to know. As stated earlier there are some system database MySQL has which will also contains very important information. Now on we will spend some time on … Continue reading

Read more

0 comments, 154 reads

Posted in Vinay Thakur on 11 May 2018

Day 10 Option file

So far we have discussed various mays to configure MySQL, Environmental Variables, Global Variable, Session Variables, Status Variable and Server Variables. All this variables are important and set the variable some of them dynamically affects the system and some required … Continue reading

Read more

0 comments, 143 reads

Posted in Vinay Thakur on 10 May 2018

Day 9 Variables

In earlier days we have discussed about providing options with environmental variable and command line, today we will be discussing on other variables, there are Global Variables and Session/Local Variables which reflects the state of the MySQL and we can … Continue reading

Read more

0 comments, 132 reads

Posted in Vinay Thakur on 9 May 2018

Older posts