Failed to load slave replication state from table mysql.gtid_slave_pos: 1146: Table 'mysql.gtid_slave_pos' doesn't exist
http://anothermysqldba.blogspot.com/2013/06/mariadb-1003-alpha-install-on-fedora-17.html
MariaDB 10.0.3 Alpha install on Fedora 17 x86_64
MariaDB 10.0.3 Alphawas just released.
So for those of you that recall my previous MariaDB 5.5 install post, I decided to see how it works with 10.0.3.
I like some of the features that are going into the MariaDB and Percona releases. Even if you are a big supporter of MySQL, when features are available in these releases that are not being back ported into MySQL releases DBAs have to review their options and make a choice.
So the install....
As I said before from the previous post I have this installed. So I will just to an upgrade first.
[root@Fedora64 10]# rpm -qa | grep maria
mariadb-5.5.31-1.fc17.x86_64
mariadb-server-5.5.31-1.fc17.x86_64
mariadb-libs-5.5.31-1.fc17.x86_64
mariadb-bench-5.5.31-1.fc17.x86_64
mariadb-devel-5.5.31-1.fc17.x86_64
So packages conflicted at the start.
MariaDB-10.0.3-fedora17-x86_64-client.rpm
MariaDB-10.0.3-fedora17-x86_64-common.rpm
MariaDB-10.0.3-fedora17-x86_64-compat.rpm
MariaDB-10.0.3-fedora17-x86_64-connect-engine.rpm
MariaDB-10.0.3-fedora17-x86_64-devel.rpm
MariaDB-10.0.3-fedora17-x86_64-server.rpm
MariaDB-10.0.3-fedora17-x86_64-shared.rpm
MariaDB-10.0.3-fedora17-x86_64-test.rpm
[root@Fedora64 10]# rpm -Uhv *.rpm
warning: MariaDB-10.0.3-fedora17-x86_64-client.rpm: Header V3 DSA/SHA1 Signature, key ID 1bb943db: NOKEY
error: Failed dependencies:
libodbc.so.2()(64bit) is needed by MariaDB-connect-engine-10.0.3-1.x86_64
MySQL-devel conflicts with (installed) mariadb-devel-5.5.31-1.fc17.x86_64
MariaDB-server-10.0.3-1.x86_64 conflicts with file from package mariadb-server-5.5.31-1.fc17.x86_64
[root@Fedora64 10]#
So this is just a Virtualbox instance,
for demo and
evaluation, so I just removed all that I could and had to uninstall. I
was hopeful that an upgrade would work but this is Alpha code still.
ie:
[root@Fedora64 10]# rpm -e mariadb mariadb-server mariadb-bench
[root@Fedora64 10]# rpm -e mariadb-libs perl-DBD-MySQL percona-xtrabackup
So now that the past is cleared out...
[root@Fedora64 10]# rpm -ihv *.rpm
Preparing... ########################################### [100%]
1:MariaDB-common ########################################### [ 11%]
2:MariaDB-server ########################################### [ 22%]
3:MariaDB-cassandra-engin########################################### [ 33%]
4:MariaDB-client ########################################### [ 44%]
5:MariaDB-devel ########################################### [ 56%]
6:MariaDB-shared ########################################### [ 67%]
7:MariaDB-test ########################################### [ 78%]
8:MariaDB-compat ########################################### [ 89%]
9:galera ########################################### [100%]
If you recall the past post, I got the init.d script this time..
[root@Fedora64 10]# /etc/init.d/mysql start
Starting MySQL..... SUCCESS!
[root@Fedora64 10]# mysql
Welcome to the MariaDB monitor. Commands end with ; or \g.
Your MariaDB connection id is 2
Server version: 10.0.3-MariaDB MariaDB Server
If they are not terrible on performance then I do not see why these are not on by default:
vi /etc/my.cnf
[mysqld]
userstat=1
# http://www.percona.com/doc/percona-server/5.5/diagnostics/user_stats.html?id=percona-server:features:userstatv2
# https://kb.askmonty.org/en/user-statistics/
feedback=ON
# https://kb.askmonty.org/en/user-feedback-plugin/
MariaDB [(none)]> show variables like '%feedback%';
+--------------------------+------------------------------------------+
| Variable_name | Value |
+--------------------------+------------------------------------------+
| feedback_send_retry_wait | 60 |
| feedback_send_timeout | 60 |
...
| feedback_url | https://mariadb.org/feedback_plugin/post |
| feedback_user_info | |
+--------------------------+------------------------------------------+
MariaDB [(none)]> show variables like '%userstat%';
+---------------+-------+
| Variable_name | Value |
+---------------+-------+
| userstat | ON |
+---------------+-------+
Issues I found 30seconds after install...:
MariaDB [(none)]> show variables;
ERROR 1946 (HY000): Failed to load replication slave GTID position from table mysql.gtid_slave_pos
That is it so far... I have it installed and can review now...
UPDATE:
I have submitted this as a bug.
The MariaDB team got right back to me and pointed out that I failed to
run mysql_upgrade and restart. That fixed the Error listed above. Still
variables feels like it should show everything it has but this is a
valid fix and mistake on my part. Thank you to the MariaDB team.
To learn more:
最新文章
- Koala – 开源的前端预处理器语言图形编译工具
- JavaMelody应用监控使用指南
- sql注入学习小结
- sql存储过程传入ID集合,和临时表的使用
- (1)创建一个叫做机动车的类: 属性:车牌号(String),车速(int),载重量(double) 功能:加速(车速自增)、减速(车速自减)、修改车牌号,查询车的载重量。 编写两个构造方法:一个没有形参,在方法中将车牌号设置“XX1234”,速 度设置为100,载重量设置为100;另一个能为对象的所有属性赋值; (2)创建主类: 在主类中创建两个机动车对象。
- java调优随记-堆和栈
- 【HDU1231】How Many Tables(并查集基础题)
- PHP获取POST方式的XML数据
- js的dom操作和函数
- HashMap,LinkedHashMap,TreeMap对比
- Java基础知识回顾之一 ----- 基本数据类型
- 简单gitblit与Jenkins结合,持续集成
- System.DllNotFoundException: Unable to load DLL 'libgdiplus': The specified module could not be found.
- 一文了解Python中的循环(for while break continue 嵌套循环...)
- HTML,CSS笔记
- 利用maven的profiles灵活的配置多环境
- SQL 必知必会&#183;笔记<;8>;分组数据
- jmeter ---监控服务器CPU, 内存,网络数据
- 基于结构化平均感知机的分词器Java实现
- Android中的各种访问权限Permission含义