- discuss - lists.mariadb.org

[Maria-discuss] MariaDB finally in Debian officially (Fwd: Debian 8 "Jessie" released)
by Otto Kekäläinen 27 Apr '15

27 Apr '15

Hello! Debian 8 "Jessie" has been released to today. It is the first official Debian release that ships with MariaDB (it has MariaDB 10.0.16 and MySQL 5.5.42). MariaDB client for C (the LGPL version) is also included. Release notes[1] state that in Debian 9 only one MySQL variant will be shipped. Hopefully the decision will tip towards MariaDB. The MariaDB "request for packaging" issue[2] was opened in bugs.debian.org in 2010. I started doing MariaDB packaging for Debian in 2013. The path here has been long and I am glad that this milestone is finally reached. [1] https://www.debian.org/releases/jessie/amd64/release-notes/ch-whats-new.en.… [2] https://bugs.debian.org/cgi-bin/bugreport.cgi?bug=565308 ---------- Forwarded message ---------- From: Paul Wise <pabs(a)debian.org> Date: 2015-04-26 5:28 GMT+03:00 Subject: Debian 8 "Jessie" released To: debian-announce(a)lists.debian.org ------------------------------------------------------------------------ The Debian Project https://www.debian.org/ Debian 8 "Jessie" released press(a)debian.org April 25th, 2015 https://www.debian.org/News/2015/20150426 ------------------------------------------------------------------------ After almost 24 months of constant development the Debian project is proud to present its new stable version 8 (code name "Jessie"), which will be supported for the next 5 years thanks to the combined work of the Debian Security team [1] and of the Debian Long Term Support [2] team. 1: http://security-team.debian.org/ 2: https://wiki.debian.org/LTS "Jessie" ships with a new default init system, systemd. The systemd suite provides many exciting features such as faster boot times, cgroups for services, and the possibility of isolating part of the services. The sysvinit init system is still available in "Jessie". The UEFI ("Unified Extensible Firmware Interface") support introduced in "Wheezy" has also been greatly improved in Jessie. This includes workarounds for many known firmware bugs, support for UEFI on 32-bit systems, and support for 64-bit kernels with 32-bit UEFI firmware (with the latter being included only on our amd64/i386 "multi-arch" installation media). Since the previous release, members of the Debian project have also made important improvements to our supporting services. One of these is a browsable view of all source code shipped in Debian [3] currently available at sources.debian.net [4]. Of course, with over 20,000 source packages, it can be quite daunting to locate the right file. Therefore, we are also very pleased to present Debian Code Search [5], available at codesearch.debian.net [6]. Both services are complemented by a completely rewritten and more reponsive package tracking system [7]. 3: https://www.debian.org/News/weekly/2013/14/#sources 4: https://sources.debian.net 5: https://www.debian.org/News/weekly/2014/17/#DCS 6: https://codesearch.debian.net/ 7: https://tracker.debian.org/ This release includes numerous updated software packages, such as: * Apache 2.4.10 * Asterisk 11.13.1 * GIMP 2.8.14 * an updated version of the GNOME desktop environment 3.14 * GNU Compiler Collection 4.9.2 * Icedove 31.6.0 (an unbranded version of Mozilla Thunderbird) * Iceweasel 31.6.0esr (an unbranded version of Mozilla Firefox) * KDE Plasma Workspaces and KDE Applications 4.11.13 * LibreOffice 4.3.3 * Linux 3.16.7-ctk9 * MariaDB 10.0.16 and MySQL 5.5.42 * Nagios 3.5.1 * OpenJDK 7u75 * Perl 5.20.2 * PHP 5.6.7 * PostgreSQL 9.4.1 * Python 2.7.9 and 3.4.2 * Samba 4.1.17 * Tomcat 7.0.56 and 8.0.14 * Xen Hypervisor 4.4.1 * the Xfce 4.10 desktop environment * more than 43,000 other ready-to-use software packages, built from nearly 20,100 source packages. With this broad selection of packages and its traditional wide architecture support, Debian once again stays true to its goal of being the universal operating system. It is suitable for many different use cases: from desktop systems to netbooks; from development servers to cluster systems; and for database, web, or storage servers. At the same time, additional quality assurance efforts like automatic installation and upgrade tests for all packages in Debian's archive ensure that "Jessie" fulfills the high expectations that users have of a stable Debian release. A total of ten architectures are supported: 32-bit PC / Intel IA-32 (i386), 64-bit PC / Intel EM64T / x86-64 (amd64), Motorola/IBM PowerPC (powerpc for older hardware and ppc64el for the new 64-bit (little- endian)), MIPS (mips (big-endian) and mipsel (little-endian)), IBM S/390 (64-bit s390x) and for ARM, armel and armhf for old and new 32-bit hardware, plus arm64 for the new 64-bit "AArch64" architecture. Want to give it a try? ---------------------- If you simply want to try Debian 8 "Jessie" without having to install it, you can use a special image, known as a live image, available for CDs, USB sticks, and netboot setups. Initially, these images are provided for the amd64 and i386 architectures only. It is also possible to use these live images to install Debian. More information is available from the Debian Live homepage [8]. 8: http://live.debian.net/ If, instead, you want to install it to your computer's permanent storage, you can choose from a range of installation media, such as Blu- ray Discs, DVDs, CDs, and USB sticks, or from the network. Several desktop environments — GNOME, KDE Plasma Desktop and Applications, Xfce, and LXDE — may be installed through CD images; the desired one may be chosen from the boot menus of the CDs/DVDs. In addition, multi- architecture CDs and DVDs are available which support installation of multiple architectures from a single disc. Or you can always create bootable USB installation media (see the Installation Guide [9] for more details). For cloud users Debian also offers pre-built OpenStack images [10], ready to use. 9: https://www.debian.org/releases/jessie/installmanual 10: http://cdimage.debian.org/cdimage/openstack/current/ The installation images may be downloaded right now via bittorrent [11] (the recommended method), jigdo [12], or HTTP [13]; see Debian on CDs [14] for further information. "Jessie" will soon be available on physical DVD, CD-ROM, and Blu-ray Discs from numerous vendors [15] too. 11: https://www.debian.org/CD/torrent-cd/ 12: https://www.debian.org/CD/jigdo-cd/#which 13: https://www.debian.org/CD/http-ftp/ 14: https://www.debian.org/CD/ 15: https://www.debian.org/CD/vendors Upgrading Debian ---------------- Upgrades to Debian 8 from the previous release, Debian 7 (codenamed "Wheezy"), are automatically handled by the apt-get package management tool for most configurations. As always, Debian systems may be upgraded painlessly, in place, without any forced downtime, but it is strongly recommended to read the release notes [16] as well as the installation guide [17] for possible issues, and for detailed instructions on installing and upgrading. The release notes will be further improved and translated to additional languages in the weeks after the release. 16: https://www.debian.org/releases/jessie/releasenotes 17: https://www.debian.org/releases/jessie/installmanual About Debian ------------ Debian is a free operating system, developed by thousands of volunteers from all over the world who collaborate via the Internet. The Debian project's key strengths are its volunteer base, its dedication to the Debian Social Contract and Free Software, and its commitment to provide the best operating system possible. Debian 8 is another important step in that direction. Contact Information ------------------- For further information, please visit the Debian web pages at https://www.debian.org/ or send mail to <press(a)debian.org>. -- To UNSUBSCRIBE, email to debian-announce-REQUEST(a)lists.debian.org with a subject of "unsubscribe". Trouble? Contact listmaster(a)lists.debian.org Archive: https://lists.debian.org/20150426022805.GA7860@chianamo -- Check out our blog at http://seravo.fi/blog and follow @ottokekalainen

