On 5 Чер, 22:16, Deepak Giridharagopal wrote:
> Roughly how many facts per node are we talking about, here? I could try
> running some simulations and see what happens.
On average 80-90 facts per host, it's about 1500 inserts per second.
Will mysql cope with the load? I plan migrate to MariaD
I suspect that the deadlock caused by insert trigger (for a log of
changes some of the facts)
DELIMITER $ $
DROP TRIGGER IF EXISTS `facts_insert`;
CREATE TRIGGER facts_insert BEFORE INSERT ON `fact_values`
FOR EACH ROW BEGIN
IF (SELECT `name` FROM `fact_names` where `id` = NEW.fact_name_id)
in
On 5 Чер, 17:51, Kewin wrote:
> now we use mysql (manage about 1000 nodes) ,the pressure is not the
> mysql , but from the puppetmaster .always occur timeout for nodes to
> get the infomation
> I recommand the percona if U prefer the mysql
>
> On 6月5日, 上午4时05分, akaroot wrot
In mysql error log:
120605 12:50:50 [ERROR] /usr/sbin/mysqld: Deadlock found when trying
to get lock; try restarting transaction
120605 12:50:50 [ERROR] /usr/sbin/mysqld: Sort aborted: Deadlock
found when trying to get lock; try restarting transaction
--
You received this message because you
Now I have about 1 000 hosts and I received deadlock errors:
Puppet: Could not retrieve catalog from remote server: Error 400 on
SERVER: Mysql::Error: Deadlock found when trying to get lock; try
restarting transaction: INSERT INTO `fact_values` (`fact_name_id`,
`updated_at`, `host_id`, `value`,
I do not use puppet dashboard, I use my own software for store reports
and generating hosts config. The database used to store inventory data
(Facter facts). It create the most load on the database (insert many
requests).
--
You received this message because you are subscribed to the Google Group
Hi!
Which database would you recommend to use mysql or postgresql for
puppet?
Estimated number of nodes 3, they send reports every 30 minutes.
Thanks
--
You received this message because you are subscribed to the Google Groups
"Puppet Users" group.
To post to this group, send email to puppet
