[
https://issues.apache.org/jira/browse/YARN-11349?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17688334#comment-17688334
]
ASF GitHub Bot commented on YARN-11349:
---------------------------------------
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
> [Federation] Router Support DelegationToken With SQL
> ----------------------------------------------------
>
> Key: YARN-11349
> URL: https://issues.apache.org/jira/browse/YARN-11349
> Project: Hadoop YARN
> Issue Type: Sub-task
> Components: federation, router
> Affects Versions: 3.4.0
> Reporter: Shilun Fan
> Assignee: Shilun Fan
> Priority: Major
> Labels: pull-request-available
>
> Router Support DelegationToken With SQLFederationStateStore.
--
This message was sent by Atlassian Jira
(v8.20.10#820010)
---------------------------------------------------------------------
To unsubscribe, e-mail: yarn-issues-unsubscr...@hadoop.apache.org
For additional commands, e-mail: yarn-issues-h...@hadoop.apache.org
