- discuss - lists.mariadb.org

[Maria-discuss] Question about Galera "pc.recovery" feature
by Marco Nicosia 05 Jun '15

05 Jun '15

Hi all! We recently discovered the configuration wsrep_provider_options="pc.recovery=TRUE" and set about to set this configuration, as we'd like to avoid unnecessary boostrapping whenever possible. We were further surprised to discover that this feature had been enabled by default. But we were frustrated in our attempts to trigger this feature to actually observe it in action. I understand that the feature is intended to recover from full cluster crashes _such as_ a power outage, but we were unable to come up with a scenario in which we could interrupt the cluster and watch it recover automatically. This included deploying to AWS and setting all three nodes to 'stop' then 'start.' In each instance, we had to manually bootstrap. Am I misunderstanding the feature, or the conditions under which we can trigger it? -- Marco Nicosia Product Manager Pivotal Software, Inc. mnicosia(a)pivotal.io c: 650-796-2948

2 1

[Maria-discuss] MariaDB 10.1.5 now available
by Daniel Bartholomew 04 Jun '15

04 Jun '15

The MariaDB project is pleased to announce the immediate availability of MariaDB 10.1.5. This is a Beta release. See the Release Notes and Changelog for details. - - Links - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - MariaDB 10.1.5 - Release Notes: https://mariadb.com/kb/en/mariadb-1015-release-notes - Changelog: https://mariadb.com/kb/en/mariadb-1015-changelog - Downloads: https://downloads.mariadb.org/mariadb/10.1.5 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

1 0

[Maria-discuss] New Question: Switch over at a database level
by AskMonty KB 04 Jun '15

04 Jun '15

Hello, A new question has been asked in "Standard Replication" by mahoarita. Please answer it at http://mariadb.com/kb/en/switch-over-at-a-database-level/ as the person asking the question may not be subscribed to the mailing list. -------------------------------- Is it possible to switch over an individual database? For example, with the below scenario: - I have 3-server replication - Server contains multiple databases owned by different users I'd like to manually switch over only one database, "MyDb1" as a failover test. The rest of the databases residing on the same MariaDB server should not be impacted. This is to minimize the impact to other databases for failover test exercise. Is this possible by Standard Replication? I'd be grateful for this information. -------------------------------- To view or answer this question please visit: http://mariadb.com/kb/en/switch-over-at-a-database-level/

1 0

[Maria-discuss] New Question: Autoinstall ODBC
by AskMonty KB 03 Jun '15

03 Jun '15

Hello, A new question has been asked in "MariaDB Connector/ODBC" by leopoldotaylhardat. Please answer it at http://mariadb.com/kb/en/autoinstall-odbc/ as the person asking the question may not be subscribed to the mailing list. -------------------------------- How can I install ODBC in silent mode with command line (windows) options? -------------------------------- To view or answer this question please visit: http://mariadb.com/kb/en/autoinstall-odbc/

1 0

[Maria-discuss] Unknown crash
by Irwanto 03 Jun '15

03 Jun '15

