Azure/Databases - Revision history

Pio2pio at 12:35, 12 December 2018

2018-12-12T12:35:24Z

← Older revision		Revision as of 14:35, 12 December 2018
Line 1:		Line 1:
	Azure constantly improves databases offering on its cloud platform. So, things here can quickly get outdated.		Azure constantly improves databases offering on its cloud platform. So, things here can quickly get outdated.
			= SQL Servers and SQL databases =
	= Enable connectivity =		These are Microsoft SQL server implementations
			= Azure Database MySQL servers =
			== Enable connectivity ==
	As of writing this Azure '''Connection Security''' it breaks down to two concepts:		As of writing this Azure '''Connection Security''' it breaks down to two concepts:
	* '''Rule Name (IP rules)''': is database-level access allowing IP(s) to connect from Internet, aka ''Limit to Hosts Matching: %'', although you won't see this in the database		* '''Rule Name (IP rules)''': is database-level access allowing IP(s) to connect from Internet, aka ''Limit to Hosts Matching: %'', although you won't see this in the database
	* '''VNET Rules''': is server-level rule that allows to connect from a specified VNET's subnet(s). All subnets must reside in the same region. Virtual network rules are based on Virtual Network service endpoints.		* '''VNET Rules''': is server-level rule that allows to connect from a specified VNET's subnet(s). All subnets must reside in the same region. Virtual network rules are based on Virtual Network service endpoints.

	= MySQL client connection =		== MySQL client connection ==
	Below it's working example of connecting to Azure MySQL managed database service. Note:		Below it's working example of connecting to Azure MySQL managed database service. Note:
	* required username <code>myroot@db-1-rw-euw1-sandbox</code>		* required username <code>myroot@db-1-rw-euw1-sandbox</code>
Line 33:		Line 35:
	</source>		</source>

	= Connection details =		== Connection details ==
	<source lang="bash">		<source lang="bash">
	mysql> status;		mysql> status;

Pio2pio: /* MySQL client connection */

2018-12-12T12:33:08Z

MySQL client connection

← Older revision		Revision as of 14:33, 12 December 2018
Line 12:		Line 12:
	** <code>db-1-rw-euw1-sandbox</code> is mysql database server name		** <code>db-1-rw-euw1-sandbox</code> is mysql database server name
	<source lang="bash">		<source lang="bash">
	mysql -h db-1-rw-euw1-sandbox.mysql.database.azure.com -u myroot@db-1-rw-euw1-sandbox -pPass123%		mysql --host <fully qualified server name> --user <server admin login name>@<server name> -p
			mysql --host db-1-rw-euw1-sandbox.mysql.database.azure.com -u myroot@db-1-rw-euw1-sandbox -pPass123%
	</source>		</source>

Pio2pio: /* Enable connectivity */

2018-12-07T17:43:22Z

Enable connectivity

← Older revision		Revision as of 19:43, 7 December 2018
Line 4:		Line 4:
	As of writing this Azure '''Connection Security''' it breaks down to two concepts:		As of writing this Azure '''Connection Security''' it breaks down to two concepts:
	* '''Rule Name (IP rules)''': is database-level access allowing IP(s) to connect from Internet, aka ''Limit to Hosts Matching: %'', although you won't see this in the database		* '''Rule Name (IP rules)''': is database-level access allowing IP(s) to connect from Internet, aka ''Limit to Hosts Matching: %'', although you won't see this in the database
	* '''VNET Rules''': is server-level rule that allows to connect from a specified VNET's subnet(s). All subnets must reside in the same region.		* '''VNET Rules''': is server-level rule that allows to connect from a specified VNET's subnet(s). All subnets must reside in the same region. Virtual network rules are based on Virtual Network service endpoints.

	= MySQL client connection =		= MySQL client connection =

Pio2pio: /* Connection details */

2018-12-07T17:07:17Z

Connection details

← Older revision		Revision as of 19:07, 7 December 2018
Line 56:		Line 56:

	Threads: 9 Questions: 8566 Slow queries: 0 Opens: 119 Flush tables: 1 Open tables: 112 Queries per second avg: 0.289		Threads: 9 Questions: 8566 Slow queries: 0 Opens: 119 Flush tables: 1 Open tables: 112 Queries per second avg: 0.289
			</source>

			Connection details:
			<source lang="bash">
			show status like '%onn%';
	</source>		</source>

Pio2pio: /* MySQL client connection */

2018-12-07T16:53:16Z

MySQL client connection

@@ Line 11: / Line 11: @@
 ** <code>myroot</code> is a db user in <code>SELECT User FROM mysql.user;</code>
 ** <code>db-1-rw-euw1-sandbox</code> is mysql database server name
-<source bash="lang">
+<source lang="bash">
 mysql -h db-1-rw-euw1-sandbox.mysql.database.azure.com -u myroot@db-1-rw-euw1-sandbox -pPass123%
 </source>
@@ Line 17: / Line 17: @@
 By default followign users are existing in Azure MySQL server
-<source bash="lang">
+<source lang="bash">
 mysql> SELECT User FROM mysql.user;
 +------------------+
@@ Line 30: / Line 30: @@
 +------------------+
 rows in set (0.01 sec)
 </source>

Pio2pio: /* Enable connectivity */

2018-12-07T16:48:14Z

Enable connectivity

← Older revision		Revision as of 18:48, 7 December 2018
Line 4:		Line 4:
	As of writing this Azure '''Connection Security''' it breaks down to two concepts:		As of writing this Azure '''Connection Security''' it breaks down to two concepts:
	* '''Rule Name (IP rules)''': is database-level access allowing IP(s) to connect from Internet, aka ''Limit to Hosts Matching: %'', although you won't see this in the database		* '''Rule Name (IP rules)''': is database-level access allowing IP(s) to connect from Internet, aka ''Limit to Hosts Matching: %'', although you won't see this in the database
	* '''VNET Rules''': is server-level rule that allows to connect from a specified VNET's subnet(s)		* '''VNET Rules''': is server-level rule that allows to connect from a specified VNET's subnet(s). All subnets must reside in the same region.

	= MySQL client connection =		= MySQL client connection =

Pio2pio: Created page with "Azure constantly improves databases offering on its cloud platform. So, things here can quickly get outdated. = Enable connectivity = As of writing this Azure '''Connection..."

