← Back to branch summary

~giuseppe-maxia/mysql-sandbox/mysql-sandbox-3

« back to all changes in this revision

Viewing changes to drafts/plugin.conf

  • Committer: Giuseppe Maxia
  • Date: 2010-05-24 20:30:20 UTC
  • Revision ID: g.maxia@gmail.com-20100524203020-fznam8olowxn2363
- Fixed bug in ./clear script. In version 5.5 and bigger, it erased the performance_schema database, which should not be removed. If it exists, its tables are now truncated.
- Fixed bug in ./clear script. The removal of databases was not executed in a clean mode.
- Added a script to install plugins in ./drafts 

Show diffs side-by-side

added added

removed removed

Lines of Context:
drafts/plugin.conf
 
1
$plugin_definition = 
 
2
{
 
3
innodb =>    {
 
4
    minimum_version => '5.1.45',
 
5
    all_servers => 
 
6
        {
 
7
        operation_sequence => [qw(stop options_file start sql_commands )],
 
8
        options_file => 
 
9
            [
 
10
            'ignore_builtin_innodb',
 
11
            'plugin-load='
 
12
             .'innodb=ha_innodb_plugin.so;'
 
13
             .'innodb_trx=ha_innodb_plugin.so;'
 
14
             .'innodb_locks=ha_innodb_plugin.so;'
 
15
             .'innodb_lock_waits=ha_innodb_plugin.so;'
 
16
             .'innodb_cmp=ha_innodb_plugin.so;'
 
17
             .'innodb_cmp_reset=ha_innodb_plugin.so;'
 
18
             .'innodb_cmpmem=ha_innodb_plugin.so;'
 
19
             .'innodb_cmpmem_reset=ha_innodb_plugin.so',
 
20
            'default-storage-engine=InnoDB',
 
21
            'innodb_file_per_table=1',
 
22
            'innodb_file_format=barracuda',
 
23
            'innodb_strict_mode=1',
 
24
            ],
 
25
        sql_commands => 
 
26
            [
 
27
                'select @@innodb_version;',
 
28
            ],
 
29
        startup_file => [ ],
 
30
        },
 
31
    },
 
32
semisynch => {
 
33
    minimum_version => '5.5.2',
 
34
 
 
35
    master => 
 
36
        {
 
37
            operation_sequence => [qw(stop options_file start sql_commands )],
 
38
            options_file => 
 
39
                [
 
40
                'plugin-load=rpl_semi_sync_master=semisync_master.so',
 
41
                'rpl_semi_sync_master_enabled=1'
 
42
                ],
 
43
            sql_commands => 
 
44
                [
 
45
                    'select @@rpl_semi_sync_master_enabled;'
 
46
                ],
 
47
            startup_file => []
 
48
        },
 
49
    slave => 
 
50
        {
 
51
            operation_sequence => [qw(stop options_file start sql_commands )],
 
52
            options_file => 
 
53
                [
 
54
                'plugin-load=rpl_semi_sync_slave=semisync_slave.so',
 
55
                'rpl_semi_sync_slave_enabled=1'
 
56
                ],
 
57
            sql_commands => 
 
58
                [
 
59
                    'select @@rpl_semi_sync_slave_enabled;'
 
60
                ],
 
61
            startup_file => []
 
62
        },
 
63
    },
 
64
gearman =>    {
 
65
    minimum_version => '5.0',
 
66
    all_servers => 
 
67
        {
 
68
        operation_sequence => [qw(start sql_commands options_file 
 
69
                                startup_file restart )],
 
70
        options_file => 
 
71
            [
 
72
            'init-file=startup.sql'
 
73
            ],
 
74
        sql_commands => 
 
75
            [
 
76
            'CREATE FUNCTION gman_do RETURNS STRING
 
77
                SONAME "libgearman_mysql_udf.so";',
 
78
            'CREATE FUNCTION gman_do_high RETURNS STRING
 
79
                SONAME "libgearman_mysql_udf.so";',
 
80
            'CREATE FUNCTION gman_do_low RETURNS STRING
 
81
                SONAME "libgearman_mysql_udf.so";',
 
82
            'CREATE FUNCTION gman_do_background RETURNS STRING
 
83
                SONAME "libgearman_mysql_udf.so";',
 
84
            'CREATE FUNCTION gman_do_high_background RETURNS STRING
 
85
                SONAME "libgearman_mysql_udf.so";',
 
86
            'CREATE FUNCTION gman_do_low_background RETURNS STRING
 
87
                SONAME "libgearman_mysql_udf.so";',
 
88
            'CREATE AGGREGATE FUNCTION gman_sum RETURNS INTEGER
 
89
                SONAME "libgearman_mysql_udf.so";',
 
90
            'CREATE FUNCTION gman_servers_set RETURNS STRING
 
91
                SONAME "libgearman_mysql_udf.so";',                
 
92
            ],
 
93
        startup_file => 
 
94
            [ 
 
95
            'set @a := (select gman_servers_set("127.0.0.1"));',
 
96
            'use test ;',
 
97
            'create table if not exists startup (msg text, ts timestamp);',
 
98
            'insert into startup (msg) values (@a);',
 
99
            ]
 
100
        },
 
101
    },
 
102
};
 
103