November 2015 - discuss - lists.mariadb.org

[Maria-discuss] Galera 23.2.7 mariadb 5.5.33a msvc 1600 binaries available
by Yann Nayn 18 Nov '24

18 Nov '24

Binaries have been uploaded for both x86 and amd64 platforms. due to github file size limitations , the directories have been uploaded unarchived. for Win33 binaries , please checkout https://github.com/YannNayn/galera-mariadb-win32.git and for Win64(amd64) binaries (being uploaded/pushed): https://github.com/YannNayn/galera-mariadb-win64.git they are not recommended for a production environment. in the my.cnf file: _________ wsrep_provider=galera_smm.dll wsrep_sst_method=msqldump # percona xtrabackup will be tested soon _________ libevent and openssl(the provided binaries use respectively 2.1.3-alpha and 1.1.0-dev versions ) will be added next on github some limitations are stated on openssl website copied here for convenience: ____________ from http://www.openssl.org/ ____________ This software package uses strong cryptography, so even if it is created, maintained and distributed from liberal countries in Europe (where it is legal to do this), it falls under certain export/import and/or use restrictions in some other parts of the world. PLEASE REMEMBER THAT EXPORT/IMPORT AND/OR USE OF STRONG CRYPTOGRAPHY SOFTWARE, PROVIDING CRYPTOGRAPHY HOOKS OR EVEN JUST COMMUNICATING TECHNICAL DETAILS ABOUT CRYPTOGRAPHY SOFTWARE IS ILLEGAL IN SOME PARTS OF THE WORLD. SO, WHEN YOU IMPORT THIS PACKAGE TO YOUR COUNTRY, RE-DISTRIBUTE IT FROM THERE OR EVEN JUST EMAIL TECHNICAL SUGGESTIONS OR EVEN SOURCE PATCHES TO THE AUTHOR OR OTHER PEOPLE YOU ARE STRONGLY ADVISED TO PAY CLOSE ATTENTION TO ANY EXPORT/IMPORT AND/OR USE LAWS WHICH APPLY TO YOU. THE AUTHORS OF OPENSSL ARE NOT LIABLE FOR ANY VIOLATIONS YOU MAKE HERE. SO BE CAREFUL, IT IS YOUR RESPONSIBILITY. ________________________________________________ msvc 1600 redistributables SP1 need to be installed/available on the target machine: vcredist_x86.exe : http://www.microsoft.com/en-us/download/details.aspx?id=8328 vcredist_x64.exe : http://www.microsoft.com/en-us/download/details.aspx?id=13523 MSys binaries are provided and msqld.bat should then be used instead of mysqld.exe (e.g. mysld.bat --console --wsrep_cluster_address=gcomm:// ) in order to have a working sh shell(cygwin has been proved to do it as well) Please note that oqgraph is disabled (boost trunk is used , that is 1.55) Comments and suggestions are welcome.

2 1

[Maria-discuss] why stdout? -> [Note] /usr/libexec/mysqld (mysqld 10.0.20-MariaDB) starting as process 115096
by Reindl Harald 05 Jul '20

05 Jul '20

Aug 6 12:24:24 testserver mysqld: 150806 12:24:24 [Note] /usr/libexec/mysqld (mysqld 10.0.20-MariaDB) starting as process 115096 ... why is this now stdout instead mysql logs? on systemd based distributions that spits now to the global syslog and finally on machines restarting 2 instances every hour for backup reasons it annoys until 10.0.19 or 10.0.20 that was not this way

5 13

[Maria-discuss] New mariadb.org in the works
by Otto Kekäläinen 18 Dec '15

18 Dec '15

Hello! We are about to renew the mariadb.org website. The idea is to replace the current mariadb.org and blog.mariadb.org with one single site that includes both the basic information about the software project and the MariaDB Foundation, as well as the blog. Work in progress is visible at https://new.mariadb.org/ Please send us your feedback!

1 1

[Maria-discuss] MariaDB 10.1.8 Stable (GA) now available
by Daniel Bartholomew 10 Dec '15

10 Dec '15

The MariaDB project is pleased to announce the immediate availability of MariaDB 10.1.8. This is the first Stable (GA) release in the MariaDB 10.1 series. See the Release Notes and Changelog for details. - - Links - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - MariaDB 10.1.8 - Release Notes: https://mariadb.com/kb/en/mariadb-1018-release-notes - Changelog: https://mariadb.com/kb/en/mariadb-1018-changelog - Downloads: https://downloads.mariadb.org/mariadb/10.1.8 About MariaDB 10.1: - https://mariadb.com/kb/en/what-is-mariadb-101/ APT and YUM Repository Configuration Generator: - https://downloads.mariadb.org/mariadb/repositories/ - - MariaDB Webinars - - - - - - - - - - - - - - - - - - - - - - - - - There are several upcoming MariaDB-focused webinars and many previously held ones available to watch on an on-demand basis at: - https://mariadb.com/news-events/webinars - - MariaDB Books - - - - - - - - - - - - - - - - - - - - - - - - - - There is an ever-growing library of MariaDB books available to help you get the most out of MariaDB. See the MariaDB Books page for details and links: - https://mariadb.com/kb/en/mariadb/books/ - - User Feedback plugin - - - - - - - - - - - - - - - - - - - - - - - MariaDB includes a User Feedback plugin. This plugin is disabled by default. If enabled, it submits basic, completely anonymous MariaDB usage information. This information is used by the developers to track trends in MariaDB usage to better guide development efforts. If you would like to help make MariaDB better, please add "feedback=ON" to your my.cnf or my.ini file! See http://mariadb.com/kb/en/user-feedback-plugin for more information. - - Quality - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - The project always strives for quality, but in reality, nothing is perfect. Please take time to report any issues you encounter at: - http://mariadb.org/jira - - Support MariaDB - - - - - - - - - - - - - - - - - - - - - - - - - - If you would like to contribute to the MariaDB Foundation, please see the "contributing" and "donations" pages. We also have merchandise available in a cafepress store. All proceeds go to support the MariaDB Foundation. - https://mariadb.com/kb/en/contributing - https://mariadb.org/en/donate/ We hope you enjoy MariaDB! -- MariaDB Website - http://mariadb.org Twitter - http://twitter.com/mariadb Google+ - http://google.com/+mariadb Facebook - http://fb.com/MariaDB.dbms Knowledge Base - http://mariadb.com/kb

