Frédéric Descamps lefred

## generate_restaurants.py
#!/usr/bin/python3.8

import mysqlx
import sys
from random import choice, randrange
from faker import Faker


def connect():
    session = mysqlx.get_session(

## mysql_8_replication_observability.sql
use sys;
DROP VIEW IF EXISTS replication_status_full;
CREATE
  ALGORITHM = MERGE
  SQL SECURITY INVOKER
  VIEW replication_status_full
AS
SELECT
	concat(s.channel_name, ' (', w.worker_id,')') AS channel,
	c.host,

## to_optimize.sql
SELECT schema_name, format_pico_time(total_latency) tot_lat,
       exec_count, format_pico_time(total_latency/exec_count) latency_per_call,
       query_sample_text
  FROM sys.x$statements_with_runtimes_in_95th_percentile AS t1
  JOIN performance_schema.events_statements_summary_by_digest AS t2
    ON t2.digest=t1.digest
 WHERE schema_name NOT in ('performance_schema', 'sys')
ORDER BY (total_latency/exec_count) desc LIMIT 1\G

## func.py (json)
import io
import json
import logging
import oci
import base64
from mysql.connector import connection
from datetime import datetime

from fdk import response

## binlog_streaming@.service
[Unit]
Description=Streaming MySQL binary logs to local filesystem using %i
After=network.target

[Service]
Type=simple
User=root
Restart=on-failure
ExecStart=/root/binlog_streaming/bin/binlog_to_local.sh /root/binlog_streaming/conf/%i.conf

## mysql_window.sql
CREATE TABLE t_win(x int AUTO_INCREMENT PRIMARY KEY);


INSERT INTO t_win
VALUES (1),
       (2),
       (3),
       (4),
       (5),
       (6),

## mds_functions.sql
create database mds;

SET GLOBAL log_bin_trust_function_creators = 1;
USE mds;

DROP FUNCTION IF EXISTS get_gtid_to_skip;
DELIMITER |
CREATE FUNCTION get_gtid_to_skip()
RETURNS LONGTEXT
BEGIN

## binlog_to_object_storage.sh
#!/bin/bash

if [ $# -eq 0 ]
then
   echo "A configuration file is required"
   exit 1
fi

CONF_FILE=$1

## binlog_to_object_storage.sh
#!/bin/bash

if [ $# -eq 0 ]
then
   echo "A configuration file is required"
   exit 1
fi

CONF_FILE=$1

## index.php
<html>
<header>
  <title>PHP on OCI with MySQL Database Service</title>
</header>
<body>
<center><h1>PHP on OCI with MySQL Database Service</h1></center>
<hr>
<?php
$user = "";
$pwd  = "";
	#!/usr/bin/python3.8

	import mysqlx
	import sys
	from random import choice, randrange
	from faker import Faker


	def connect():
	session = mysqlx.get_session(
	use sys;
	DROP VIEW IF EXISTS replication_status_full;
	CREATE
	ALGORITHM = MERGE
	SQL SECURITY INVOKER
	VIEW replication_status_full
	AS
	SELECT
	concat(s.channel_name, ' (', w.worker_id,')') AS channel,
	c.host,
	SELECT schema_name, format_pico_time(total_latency) tot_lat,
	exec_count, format_pico_time(total_latency/exec_count) latency_per_call,
	query_sample_text
	FROM sys.x$statements_with_runtimes_in_95th_percentile AS t1
	JOIN performance_schema.events_statements_summary_by_digest AS t2
	ON t2.digest=t1.digest
	WHERE schema_name NOT in ('performance_schema', 'sys')
	ORDER BY (total_latency/exec_count) desc LIMIT 1\G
	import io
	import json
	import logging
	import oci
	import base64
	from mysql.connector import connection
	from datetime import datetime

	from fdk import response
	[Unit]
	Description=Streaming MySQL binary logs to local filesystem using %i
	After=network.target

	[Service]
	Type=simple
	User=root
	Restart=on-failure
	ExecStart=/root/binlog_streaming/bin/binlog_to_local.sh /root/binlog_streaming/conf/%i.conf
	CREATE TABLE t_win(x int AUTO_INCREMENT PRIMARY KEY);


	INSERT INTO t_win
	VALUES (1),
	(2),
	(3),
	(4),
	(5),
	(6),
	create database mds;

	SET GLOBAL log_bin_trust_function_creators = 1;
	USE mds;

	DROP FUNCTION IF EXISTS get_gtid_to_skip;
	DELIMITER \|
	CREATE FUNCTION get_gtid_to_skip()
	RETURNS LONGTEXT
	BEGIN
	#!/bin/bash

	if [ $# -eq 0 ]
	then
	echo "A configuration file is required"
	exit 1
	fi

	CONF_FILE=$1
	<html>
	<header>
	<title>PHP on OCI with MySQL Database Service</title>
	</header>
	<body>
	<center><h1>PHP on OCI with MySQL Database Service</h1></center>
	<hr>
	<?php
	$user = "";
	$pwd = "";