3 5

[Maria-discuss] Proxy users in MariaDB?
by Felipe Gasper 24 Apr '15

24 Apr '15

Hello, Is it possible to emulate user roles via PROXY in MariaDB? Basically, I want to log in as “temp_w3gj6d6” but have the system treat that user as “frank”, including setting of DEFINERs and the like. I see that there is a PAM plugin in MariaDB .. has anyone used that plugin to achieve this effect? Thank you! -Felipe Gasper Houston, TX

3 9

[Maria-discuss] New Question: Executing: gpg --ignore-time-conflict
by AskMonty KB 23 Apr '15

23 Apr '15

Hello, A new question has been asked in "MariaDB Community" by zakaria. Please answer it at http://mariadb.com/kb/en/executing-gpg-ignore-time-conflict/ as the person asking the question may not be subscribed to the mailing list. -------------------------------- HI, I want to install mariadb in ubuntu server 12.04, but i get this error Executing: gpg --ignore-time-conflict --no-options --no-default-keyring --secret-keyring .... gpg: requesting key 1BB943DB from hkp server keyserver.ubuntu.com gpg: key 1BB943DB: "MariaDB Package Signing Key <package-signing-key(a)mariadb.org>" imported gpg: no ultimately trusted keys found gpg: Total number processed: 1 gpg: imported: 1 when I use this following command : apt-key adv --recv-keys --keyserver hkp://keyserver.ubuntu.com:80 0xcbcb082a1bb943db I tried to create a file with full key : 1993 69E5 404B D5FC 7D2F E43B CBCB 082A 1BB9 43DB but i got gpg:no valid openPGP data found. kind regards -------------------------------- To view or answer this question please visit: http://mariadb.com/kb/en/executing-gpg-ignore-time-conflict/

