slfan1989 commented on PR #5244:
URL: https://github.com/apache/hadoop/pull/5244#issuecomment-1429247951
### Mysql5.7
> select version();
```
information_schema> select version()
[2023-02-14 13:30:38] 1 row retrieved starting from 1 in 236 ms (execution:
172 ms, fetching: 64 ms)
5.7.18-txsql-log
```
> FederationStateStoreDatabase.sql
```
> CREATE database FederationStateStore
[2023-02-14 13:27:09] 1 row affected in 170 ms
```
> FederationStateStoreUser.sql
```
[2023-02-13 11:22:20] completed in 166 ms
> CREATE USER 'FederationUser'@'%' IDENTIFIED BY 'FederationPassword'
[2023-02-14 13:30:57] completed in 168 ms
> GRANT ALL PRIVILEGES ON FederationStateStore.* TO 'FederationUser'@'%'
[2023-02-14 13:30:58] completed in 173 ms
> FLUSH PRIVILEGES
```
> FederationStateStoreTables.sql
```
.....
federationstatestore> CREATE TABLE delegationTokens
(
sequenceNum bigint NOT NULL,
tokenIdent varchar(1024) NOT NULL,
token varchar(1024) NOT NULL,
renewDate bigint NOT NULL,
CONSTRAINT pk_sequenceNum PRIMARY KEY (sequenceNum)
)
[2023-02-14 13:31:30] completed in 174 ms
federationstatestore> CREATE TABLE sequenceTable (
sequenceName varchar(255) NOT NULL,
nextVal bigint(20) NOT NULL,
CONSTRAINT pk_sequenceName PRIMARY KEY
(sequenceName)
)
[2023-02-14 13:31:31] completed in 171 ms
use federationstatestore;
show tables;
applicationshomesubcluster
delegationtokens
masterkeys
membership
policies
reservationshomesubcluster
sequencetable
```
> FederationStateStoreStoredProcs.sql
```
[2023-02-14 13:35:02] completed in 180 ms
federationstatestore> CREATE PROCEDURE sp_deleteDelegationToken(
IN sequenceNum_IN bigint, OUT rowCount_OUT int)
BEGIN
DELETE FROM delegationTokens
WHERE sequenceNum = sequenceNum_IN;
SELECT ROW_COUNT() INTO rowCount_OUT;
END
[2023-02-14 13:35:08] completed in 169 ms
federationstatestore> CREATE PROCEDURE sp_getDelegationToken(
IN sequenceNum_IN bigint, OUT tokenIdent_OUT
varchar(1024),
OUT token_OUT varchar(1024), OUT renewDate_OUT
bigint)
BEGIN
SELECT tokenIdent, token, renewDate INTO
tokenIdent_OUT, token_OUT, renewDate_OUT
FROM delegationTokens
WHERE sequenceNum = sequenceNum_IN;
END
[2023-02-14 13:35:53] completed in 171 ms
SELECT * FROM information_schema.Routines where ROUTINE_SCHEMA =
'federationstatestore'
[2023-02-14 13:38:33] 25 rows retrieved starting from 1 in 279 ms
(execution: 173 ms, fetching: 106 ms)
sp_addApplicationHomeSubCluster
sp_addDelegationToken
sp_addMasterKey
sp_addReservationHomeSubCluster
sp_deleteApplicationHomeSubCluster
sp_deleteDelegationToken
sp_deleteMasterKey
sp_deleteReservationHomeSubCluster
sp_deregisterSubCluster
sp_getApplicationHomeSubCluster
sp_getApplicationsHomeSubCluster
sp_getDelegationToken
sp_getMasterKey
sp_getPoliciesConfigurations
sp_getPolicyConfiguration
sp_getReservationHomeSubCluster
sp_getReservationsHomeSubCluster
sp_getSubCluster
sp_getSubClusters
sp_registerSubCluster
sp_setPolicyConfiguration
sp_subClusterHeartbeat
sp_updateApplicationHomeSubCluster
sp_updateDelegationToken
sp_updateReservationHomeSubCluster
```
> dropStoreProcedures.sql
```
federationstatestore> DROP PROCEDURE sp_getMasterKey
[2023-02-14 15:12:18] completed in 180 ms
federationstatestore> DROP PROCEDURE sp_deleteMasterKey
[2023-02-14 15:12:21] completed in 173 ms
federationstatestore> DROP PROCEDURE sp_addDelegationToken
[2023-02-14 15:12:23] completed in 183 ms
federationstatestore> DROP PROCEDURE sp_getDelegationToken
[2023-02-14 15:12:27] completed in 183 ms
federationstatestore> DROP PROCEDURE sp_updateDelegationToken
[2023-02-14 15:12:29] completed in 181 ms
federationstatestore> DROP PROCEDURE sp_deleteDelegationToken
[2023-02-14 15:12:32] completed in 248 ms
federationstatestore> SELECT * FROM information_schema.Routines where
ROUTINE_SCHEMA = 'federationstatestore'
[2023-02-14 15:13:10] 0 rows retrieved in 200 ms (execution: 177 ms,
fetching: 23 ms)
```
> dropTables.sql
```
federationstatestore> DROP TABLE policies
[2023-02-14 15:13:38] completed in 174 ms
federationstatestore> DROP TABLE reservationsHomeSubCluster
[2023-02-14 15:13:40] completed in 170 ms
federationstatestore> DROP TABLE masterKeys
[2023-02-14 15:13:43] completed in 180 ms
federationstatestore> DROP TABLE delegationTokens
[2023-02-14 15:13:46] completed in 173 ms
federationstatestore> DROP TABLE sequenceTable
[2023-02-14 15:13:48] completed in 174 ms
federationstatestore> use federationstatestore
[2023-02-14 15:14:12] completed in 218 ms
federationstatestore> show tables
[2023-02-14 15:14:12] 0 rows retrieved in 140 ms (execution: 130 ms,
fetching: 10 ms)
```
> dropDatabase.sql
```
federationstatestore> DROP DATABASE FederationStateStore
[2023-02-14 15:14:34] completed in 182 ms
```
> dropUser.sql
```
> DROP USER 'FederationUser'@'%'
[2023-02-14 15:14:43] completed in 169 ms
```
### Mysql8.0
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: common-issues-unsubscr...@hadoop.apache.org
For queries about this service, please contact Infrastructure at:
us...@infra.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: common-issues-unsubscr...@hadoop.apache.org
For additional commands, e-mail: common-issues-h...@hadoop.apache.org