My Server :Windows 2003 R2RAM 4GMariaDB 10.0.19 01 June i'm sure i shutdown normally02 June is holiday03 June i see "crash recovery" in log file i'm sure disk is ok with chkdsk e: sometime i get this word in log file, so what caused this here my log 150601 20:17:10 [Note] InnoDB: Using mutexes to ref count buffer pool pages150601 20:17:10 [Note] InnoDB: The InnoDB memory heap is disabled150601 20:17:10 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions150601 20:17:10 [Note] InnoDB: Memory barrier is not used150601 20:17:10 [Note] InnoDB: Compressed tables use zlib 1.2.3150601 20:17:10 [Note] InnoDB: Not using CPU crc32 instructions150601 20:17:10 [Note] InnoDB: Initializing buffer pool, size = 1008.0M150601 20:17:10 [Note] InnoDB: Completed initialization of buffer pool150601 20:17:10 [Note] InnoDB: Highest supported file format is Barracuda.150601 20:17:10 [Note] InnoDB: 128 rollback segment(s) are active.150601 20:17:10 [Note] InnoDB: Waiting for purge to start150601 20:17:10 [Note] InnoDB: Percona XtraDB (http://www.percona.com) 5.6.23-72.1 started; log sequence number 10406975924150601 20:17:11 [Note] Server socket created on IP: '0.0.0.0'.150601 20:17:11 [Warning] 'proxies_priv' entry '@% root@kutu' ignored in --skip-name-resolve mode.150601 20:17:11 [Note] Event Scheduler: Loaded 0 events150601 20:17:11 [Note] E:\smart\smart_database_mariadb.10\bin\mysqld.exe: ready for connections.Version: '10.0.19-MariaDB-log' socket: '' port: 3309 mariadb.org binary distribution150601 20:22:11 [Note] feedback plugin: report to 'https://mariadb.org/feedback_plugin/post' was sent150601 20:22:14 [Note] feedback plugin: server replied 'ok'150601 20:33:39 [Note] E:\smart\smart_database_mariadb.10\bin\mysqld.exe: Normal shutdown 150601 20:33:39 [Note] Event Scheduler: Purging the queue. 0 events150601 20:34:02 [ERROR] feedback plugin: ssl failed for url 'https://mariadb.org/feedback_plugin/post' CryptGenRandom error150601 20:34:02 [Note] InnoDB: FTS optimize thread exiting.150601 20:34:02 [Note] InnoDB: Starting shutdown...150603 7:12:49 [Note] InnoDB: Using mutexes to ref count buffer pool pages150603 7:12:49 [Note] InnoDB: The InnoDB memory heap is disabled150603 7:12:49 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions150603 7:12:49 [Note] InnoDB: Memory barrier is not used150603 7:12:49 [Note] InnoDB: Compressed tables use zlib 1.2.3150603 7:12:50 [Note] InnoDB: Not using CPU crc32 instructions150603 7:12:50 [Note] InnoDB: Initializing buffer pool, size = 1008.0M150603 7:12:50 [Note] InnoDB: Completed initialization of buffer pool150603 7:12:50 [Note] InnoDB: Highest supported file format is Barracuda.150603 7:12:50 [Note] InnoDB: The log sequence numbers 10406975924 and 10406975924 in ibdata files do not match the log sequence number 10407001762 in the ib_logfiles!150603 7:12:50 [Note] InnoDB: Database was not shutdown normally!150603 7:12:50 [Note] InnoDB: Starting crash recovery.150603 7:12:50 [Note] InnoDB: Reading tablespace information from the .ibd files...150603 7:13:01 [Note] InnoDB: Restoring possible half-written data pages 150603 7:13:01 [Note] InnoDB: from the doublewrite buffer...InnoDB: Last MySQL binlog file position 0 11515, file name E:\smart\smart_database_mariadb.10\repl\KMS-PLB-bin.000001150603 7:13:02 [Note] InnoDB: 128 rollback segment(s) are active.150603 7:13:02 [Note] InnoDB: Waiting for purge to start150603 7:13:02 [Note] InnoDB: Percona XtraDB (http://www.percona.com) 5.6.23-72.1 started; log sequence number 10407001762150603 7:13:03 [Note] Server socket created on IP: '0.0.0.0'.150603 7:13:03 [Warning] 'proxies_priv' entry '@% root@kutu' ignored in --skip-name-resolve mode.150603 7:13:03 [Note] Event Scheduler: Loaded 0 events150603 7:13:03 [Note] E:\smart\smart_database_mariadb.10\bin\mysqld.exe: ready for connections.Version: '10.0.19-MariaDB-log' socket: '' port: 3309 mariadb.org binary distribution150603 7:18:03 [Note] feedback plugin: report to 'https://mariadb.org/feedback_plugin/post' was sent150603 7:18:04 [Note] feedback plugin: server replied 'ok'

1 0

[Maria-discuss] security scans: 5.5.5-10.0.19 should be 5.5.43-10.0.19
by Reindl Harald 01 Jun '15

01 Jun '15

[harry@rh:~]$ telnet localhost 3306 Trying 127.0.0.1... Connected to localhost. Escape character is '^]'. ] 5.5.5-10.0.19-MariaDB the 5.5.5 srting leads in false positives for security scans and while i reported that to OpenVAS the correct soultion would be updating the 5.5.5 string to the latest 5.5x release instead "Fix" each scanner out there Medium (CVSS: 4.0) NVT: MariaDB 'COM_CHANGE_USER' Command Insecure Salt Generation Security Bypass Vuln... (OID: 1.3.6.1.4.1.25623.1.0.804037) Solution Upgrade to MariaDB version 5.2.14, 5.3.12, 5.5.29 or later, For updates refer to https://mariadb.org Medium (CVSS: 5.0) NVT: MariaDB Denial Of Service Vulnerability (Windows) (OID: 1.3.6.1.4.1.25623.1.0.804035) Solution Upgrade to MariaDB 5.1.68, 5.2.15, 5.3.13, 5.5.30 or later, For updates refer to https://mariadb.org Product detection result: cpe:/a:mariadb:mariadb:5.5.5- by MySQL/MariaDB Detection (OID: 1.3.6.1.4.1.25623.1.0.100152)