1 0

[Maria-discuss] tx_read_only Vs transaction_read_only
by Rhys Campbell 23 Apr '15

23 Apr '15

You cannot use the tx_read_only in the .cnf file. You must specifiy transaction_read_only = 1 for it to set the value of tx_read_only on system startup. Conversely we do not seem to be able to do... SET SESSION transaction_read_only = OFF; Is this intended? Rhys Campbell Database Administrator TradingScreen, Inc. 23 York House, 5th Floor London WC2B 6UJ Email: rhys.campbell(a)tradingscreen.com<mailto:rhys.campbell@tradingscreen.com> Follow TradingScreen on Twitter<http://twitter.com/#!/TradingScreen> , Facebook<http://www.facebook.com/pages/TradingScreen/214046251945650> and our blog Trading Smarter<tradingsmarter.tradingscreen.com> This message is intended only for the recipient(s) named above and may contain confidential information. If you are not an intended recipient, you should not review, distribute or copy this message. Please notify the sender immediately by e-mail if you have received this message in error and delete it from your system.

1 0

[Maria-discuss] How many open files by daemon is still sane?
by Honza Horak 22 Apr '15

22 Apr '15

Hey, with limited experiences with mariadb deployments, I'm wondering how many open files by the mysqld daemon is still sane (expected). We have a customer that reports hundreds of thousands of open files with 600 connections (thread_pool_max_threads is used). Those processes seem rather stalled, but files in the datadir are often opened 40.000 times. Is it even possible that one file is opened several times during processing one query? Or does it mean there are ~40.000 queries running? Version of MariaDB: 5.5.40 Honza

6 14

[Maria-discuss] garb: unrecognized service
by Umarzuki Mochlis 21 Apr '15

21 Apr '15

$ sudo service garb start garb: unrecognized service After I installed galera-3, the above error appeared when I tried to start garb service. OS: Ubuntu 14.04 galera-3 v25.3.9-trusty

2 1

[Maria-discuss] New Question: Is MariaDB Client Library for Java Applications working on JAVA 6?
by AskMonty KB 21 Apr '15

21 Apr '15

Hello, A new question has been asked in "MariaDB Java Client" by jihoonko. Please answer it at http://mariadb.com/kb/en/is-mariadb-client-library-for-java-applications-wo… as the person asking the question may not be subscribed to the mailing list. -------------------------------- Hi. Requirements for Latest version of MariaDB Client for java is written java 7 or 8. Which older version of MariaDB Client Library for java is working on java 6 well? Thank you. -------------------------------- To view or answer this question please visit: http://mariadb.com/kb/en/is-mariadb-client-library-for-java-applications-wo…

1 0

[Maria-discuss] New Question: How to cleanly uninstall MariaDB
by AskMonty KB 20 Apr '15

20 Apr '15

Hello, A new question has been asked in "MariaDB Documentation" by yaroslav_nikitenko_g. Please answer it at http://mariadb.com/kb/en/how-to-cleanly-uninstall-mariadb/ as the person asking the question may not be subscribed to the mailing list. -------------------------------- I've been using MariaDB on my server. It seemed to be hacked. I couldn't restart mariadb, and I deleted it with package manager yum. However, after reinstalling that I still experienced some problems (they didn't disappear). There is an opinion http://superuser.com/a/778269/387511 that some files such as databases are not removed during MariaDB uninstall. Is it true, and what should I take care of when uninstalling MariaDB? Thank you. I've used site search but couldn't find an answer in the official documentation. I suggest adding this to the part about installation of MariaDB. -------------------------------- To view or answer this question please visit: http://mariadb.com/kb/en/how-to-cleanly-uninstall-mariadb/