2018-12-07T16:44:24Z

Created page with "Azure constantly improves databases offering on its cloud platform. So, things here can quickly get outdated. = Enable connectivity = As of writing this Azure '''Connection..."

New page

Azure constantly improves databases offering on its cloud platform. So, things here can quickly get outdated.

= Enable connectivity =
As of writing this Azure '''Connection Security''' it breaks down to two concepts:
* '''Rule Name (IP rules)''': is database-level access allowing IP(s) to connect from Internet, aka ''Limit to Hosts Matching: %'', although you won't see this in the database
* '''VNET Rules''': is server-level rule that allows to connect from a specified VNET's subnet(s)

= MySQL client connection =
Below it's working example of connecting to Azure MySQL managed database service. Note:
* required username <code>myroot@db-1-rw-euw1-sandbox</code>
** <code>myroot</code> is a db user in <code>SELECT User FROM mysql.user;</code>
** <code>db-1-rw-euw1-sandbox</code> is mysql database server name
<source bash="lang">
mysql -h db-1-rw-euw1-sandbox.mysql.database.azure.com -u myroot@db-1-rw-euw1-sandbox -pPass123%
</source>

By default followign users are existing in Azure MySQL server
<source bash="lang">
mysql> SELECT User FROM mysql.user;
+------------------+
| User |
+------------------+
| az00cb7874715555 |
| myroot |
| azure_superuser |
| azure_superuser |
| mysql.session |
| mysql.sys |
+------------------+
6 rows in set (0.01 sec)
</source>