2 1

Re: [Maria-discuss] Dynamic Columns ORM
by Tom Worster 23 May '15

23 May '15

Hi Daniel, Yes, I shall add remarks about indexes to the docs. I didn't have any purpose for "token" other than I needed a name for the strings that go in the SQL that refer to dynamic columns. Is there a problem with that particular word or do you think it would be better to do without any such name? You're spot on about computed columns. From my point of view, doing that amounts to adding the column to the schema. The column name appears in DDL and the corresponding attribute is therefore no longer ad hoc in the the application. The same point applies (in some imaginary future) to adding an index to a dynamic column without needing a computed column. If attributes represented in the application are to be truly fluid then their corresponding dynamic column cannot be indexed, at least not as I understand indexes in MySQL. Thanks for taking a look. Tom From: Daniel Black <daniel.black(a)openquery.com.au> Date: Saturday, May 23, 2015 at 1:27 AM To: Tom Worster <fsb(a)thefsb.org>, maria-discuss email list <maria-discuss(a)lists.launchpad.net> Subject: Re: [Maria-discuss] Dynamic Columns ORM They are generally good for blob like information that is generally retrieved in a query with some structure around name->value pairs. You mentioned (forum) that there isn't an index on these items so you'll get more row scanning on these if people search on a Dynamic attribute tokens (not sure why you are adding "token" to the language here). This limitation to be mentioned more in the documentation you've written. You could use computed columns to extract a variable to index if really needed but you'll need to ask why isn't it a column in its own right. https://mariadb.com/kb/en/mariadb/virtual-computed-columns/ Enhancing frameworks to expose database features is a good thing as they often get omitted in the reduction to the lowest common factor (mysql-5.0?) and sometimes the lowest common factor across db implementations (ansi SQL(?)). -- -- Daniel Black, Engineer @ Open Query (http://openquery.com.au) Remote expertise & maintenance for MySQL/MariaDB server environments.

2 1

[Maria-discuss] Dynamic Columns ORM
by Tom Worster 23 May '15

23 May '15

In January I was asking about Dynamic Columns because I had started working on an ORM extension for it. It is now tagged 0.1.0 in Github. There probably aren't many here using Yii Framework but at least this shows that some of us like and use Maria's Dynamic Columns. Thank you, Maria. I already got some feedback on IRC from Kolbe who hated it :'( and we'd welcome more of the same :-) https://github.com/tom--/dynamic-ar Yii Framework forum thread: http://www.yiiframework.com/forum/index.php/topic/63995-/ Previous thread started here: https://lists.launchpad.net/maria-discuss/msg02159.html tom[] The empty array without a dollar sign

2 1

[Maria-discuss] mysqldump Spider tables
by Nicolas Payart 21 May '15

21 May '15

Hi list, I am using Spider Storage Engine for multiple purpose. I often create spider tables as a drop-in replacement for Federated(x) tables. But one main difference I notice using spider SE vs Federated is that mysqldump dumps the whole data of remote spider tables whereas it only dumps the table schema of federated tables. I expected these two close storage engines to behave similarly... Is this an expected behaviour of Spider SE (and/or mysqldump)? Is there a workaround to make mysqldump dump only schema of Spider tables, just like it would do with a federated table? Of course, I can use the --no-data option but it's a bit annoying when you have a mix of innodb tables and spider tables in the same database. Thanks, -- Nicolas

2 2

[Maria-discuss] Query Cache with TTL and unconsistent values - remove memcache servers
by Roberto Spadim 20 May '15

20 May '15

Hi guys! I created a MDEV (feature request) sometime ago, https://mariadb.atlassian.net/browse/MDEV-6777 There's a patch ( http://ebergen.net/wordpress/2007/04/23/select-sql_cache_ttl/) but i want change a bit to work "better", it's using "SELECT SQL_CACHE_TTL ..." hint, and could be better change it to "SELECT SQL_CACHE_TTL=9999 ..." to easily change TTL instead of a fixed TTL set by "SET ttl=999;SELECT SQL_CACHE_TTL ..." query, could anyone help me with it? Why? With this we can reduce the memcache use in small/medium systems, reducing app side caching code too the difference between query cache and query cache with ttl is how it's removed from cache, one is removed with table invalidation (consistent cache), and other is removed with time to live even if table change (unconsistent cache) =] help is welcome, thnks guys -- Roberto Spadim

1 0