3 4

[Maria-discuss] What should offer base mariadb docker image
by Honza Horak 18 Apr '15

18 Apr '15

We're having quite interesting discussion about what users expect from general mariadb docker image, so trying to reach out (future) consumers. I see few options, from simple to feature rich scenarios, so let's take three examples.. A) simple one would only include installed packages and run the mysqld server with default configuration. (That one would probably be almost unusable, since users wouldn't have easy way to initialize datadir..) B) the image would include scripts that help to initialize datadir, set basic authentication (if given) and also offers to import some dump during initialization, e.g.: #> docker run -v /mydata:/var/lib/mysql mariadb #> docker run -v /mydata:/var/lib/mysql -v /dump.sql:/expected/dir mariadb #> docker run -e ROOT_PASS=abcdefgh -v /mydata:/var/lib/mysql mariadb C) full featured image that offers simple master/slave replication just by running: #> docker run -e TYPE=master mariadb #> docker run -e TYPE=slave -e MASTER=172.16.1.12 mariadb There are some advocates of the C) but IMHO it is not doable to deliver general enough solution for master/slave (thinking about failover scenarious in the first place), right? So B) sounds much more useful and I'd prefer such docker images. Does anybody has a different opinion? (either developer/user PoV would be welcome) Honza

2 1

[Maria-discuss] verifying a table is using autogenerated PK or not
by Umarzuki Mochlis 17 Apr '15

17 Apr '15

when I deleted a few rows, those rows did not get deleted on mariadb cluster second node. $ sudo grep "wsrep_certify_nonPK" /etc/mysql/my.cnf wsrep_certify_nonPK=1 > show create table comp2012db.uni12_jevents_vevdetail; +-------------------------+---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+ | Table | Create Table | +-------------------------+---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+ | uni12_jevents_vevdetail | CREATE TABLE `uni12_jevents_vevdetail` ( `evdet_id` int(12) NOT NULL AUTO_INCREMENT, `rawdata` longtext NOT NULL, `dtstart` int(11) NOT NULL DEFAULT '0', `dtstartraw` varchar(30) NOT NULL DEFAULT '', `duration` int(11) NOT NULL DEFAULT '0', `durationraw` varchar(30) NOT NULL DEFAULT '', `dtend` int(11) NOT NULL DEFAULT '0', `dtendraw` varchar(30) NOT NULL DEFAULT '', `dtstamp` varchar(30) NOT NULL DEFAULT '', `class` varchar(10) NOT NULL DEFAULT '', `categories` varchar(120) NOT NULL DEFAULT '', `color` varchar(20) NOT NULL DEFAULT '', `description` longtext NOT NULL, `geolon` float NOT NULL DEFAULT '0', `geolat` float NOT NULL DEFAULT '0', `location` varchar(120) NOT NULL DEFAULT '', `priority` tinyint(3) unsigned NOT NULL DEFAULT '0', `status` varchar(20) NOT NULL DEFAULT '', `summary` longtext NOT NULL, `contact` varchar(120) NOT NULL DEFAULT '', `organizer` varchar(120) NOT NULL DEFAULT '', `url` text NOT NULL, `extra_info` varchar(240) NOT NULL DEFAULT '', `created` varchar(30) NOT NULL DEFAULT '', `sequence` int(11) NOT NULL DEFAULT '1', `state` tinyint(3) NOT NULL DEFAULT '1', `modified` datetime NOT NULL DEFAULT '0000-00-00 00:00:00', `multiday` tinyint(3) NOT NULL DEFAULT '1', `hits` int(11) NOT NULL DEFAULT '0', `noendtime` tinyint(3) NOT NULL DEFAULT '0', PRIMARY KEY (`evdet_id`) ) ENGINE=InnoDB AUTO_INCREMENT=515 DEFAULT CHARSET=utf8 | +-------------------------+---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+ 1 row in set (0.00 sec) It seems that there's a PK. But what would cause this?

2 1