6 9

[Maria-discuss] replicate_rewrite_db as a system variable
by Ian Gilfillan 27 Nov '15

27 Nov '15

Is there a reason replicate_rewrite_db is not available as a system variable, while other similar settings, such as replicate_do_db are?

2 1

[Maria-discuss] New Question: Moving from Oracle to MariaDB
by AskMonty KB 27 Nov '15

27 Nov '15

1 0

[Maria-discuss] New Question: How to install MariaDB Galera without internet connection( without YUM)?
by AskMonty KB 25 Nov '15

25 Nov '15

Hello, A new question has been asked in "MariaDB Galera Cluster" by pluto0327. Please answer it at http://mariadb.com/kb/en/how-to-install-mariadb-galera-without-internet-con… as the person asking the question may not be subscribed to the mailing list. -------------------------------- Hi guys, I want to install a HA ( high availability ) environment without internet, but I am a rookie. Most webs, I can't find relative information how to do this job. First, how to do with step by step instructions, please? Second, is it correct that I must have 4 PCs ( 3 cluster nodes and 1 HA proxy)? -------------------------------- To view or answer this question please visit: http://mariadb.com/kb/en/how-to-install-mariadb-galera-without-internet-con…

1 0

[Maria-discuss] MariaDB and Galera Support from Redhat (instead of MariaDB corp)
by Lukas Lehner 25 Nov '15

25 Nov '15

Hi we run DBaaS (Galera Cluster) with growing customer base. We also offer MongoDB, where we have commercial support from MongoDB (we can recommend it). MariaDB is included in RHEL, so Red Hat offers support. We anyway pay for Redhat support. So it means we don't need to buy support from MariaDB? Does Redhat employs MariaDB developers and have DBA/Expert know how? Lukas

2 2

[Maria-discuss] Creating MySQL .MYD, .MYI and .frm tables in Maria
by Carl Whalley 25 Nov '15

25 Nov '15

This is the final stage from my thread regarding a botched F22->23 upgrade which hosed bacula. I have been on to bacula support and they claim not to support Maria. Well, "not support" isn't right, just "not explicitly tested" - I know everything was ok under F22/Maria as I have another server to upgrade which runs fine now with this setup. It seems the MySQL tables were created when bacula was installed several iterations of Fedora ago, and at that time they were of the .MYD, .MYI style. Each time fedora was updated, these were carried forwards - possibly through the swap from when MySQL was native to it becoming Maria, as we see now. That's why all the existing ones are in the form with the extensions I mentioned. So, I'm now in a situation where it seems I have to create one last table ("Snapshot") and am having trouble because it somehow has been created but not in the .MYD, MYI style. The create table command is supplied already for me to enter - how can I remove the phantom one and create it again in the format the rest of the tables are in please?

2 1

[Maria-discuss] After Fedora 22->23 update maria db doesn't start
by Carl Whalley 24 Nov '15

24 Nov '15

>From the log after systemctl restart mariadb.service: InnoDB: wrong number of columns in SYS_INDEXES record 151124 9:51:40 [Note] InnoDB: Percona XtraDB (http://www.percona.com) 5.6.25-73.1 started; log sequence number 583845802 151124 9:51:40 [Note] Plugin 'FEEDBACK' is disabled. InnoDB: wrong number of columns in SYS_INDEXES record 151124 9:51:40 [Warning] InnoDB: Cannot open table mysql/plugin from the internal data dictionary of InnoDB though the .frm file for the table exists. See http://dev.mysql.com/doc/refman/5.6/en/innodb-troubleshooting.html for how you can resolve the problem. 151124 9:51:40 [ERROR] Can't open the mysql.plugin table. Please run mysql_upgrade to create it. InnoDB: wrong number of columns in SYS_INDEXES record 151124 9:51:40 [Warning] InnoDB: Cannot open table mysql/servers from the internal data dictionary of InnoDB though the .frm file for the table exists. See http://dev.mysql.com/doc/refman/5.6/en/innodb-troubleshooting.html for how you can resolve the problem. 151124 9:51:40 [ERROR] Can't open and lock privilege tables: Table 'mysql.servers' doesn't exist in engine 151124 9:51:40 [Note] Server socket created on IP: '::'. 151124 9:51:40 [ERROR] Fatal error: mysql.user table is damaged or in unsupported 3.20 format. 151124 09:51:40 mysqld_safe mysqld from pid file /var/run/mariadb/mariadb.pid ended Trying other things [root@tiger ~]# mysqld_safe -uroot 151124 10:24:03 mysqld_safe Logging to '/var/log/mariadb/mariadb.log'. 151124 10:24:03 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql 151124 10:24:03 mysqld_safe mysqld from pid file /var/run/mariadb/mariadb.pid ended [root@tiger ~]# mysql_upgrade Version check failed. Got the following error when calling the 'mysql' command line client ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2 "No such file or directory") FATAL ERROR: Upgrade failed [root@tiger ~]#

3 11